Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: Help me in the Report design-Monthly expenses Post Reply Post New Topic
Author Message
pritamdas24
Newbie
Newbie
Avatar

Joined: 30 Jul 2007
Location: India
Online Status: Offline
Posts: 24
Quote pritamdas24 Replybullet Topic: Help me in the Report design-Monthly expenses
    Posted: 16 Aug 2007 at 9:51am
Hi
i am using CR XI.
i have a table in oracle Tab1 having column Invoice Date and amount
user will input from date and to date as parameter.
 
i want the sum of the amount month wise
 
i want in my report  like this
 
supppose user selects Jan/07 to mar/07
 
report should look like below
 
Prior month        sum prior month exp        current month      sum current month exp
 
Jan/07                   100                                feb/07                    200
 
feb/07                    200                               mar/07                    300
 
 
Please help me to design this report.
 
 
Regards
Pritam
IP IP Logged
BrianBischof
Admin Group
Admin Group
Avatar

Joined: 09 Nov 2006
Online Status: Offline
Posts: 2458
Quote BrianBischof Replybullet Posted: 20 Aug 2007 at 10:40pm
I have no idea how to design this in CR. I would use .NET to create a custom datasource the provides the data in the way you want.

Does anyone have any ideas for this one?
Please support the forum! Tell others by linking to it on your blog or website:<a href="http://www.crystalreportsbook.com/forum/">Crystal Reports Forum</a>
IP IP Logged
yggdrasil
Senior Member
Senior Member
Avatar

Joined: 19 Jun 2007
Location: United Kingdom
Online Status: Offline
Posts: 150
Quote yggdrasil Replybullet Posted: 21 Aug 2007 at 5:33am
Could you use shared variables to transfer the fields into a report footer where you could place them wherever you want.?
IP IP Logged
BrianBischof
Admin Group
Admin Group
Avatar

Joined: 09 Nov 2006
Online Status: Offline
Posts: 2458
Quote BrianBischof Replybullet Posted: 21 Aug 2007 at 8:29am
Hmmm.... I'm also thinking that you could use the PreviousValue() and NextValue() functions so that the data from two records could be printed in one detail section. Of course, you would have to skip the first record being printed by testing for PreviousIsNull().
Please support the forum! Tell others by linking to it on your blog or website:<a href="http://www.crystalreportsbook.com/forum/">Crystal Reports Forum</a>
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.016 seconds.