p2p.wrox.com Forums

Need to download code?

View our list of code downloads.


  Return to Index  

crystal_reports thread: Distinct Values in sub report


Message #1 by =?iso-8859-1?q?chinna=20thirummorthy?= <cthirumoorthy@y...> on Sun, 10 Nov 2002 13:51:20 +0000 (GMT)
Friends


I am using vb6,crystal report 7 and sql server 7 .
I am having a main report and sub report in report.

I am having only one field in subreport and many
fields in main report.I have linked
the sub report with the main report

I am getting the report as expected.In some report the

values for field in sub report will be more than 3 or 
4 based on the main report field values.

In some cases the value of field in sub report will be
duplicated
based the values of field in main report. To avoid
this i have
format the field and checked the check box suppress if
duplicated.

Because of this if i have 3 values in sub report and
first and
second values are same then it prints first
value,blank spaces(as
suppress if duplicated is enabled),and third value.i
want to
avoid this blank spaces and print only distinct values
in sub report.

I want your help and guidance to achieve this

cthirumoorthy









________________________________________________________________________
Missed your favourite TV serial last night? Try the new, Yahoo! TV.
       visit http://in.tv.yahoo.com
Message #2 by Sigi Jose <sigi_jose@y...> on Mon, 11 Nov 2002 03:53:40 -0800 (PST)
Hi 
 To avoid the blank lines, Right click on the desired section, Click on "Format Section" & check the option "Suppress blank
section" .
Hope this will help u
Regards 
Sigi Jose
 chinna thirummorthy <cthirumoorthy@y...> wrote:Friends


I am using vb6,crystal report 7 and sql server 7 .
I am having a main report and sub report in report.

I am having only one field in subreport and many
fields in main report.I have linked
the sub report with the main report

I am getting the report as expected.In some report the

values for field in sub report will be more than 3 or 
4 based on the main report field values.

In some cases the value of field in sub report will be
duplicated
based the values of field in main report. To avoid
this i have
format the field and checked the check box suppress if
duplicated.

Because of this if i have 3 values in sub report and
first and
second values are same then it prints first
value,blank spaces(as
suppress if duplicated is enabled),and third value.i
want to
avoid this blank spaces and print only distinct values
in sub report.

I want your help and guidance to achieve this

cthirumoorthy









________________________________________________________________________
Missed your favourite TV serial last night? Try the new, Yahoo! TV.
visit http://in.tv.yahoo.com



---------------------------------
Do you Yahoo!?
U2 on LAUNCH - Exclusive medley & videos from Greatest Hits CD

  Return to Index