|
juliom
Costa Rica
36 Posts |
 Posted - 05/25/2009 : 15:52:18
|
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, |
|
Report Portal
Problem with Store Proce Based Reports
