Re: Help required in VS.Net Crystal Report

From: Rick Rothstein (rickNOSPAMnews_at_NOSPAMcomcast.net)
Date: 02/28/04 

Date: Sat, 28 Feb 2004 14:08:37 -0500

Almost everybody in this newsgroup is using VB6 or lower. While you may get
a stray answer to VB.NET questions here, you should ask them in newsgroups
devoted exclusively to .NET programming. Look for newsgroups with either the
word "dotnet" or "vsnet" in their name.

For the microsoft news server, try these newsgroups...

microsoft.public.dotnet.general
microsoft.public.dotnet.languages.vb
microsoft.public.vsnet.general

There are some others, but these should get you started.

Rick - MVP

"RJN" <rjn@yahoo.com> wrote in message
news:%23HSvcvi$DHA.3220@TK2MSFTNGP10.phx.gbl...
>
>
> Hi
>
> I'm new to VS.Net Crystal Report. I'm using data sets as the source for
> crystal report. I've a dataset which has 2 data tables. The first
> table's schema is like this
>
> Ptid String
> Prid String
> Chid String
> PtName String
> Count int
>
> The columnc Ptid, Prid and Chid are the primary key columns
>
> The second table's schema is like this
>
> Prid String
> Chid String
> Prtext String
> Chtext String
>
> The columnc Prid and Chid are the primary key columns
>
> There is foreign key relationship between Prid and Chid between the
> tables.
>
> My report is something like this.
> I want to group based on Ptid and Prid and for each of these matching
> values I want a list of Chid and Count.
>
> Ptid1
> Prid1
> Chid1 100
> Chid2 0
> Prid2
> Chid1 0
> Chid2 400
>
> Total 500
>
> Ptid2
> Prid1
> Chid1 300
> Chid2 0
> Prid2
> Chid1 600
> Chid2 0
>
> Total 900
>
> I'm able to set up the dataset as the source to the crystal report. When
> I add the tables, Crystal report links the tables and identifies the
> relationship.
>
> But I'm not able to get the list of all chid's for a given Prid.
>
> My report looks something like this
>
> Ptid1
> Prid1
> Chid1 100
> Prid2
> Chid2 400
>
> Total 500
>
> Ptid2
> Prid1
> Chid1 300
> Prid2
> Chid1 600
>
> Total 900
>
> Can somebody help me how will I be able to get such a report. Is there
> any possibility of saying
>
> select chid from table2 where table2.prid = table1.prid
>
> Any help is highly appreciated.
>
> Regards
>
> RJN
>
>
>
>
>
>
>
>
>
>
> *** Sent via Developersdex http://www.developersdex.com ***
> Don't just participate in USENET...get rewarded for it!