Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2012 Forums
 Analysis Server and Reporting Services (2012)
 Report like tables in DB

Author  Topic 

under2811
Constraint Violating Yak Guru

366 Posts

Posted - 2015-01-14 : 00:09:32
Hi Experts,

I’ve a requirement of showing data in SSRS report same as in SQL Server table. User can pick a table from list of tables in database and the report has to display data inside the table. Fields report varies based on columns in table.

T.I.A

gbritton
Master Smack Fu Yak Hacker

2780 Posts

Posted - 2015-01-14 : 07:03:31
So, what's the question?
Go to Top of Page

under2811
Constraint Violating Yak Guru

366 Posts

Posted - 2015-01-15 : 01:31:20
Is it possible to generate such type of report?
We can generate reports like creat DS and used table/s and pick required columns from it but here i need to produce report as per user's selection of tables and accordingly the columns vary..
T.I.A
Go to Top of Page

gbritton
Master Smack Fu Yak Hacker

2780 Posts

Posted - 2015-01-15 : 07:05:03
Yes it is possible.
Go to Top of Page

under2811
Constraint Violating Yak Guru

366 Posts

Posted - 2015-01-22 : 00:03:37
Thanks! Can you please help me out here?.

T.I.A
Go to Top of Page
   

- Advertisement -