alfie1109

Problem solved! Added another Crosstab in the Last Page footer, based on Regions.

I would like to add a Grand Total at the end of the report (Sum of Total), but not sure how to go about on doing these using Crosstab. Below is an example of what my report looks like right now (minus the Grand Total at the end). Region Florida Beer BtlBeer DraftBeerBeveragesFoodLiqorTotals1 - Tavern Lake207.10268.45333.00172.001666.92649.253296.722 - Tavern Park154.25587.45295.80139.201422.18476.003074.88 Totals:361.35855.90628.80311.203089.101125.258087.36 Region Georgia Beer BtlBeer DraftBeerBeveragesFoodLiqorTotals1 - Tavern Heights142.20135.95196.25182.451603.15463.503217.002 - Tavern Court149.00181.00302.50156.001733.87525.003299.12Totals:291.20316.95498.75338.453337.02988.506516.12 Now, I want to add the Totals of both Regions for each column. How do I go about on adding a new row for Grand Total? Beer BtlBeer DraftBeerBeveragesFoodLiqorTotalsGrand Total: 652.551172.851127.55397.713822.85988.5014603.48 Any help is very much appreciated! Thank you!!!! ~a

Hi- I am testing the Jaspersoft Studio Professional v. 7.1 and I can't seem to find the "Sort" component like the one on iReport Designer v.5.5. Is sort component not available in Professinoal edition? How do you use sorting on the Professional version? Thank you, ~alfie

Created multiple variables to get Highest Totals and then applied the calculation directly to the text field. {Group Highest Total / Report Overall Highest Total} * 100 = [%Rpt]

All my reports are setup the way I mentioned on my last comment. So, when I run the report, the PDF document generated is in Landscape mode and when I print it, it still prints in Landscape mode. I am not sure how it works if you print if from .Net code, maybe the settings in jasper are getting overwritten (not 100% sure).

I'm just curious, did you change/update the Table Datasource? If not, check if your Dataset/Datasource are pointing to the correct Dataset and Connection/Datasource. ~a

I set the following variables in order and set each variable (see below) Name = Discounts_Total Variable Class = java.lang.float Calculation = Sum Reset Type = Group Reset Group = Group ID Increment Type = None Increment Group = Variable Expression = Float.parseFloat($F{Discounts}) Name = Dsct_TotalGrp Variable Class = java.lang.float Calculation = Highest Reset Type = Group Reset Group = Group ID Increment Type = Group Increment Group = Group ID Variable Expression = $V{Discounts_Total} On the text field properties: Text Field Expression: $V{Dsct_TotalGrp} Change Evaluation Time and Group Evaluation Time = Group Evaluation Group = Group ID After I made the following changes, report works!!!!!

Hi All- I am having trouble getting the Total of 'Rpt %' column. The calcuation for 'Rpt %' column is based on two different variables and calculation is done directly on the TextField Expression. Here are the setup/calculation for both Net and Rpt % columns. Net (for each row) Name: SalesQty_Total Variable Class: java.lang.float Calculation: SUM Reset Type: Group Reset Group: ID Group Increment Type: None Increment Group: blank Variable Expression: Float.parseFloat($F{SalesQty}) - Float.parseFloat($F{VoidsQty}) - Float.parseFloat($F{RefundsQty}) Net Totals: Name: SalesQty_TotalGrp Variable Class: java.lang.float Calculation: SUM Reset Type: Group Reset Group: Cat Group Increment Type: None Increment Group: blank Variable Expression: Float.parseFloat($F{SalesQty}) - Float.parseFloat($F{VoidsQty}) - Float.parseFloat($F{RefundsQty}) Rpt % (for each row) Calculation is directly on the "Text Field Expression" ($V{SalesQty_Total}/$V{SalesQty_TotalAll}) * 100 (SalesQty_Total / SalesQty_TotalAll) * 100 (3 / 271 ) * 100 = 1.11 (12 / 271) * 100 = 4.43 (21 / 271) * 100 = 7.75 (235 / 271) * 100 = 86.75 NameNetRpt %Pepsi31.11Dr Pepper124.43Iced Tea217.75Coke23586.75Totals:271[Need Total] So my question is: 1. How do I get the Total of "Rpt %" column? I can't seem to get the correct calculation and I have tried different setup. Any help/suggestion is very much appreciated. Thanks! ~a

@hozawa, the variables are correctly set in placed, and still didn't work.

Hi All- Issue: When I added a table (under Details band) to my Main Report, I don't get prompted anymore to enter values to each parameters I added. I have several parameters that I added to my Main Report (see below): this are all under Column Header on my Main Report Employee$P{Day1}$P{Day2}$P{Day3}$P{Day4}$P{Day5}$P{Day6}$P{Day7} So, when I preview the report, I get prompted to enter Value for each paramenter.....GREAT! everything is working as intended. I get the following results EmployeeSundayMondayTuesdayWednesdayThursdayFridaySaturday Now, I added a Table under Details band, I succesfuly configured the table datasource and datasets and it populates my table. But, the problem I'm having is when I preview the report it DOESN'T PROMPT me to enter values for each parameters anymore, it just compiles and sends me directly to Preview page. I see the table, but now my Column Headers are blank. Did I miss anything? What else do I need to do? All I did was added a table, so how did the prompts stopped working. The result I get after adding the table to my Main Report. The parameters for Day Of Week are blank, I did not get prompted to enter values. Employee Test Test10:00 AM - 2:00 PM(5:00 PM - 9:00 PM)10:00 AM - 2:00 PM 6:00 PM - 10:00 PM 10:00 AM - 2:00 PM10:00 AM - 2:00 PM10:00 AM - 2:00 PM 6:00 PM - 10:00 PM10:00 AM - 2:00 PM Please help!!! Thank you, ~a

Hi All- I have variables that does some calculation First Variable: Adds all Discounts (Discounts Column) Name: Discounts_Total Variable Class: java.lang.float Calculation: SUM Reset Type: Group Reset Group: Group ID Increment Type: None Increment Group: blank Variable Expression: Float.parseFloat($F{Discounts}) Initial Value Expression: 0 Second Variable: Return the Highest Total for each Group ID (Discounts Column) Name: Discount_TotalGrp Variable Class: java.lang.float Calculation: Highest Reset Type: Report Reset Group: blank Imcrement Type: Page Increment Group: blank Variable Expression: $V{Discounts_Total} The Result: First row is blank, it should be $119.95 first and then so on and so on....... IDNAMEDISCOUNTS1FOOD[blank, should be 119.95 here and then so on... so on...]2FOOD SPCL119.953BEVERAGES0.004LIQUOR2.205BEER BTL15.306BEER SPCL2.507WINE0.008BEER DRAFT0.00TOTAL 139.95 Any ideas on why the value returns to the second row instead of first row? Thanks! ~a

Not sure if this will help, but have you done the following: 1. On Main Report, under "Orientation" did you select "Landscape" 2. Are your page width and height set to 792/612, with margin set to 20 Hope this helps!

I used a list component and re-structured my xml file to accomplish what I wanted to do. Ref: https://community.jaspersoft.com/questions/1101621/how-call-attribute-xml-file-and-use-it-condition-expression

No, not yet. But I went different direction and I got it to work. I used list component and restructed my xml file. Thank you for your reply.

Enter the following expression directly to the Text Field Expression (somehow using style doesn't work) $F{ot}.equals("1")?"<style forecolor='red'>"+$F{Shift}+"</style>":"<style forecolor='black'>"+$F{Shift}+"</style>"[/code]