Hi,
I need to produce a report in MS SQL Server Reporting Service 2005 which has some date fields & need to pass these date fields to find out the no_of_User on that date from another database. For example
Itemid
Availabilty_Start_Dt
Availabilty_End_Dt
User_On_St_DT (this info is in another DB & need to pass Availabilty_Start_Dt )
User_On_ED_DT (this info is in another DB & need to pass Availabilty_Start_Dt )
I am facing two problem here. Since hereis two different dataset needed how can I combine the dataset result to produce each row of the report.
REally appreciate if anyone can show me some light on it.
Regards,
write a strored procedure in the backend and try to write the two queries and combine the results and store in a temp table.
use the stored procedure in the reporting services. Backend is the best solution for it.
