Print Page | Close Window

Getting duplicated data and cannot figure it out

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2022
Forum Name: Data Connectivity
Forum Discription: How to connect to data sources and export reports
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=16136
Printed Date: 21 Apr 2025 at 1:32pm


Topic: Getting duplicated data and cannot figure it out
Posted By: gloworm
Subject: Getting duplicated data and cannot figure it out
Date Posted: 10 Apr 2012 at 9:55am
I am using Crystal Reports XI and am having some issues getting correct data.  I think the tables are not joined correctly, but I do not have a resource to tap for help here.

I have asked if there is someone here that is more familiar with the tables and how they need to be joined and the answer was NO.

I created a Command table using this query file:///C:%5CUsers%5CGloworm%5CAppData%5CLocal%5CTemp%5Cmsohtmlclip1%5C01%5Cclip_colorschememapping.xml -



file:///C:%5CUsers%5CGloworm%5CAppData%5CLocal%5CTemp%5Cmsohtmlclip1%5C01%5Cclip_colorschememapping.xml -

file:///C:%5CUsers%5CGloworm%5CAppData%5CLocal%5CTemp%5Cmsohtmlclip1%5C01%5Cclip_colorschememapping.xml - -



Replies:
Posted By: CircleD
Date Posted: 11 Apr 2012 at 9:42am
If I understand what you're trying to do you can try to format the field and check the box "Suppress If Duplicated". Another thing you can try if it is your links,is place this formula  {table.field}=previous({table.field})  in the section expert formula field for " Suppress(No-Drilldown) ". The "table.field" will be the field you're getting duplicates in.


Print Page | Close Window