Reporting Services

I am trying to jump to a seprate report from a text box.

In properites on the Navigation tab I selected Jump to (name or report) and in the Parameters box I selected =Fields!ProjName.Value so it will only give me the project name.

When I run and try to jump to the report I get this error.

An error occured during local report processing. An attempt was made to set a report parameter ProjectName this is not difined in this report.

Hey David,

I am trying to get a good idea of what you are attempting to do, however I am having a difficult time seeing it.

Are you trying to change reports when someone types a report name in a text box?

Are you trying to run a specific report for a certain project?

Do you have a report that actually has a ProjectName parameter created in it?|||Here is what I am trying to do I have a report That lists projects in a table. I want to be able to click on a project and have it jump to a completely different report based on the value of the item I clicked on. so If I click on project A it will take me to a different report that contains all the data about project A. to do this I am right clicking on the cell or textbox in the table that contains the project field (=Fields!ProjName.Value) I bring up the Textbox Properties box and select the Navigation box in the Jump to report I select the other report I created called DevSummary I then click on the Parameters box and add the following Parameter Name ProjName Parameter Value: =Fields!ProjName.Value When I run the report I get this error. An error occurred during local report processing. An attempt was made to set a report parameter 'ProjName' that is not defined in this report. below is a screen shot of what I am trying to do.|||

Hi,

What are your parameter names in the DevSummary report?

Aidan

|||Apologies Awysbrke - just noticed that you had already asked the same question...|||

There are no parameters defend in the DevSummary report?

How do I define parameter names here?

|||Ok David, I may see what is going on here.

You are wanting to view a report named DevSummary, with the information for the project that was clicked on in the specific text box. As far as I know this is all correct.

Now, where we are getting tossed by SSRS is when we try to pull up the second report. You are telling SSRS that you want the DevSummary report to process all the information for Parameter Name "ProjName".

Your DevSummary report definition file does not contain a parameter for ProjName, so it is kicking it back.

When you created the DevSummary report file, specifically the dataset, did you put any parameters in your SQL statement? What is the criteria for the actual DevSummary report using to retrieve the data?

If you are making a report for a specific project, you probably used a parameter for teh criteria, get that parameter name and then put the new name into the textbox navigation instead of the one named "ProjName"

I apologize if I insulted anyones intelligence, I am still learning this myself and like to write things out in detail :)

I hope this helps!

Anthony|||

You did not insult my intelligence at all. It makes perfect sense now. I need to create a dataset with a parameter in it and use the value from that in my second report called DevSummary. So correct me if I am wrong but the SQL would go something like

SELECT ProjName, whatever, whatever, whatever

FROM ProjectTable

WHERE ProjName = @.ProjName

Then use the @.ProjName in the report parameter in the DevSummary Report.

|||Exactly bro :)|||

I am now getting this error.

A data source instance has not been supplied for the data source 'DataSet4_Project'.

What does it mean

|||David,

How are you accessing this report?

Are you using hte default Report Manager, or are you writing your own asp application to view the report using the Report Viewer?

Also, 2000 or 2005?|||

I am Wrinting my own app using Report Viewer and SQL Server 2000

I am doing my development in Visual Studio.net 2005

|||David,

The error you are getting is telling you that there is no datasource on the server for the report. When you created the report, the first thing it should have asked was how you wanted to connect. This should have created the Shared Datasource, or individual datasource.

I believe that the problem is that your datasource wasn't uploaded to the server correctly. I could be mistaken. Double check and make sure the datasource that the report is using, is actualy on the server. You may have to rightclick on the project properties and make sure that overwrite current datasources is either checked or unchecked. If you made changes to an existing datasource, and that box isn't checked, it won't overwrite it with the new one.|||

I created a new datasource. two thngs

First: when I go to the project properties I can not find anything called overwrite current datasources there is nothing about datasources.

Second: When you sayuploaded to the server are you talking about the Web Server or the SQLServer?

|||Here's my scenario.

I am using VS2005, with SQL 2005, and the 2005 Reporting Service.

When I create a report, I do it in VS2005 with the Report Project.

I go through the wizard, selecting the datasource, selecting the fields etc..etc..

Now, in the Project properties, you should see General > Deployment and it has options there to overwrite datasources, and settings for report server url and folder.

This tells Visual Studio where to deploy the files to. The overwrite datasource is usually defaulted to False.

So, you create the report file in VS2005(which still has me purplexed because I was under the impression you needed SSRS 2005 to create reports in VS2005), then when you run it, VS automatically uploads your files to the respective server. If the overwrite datasource option is true, then it will overwrite your current datasource.

The report server is different from the SQL server and the Web Server.