November 6, 2006 at 1:44 pm
Hello
I have a report that there are several sub reports in it, that allow a different report with more detail to be opened when a link is clicked on. As time goes on and as people request we add information to the reports. They are intended to be a very high level view of either an Order or a Part Number. When I deployed the report everything looked normal until I clicked on the link in the sub-report for a specific report, RS opens the report displays the report title and a white screen. If I open the linked report and execute it works fine. It works fine from start to finish if I initiate it in a Visual Studio Preview. Here the catch the sub-report is the only one that does this the rest of the sub-reports work as intended. Any suggestions would be greatly appreciated.
Kurt
Kurt Kracaw
November 6, 2006 at 4:03 pm
Is this actually a sub-report or is it actually a report you are clicking through to? Make sure your parameters are correct. If you can, use SQL Profiler to see the statement that is actually being passed to SQL Server.
Aunt Kathi Data Platform MVP
Author of Expert T-SQL Window Functions
Simple-Talk Editor
November 7, 2006 at 5:04 am
Sorry let me clarify a little better. I have a report with several sub-reports with each of the sub-titles in the sub reports being a link to a full blown version of that sub-report. The report and the sub-report work fine it is the link from the sub-report to the full blown version of the report that give me that blank page. If I open the full blown version of the report it works fine, it only gives me a problem from the link of the sub-report. Again sorry for the confusion
Kurt
Kurt Kracaw
November 7, 2006 at 7:36 am
Again, I would double-check the parameters that get passed to that report.
Aunt Kathi Data Platform MVP
Author of Expert T-SQL Window Functions
Simple-Talk Editor
November 7, 2006 at 7:42 am
Kathi,
Thanks for the help you were right on. Found a space in an expression used for a parameter were I shouldn't of had a space. But I am still a little confused why it worked as a stand alone report yet when I went to it through a sub-report it became a problem?
thanks again!
Kurt Kracaw
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply