Click to See Complete Forum and Search --> : Datasets --- Reports


unspoken_words2003
May 29th, 2007, 03:33 PM
hi,
asp.net 2.0
c sharp web based appln

I am working on reports in c sahrp web based application.I am new to reports
so need some help.
I have populated two datasets.Can i use the both datasets in a single report
its doesn't work when i use both...What can be the solution???

Any help will be highly appreciated.

Kind Regards,
SY

mcmcom
May 30th, 2007, 02:22 PM
What Kind of reports are you using? MS Reporting Services or something like Crystal Reports.

Two Datasets can be used in a master / child scenario. However you have to add Key fields to both datasets to link them so data is not repeated.

Let us know what reports your using and we can be more specific. Also maybe you can be more detaied about how it does not work. ANy error messags you can tell us ?

hth,
mcm

unspoken_words2003
June 3rd, 2007, 07:34 AM
Hi..
I am working on Crystal Reports,tht come with VS 2005 package.
When i use the datasets independentlly,i.e if i use one dataset at a time, its diplaying the correct data.But when i try to use both of them at the same time,its not displaying anything.

In first dataset i have

Project Id
Project Title
Started Date
Expected Finish Date

In second Dataset i have

Update Details.(which can be multiple for each project)

I want to display the data i have in dateset 1 at the begging of the report followed by the Update Details..

I am executing both the queries for retriving into dataset at the print option.

whats the way out.

Regards,
SY

mcmcom
June 4th, 2007, 10:55 AM
have you read the crystal reports help on Master / Detail reporting?

You use one dataset for a master report, and then you can use one dataset for a child report (which would be the details). You link them by their key fields so only the data for the child that matches the parent shows up.

you should go to "businessobjects.com" and use their forums. They have crystal report specific forums and you will probably get someone who can answer your question a lot better there.

hth,
mcm