Crosstab with some static data and some dynamic data

dsrikanth · 2011-05-24T07:49:13+00:00

Hi everyone, I am new to BIRT. I attached a pdf file. I want report in this format, how to do that? Every thing will come in single query only. I can't do the grouping. The columns are going to be increased after displaying some static columns. <strong…

dsrikanth

Hi everyone, I am new to BIRT. 
I attached a pdf file. I want report in this format, how to do that? Every thing will come in single query only. 
 
I can't do the grouping. The columns are going to be increased after displaying some static columns. 
 
JACKS NADI, JACKS SHERATON, JACKS TOKATOKA..... are dynamic units & every unit contains 4 columns (sales qty, sales val, stock qty, stock val) 
 
And i need to display SUM of all unit's qty's and val's in static columns. 
 
These list of units are going to be selected at report parameters. 
 
How to display this using cross tab 
 
Pls anybody help me.

Find more posts tagged with

Comments

mwilliams

So, you need to make the crosstab and then show the totals of the 5 values in stacked row form like in the pdf? Is that what you mean?

dsrikanth

Thanks mwilliams for the reply,

Yes need it exactly like that. I am attaching my report to respond well.

Thanks in advance.

mwilliams

In your report, you just use a table. Have you tried setting up a crosstab with the setup that you want? For the totals section, you'd just need to keep sums of the columns you want to sum in script and then access them in a grid below your crosstab. Or, you could use the grand totals of the crosstab to do that for you and hide them in the crosstab and just store the values in variables for use in a grid below your crosstab in the same way.

dsrikanth

Thanks MWilliams for the reply,

I am new to cross tab, Will you please advice me to work with it and design the report as like my requirement. If you don't mind pls alter this report into cross tab. I am getting every thing in the query but i don't know how to use cross tab to get desired result. It needs repeated rows and repeated columns, but i have only repeated columns not rows. Summarized fields need to be displayed along with the actual data.

Pls change the report to get desired result. It is really helpful to me.

Thanks,
Srikanth

dsrikanth

Williams apart from the above post i have another issue.

Even to display the table data it generates the blank report after waiting a long time for the query result. Of course query taking nearly 45mins of time but after that time the report is not showing any thing on the page even an error. What is the problem? Is the database connection timed out? Why it is not showing even the error?

Thanks,
Srikanth D

mwilliams

Can you provide me a CSV flat file of sample data how it looks in your dataSet? Then I can try to create a setup exactly like in your pdf.

dsrikanth

Thanks for the reply Williams, 
 
I am attaching the csv file and report file. Here we need to calculate the unitstockval by multiplying the unitstockqty and rate where rate or unitstockqty may me null or 0. Before producing the result we need to check them. The grand totals should be displayed after Price val and before unit data(sales qty, sales va, stock qty, stock val) displayed. If any details or not there for unitsalesqty,unitsalesval,unitstockqty,unitstockval we need to place 0 and show sum as 0. 
 
I tried a sample, I attached it as image, but i am unable to add 0 for some empty cells and 0.00 for some other empty cells, And how to add headers(Name, Email, Address) for the left columns? 
 
Regards, 
Srikanth D

dsrikanth

I am waiting for your reply Williams. Replace double quotes(") with blank and semi colon (; ) with coma (, ) in the database file that what i attached, then only it is going to work.

Regards,
Srikanth D

dsrikanth

Mr. Williams when i run the same report with flat file, eclipse also given the same error (Outofmemory). What i have to do to avoid that? Why it is not using virtual memory? Pls design the report acc. to PDF format.

Thanks in advance,
Srikanth D.

mwilliams

I don't see a file attached. Can you try attaching again?

Let me know your BIRT version and I'll just make a sample that takes values from a crosstab and puts them in a grid below.

dsrikanth

Thanks for the support, 
 
I attached the report in some other post, this is the link 
 
<a class='bbc_url' href='http://www.birt-exchange.org/org/forum/index.php?app=core&module=attach?ion=attach&attach_id=5240'>Attachement</a> 
 
Please tell me how to add page break after every 40 rows in crosstab, and how to remove grouping rows while displaying data like in pdf that what i attached, I mean even though column is repeating it should not group and display single for entire group. It should display it for each and every row. Page break is not working for web viewer. 
 
How to add headers for the left columns and TOTAL_STOCKQTY column to Grand Total group, how to calculate stock val ( TOTAL_STOCKQTY * RATE ) and add it to Grand Total group. 
 
If you don't mind pls change the report for me. I want to know does i did every thing right or not in the attached report? If you do any changes in the report pls tell me what are they, so that i can change it in my original report which deals with database directly. 
 
Pls tell me if there is any optimization techniques for this report to get quick result. In order to process 1000 recards (Flat file DS) it is taking 1min time. So i need to reduce it if possible. Everything is coming from the DB except sum of cols(salesqty, salesval). Does report start processing upon receiving the data or it starts processing only after getting entire data from database? 
 
While running the report inside the tomat it is giving some error like attached file. What is the problem. 
How to configure inside tomcat? Even though i am placing ojdbc14.jar file inside tomcat lib dir it is giving same error. Is it require to configure jndi datasource separately in tomcat. 
 
Thanks in advance. 
Regards, 
Srikanth D