[dba-SQLServer] Reporting Services Question

Arthur:

Are you using Visual Studio to create the report? If so, you should see
three tabs in the Report Designer: Data, Layout and Preview. If you open the
Data tab, you should see a combo box for Dataset. If you dropdown the combo
box, you will see an option for <New Dataset>. Use that to create a dataset
for unique Categories and then you can point your Parameters combo box at
the new dataset.

Hope that helps.

James Barash


-----Original Message-----
From: dba-sqlserver-bounces at databaseadvisors.com
[mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Arthur
Fuller
Sent: Tuesday, September 02, 2008 10:26 AM
To: Discussion concerning MS SQL Server
Cc: Joe Michel
Subject: [dba-SQLServer] Reporting Services Question

I'm building a report whose data set is based on a parameterized stored
procedure. The params are @CategoryID and @SubCategoryID. I have opened the
Report Parameters screen and changed both parameters to combo boxes and
specified the value field and label field. Ok fine. Only problem is I'm
getting repeated values in the Preview mode, rather than a unique list of
all categories.

When I open the toolbox, at the top it says Datasets. This implies that I
could add two more datasets to the report, and use them as the dataset for
the combo boxes. But after a couple of hours of poking around, I cannot find
out how to add another dataset. If you can only have one, why does the
toolbox label say Datasets?

Anybody know if it's possible, and if so how to do it? Or some other way of
populating my combo box parameters?

TIA,
Arthur
_______________________________________________
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
http://www.databaseadvisors.com