My application allows the user to enter Invoice Info into an SQL database.

When the user starts the app. the dataset Invoice_DS is loaded with all pertinent info about current Invoices.

at any given time there are about 200 - 300 invoices in this dataset. The dataset is also made up of 7 tables.

Header, Details, and supporting tables.

When the user is finished entering the data she needs to print a copy of the invoice.

I have tried to print using the Invoice_DS dataset just to see if I am getting some data out. I realize there are a few hundred records there and I eventually only want to print the Invoice that the user is currently viewing.

I tried using the following code to print using a Dataset. But I only get a blank layout of the Invoice Printout.

tattoo

Did you add a data set(typed dataset) to your project.The structure of this dataset should be same as your untyped dataset, the one you created in code (Invoice_DS). Design your report using that typed dataset.

For this go to Field Explorer > Database fields > Add/Remove database > find XML source as data specify path to your typed dataset file.All the tables you created in

The name of both typed and untyped dataset should be same as well the structure.

NOw debug your application , just before you setData source check that there is data in dataset (Invoice_DS)

Regarding your second question for efficient use of resource.

create another table in your dataset with only those columns that you need in your report, now fill this newtable with data from rest of your tables, only fill that data that the userhas selected.This way you will always fetch data from dataset not Database.

Did you add a data set(typed dataset) to your project.The structure of this dataset should be same as your untyped dataset, the one you created in code (Invoice_DS). Design your report using that typed dataset.

For this go to Field Explorer > Database fields > Add/Remove database > find XML source as data specify path to your typed dataset file.All the tables you created in

The name of both typed and untyped dataset should be same as well the structure.

NOw debug your application , just before you setData source check that there is data in dataset (Invoice_DS)

Regarding your second question for efficient use of resource.

create another table in your dataset with only those columns that you need in your report, now fill this newtable with data from rest of your tables, only fill that data that the userhas selected.This way you will always fetch data from dataset not Database.

Thanks Cappy, that worked like a charm..

tattoo