March 6, 2017 at 10:03 pm
Hello,
I hope somebody can help me out here. I have created a report using multiple datasets. Table A uses dataset A, and table B used dataset B. Now, I created table A, and need the second table to be identical, so in Report Designer I copied the table, pasted it back in (this is now table B), and then made sure that table B used dataset B by highlighting the table and changing the dataset used in its properties.
I run the report and table A looks great, but table B is nowhere to be seen. So I deleted the fields and reentered them just to be sure, but once the report was ran, the tables was not visible again.
Ok, I thought, so I deleted Table B, and created a new table that was the same, but again, once I ran the report table B failed to appear.
Why wont the second table show up in the report? This is driving me crazy!
Thank you.
D.
March 6, 2017 at 11:44 pm
Hii Duran
I am not sure..But table B should be show in report in runtime..
Can you please check next page of report in runtime via page next option on upper tab(see attachment) as may be table B shift to another page..
Hope it will resolve..🙂
Regards
Sidra
March 7, 2017 at 3:27 pm
Hello,
Thank you for replying, no afraid not, I'd already checked that, its just the one page.
One think I missed out in my previous posting what that I am using Visual Studio 10.0.40219.1 SP1Rel, and SQL Server 2012 is on SP2 CU6 though, so I am now wondering if I have the most up to date version of SSRS. Mind you, it would be a bit lucky if SP3 solved my issue.
Anyone have this issue?
Regards,
D.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply