Peduliar problem in SSRS

Hi all ,

I am encountering a peculiar problem while creating a linked report in SSRS.

The scenario:

My first reports contains 3 columns . The first 3 columns contain data from vendor table in AdventureWorks DB. They are VendorID , Name, CreditRating. The fourth column contains a link to the second report. It is just a link which jumps to the other report and passes the above three values as parameters to the second report.

The second report contains 4 parameters which includes VendorID , Name, CreditRating and one more Postedby parameter which has to be entered manually when the second report is displayed. The three parameters from first report are passed on and one extra parameter has to entered manually then only the second report displays.

It works fine when I check it on Visual Studio preview mode. I click the link for a particular row in First Report and it asks me to enter the Postedby Parameter. After entering it it displays the 2nd report. But the problem arises when I deploy it to report server. When I click the link on first report it throughs an error like " The Parameter 'PostedBy' is missing a value" whereas it should prompt the user to enter the PostedBy Parameter.

I am stuck in this and not able to understand why this happens in ReportServer and not in Visual Studio Preview mode.

Does anybody has any idea why this is happening ?

Any Suggestion will be appreciated.

Regards...

Girija Shankar Beuria

You must specify the default value for the fourth parameter. Visual Studio is an interactive environment, so you get to enter the value on request by the VS. But in production environment, reports are consumed by other applications and the report will not be able to request for an input from the calling application and this applies to Report Manager also which is an external web application that consumes the reporting services.

Shyam

|||

just go to the code and see if there is any parameter hard coded in xml.

Remove that parameter and save it .

This will probably solve your problem.

Vamsi Krishna Korasiga

PDF rendering extension not working on SQL RS 2K sp2

I am in the process of migrating apps from SSRS 2K sp1 to SP2 and one of the
application renders to PDF and it is not working.
I thought pdf rendering was missed out from rsserver.config file and added
the line below
<Extension Name="PDF"
type="Microsoft.ReportingServices.Rendering.ImageRenderer.PdfReport,Microsoft.ReportingServices.ImageRendering"/>
...thinking it might help, but still not.
THis is the error msg we are getting whenever we run the report from the
application.
An attempt has been made to use a rendering extension that is not registered
for this report server. --> An attempt has been made to use a rendering
extension that is not registered for this report server. --> An attempt has
been made to use a rendering extension that is not registered for this report
server
When we run the report from reporting service it works...
Can some one help me or point me in how to fix ...
Env: Win2k3 - SQL 2k - SSRS Sp2.
Thanks
- SaravanaAnyone can you reply about this, as I am in a time crunch
regards
- Saravana
"SK" wrote:
> I am in the process of migrating apps from SSRS 2K sp1 to SP2 and one of the
> application renders to PDF and it is not working.
> I thought pdf rendering was missed out from rsserver.config file and added
> the line below
> <Extension Name="PDF"
> type="Microsoft.ReportingServices.Rendering.ImageRenderer.PdfReport,Microsoft.ReportingServices.ImageRendering"/>
> ...thinking it might help, but still not.
> THis is the error msg we are getting whenever we run the report from the
> application.
> An attempt has been made to use a rendering extension that is not registered
> for this report server. --> An attempt has been made to use a rendering
> extension that is not registered for this report server. --> An attempt has
> been made to use a rendering extension that is not registered for this report
> server
> When we run the report from reporting service it works...
> Can some one help me or point me in how to fix ...
> Env: Win2k3 - SQL 2k - SSRS Sp2.
> Thanks
> - Saravana

PDF file

Can SSRS write reports in PDF files? What about multiple reports in a single PDF file? Thanks.Yes - PDF is an output type. You can create multiple reports and join them in one 'master' report as subreport objects to return them all in one file.|||Please kindly provide related tutorial links. Thanks.