Reporting Services Parameters and Folder Names

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

nduckste - 26 Aug 2008 17:07 GMT

We have written several reports and deployed to our report server. Now
we have two things left to do:

1. Figure out how to pass it an ugly parameter containing "/", ":",
and "_".
2. How would one query the list of reports in a particular report
folder in order to display them in a list for users to choose from?

All this is written in VB.NET. Can anyone point me to some good
tutorials or discussions on how to do this.

Thanks in advance.

Nick

Reply to this Message

Bruce L-C [MVP] - 26 Aug 2008 17:56 GMT

I just posted on this:

> We have written several reports and deployed to our report server. Now
> we have two things left to do:
[quoted text clipped - 10 lines]
>
> Nick

Reply to this Message

Bruce L-C [MVP] - 26 Aug 2008 17:57 GMT

Can't help with ugly parameters but for the list of reports I just posted on
this:
select path,name, type, description from catalog order by type,name

Type evaluates to (based on my observation, not any documentation)

1: folder

2: report

3: Non-rdl (I have some html and .doc files uploaded to Reporting Services.

Those have a type of 3 when I query the catalog table.)

4: linked report

5: data source

Signature

Bruce Loehle-Conger

MVP SQL Server Reporting Services

> We have written several reports and deployed to our report server. Now
> we have two things left to do:
[quoted text clipped - 10 lines]
>
> Nick

Reply to this Message

nduckste - 27 Aug 2008 23:50 GMT

On Aug 26, 9:57 am, "Bruce L-C [MVP]" <bruce_lcNOS...@hotmail.com>
wrote:

> Can't help with ugly parameters but for the list of reports I just posted on
> this:
[quoted text clipped - 36 lines]
>
> - Show quoted text -

Thanks Bruce. What about just examples of passing parameters via
VB.net, ugly or not?

Nick

Reply to this Message

Bruce L-C [MVP] - 28 Aug 2008 13:56 GMT

How are you integrating? Are you using the Report Viewer control? Are you
using URL integration? URL integration is the easiest way. You just embed
the IE browser control and create the string and set the url property to it.

Signature

Bruce Loehle-Conger
MVP SQL Server Reporting Services

On Aug 26, 9:57 am, "Bruce L-C [MVP]" <bruce_lcNOS...@hotmail.com>
wrote:

> Can't help with ugly parameters but for the list of reports I just posted
> on
[quoted text clipped - 42 lines]
>
> - Show quoted text -

Thanks Bruce. What about just examples of passing parameters via
VB.net, ugly or not?

Nick

Reply to this Message