chad_sriram
asked on
Displaying group data from a table in a textbox outside the table in SSRS 2008
I am new to SSRS 2008.
Â
I'm creating a report with a table that is grouped by an invoice number. There's a page break at the end of each grouping in the table, So each page only has data only for that invoice number. Outside of the table, I want to have a textbox that contains the concatenated values of the customer details that exist in the same dataset that the table is linked to. I need to display that.
I do not have SSRS 2008 R2, so the Lookup function is out of question. I found this online:
http://stackoverflow.com/questions/898309/how-do-i-reference-group-data-in-a-textbox-on-reporting-services
However, the solution describing subreports, since I am new to SSRS 2008, I do not know how to use a subreport.
Right now, I have 1 report in my solution. In order to use the subreport like specified above, do I have to add another report to my solution? How do I go about doing that in order for the textbox to use the subreport and display details pertaining to the invoice (customer details) in the page header outside the table?
Urgent help is needed.
Thanks,
Chad
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
To pssandhu:
This almost worked for me since I already tried that. For some reason, record 1 out of possible 94 records for my dataset does not display the value of ReportItems!HiddenCustDeta
As you can see, I named the hidden text box HiddenCustDetails inside my table and hid the column (not the textbox).
Every single record displayed the value except for record 1. Any pointers there? I cannot, for the life of me, explain why every record except record 1 has a value for that report item hidden textbox. It is driving me crazy. If it had worked, I would have been done with this report last week, hence this last resort of a subreport.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
To pssandhu:
Yes, it does display every single record with the hidden textbox value if I unhide the column. Hiding the textbox but not the column, that did the trick. I was hiding the column but not the textbox.
I will go ahead and accept your solution, you saved me a ton of time. Thank you very much.
Glad I could help!
Can can add a rectangle to your report and place a number of textboxes inside it. Then you can work with your dataset from there.