ReportPortal
ReportPortal
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 ReportPortal General Forum
 Report Portal General Issues
 Problem with Store Proce Based Reports
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

juliom

Costa Rica
36 Posts

Posted - 05/25/2009 :  15:52:18  Show Profile  Reply with Quote
If you have a report based on a Store Procedure it's not possible for the user to edit the filters or the columns. When you try to do so, you get an error with an Unhandled Exception stating that there has been a sintax error in the select that populates the forms with the available fields and filters.
This is really inmportant, given that the only way to have an "All" option in a filter is doing it through store procs.

Some thing else that you cannot do is to sort, when the report is based on a store procedure. Theres a post where Igor suggest a method for solving this here http://www.reportportal.com/forum/topic.asp?TOPIC_ID=271

With this method you can actually sort, but when it comes to the user to edit columns and/or filters, you have the same result I just mentioned, an unhandled exception.

Regards,

juliom

Costa Rica
36 Posts

Posted - 05/25/2009 :  20:15:49  Show Profile  Reply with Quote
I have to correct my self. Using store procs is not the only way to have "All" option in a filter. I stumble upon this http://www.sqlstuff.dk/post/Filter-parameters-in-a-Stored-Procedure.aspx
It's a great post... is actually quite simple and it help me overcome this issue... Now I have it all, I have the "All" option in the filters and I can sort the results if I want and... I can edit the columns and filters to include in the report...

Thanks,
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
ReportPortal © 2000-2002 Snitz Communications Go To Top Of Page