Print Page | Close Window

Show Expected Income in Report

Printed From: Crystal Reports Book
Category: Crystal Reports for Visual Studio 2005 and Newer
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=11785
Printed Date: 21 Apr 2025 at 5:15am


Topic: Show Expected Income in Report
Posted By: pnini1000
Subject: Show Expected Income in Report
Date Posted: 05 Dec 2010 at 2:41am

Hi,

I have to do a report "Expected Income". this report display the future montly incomes for every client. Per month should be a column.
Each client has different number of months and the report  should grow  According to months.
 
how can I do it in crystal report?
 
Does anyone have an idea?
 
thanks,
pnini1000


Replies:
Posted By: lockwelle
Date Posted: 06 Dec 2010 at 4:20am
I would think that you would use a cross tab style report.
 
I haven't used them in crystal, but in ssrs, and probably in crystal, you want an entry for each column displayed, irrespective of if that entry actually has a value...so a entry with a null value is fine.
 
if you are joining straight to the tables, off-hand, I have no idea how to enforce this rule.  In a stored proc, you can just add the rows that are needed to make the report look correct.
 
HTH

Posted By: pnini1000
Date Posted: 12 Dec 2010 at 1:22am
Hi,
thank you but I need to create a crosstab from right to left (like Arabic or Hebrew letters).
Where the Row will printed on the right side and Total for each row will printed on the left side.

Is there any clues / tips / tricks / scripts that I can use to accomplish this task?

 
Perhaps you have another idea instead of crosstab?

Thanks in advance.
pnini1000


Print Page | Close Window