Error in preview

Stimulsoft BI Designer discussion
Post Reply
alikamran
Posts: 1
Joined: Mon Aug 17, 2020 12:30 pm

Error in preview

Post by alikamran »

Hi,
I created a report but it doesnt't show me the Preview and says "Could not find stored procedure......"
I used a stored Procedure for creating and it added correctly.

What should I do? Tnx
Lech Kulikowski
Posts: 6163
Joined: Tue Mar 20, 2018 5:34 am

Re: Error in preview

Post by Lech Kulikowski »

Hello,

Please check the query of your data source.

Thank you.
veeranarayana
Posts: 9
Joined: Fri Aug 05, 2022 10:08 am

Re: Error in preview

Post by veeranarayana »

Dear Lech Kulikowski,
While designing the report in designer getting the below error.

Must Declare the scalar variable "@Portfoliodate even that variable is not required.

Back Ground:
Have stored procedure with columns and parameters,retrieved all the details and added new parameters as FromDate and ToDate in variable section in the report.

Please help me on the same.

Regards,
Veera
Lech Kulikowski
Posts: 6163
Joined: Tue Mar 20, 2018 5:34 am

Re: Error in preview

Post by Lech Kulikowski »

Hello,

Please add @Portfoliodate parameter to the data source.

Thank you.
veeranarayana
Posts: 9
Joined: Fri Aug 05, 2022 10:08 am

Re: Error in preview

Post by veeranarayana »

Dear Lech Kulikowski,
Thanks a lot for your prompt response.

In my report,don't need the Portfoliodate parameter hence removed.

I have date range(from Date and To Date).

Regards,
Veera
Lech Kulikowski
Posts: 6163
Joined: Tue Mar 20, 2018 5:34 am

Re: Error in preview

Post by Lech Kulikowski »

Hello,

Please send us your report for analysis.

Thank you.
veeranarayana
Posts: 9
Joined: Fri Aug 05, 2022 10:08 am

Re: Error in preview

Post by veeranarayana »

Dear Lech Kulikowski,

The attached one is my report design in stimulsoft Designer.

Have 3 parameters and created variables only for those and deactivated Portfoliodata variable and getting the error while previewing.

Regards,
Veera
Attachments
Transaction report issue.PNG
Transaction report issue.PNG (13.01 KiB) Viewed 16906 times
Lech Kulikowski
Posts: 6163
Joined: Tue Mar 20, 2018 5:34 am

Re: Error in preview

Post by Lech Kulikowski »

Hello,

Please send us your .mrt file for analysis.

Thank you.
Post Reply