July 7, 2008 at 5:50 am
Hello
I am trying to develop a subreport that will be generated the moment an end user clicks on a link within the parent report (Main report)
Basically, when a user runs a report, which consist of hundreds of records, I will wont them to be able to click on the Order ID, which will then generate another report that will display the customer details and total amount of goods bought.
Can anyone help?
July 7, 2008 at 7:21 am
I think you are talking about Drill through reports.
First you need to create that report where you want to navigate from current report.
After completion of that report, just click on the reportitem (from where you want to navigate) and go to properties--> Navigation --> Report Navigation -->
Now select the report from the list and pass the parameters.
Hope it will work.
July 7, 2008 at 7:45 am
Thanks Hari Narayan Sharma
I got the navigation alright, but i am having problems with the retrieval of the requested records based on the OrderID, when i click an OrderID, it retrieves all of the records in the customer table instead of the single customer record associated with the OrderID.
Any suggestions?
July 7, 2008 at 7:52 am
Its simple to achieve.
You need to create one more parameter for your second reports.
Pass the field value of orderID to navigated report.
Also you need to change Query/Procedure of your second report.
Pass the parameter and use it in WHERE clause (filter condition).
for further help, feel free to ask 🙂
July 7, 2008 at 9:04 am
Hello Hari Narayan Sharma
I got the following error message in BIDS:
Cannot read the next data row for the data set reports_test.
The conversion of the nvarchar value '505555555555' overflowed an int column. Maximum interger value exceeded.
Any suggestions?
July 7, 2008 at 9:21 am
Fixed!!!!!!!!!!
I forgot to set the correct parameter value:blush:
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply