create dataset and get a report

[hamid]

i have 5 tables and i want create report of them.

i want create this report by Crystal Report in vs.net 2005

my report created in 5 tables as you can see in attach.

 

1. create new dataset that include some of fileds of all tables.

2. create report like as image

 

please help me how can i do it?

[Denaes]

IMO, the easiest way to do this is going to be to create a View or a Stored Procedure on the Database that merges these 5 tables into one super table. Or create a procedure in your dataset that creates a DataTable with all the info you need.

 

But I haven't used Crystal Reports yet, so maybe 5 related tables are just as easy to use.

 

How we're going to do it on the project I'm working on, we're going to use databases Stored Procedures to send the database values (maybe "all" or maybe an employees name/number for example) and have the relevant table for the report created and returned. But this is our plans. We're still a month or two away from really getting into the reporting.

[hamid]

how can i make a new DataTable from 5 datatable (some fileds of each) and use new datatable in Report ?

please help me

i must craete report from 5table and i dont know how shall i do :(

[davearia]

The way I have done it in the past is to have 1 datasource. Write a stored procedure that will do all of the necassary joins on these 5 tables. Fill your dataset with the results of calling this stored procedure at use that as your crystal data source.

 

I hope I am understood you correctly.