[cfaussie] Re: CFReport Builder issue - again!
Hi Adam / Dale and everyone else, Embarassingly - it turned out to be a developer error! I noticed after trying both your suggestions (and it frustratingly - still not working) that when in the master report that call the sub reports, If you select a sub-report there is an attribute for sub-report parameters. Setting this value to be the same as the aparameter passed in in the cfreport tag, made everything work as expected. Again thanks for your suggestions... At least I have them working now... Despite now having a formatting issue whereby a sub report overwrites the content of another one. and pagination being less than consistent But otherwise - well on the way now, thanks! Gavin. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] Re: CFReport Builder issue - again!
OKay, I have an update... The report I am calling, includes a subreport. If I change the reporttag to call the sub-report alone, then the report runs correctly as requested. I have removed all sub-reports and now only have one (sub report). And I still ge the error message. So it would seem there is an issue with the reportparam being used by a subreport. It doesn't help me any in solving it but it might help smeone else who has done this already and worked it out. Thanks agan. On Jul 9, 1:53 pm, Gavin Baumanis beauecli...@gmail.com wrote: Hi Everyone, I am back to trying to fix my reporting issues and have been working on it for the past three hours - and I have finally thrown the towell in! I am creating a structure, that stores the results of several queries. if I dump the structure, (from the page that contains the cfreport tag) I get an appropriate dump of a struct with the expected key- value pairs. I then use the struct as a reportparam. cfreport template=print_CAR.cfr format=pdf cfreportparam name=reportParamStruct value=#reportParamStruct# /cfreport But I get the following error when I try and run this page; Error evaluating expression : Source text : param.reportParamStruct.problemdescription I have tried with and without pound signs, I have also included a print when condition that checks for the structure and its key exisiting and that the key isn't an empty string. seemingly no matter what I try - I still get the above error. If anyone has any ideas at all - I would be most grateful. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] Re: CFReport Builder issue - again!
Hi Gavin, You could try this: cfreport template=print_CAR.cfr format=pdf cfloop collection=#myStruct# item=i cfreportparam name=#i# value=#myStruct[i]# / /cfloop /cfreport Then reference each param individually.. #params.myKey# Hope this helps.. Regards, Adam -Original Message- From: Gavin Baumanis [mailto:beauecli...@gmail.com] Sent: Thursday, 9 July 2009 1:53 PM To: cfaussie Subject: [cfaussie] CFReport Builder issue - again! Hi Everyone, I am back to trying to fix my reporting issues and have been working on it for the past three hours - and I have finally thrown the towell in! I am creating a structure, that stores the results of several queries. if I dump the structure, (from the page that contains the cfreport tag) I get an appropriate dump of a struct with the expected key- value pairs. I then use the struct as a reportparam. cfreport template=print_CAR.cfr format=pdf cfreportparam name=reportParamStruct value=#reportParamStruct# /cfreport But I get the following error when I try and run this page; Error evaluating expression : Source text : param.reportParamStruct.problemdescription I have tried with and without pound signs, I have also included a print when condition that checks for the structure and its key exisiting and that the key isn't an empty string. seemingly no matter what I try - I still get the above error. If anyone has any ideas at all - I would be most grateful. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] Re: CFReport Builder issue - again!
Have you tried like this param.reportParamStruct['problemdescription'] Regards Dale Fraser http://dale.fraser.id.au http://learncf.com http://flexcf.com -Original Message- From: cfaussie@googlegroups.com [mailto:cfaus...@googlegroups.com] On Behalf Of Gavin Baumanis Sent: Thursday, 9 July 2009 1:53 PM To: cfaussie Subject: [cfaussie] CFReport Builder issue - again! Hi Everyone, I am back to trying to fix my reporting issues and have been working on it for the past three hours - and I have finally thrown the towell in! I am creating a structure, that stores the results of several queries. if I dump the structure, (from the page that contains the cfreport tag) I get an appropriate dump of a struct with the expected key- value pairs. I then use the struct as a reportparam. cfreport template=print_CAR.cfr format=pdf cfreportparam name=reportParamStruct value=#reportParamStruct# /cfreport But I get the following error when I try and run this page; Error evaluating expression : Source text : param.reportParamStruct.problemdescription I have tried with and without pound signs, I have also included a print when condition that checks for the structure and its key exisiting and that the key isn't an empty string. seemingly no matter what I try - I still get the above error. If anyone has any ideas at all - I would be most grateful. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---