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

Auto Generate Columns? Expand / Collapse
Author
Message
Posted Wednesday, November 21, 2012 9:37 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Monday, March 31, 2014 9:19 AM
Points: 314, Visits: 677
Guys,

Some of the Devs I work with have coded certain pages such that columns are automatically generated on an aspx page based on a stored procedure, so, add another field into the SP and hey presto the page pulls the field through :)

Is the same functionality possible in SSRS?!

I've had a quick scoot around Google and nothing obvious jumps out at me.

Thanks in advance :)
Post #1387492
Posted Monday, November 26, 2012 7:25 AM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Tuesday, November 18, 2014 3:15 PM
Points: 3,149, Visits: 794
Not automatically.

You can place code in a report, but that world require some maintenance and lot sof testing.

A Tablix can be used for columns of a Cross-Tab, but I think you are referring to something different.

See the Tablix posting - http://www.sqlservercentral.com/articles/Stairway+Series/72649/ - from Jessica Moss on the Stairway to SSRS series.

Thomas


Thomas LeBlanc, MCITP DBA 2005, 2008 & MCDBA 2000
http://thesmilingdba.blogspot.com/
Post #1388622
Posted Monday, November 26, 2012 8:19 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Monday, March 31, 2014 9:19 AM
Points: 314, Visits: 677
Ah okay, thanks Thomas. The SSRS stairway series is great (as at most if not all stairway series here :) ) and I use Tablix quite a bit already.

There's not a huge demand for this feature, it's more out of lazyness to be honest!

Post #1388649
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse