Error when click on page down

[Nilam]

Hi experts,

I have one report which has many pages and When I click on page down it is giving error "Data source adapter error: com.microsoft.sqlserver.jdbc.SQLServerException: The value is not set for the parameter number 1. - when processing query". page 1 is working fine. The report is using Stored procedure based package.

Please help me on this?????

Many Thanks, Nilam

[cognos810]

Hello Nilam,
Can you try running the report in PDF? HTML only fetches 20 rows(by default) at a time and you have not encountered the error yet, so you see the results. A PDF format run should fail right away, as it waits for all the results and then renders it into PDF.
Do not know the details of the report, but from what you have explained, looks like you are passing some value of a data item to a Stored Procedure. May be, again I am guessing, the stored procedure is not expecting a NULL value and one of the values for the data item being passed to SP is a NULL value.

-Cognos810