I have a report that is link from another report, I've created this link in the report designer by using the rightclick textbox>select properties>Navigation tab > jump to report.
Now I have passed 4 parameters over to the new report, these are hidden and shouldn't be seen by the user. There is however a fifth parameter that should be set by the user at run time, as this controls what the report shows. This works perfectly when I'm in the designer using the preview tab. However once I upload the report to the server, I get an error message saying that the fifth parameter is missing a value! Even though in report manager the fifth parameter is set to prompt User, it will not display a prompt and allow a user to input the data, it just says that the parameter is missing a value and that's as far as it gets.
I think this must have something to do with how report manager renders the parameters of a report but I can't seem to find any information on it anywhere. Can anyone help at all?
Hi James,Two days ago I encountered the same issue with one of my reports. On the local designer studio everything worked fine and as soon as I uploaded it to Report Manager the parameter was not prompting for value but kept on complaining.
All I had to do was, save the report locally, reboot the machine and upload it again. I know its a crazy answer but it worked for me. On a hindsight, I guess it was caused by RDL file not getting updated or getting corrupt for some reason.
HTH
Uday
|||
Cheers hedgeu
I tried that though and it's still not working, i'm not sure if it's the way that i'm passing the parameters or weather it's a rendering problem all i know is i can't seem to get it to work.
James
|||I'm not sure if this will fix your problem, but I have an idea you can try if you are still stuck.
Go to: http://localhost/Reports (keep in mind this is a different location from ReportServer)
Find the report which is accepting the parameters (ie, the one in which the user should enter a value for the parameter) and open the report.
Now, at the top of the page, click "Properties". Then select "Parameters"
Verify that your fifth parameter has a check for the prompt user option and that the hidden checkbox is not selected.
Once that is fixed, you should be good to go. Try to link to that report now.
No comments:
Post a Comment