sql server reporting services: Is there another way to obtain '-all-' the fields? -- sql server reporting services

You're in the

sql server reporting services

group:

Is there another way to obtain '-all-' the fields?

Gerardo
1/11/2005 2:35:02 PM

sql server reporting services:

Hi all,

I'm using a Reporting Services webpart for Sharepoint. I made the reports
using Parameters with the SELECT UNION statement to bring 'ALL' the rows,
something like this:

SELECT priority AS prior, prioridad AS value
FROM dbo.priority
WHERE (priority <> ' ')
UNION
SELECT '-ALL-' AS prior, NULL AS value
ORDER BY priority

This worked excelent..!!, But know that i'm integrating it to the webpart it
doesnÂ´t shows the parameters.

My question is, if there is another way to bring ALL the rows without using
the UNION statement? cause i proved that without it, the parameter appears in
my Reporting Services WebPart in Sharepoint.

Please help me, Masters of the Reporting Services and SQL..!!

--

Re: Is there another way to obtain '-all-' the fields?

Brian Welcker [MSFT]
1/24/2005 2:20:00 PM

Currently, this is the way to do this. We will support multi-select
parameters in the SQL 2005 version.

--
Brian Welcker
Group Program Manager
SQL Server Reporting Services

This posting is provided "AS IS" with no warranties, and confers no rights.

[quoted text, click to view]

Re: Is there another way to obtain '-all-' the fields?

Gerardo
1/24/2005 3:11:02 PM

Thanks a lot, Brian, now i know what to say to my clients.
Cheers.

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server reporting services group.

home · blog · groups

Questions? Comments? Contact the dn