Skip to main content



      Home
Home » Archived » BIRT » Stored procedure data retrieval used in multiple charts(Can one stored procedure be the source of data for multiple charts?)
Stored procedure data retrieval used in multiple charts [message #1023568] Sun, 24 March 2013 11:50 Go to next message
Eclipse UserFriend
This is a strategic question so we get on the right path early in the process --

We have an application that asks several questions with all answers going into an Answers table with relational information about the question and answer.

we need to report the results in several charts that have to aggregate the data in different ways.

I created a stored procedure that returns a superset of the data needed for all reports.

What is the best approach to supply the data for the individual reports?

Multiple chart specific stored procedures with selection and aggregation for each chart;
One "master" procedure used by multiple datasets, one for each chart;
Other?

We will be running several charts for each instance of the reports.

Thanks,

Dave
Re: Stored procedure data retrieval used in multiple charts [message #1029545 is a reply to message #1023568] Fri, 29 March 2013 17:08 Go to previous messageGo to next message
Eclipse UserFriend
Creating a large result set that has to be filtered many times within a chart would probably be slower than creating separate dataSets for each chart.

[Updated on: Fri, 29 March 2013 17:11] by Moderator

Re: Stored procedure data retrieval used in multiple charts [message #1029652 is a reply to message #1023568] Fri, 29 March 2013 20:54 Go to previous messageGo to next message
Eclipse UserFriend
Michael,

Thank you for the insight.

Dave
Re: Stored procedure data retrieval used in multiple charts [message #1030065 is a reply to message #1029652] Sat, 30 March 2013 12:26 Go to previous messageGo to next message
Eclipse UserFriend
No problem. I might have misread your question above. My answer was based on bringing all of the data into BIRT and filtering it down for each chart. You definitely wouldn't want that with lots of data, if you have the opportunity to limit the size of the data earlier. The earlier you can limit the data, the better. If you can get all of your charts' data with a single stored procedure and passing it different parameters, you could create separate dataSets with a single stored procedure. Depending on your report, you could possibly create a single dataSet and just change the parameter values that are passed to it, eliminating the need to create separate dataSets. Let me know if you run into issues.
Re: Stored procedure data retrieval used in multiple charts [message #1030234 is a reply to message #1023568] Sat, 30 March 2013 18:24 Go to previous message
Eclipse UserFriend
Thanks for the additional input. What you are describing (stored procedures to pass parameters) to select the data of interest and then data manipulation in BIRT is where I'm thinking now.

Some of the reporting in charts I need to do are time series (by month or quarter.) It looks to me that doing the data manipulation in BIRT will be less complicated than in the stored procedure.

Thanks for your help.
Previous Topic:XML report
Next Topic:export report to image (i.e. png)
Goto Forum:
  


Current Time: Sun Apr 20 19:41:40 EDT 2025

Powered by FUDForum. Page generated in 0.04155 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software

Back to the top