Re: Need Help with Reports 2.5

1. Create a summary column (use the tool marked with sigma from the data model) for EACH of the columns you want to total - for report level totals the summary columns should be on the data model, outside of all the queries

CS_sum_column1      SUM of COLUMN1, reset at REPORT
CS_sum_column2      SUM of COLUMN2, reset at REPORT
CS_sum_column3      SUM of COLUMN3, reset at REPORT
CS_sum_column4      SUM of COLUMN4, reset at REPORT

Display the values of the totals in field outside of all the repeating frames in the layout editor.

2) I'm not sure exactly what you want here - what distinguishes the rows of the report ? i.e. why do the values 10 6 16 0 5 5 0 0 0 0 0 0 appear on the second line, not on the first ?

Looks like this could be achieved using either a matrix report or a complicated decode statement

HTH,
Steve

dwarakv_at_hotmail.com wrote:

>Hi,
> I am kind of new to reports 2.5. I have a couple of questions.
 

>1) I have created a report with number of columns and the values in them are
>for e.g.
 

> column1 column2 column3 column4
 

> 1 15 18 100
> 4 10 19 73
> 6 17 33 57
 

>I need to generate the totals for all the four column at the bottom which
>should read as
 

>Total 11 42 70 230.

>2) My second question is that I need to create a report which shows data for
>all the 12 months in a year. Suppose, I give in a date as a parameter(for
>e.g. 1st of May(05/01/98)), I should have values for the period from jan'98
>to april '98 and 0 for may'98 to dec'98. I need to display all the 12 months
>or atleast the the preceeding two months and the following two months when I
>view/print my report.
 

> Mar Apr May Jun
>col A B tot col A B tot col A B tot col A B tot
>5 7 12 6 0 6 0 0 0 0 0 0
>10 6 16 0 5 5 0 0 0 0 0 0

> I am totally clueless abt how I would tackle these issues. Can someone out
>there help me, please.
 

>Thanks
>Dwarak
 

>-----== Posted via Deja News, The Leader in Internet Discussion ==-----
>http://www.dejanews.com/ Now offering spam-free web-based newsreading
Received on Wed May 13 1998 - 00:00:00 CDT