Applying two datatable to Crystal Datasource

Make a view or in custom function or stored procedure in one of those two database. I prefer to make it in Master Database. Let say you make a stored procedure in (dt1) then generate a temporary table and load it with both database data. call that stored procedure from your crystal report only use

rpt.SetDataSource(dt1)

it will be faster in performance.

Hi,
You can go with two options. One by using "Typed DataSets" and Second is "Sub Report".

Typed datasets will take multiple datatables with relationship defined and based on which the report would get generated.

Using Crystal Reports in ASP.Net Making use of strongly typed datasets[^]

Sub report is another report by itself linked to the main report. you can have any number of sub report in single main report.
Create a Subreport in Crystal Reports [^]
Adding a Subreport to the Original Report[^]
Step by Step Creation of Crystal Report using its Features Group, Graph, Cross-Tab and Sub Report[^]
Crystal Reports and Subreports[^]

I recommend to go with subreports.

hope it helps.

Dim ds As New DataSet()
ds.Tables.Add(dt1)
ds.Tables.Add(dt)
rpt.SetDataSource(ds)

This is working ...

i Solved my self....

Using Some Trick and solved it for temporary basis

didn't need to share any one need please reply