sql server reporting services: Can the report table have varying number of columns ??? -- sql server reporting services

Can the report table have varying number of columns ???

Alok
8/26/2004 11:55:05 PM

sql server reporting services:

The requierment is tyo have a dynamic report, that has a table with number of
columns decided on the input from recordset.

The SQL procedure takes in parameters and returns recordset, that can have
varying number of columns. All we want to do is to link this recordset to a
table on the report.

The report table should show the columns as they are in the Recordset. ( and
the column name in the recordset shall appear as the column header in the
Reporting table.)

-- Alok Kumar Gupta

Re: Can the report table have varying number of columns ???

Chris Hays [MSFT]
8/30/2004 1:13:59 PM

There's really no good way to do this in the current version, no.

--
This post is provided 'AS IS' with no warranties, and confers no rights. All
rights reserved. Some assembly required. Batteries not included. Your
mileage may vary. Objects in mirror may be closer than they appear. No user
serviceable parts inside. Opening cover voids warranty. Keep out of reach of
children under 3.
[quoted text, click to view]