how to combine report group resaults in on line horisontaly

[dzavad]

I have report in CR9 that consists of one group called "Region" and all I do is displaying region Name of each group Verticaly in the report.
Ex:
Group1 = TableA.RegionID TableA.Region_name
1 Vancuver Coastal
4 North
5 Fraser
Is it posible to display all the selected reagions in horisontal Line?
Ex:
Footer: Vancuver Coastal, North,Fraser

 

[synapsevampire]

So in the Group Footer you want ONLY the Region Names, not the Region IDs?

You can drop a Cross-tab in the group footer.

Or you can collect up the names in a formula:

group header
whileprintingrecords;
stringvar Regions:="":

details
whileprintingrecords;
stringvar Regions:=Regions+{table.region_name}+", "+:

group footer
whileprintingrecords;
stringvar Regions;
left(Regions,len(Regions)-2)

-k

 

[dzavad]

Hmmm...Let me try it...thanks

 

[lbass]

I think you mean you want a list for the report as a whole. You would need to eliminate SV's reset formula, and then display his last formula in the report footer.

-LB

 

[synapsevampire]

I think LB is correct in rereading your post.

Either use a cross-tab in the report footer or if using the formula method, nuke the Group header formula and just use the details formula, and move the group footer formula to the report footer.

-k

 

[dzavad]

it worked fine thank you .
i used only two formulas as per lbass and it do the job..
Tahnk you synapsevampire and lbass .

 

[sat6845]

Hi.

I need to put this information in the cross tab.

After calulating here is the data looks in the detail.

ITEM|Received Date - Approved in week - Despatch within week
xx 1/1/2005 2 4
x1 1/2/2005 1 1

Approved in week:
Datediff("W" Received_date,Approved in week)
despatch("w" Received_date,Despatch in week)

The requirement is get the count for the week1 how many got dispatch once the order got received and approved with 1 week or 2 week or 3 week. I need count for...

I need to get the cross tab like this.

WEEK 1 - Week 2 - Week 3 - Week 4
Aproved 2 1 1 1
despatcvh 1 2 1 2


Is this possibbe in cross-tab.

Thank you.

sat