Report Portal

All Forums  ReportPortal General Forum  Report Portal General Issues  Problem with Store Proce Based Reports

Note: You must be registered in order to post a reply.
To register, click here. Registration is FREE!

Screensize: 640 x 480 800 x 600 1024 x 768 1280 x 1024 UserName: Password: Anti-Spam Code: Message: * HTML is ON * Forum Code is OFF Smilies [quote][i]Originally posted by juliom[/i] [br]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, [/quote]   Check here to include your profile signature. Check here to subscribe to this topic.