Is this possible in 8.5?

[yehong]

Here is the report layout that is desired by my client. Need to find out if there is a way to lay out the report in this format and any idea how to do it.

Project1 Project2 Project3

Begin Date: 01/05/04 01/01/03 04/24/02
End Date : 03/05/04 06/01/03 07/02/02
Fund Amount: $5000 $3000 $3400
Proj Mgr: Fname,Lname Fn,Ln Fn,Ln
====================================================
Totals: $5000 $3000 $3400

There are still four more fields.
The relation is 1 to 1 of a Project name to other fields.
Like Project1 has one beging and end date,one funding amount, one project manager and etc.
I tried to use crosstab but it didn't help.
If I knew there was only three projects then I could have created three subreports and drop em on the main report. But unfortunately it will undetermined as to how many projects will print on the report. I guess maximum no. of projects is less than 10.
Hope you guys have an idea what I am trying to do here

 

[synapsevampire]

You'd probably use multiple formulas/aggregates to get the data in that layout, but you'd need to share the tables layout for those fields for anyone to advise you correctly.

-k

 

[Ngolem]

depending on the layout and how much data was involved this is easy enough creating a manual crosstab using Arrays to store the information to be printed in the report or a group footer.

A lot more details are required for something more definate

Jim Broadbent

The quality of the answer is directly proportional to the quality of the problem statement!

 

[vidru]

You should be able to do it in a cross-tab. Just put in your data fields for the columns (no rows), add the FundAmt as your summarized field, then suppress all of the subtotals on the Customize Style tab(except for the FundAmt). Then, all you'll have to do is manually add your labels to the left of the grid...

... works for me anyway .

p.s. I had to make the Amt field the last column field to get it to work right.

-dave

 

[yehong]

Thanks for all advises. So far I have tried Vidru's solution and it has worked perfect.

Thanks

 

[synapsevampire]

Hmmm, I guess I thought that the totals would be a problem in a crosstab, glad that it worked.

-k

 

[pgmr]

Hi,
CR 8.5 ODBC connection to AS400
I created a Trial Balance report
Debits and Credits as columns.
Debit is a calculation for each GLminor, GLmajor ,GLaccount :
If {?Period} = 1 and {MSTGL.GYEAR} = {?year} then
Abs ({MSTGL.GD01}) - Abs ({MSTGL.GC01})
else
If {?Period} = 2 and {MSTGL.GYEAR} = {?year} then
(Abs ({MSTGL.GD02})-Abs ({MSTGL.GC02}))+
(Abs ({MSTGL.GD01})-Abs ({MSTGL.GC01})) and so on...
Credit colums is the same calculation.
I suppress debit if <0 and suppress credit if >0.
That works fine.
Now I need a report which has a column of debits and credits for period 12 of year 2002 (hardcoded)
in addition to my columns listed above for each account.
My problem is these don't apear on the same row for each detail record. I get the period 12 yr 2002 debit or credit then the next row has the {?period} {?year} debit or credit. I need them in the same row and I am going to want to add them together for each detail record.
Is this possible?
Report would look like this
Dec 2002 {?period}{?yr} Total
GMAJ GMIN ACCT DESC DEB CRED DEB CRED DEB CRED
Thanks in advance

 

[vidru]

You should probably start a new thread. And try to clarify your description a bit, e.g. table structure, linking (if data is coming from more than one table), expected output (real values, not just headers), etc...

-dave

 

[yehong]

You can also chekc the Underlay Following Sections in format Section window for your detail sections.

 

[kishorsp]

Hi alansaw,
Glad that ur problem is solved. But does anyone know how to do the same if the rows as well as the columns were dynamic. I mean something of this sort:

User | Project_1 | Project_2 | Project_3 ... Total
----------------------------------------------
John | 10 20 08 28
Mac | 08 06 04 18
.
.
.
----------------------------------------------
The figures under the project columns are, say,
hours worked on the project.

 

[yehong]

Hi Kishorsp,
I did that in a cross tab. I did not add any fields in the Rows section of the cross tab. I added all fields in the columns section and one summary field in the Summarized Fields section. I think in your case you would need to add User as a Row and rest of the fields in the Columns section.
Just try this. Play with the cross tab and you would be able to find a way hopefully.

 

[kishorsp]

Thank you alansaw. I'll surely give it a try today and will
post the details here.