text field filter expressions and multiple bands

[rajuchacha007]

Hello all,

 

I am newbie to ireport 3.7 (or any other version). I have designed a report based on a mysql database connection. I am sure there is no problem in the query. I am able to display data values from table. Now I do have field called description. Description itself contains data/value. I want to group the records based on the description field. I hope I am clear to highlight on the problem. I will elobarate this with the example.

This is my query.select
riamp_data_profile.ID,riamp_data_profile.RULE_CODE,riamp_data_profile.PARAMETER,riamp_data_profile.COLUMN_NAME,riamp_data_profile.RULE_MESSAGE,riamp_data_profile.STEP_RUN_ID,description
FROM riamp_data_profile,dp_rules where riamp_data_profile.RULE_CODE=dp_rules.CODE order by riamp_data_profile.ID

I am getting following table

 

1. Check if data contains only alphabets. ( isAlphaTypeData <([a-zA-Z])> )

Processing_Date:          0 of 100000 records satisfy the rule.
--------------------------------------------------------------------------------------------------

2. Check if data satisfies given pattern. ( checkPattern <2003([0-9])> )

Account_Number:           0 of 100000 (0.0%) records satisfy the rule.

------------------------------------------------------------------------------------------------------
3. Check if data satisfies given pattern. ( checkPattern <2003([0-9])> )

Processing_Date:          100000 of 100000 (100.0%) records satisfy the rule.
-------------------------------------------------------------------------------------------------------

4. Get the maximum value of the column. ( maxValue )

Check_Amount:             Maximum value is 1500        
--------------------------------------------------------------------------------------------------------

5. Get the maximum value of the column. ( maxValue )

Tran_Code:                Maximum value is 701        

--------------------------------------------------------------------------------------------------------- 

6. Get the minimum value of the column. ( minValue )

Check_Amount:             Minimum value is 1           
----------------------------------------------------------------------------------------------------------

7. Get the minimum value of the column. ( minValue )

Tran_Code:                Minimum value is 0          

---------------------------------------------------------------------------------------------------------- 

and I wish to display in following way.

1. Check if data contains only alphabets. ( isAlphaTypeData <([a-zA-Z])> )

Processing_Date:          0 of 100000 records satisfy the rule.
--------------------------------------------------------------------------------

2. Check if data satisfies given pattern. ( checkPattern <2003([0-9])> )

Account_Number:           0 of 100000 (0.0%) records satisfy the rule.
Processing_Date:          100000 of 100000 (100.0%) records satisfy the rule.
--------------------------------------------------------------------------------

3. Get the maximum value of the column. ( maxValue )

Check_Amount:             Maximum value is 1500        
Tran_Code:                Maximum value is 701         
--------------------------------------------------------------------------------

4. Get the minimum value of the column. ( minValue )

Check_Amount:             Minimum value is 1           
Tran_Code:                Minimum value is 0           
--------------------------------------------------------------------------------

5. Get the average value of the column. ( avgValue )

Check_Amount:             Average value is 391         
Tran_Code:                Average value is 347   

In short, I am trying to group data of the data. Does anyone know solution about this? Has anyone done similar thing before?

I will welcome your advices/suggestions/ideas. Thanks in advance.

 

Best regards.

[rajuchacha007]

Guys,

 

Has anyone worked on similar task? I am looking for your suggestions and ideas. Is it posible to use group by clause on data of the data?

 

Best regards.