Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Drag And Drop Expand / Collapse
Posted Monday, August 27, 2012 12:45 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, October 29, 2013 4:54 AM
Points: 1, Visits: 8

We are working on one project where the user needs so many real time reports. The reports are combine of so many columns so its difficult to involve all columns in all reports..

Can any one guide me, if is there any option to drag and drop columns and generate the report real time?? Basically we want to give the access to the users to develop the reports on the fly?

Need your help

Post #1350220
Posted Monday, August 27, 2012 1:25 AM



Group: General Forum Members
Last Login: Today @ 8:28 AM
Points: 14,838, Visits: 12,892
Which environment are you working on?
A possibility is to use PivotTables in Excel, either based directly on the SQL relation engine, or on an SSAS cube or on a PowerPivot model.

If you have SQL Server 2012, you could also think about using PowerView.

How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at SQLKover.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1350228
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse