Using a variable in a report

[Michelle D.]

Does anyone have any clever workarounds so that you can actually "use" a
variable in a report (for things like sorting, totaling, data selection,
etc.)? I'm most interested in the best way to handle the following example:

I have a variable called PickMonth which is fiscal year and fiscal year
period concatenated. I need to total by PickMonth. In the following,
PickMonth 210 equals October, 2002 and so on.

Item No. PickMonth Dollars
12345 210 2,500
67890 210 5,000
Total 7,500
44433 211 3,000
Total 3,000
99654 212 6,000
93535 212 3,400
Total 9,400

The "Total" lines are what I need. Not sure how much difference it makes,
but I am sequencing on DCTO, PDDJ, LITM and page breaking on DCTO.

Thank you in advance for any ideas!

Michelle Dulay
ERP Coordinator
Pump & Engine Control Systems
Goodrich Corporation
[email protected]

LIVE ON:
OneWorld Xe, SP 18.1, Update 2
ESU JD10371, JD10833, JD11176, JD12367
Windows 2000 Deployment / Enterprise
SQL 2000

 

[CHo]

I see your problem.

The tabular section won't work because the totals are based on level breaks in data sequence.

If I remember correctly, subtotalling in the group section has to be on business view field. OW only allows for one level break in group section.

I'm afraid that it's going to be good old fashion programming.

You can try to subtotal first by the year, then do another subtotal by the month. (Thinking from the top of my head.)

C Ho

Xe SP 15.1, update1
AS/400 V5R1 coexistant
CO on SQL 7.0 SP2 + hotfix

 

[aoanta]

Also, on my previous post, I forgot to tell you that the driver section
would be a columnar and the custom would be a group (I guess in your
original report you were using a tabular, which will NOT work for custom
sections)

Adrian