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 SP2 and SQL Server SP3a

My company is preparing to install RS SP2. My SQL Servers are currently running SP3a. Is SQL Server SP4 required to run RS SP2? Thanks.

No, you do not need to upgrade to SP4 for any version of RS. It's a good idea, though.

Reporting Services setup

I installed and started playing around with Reporting Services and realized that you are required to run IIS on your SQLserver in order to use RS. Is this 100% true?
Please tell me there is an alternative...this is huge roadblock due to company policy.

Thanks.Nevermind ...I found the answer here:MSDN library-Reporting Services

Reporting services setup

Hello -
How much does Reporting services cost and could anyone tell me what software
is required? We are using SQL 2000 and Server 2003. Thanks.If you have a valid licence for SQL Server 2000 you have all you need to run
the report server. For designing of the report you need the frontend
application Visual Studio .NET 2003, whereas a "one-language" version will
be enough. More information about that is written here:
http://www.microsoft.com/sql/reporting/howtobuy/faq.mspx
BTW: SQL Server 2005 will come with a integrated way of designing report
rather than buying VS NET.
--
HTH, Jens Suessmeyer.
--
http://www.sqlserver2005.de
--
"FRR" <FRR@.discussions.microsoft.com> schrieb im Newsbeitrag
news:901DB7A3-64F2-4F7E-B8D8-02B00BDBB826@.microsoft.com...
> Hello -
> How much does Reporting services cost and could anyone tell me what
> software
> is required? We are using SQL 2000 and Server 2003. Thanks.

Reporting Services how do I disable a drop down box

Hi,

SQL Server Reporting Services 2005.

I have a tick box that is required to enable or disable two associated drop down boxes.

Example: Tick box has 2 associated drop down boxes. The drop down boxes list details of Area from a database. The Area is linked to Properties. This allows the selection of Properties to be filtering by Area. Ticking the tick box allows the user to select from the drop down boxes.

I have tried setting the Report Parameters in different ways, but without any success.

Please can someone suggest how I can set the two drop down boxes to be disabled when the tick box is unticked and enabled when the check box is ticked?

Thanking you,

dwemh

Hi,

I think enabling or disabling of parameter controls is not possible, since we have limited access to report parameter controls.

You could have cascaded parameters instead. On selection of tick box populate the Area dropdown (by filling the Area dataset with the result of the tick box as input parameter), which in turn populates Properties based on the default Area value.

By tick box do you mean check box, because when I choose a Boolean report parameter type I am getting radio buttons!

Thanks,

JDee

Reporting Services Errors

One or more datasource credentials required to run the report have not been
specified. (rsCredentialsNotSpecified)
When I run a report through our Report Server I npw get the above error. I
cannot find any help files on this error through MSDN or Microsoft.
I ran RSKeyMgmt trying to resolve another issue, any help would be greatly
appreciated.If you ran RSKeyMgmt and deleted encrypted content, you may have deleted
the stored credentials for your report.
Check the report data source properties and make sure they are set
appropriately.
--
| Thread-Topic: Reporting Services Errors
| thread-index: AcVwK9IkFDn5aIhfTdivKQFhEtVjvw==| X-WBNR-Posting-Host: 204.87.106.66
| From: "=?Utf-8?B?V2lsZGxpZmU=?=" <Wildlife@.discussions.microsoft.com>
| Subject: Reporting Services Errors
| Date: Mon, 13 Jun 2005 08:23:16 -0700
| Lines: 8
| Message-ID: <CB0471BF-57FE-481D-A917-B265A4ADB010@.microsoft.com>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="Utf-8"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Content-Class: urn:content-classes:message
| Importance: normal
| Priority: normal
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| Newsgroups: microsoft.public.sqlserver.reportingsvcs
| NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
| Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA03.phx.gbl
| Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.reportingsvcs:45817
| X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
|
| One or more datasource credentials required to run the report have not
been
| specified. (rsCredentialsNotSpecified)
|
| When I run a report through our Report Server I npw get the above error.
I
| cannot find any help files on this error through MSDN or Microsoft.
|
| I ran RSKeyMgmt trying to resolve another issue, any help would be
greatly
| appreciated.
|

Reporting Services Data Extension - Missing Microsoft.ReportingServices

Hi All,

I am trying to run an existing ReportingServices.DataExtension project. However, the required namespace "microsoft.reportingservices" doesn't seem to be available.
I thought that the required VS 2005 components and libraries would be installed as part of SQL Server 2005, but they don't seem to be there...

Any ideas on what I am missing?

Running VS 2005 on Windows XP SP2

We also have SqlServer 2005 Developer edition.

Thanks

It sounds like you didn't add a reference to Microsoft.ReportingServices.Interfaces.dll to your custom data extension project - that's why the namespace can't be found.

See also: http://msdn2.microsoft.com/en-us/library/ms153959.aspx

-- Robert