Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: Date restriction for Balance Sheet Post Reply Post New Topic
Author Message
desiree
Newbie
Newbie


Joined: 08 Aug 2007
Online Status: Offline
Posts: 3
Quote desiree Replybullet Topic: Date restriction for Balance Sheet
    Posted: 08 Aug 2007 at 1:19pm
I have developed several financial statements in CR 10.  I need to put a date restriction in so that I can have the data cut off as of the end of the month.  I am using the memo balance field for most of my data and it updated in real-time from the database.  This causes a problem at month end because when I refresh my report, I have current data mixed in with month-end data.  Can someone PLEASE help me figure out how to put this limitation on here so that I can run reports for a specified period.
 
Thank you in advance.
 
Desiree
IP IP Logged
BrianBischof
Admin Group
Admin Group
Avatar

Joined: 09 Nov 2006
Online Status: Offline
Posts: 2458
Quote BrianBischof Replybullet Posted: 08 Aug 2007 at 3:55pm
I've run into this before. You need a way to determine which fields are flagged as month end transactions. Is there a field that specfies this? Maybe a particular account range? Maybe the Description always starts with "Month End"? Something like that. Then you can filter out those transactions from your report.
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
desiree
Newbie
Newbie


Joined: 08 Aug 2007
Online Status: Offline
Posts: 3
Quote desiree Replybullet Posted: 08 Aug 2007 at 4:01pm
No, unfortunately there are no differences in the accounts.  All transactions go into the accounts, in my case objects, whether they are regular or month end transactions.  I have the mb.period field, but I have not found a way to write a parameter to use it correctly.
 
Thanks!
IP IP Logged
BrianBischof
Admin Group
Admin Group
Avatar

Joined: 09 Nov 2006
Online Status: Offline
Posts: 2458
Quote BrianBischof Replybullet Posted: 08 Aug 2007 at 9:57pm
Bummer. What about an account range? Like a closing account or a summary account. Make a list of those and filter them out.
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
desiree
Newbie
Newbie


Joined: 08 Aug 2007
Online Status: Offline
Posts: 3
Quote desiree Replybullet Posted: 13 Aug 2007 at 3:42pm
No such luck.  The only thing that seperates the data is the field name differences "b_cy_memo_bal" vs. "b_ny_memo_bal"
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.031 seconds.