Discussions
Categories
Groups
Community Home
Categories
INTERNAL ENABLEMENT
POPULAR
PUBLIC CLOUD
PRIVATE CLOUD
Quick Links
MY LINKS
HELPFUL TIPS
Back to website
Home
Intelligence (Analytics)
script is executing multiple times because of cross tab
srikar
<p>[font="arial, sans-serif;font-size:13px;"]Hi,[/font]</p><div style="font-family:arial, sans-serif;font-size:13px;">my birt report is having a dynamic cross tab.. the script (my sql script) is executing multiple times which i have observed from the log.. i found that the number of times the sql script is hitting database is based on the number of groups in the cross tab</div><div style="font-family:arial, sans-serif;font-size:13px;"> </div><div style="font-family:arial, sans-serif;font-size:13px;">number of times the sql hits the DB == number of groups in the dynamic cross tab</div><div style="font-family:arial, sans-serif;font-size:13px;"> </div><div style="font-family:arial, sans-serif;font-size:13px;">I am using BIRT 3.7 version..</div><div style="font-family:arial, sans-serif;font-size:13px;"> </div><div style="font-family:arial, sans-serif;font-size:13px;">this leads to the delay in the execution of the report..</div><div style="font-family:arial, sans-serif;font-size:13px;"> </div><div style="font-family:arial, sans-serif;font-size:13px;">please provide a solution for this ... <strong>what i exactly want is my sql script will execute only once for the cross tab</strong></div><div style="font-family:arial, sans-serif;font-size:13px;"> </div><div><strong>or is there any work around solution to represent the dynamic data by avoiding cross tab/ data cube completely???</strong></div><div style="font-family:arial, sans-serif;font-size:13px;"> </div><div style="font-family:arial, sans-serif;font-size:13px;">thanks in advance</div><div style="font-family:arial, sans-serif;font-size:13px;">Srikar.</div>
Find more posts tagged with
Comments
mwilliams
<p>Are you embedding a crosstab into another element? What does your data look like and what are you needing it to look like in your report?</p>
srikar
<p>williams,</p><p> </p><p>i have embedded cross tab inside a grid.. </p><p> </p><p>the dataset will gives the output as follows:</p><p> </p><p>country_id country_name language state population</p><p>**** xxxx xxxx xxxx xxxx</p><p>**** xxxx xxxx xxxx xxxx</p><p>**** xxxx xxxx xxxx xxxx</p><p>**** xxxx xxxx xxxx xxxx</p><p>**** xxxx xxxx xxxx xxxx</p><p> </p><p> </p><p> </p><p> </p><p>---language and state are taken as parameter from user</p><p> </p><p> </p><p> </p><p> </p><p>and i am displaying the above data using cross tab as follows:</p><p> </p><p>country1 language1 language2 language3 total _population</p><p> </p><p>state1 x x x ****</p><p>state2 x x x ****</p><p>state3 x x x ****</p><p> </p><p> </p><p>country2 language1 language2 language3 total _population</p><p> </p><p>state1 x x x ****</p><p>state2 x x x ****</p><p>state3 x x x ****</p><div> </div><p> </p><p> </p><p>here country is dynamic column and language is also dynamic column </p><p> </p><p>please gimme a suggestion how to get display this sort of data with out using cross tab</p><p> </p><p>Regards,</p><p>Srikar</p>
mwilliams
<p>Sorry for the delay. So, the crosstab is embedded in a table grouped by country? Any way you can attach a sample report that shows your setup?</p>
srikar
<p>Michael,</p><p> </p><p>I have not created any report as of now.. the requirement is like that and i need to display that in table but not using cross tab or data cube.. Is there any way to represent the above given data to display without using cross tab?? please share any rptdesign files of such a kind ??</p><p> </p><p> </p><p>Regards,</p><p>Srikar.</p>
mwilliams
<p>In your first post, you said you had a report with a crosstab. I was pretty certain the SQL only ran once if you only had a single data cube. I guess I could be wrong on this, but if you've not created a report, yet, then, could you try with a data cube and crosstab? Let me know if I'm misunderstanding you.</p>
