reporting tool... group by problem..

[LinuXelite]

Hi!!
check this out:

http://www.nor-web.ca/screen1.png

http://www.nor-web.ca/screen2.png

funny heh? Lets me explain..

I wanna do a multi-group by report.

So I designed something like..
SQL= select * from table group by year, month, day order by date (mysqlcomponent)

In rave 5, I started a blank report with:
page1
REGION
band (key=year) (controlledband=databand1)
band (key=month) (controlledband=databand1)
databand (day)

The output is:
new: 2002
june
detail1
detail2
novembre
detail1
new: 2001
detail1 (I should see november... and then detail)
detail2
august
detail1
detail2

new:
detail1 (I should see 2001 and then august...... and then detail)



Can you help me?

 

[LucieLastic]

Sorry I haven't used Rave but I've used Crystal which has similar grouping. Are you sure you don't have a 'suppress when duplicated' type flag enabled for this field?

Also, if it is like crystal, all the grouping should be handled in the report (with your layout) so you may be able to take the Group by function out of the SQL as it may be ignoring it.

Sorry I'm not more helpful.

lou

 

[LinuXelite]

nop I dont have that.

Im completly discouraged...

 

[LinuXelite]

I CANT BELIEVE noone can help me with this issue!!!

Nobody use Rave report? You never done many group by report?
Come on....

 

[LinuXelite]

Hi! Yes, they answered it. The problem was with the Band 2: the groupkey should be Country + State. Here is how they answered it:



Standard Band 1 - Controller: DataBand, Style Group Header, GroupDataView:
MyDataView, GroupKey: Country
Standard Band 2 - Controller: DataBand, Style Group Header, GroupDataView:
MyDataView, GroupKey: Country + State
DataBand - DataView: MyDataView