create dataset and get a report

H

hamid

Well-known member
Joined
Jul 13, 2004
Messages
113
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?
 
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 havent used Crystal Reports yet, so maybe 5 related tables are just as easy to use.

How were going to do it on the project Im working on, were 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. Were still a month or two away from really getting into the reporting.
 
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 :(
 
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.
 
Back
Top