I am converting from Crystal Reports and currently using SQL Server 2005 Reporting Services. In Crystal I could accomplish a lot of tasks using the whileprintingrecords method.
I have a data set with 3 levels of grouping. Group 1 we'll call Program Code, Group 2 we'll call Person, and Group3 we'll call Services. Within a program I need to build a string that displays all of the services that person received in a single string without printing these items on each individual detail line. When the program or person changes I need to start the string over for the next person.
In crystal I could declare a Global Variable, initialize it in the report header, reset it whenever my group(s) changed, update it in my detail, and output in my group footer.
I tried using built in code in SRS to accomplish this but it did not print my group footer for the previous person until after it had printed the group header and detail for the next person.
Does anyone have any success stories to share on how I could accomplish this task in SRS.
Thanks in advance,
Jeremy
I have a data set with 3 levels of grouping. Group 1 we'll call Program Code, Group 2 we'll call Person, and Group3 we'll call Services. Within a program I need to build a string that displays all of the services that person received in a single string without printing these items on each individual detail line. When the program or person changes I need to start the string over for the next person.
In crystal I could declare a Global Variable, initialize it in the report header, reset it whenever my group(s) changed, update it in my detail, and output in my group footer.
I tried using built in code in SRS to accomplish this but it did not print my group footer for the previous person until after it had printed the group header and detail for the next person.
Does anyone have any success stories to share on how I could accomplish this task in SRS.
Thanks in advance,
Jeremy