reporting services - Parameter missing a value -
I am new to the Reporting Services Reporting and Reporting Services 2005, which I would like to use as a base report template Our organization is working on trying to replace the report, whose report was finally amended in the page header of the report report. However, I continue to get a 'Paramix' parameter, when I try it is missing a value area, I have done this:
Set up a parameter report with the default value of the globe Do it! ReportName It is also hidden and internal.
Set up a dataset reporter, which calls a stored procedure that returns the report to the last update or another date, if the report is not on the report server its parameters specify the @ReportName parameter The parameter is! ReportName.Value Dataset Returns values when running on the Dataset tab in BI tool.
Set the parameter report, based on the query and the ModDate column, based on the dataset report that has a default value query. This is the last parameter in the report parameter list.
I specify a text box for the parameter.
When I preview, I do not have any value in the "ReportVersion" parameter, I place it in the Report Body or Page Header (which I want). I delete and add the parameter again Given, hidden on it and collided with the internal settings.
What is this error really, I mean, what I'm remembering, and can I do the same with the parameter? >
Thanks in advance
Jim
If I understand what you are doing then it seems that you want to use the field where you are applying a parameter ...
If you are doing this, you can just throw a text box there, and use something like this: field! ModDate.Value to display it.
< The p parameter values that are in the query, are the fields that they give.Hopefully, It helps ...
EDIT: OK, are you trying to get the up-to-date date column price from the reporter DB? If we are talking about this, then you will need to add some things to the report. To add a dataset to the DB report, a dataset containing the date (query below), a list object in the report related to the dataset, and the field that contains a text box in the list object to display. If you hit the Report Server with a query like this:
Select MAX (Modified Date) list as the ModDate name = 'myReportName'< / Pre>This will return your revised date from the ReportSErvices database to the field that you can use.
Comments
Post a Comment