date ranges

[qwertyu1]

Hello all,

I am using ceystal reports xi and oracle 9i.

iam using table like :fr_planning_schedule

i have database fields like:
schedule_year, schedule_acres,schedule_timber.

parameter field:schedule_prop.


i would like to see report as below.

schedule_year : schedule_acres
2007 : 56756
2008 : 481
. .
. .
. .
. .
. .
2021 : 27678

group by: schdule_year

the above schedule_acres is sum of total acres for that perticular year (i.e 2007) .

and exactly beside i would like to see one more report like:

schedule_year : schedue_timber : schedule_ACRES
2008 A 256
2008 C 100
2008 H 125

TOTAL 481

TOTAL SHOULD MATCHES ABOVE 2 REPORTS FOR EACH PERTICULAR YEAR.

AND I WOULD LIKE TO SEE ALL THE YEARS UP TP 2021 (i.e 2007 to + 15 yrs(2021))

can we use sub report for this.
help me.

 

[lbass]

Yes, if you group on schedule year, you can then place a subreport in the group header that is linked to the main report on schedule year. If you have any selection criteria in the main report, you would want to add the same selection criteria to the subreport.

-LB

 

[qwertyu1]

ok thanks.

can you tell me , how i can get schedule year 2007 to 2021.

bcoz , i have data in database up to 2091.

 

[synapsevampire]

In the Report->Select Formula->Record place:

{table.year} in year(currendate) to year(currendate)+15

This will allow for going forward as well.

-k

 

[qwertyu1]

thanks

 

[qwertyu1]

i tried the same way as u said, but in the subreport i am getting data for all the years continuously.i.e for 2007
in main report , iam getting data for all years in subreport.

i would like to see data as below:

(main report fields) (sub report fields)
s.year acres_amt s.year s.type acres_amt
2007 576 2007 A 230
2007 B 146
2007 C 200

total: 576

is this possible, can we see data each year.if so please let me know.thanks.

 

[synapsevampire]

that has to do with how you are LINKING the subreport to the main report, make sure that you join by the year field and have a year group in the main report and place the subreport in the year group header or footer.

-k

 

[lbass]

Link the subreport to the main report on the schedule.year field.

-LB

 

[qwertyu1]

i linked with year field and i created group on year field in main report and i placed sub report in group header of main report.

and i disabled option on left hand side corner below
" select data in subreport based on field" in sub report linking screen. do i enable this option please let me know thanks.

 

[lbass]

No, don't disable it. Enable it and choose {table.schedule year} for the subreport field.

-LB

 

[qwertyu1]

do i need to supress any sections in the subreport.

i placed fields in details section.and i have parameter like prop_code.i created parameter in both reports.