Grand Total
Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
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=20706
Printed Date: 01 May 2024 at 9:05pm
Topic: Grand Total
Posted By: Kitty1
Subject: Grand Total
Date Posted: 05 May 2014 at 10:20am
Hello, I am stuck on something that probably has a simple solution but I'm just not getting it.  I wrote a report to pull out only a certain account from the G/L detail, also i have parameter fields with first date and last date, and I'm pulling only records between those 2 dates. Everything is working fine, except when I try to add a Grand Total summary at end of report, it looks like it's pulling every single record for the sales account (the whole year)
|
Replies:
Posted By: praveeng
Date Posted: 05 May 2014 at 10:23am
|
Hi, In record selction write the logic as below {table.datefield} >= {?Paramter1} and {table.datefield} <= {?Parameter2} --Praveen G ------------- Praveen Guntuka, praveen_guntuka@yahoo.com |
Posted By: Kitty1
Date Posted: 05 May 2014 at 10:36am
| Hi, thank you for your reply. I tried that and it's still not working for me. :( |
Posted By: DBlank
Date Posted: 05 May 2014 at 12:06pm
| when you add the sum is it a field from another table (a joined table) |
Posted By: Kitty1
Date Posted: 06 May 2014 at 11:10am
| Hi, thanks. I scrapped that report and started a whole new report, pulling from a different table and it's working fine now. Don't know what I did wrong...thanks so much for your replies! |