Stop data duplication in crystal report

Question

0.00/5 (No votes)

See more:

Look at this query :
select sp.MaintenceCode, sp.MDate, sp.PDes,sp.SPCode, s.SpareParts, em.EmpName as MaintainedBy, md.MachinaryName, sp.SPMCode from tblDailyMaintenceDetails dm inner join tblEmployeeInformation em on em.EmpCode=dm.EmpCode inner join tblSparePartsMaintenance sp on sp.MaintenceCode=dm.MaintenceCode inner join tblSpareParts s on s.SPCode=sp.SPCode inner join tblMachinaryDetails md on md.MDCode=dm.MDCode where md.MDCode='MDP-000001' and sp.MDate='15-May-2013'

The result of this query is :

MaintenceCode MDate      PDes      SPCode   SpareParts  MaintainedBy   MachinaryName  SPMCode
____________  _____     ____       ______     __________  ___________   ___________  _______
DMC-002	     2013-05-15  bad	   SPC-000002 Cable	   HASNA BEGUM	  Toshiba SPM-000002
DMC-002	     2013-05-15  not good  SPC-000001	Motor	   HASNA BEGUM	  Toshiba SPM-000004

I have to show this query in Crysta report. Here MDate means Maintenance date of a Spare parts. If two spare parts is Maintained in the same date then the two spare parts will be shown in crystal report seperating by a comma. But other columns duplication should be stopped. Please give me a proper solution. I also want to mention that I use ADO.NET to create crystal report.

Posted 8-May-13 0:12am

Sumon562

Updated 8-May-13 0:30am

Aarti Meswania

v3

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Aarti Meswania · Answer 1 · 2013-05-08T00:23:00

insert group of you date field in report

now in create 3 formulas
1. Reset_SpareParts //Put in Header-section of Date group //Suppress it

VB

Global StringVar Sp
SP:= '';

2. Merge_SpareParts //Put in Detail section //Suppress it

VB

Global StringVar Sp
SP := SP + ',';

3. Print_SpareParts //Put in Footer-section of Date group

VB

WhilePrintingRecords;
Global StringVar Sp
SP;

Now, drag-drop other Comman fields in Footer-section of Date group
...MaintenceCode, MDate, Print_SpareParts , MaintainedBy, MachinaryName.

Happy Coding!
:)