about report

[qwertyu1]

hello all

I am using crystal xi and oracle9.

my question is?

I have a report on that i need to see data like below .



i have a colums like:

timber base past present future
text year acres acres acres
forest: ab 1977 30 54 55
ac 1977 15 17 17
ad 1977 12 12 12

tot 57 83 84


(note: for this data i used record selection formula like
FR_TIMBER_TYPE.FOREST_FLAG="F")



nonforest: ba 1977 11 10 10
bc 1977 12 10 11

total 23 20 21


grand total 80 103 105

(note: for this data i used record selection formula like
FR_TIMBER_TYPE.FOREST_FLAG="x")



forested and non-forested fields are just text fields. and other field ares database fileds.coming from

DATA BASE view :fr_recon_past,prest,futrue
DATA BASE TABLE :fr_TIMBER_TYPE

i am getting only forest type data and non forest type data
in two differt reports. but i need to see one below the another. and grand total on same page.

how i can get? please help me

thanks.

 

[lbass]

Change your record selection to:

{FR_TIMBER_TYPE.FOREST_FLAG} in ["x","F"]

Then insert a group on {FR_TIMBER_TYPE.FOREST_FLAG} and insert summaries at the group level.

-LB

 

[qwertyu1]

I did the same thing as you said above.
but am not getting the result as i want.

in data base view the past, present and future acres amt fields are not detailed level those are group levl .


is that the reason am not getting the result.

 

[lbass]

Make sure that the new group is your group #1. You shouldn't have to change your report in any other way, except to insert totals at the new group level.

-LB

 

[ForMe2]

If I'm understanding this correctly, you could create a subreport for the non-forest & insert it into the forest report. In order to get the grand total, you would have to add the forest & non-forest together. For the non-forest subreport total to show & allow you to add it to the forest total, you would do the following:

In the subreport insert this formula:
WhilePrintingRecords;
Shared NumberVar myTotal:=Sum({Field1})

In the main report insert this formula into the SECTION below the subreport's location:
WhilePrintingRecords;
Shared NumberVar myTotal;
myTotal

You should then be able to add the 2 together. I hope this isn't too confusing.

 

[qwertyu1]

thanks.
can u tell me where should i place subreport in main report. and do need to link the subreport to main report
i got a one parameter field.do i use this field to link
subreport to main report,and where should i place subreport formula in section expert.

 

[lbass]

I don't see any need for a subreport. If you have an existing report as shown in your first post, say for flag = "F", then all you need to do is change the record selection formula and insert a group on the flag field. Then go to the group expert and use the arrow key to make the flag field your first group. This will automatically give you the results you want. All that's left for you to do is to right click on the detail fields and insert summaries at the Group #1 level. You already have the Group #2 summaries and grand total summaries.

-LB

 

[qwertyu1]

thanks