Regarding multiple datasources in crystal reports

Hi,
I need to generate a report like where i need to get data from two different sources.One is xml file and the other is from sqlserver database

ITEM                 DESCRIPTION                           QTY     RATE   AMOUNT
                  OFFSHORE TESTING OF THE
                   PRODUCT FOR EUROPE

TSYS ODC     For the week July 29, 2007             000.00    00        00000.00
TSYS ODC     For the week Aug 05, 2007            000.00    00        00000.00
TSYS ODC     For the week Aug 12, 2007            000.00    00        00000.00
TSYS ODC     For the week Aug 19, 2007            000.00    00       00000.00
TSYS ODC     For the week Aug 26, 2007            000.00    00       00000.00

Say for example this is my report ,Fields like item and description header and other fields i am getting from xml file.Now i need to use sqlserver database for getting description,qty fields.So can i use this multiple datasources for report generation.If anybody know kindly help me in doing that

Thanks & Regards,
Lavanya

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

sai babu19y ago
yes, u can use the multiple datasources

first if you are creating datasource, u will get a some fields to datasrouces and creating another datasource this is sepere connection u will access some other file so now can able display the report from two different files in a single report

Regards

sai