Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: Cross Tab 2008 Design Issue Post Reply Post New Topic
Author Message
myway
Newbie
Newbie


Joined: 02 Apr 2009
Online Status: Offline
Posts: 2
Quote myway Replybullet Topic: Cross Tab 2008 Design Issue
     Posted: 02 Apr 2009 at 7:13am
May I know is it possible to create something like that :
 
Date  Item   Quantity     Price   Amount     Total
xxxx |  xxxx | 9999     |  9999 | 99999   |  99999 
        |  xxxx | 9999     |  9999 | 99999   |  99999
        |-----------------------------------------------------
        |             {@Remark}      Sub Total|  99999
-------------------------------------------------------------
xxxx |  xxxx | 9999     |  9999 | 99999   |  99999 
        |  xxxx | 9999     |  9999 | 99999   |  99999
        |-----------------------------------------------------
        |             {@Remark}      Sub Total|  99999
-------------------------------------------------------------
                                           Grand Total|  99999
----------------------------------------------------
 
I have difficulties to put the remark ({@Remark}) that according to the date value. Can anyone please help me CryCry.
 
Or is there any other suggestion to achieve some result like tat on Cross Tab? Thanks in Advance.
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 02 Apr 2009 at 7:46am
I don't think you can get a formula that will change based on the date into the crosstab (unless you use it as grouping field which is not what you want).
Perhaps you mimic the above by grouping, using your sum and COunts functions, moving those to Gheaders and then suppressing groups headers as needed. hard to tell as I do not know what each of the columns are doing exactly in your description above.
If you "Remark" is based on data changes another odd option is to move you crosstab into the group header level and try to play with the formatting This would allow you to drop the formula into the sub total text field and it would change per group (because it is a new crosstab per group) but it will mess up your final total as well as repeat your headers on each group.
Just a couple of suggestions to mess with to see if can make this work.
IP IP Logged
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