Binding multiple datasets to table
Posted 06 June 2012 - 01:11 PM
Posted 07 June 2012 - 07:57 AM
Posted 07 June 2012 - 05:52 PM
Posted 12 June 2012 - 08:58 AM
Posted 13 July 2012 - 12:13 PM
I have the following scenario:
I am using a flat file data source and don't have the ability to join the data sets.
Dataset1: Field: Signer_Name - has EMP ID
Dataset2: Fields: EMP ID, EMP NAME, EMP EMAIL.
I have a need to read the EMP ID (Multiple values) and then display the results for the EMP from the Dataset2. I was able to do this on the report designer using the Nested Tables, but the realtime report takes a lot of time to generate and sometime times out. Is there a way that I can read values from Dataset1 into a Global Variable and then display the matching EMP details from Dataset2 ?
Any suggestions will be greatly appreciated.
Posted 16 July 2012 - 07:08 PM
Posted 17 July 2012 - 06:20 AM
11111, 1/1/2012 10:00:00 AM
11112, 1/20/2012 10:00:00 AM
11233, 10/11/2012 11:00:00 AM
EMP ID, EMP NAME, EMP EMAIL
11111, TOM CRUSE, Tom_Cruse@gmail.com
11233, Mike Tyndal, Mike@gmail.com
The Dataset1 is being derived from one business process (Employee Signature on purchase orders) and the Dataset2 is being derived from a different business process (Full Company Employee Dataset).
Other fields in the Dataset1:
Order_number, Order_desc, Order_date, Vendor_ID.
My expectation is that when the report is run, it picks up the order details and in the signature details (Table), I want to display the EMP_NAME and EMP_EMAIL by looking at the EMP ID from Dataset2 and Corresponding value if available from Signer_Name in dataset1.
Signer Name, Signer Email, Signature Date
EMP_NAME, EMP_EMAIL, SIGN_DATE
TOM CRUSE, Tom_Cruse@gmail.com, 1/1/2012 10:00:00 AM
Mike Tyndal, Mike@gmail.com, 10/11/2012 11:00:00 AM
I hope I was able to provide all the information that you asked for.
Posted 17 July 2012 - 09:40 AM
Number of downloads: 29