Report Design
 Crystal Reports Forum : Crystal Reports .NET 2003 : Report Design
Message Icon Topic: Sub Report + Main Report Problems URGENT Post Reply Post New Topic
Author Message
Maignanamurthy
Newbie
Newbie
Avatar

Joined: 20 Feb 2008
Location: India
Online Status: Offline
Posts: 3
Quote Maignanamurthy Replybullet Topic: Sub Report + Main Report Problems URGENT
    Posted: 20 Feb 2008 at 6:46am

Shocked
Hi Experts ,
I have one main report and two sub reports.
i had created One Group section in main report and i call the subreport1 from
group header section and subreport2 from group footer section.
The main report run successfully. sometimes it shows more than one pages
based on sql database records.

The Problem is,

The Two Sub reports having separate running totals. I had shared that parameters,
 then i called those from main report.
Now i want to add(addition) the sub report running totals, and show it as a
pagewise total in main report.

i add the two shared variables(subreport running totals) with the same name in main report
as formula named as netotal.
and paste this nettotal formula in main report page footer.

when the main report preview can contain multiple pages, the nettotal shows
the total amount in the last page only, but i want the pagewise total,

how can i solve this problem.

Awaiting Your Valuble Reply
With Thanks
Maignanamurthy.A
IP IP Logged
BrianBischof
Admin Group
Admin Group
Avatar

Joined: 09 Nov 2006
Online Status: Offline
Posts: 2458
Quote BrianBischof Replybullet Posted: 21 Feb 2008 at 6:42pm
I'm confused when you say that you have two subreport totals with the same name. If this is true, then one will overwrite the other and lose its value. If you give them different names, then the values will stay separated and the main report can add them together in it's subtotal. Another problem you could be having is that you might be initializing the variable to zero when you declare it. If so, then it will wipe out any previous value it had from the last time the subreport ran. Check on these things to see if they help.
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
Maignanamurthy
Newbie
Newbie
Avatar

Joined: 20 Feb 2008
Location: India
Online Status: Offline
Posts: 3
Quote Maignanamurthy Replybullet Posted: 05 Mar 2008 at 10:35pm
Hi Friend,
 
Now i am giving the different names for two sub reports total
and also initialize the both variables as Zero.
 
i add the two sub reports total in main report page footer.
but it doesnot show the page wise total,
it returns the total value in the last page only.
But i want the Page wise total
if its Possible?
Its Urgent...
Advance thanks
Awaiting Your Valuble Reply
With Thanks
Maignanamurthy.A
IP IP Logged
anandsmailbox
Newbie
Newbie


Joined: 20 Nov 2007
Location: India
Online Status: Offline
Posts: 2
Quote anandsmailbox Replybullet Posted: 11 Mar 2008 at 2:47am
Hi,
 
I hope this would work out..
 
1.create a Group header with the below formula on your 2nd sub-report (which was placed in the page footer of the main report) .
----------------
whilereadingrecords;
""
-----------------
 
2. Create a new section for the Group header and place the running total field in it.
 
3. In the Group section , select the 'Show group header on every page'
option.
 
 
IP IP Logged
OnAWingNAPrayer
Newbie
Newbie
Avatar

Joined: 24 Mar 2008
Online Status: Offline
Posts: 1
Quote OnAWingNAPrayer Replybullet Posted: 24 Mar 2008 at 7:50pm
Hello! I am new to CR and have a problem already. I am using a subreport to obtain a subset (like using sub query) of data that returns a date. The main report is responsible for conditions on calculating an amount of time that has passed for each record (like a query) it brings in. This needs to return a total amount of time PER record. If I only specify via the select expert one record ID, all is fine. However, when several records are processed, the totals are printed as one single number; I suppose it would be the last record's total. I need this to report per group of records specified in the group expert.
 
How do I get the report to post totals obtained from the main report per record and how do I get a final average time (in hours, by  the way) of all records?
Thank You!
IP IP Logged
me_kenny
Newbie
Newbie


Joined: 04 Dec 2009
Location: Malaysia
Online Status: Offline
Posts: 4
Quote me_kenny Replybullet Posted: 04 Dec 2009 at 5:06am
Has anyone have the solution to the problem mentioned by Maignanamurthy ? Mind sharing as im also stuck with the same problem.
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.