Trimming of Data
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=897
Printed Date: 04 May 2024 at 9:39pm
Topic: Trimming of Data
Posted By: siktui82
Subject: Trimming of Data
Date Posted: 20 Jun 2007 at 11:20pm
Hi, based on above captures, how do i trim away repeated data in the columns? |
Replies:
Posted By: redeyeball
Date Posted: 20 Jun 2007 at 11:57pm
|
Have you tried inserting a group section and moving your details in details section to the group ? |
Posted By: siktui82
Date Posted: 21 Jun 2007 at 8:53pm
if i move everything to group. it will show only
but my others details will truncated. |
Posted By: redeyeball
Date Posted: 22 Jun 2007 at 12:11am
| O now I see, doh! Maybe try to see if you can change the data (SQL query) thats comming from DB. |
Posted By: __Yuri__
Date Posted: 24 Jun 2007 at 1:53am
|
I write suppress formating formulas. You can use IF to compare your values with global vars, previous(), isnull({...}) and so on... for instance: if Date({DM_ACTIVITY.time_from}) = Date(Previous ({DM_ACTIVITY.time_from})) and {DM_ACTIVITY.activity_code} = Previous ({DM_ACTIVITY.activity_code}) then true else false; ------------- One, two, Freddy's coming for you... |
Posted By: siktui82
Date Posted: 25 Jun 2007 at 2:22am
|
thanks for all the idea, i use cross tab reports to show remove dup data. :) btw, i working on view on SQL. can anybody help? wanted to create a view to store create a temp table and store data. CR will pull data from the temp table. Can this work? |