reporting services valid values query based

I have a parameter that is query based. I have created my own UI to list out
the text boxes per parameter required by the report. Now comes the problem of
a query based parameter. How to I get the queary based valid values to
populate my drop down list boxEddie,
If I understand your correctly I may have some ideas that will help you with
query based Parameters, but first please clarify the reason you built a UI
for users to pass parameters into the report?
thx.
"Eddie" wrote:
> I have a parameter that is query based. I have created my own UI to list out
> the text boxes per parameter required by the report. Now comes the problem of
> a query based parameter. How to I get the queary based valid values to
> populate my drop down list box|||I have several clients that use browsers which the report viewer doesn't
behave well.
I did figure it out. The valid values come back as array when you call the
GetReportParameter method and set the "ForRendering" to TRUE.
So all I did was add the values to ListItems and populated a drop down.
Also, a nifty thing was to find all the Date type parameters and lock the
text box and provide a calendar. This allowed me to use our application's
Localization methods to handle all the different Date formats.
"RS_CZAR" wrote:
> Eddie,
> If I understand your correctly I may have some ideas that will help you with
> query based Parameters, but first please clarify the reason you built a UI
> for users to pass parameters into the report?
> thx.
> "Eddie" wrote:
> > I have a parameter that is query based. I have created my own UI to list out
> > the text boxes per parameter required by the report. Now comes the problem of
> > a query based parameter. How to I get the queary based valid values to
> > populate my drop down list box

Reporting Services Third Party Utilities

I was wondering if anyone knows of a report utility that works with Reporting Services to enable end users to create their own reports? A utility that is user-friendly enough for end users to modify reports without the aid of a developer.SQL Server 2005 ships with an application called Report Builder that does this. It is bundled with every edition (except Express, Mobile, or Anywhere). It is easy to install on end-user machines, it even deploys with clickonce!|||I have tried Report Builder, and it seems to do everything that I've needed. Thanks for your post and help.sql

Reporting services -Help please :-)

Hi all,Hope you can help.

I read the solution about how to create your own legend in cases where the number of serious is dynamicly changing.

The problem is i dont know how to set the chart colors , or like the authors wrote:

"Set the color of the data point in the chart as well as the background color of the first column in the table to:

=Code.GetColor(Fields!Series.Value)"

How do i do that?

You will need at least RS 2000 SP1 or RS 2005.

The steps are:
1. Open the Chart Properties dialog box
2. Click the Data tab.
3. In the Values list, select a [Value], and then click Edit.
4. In the Edit Chart Value dialog box, click the Appearance tab.
5. Click Series Style to open the Style Properties dialog box.

-- Robert

|||

Thanks.

I find the answer in another article of yours :-)