Regarding multiple datasources in crystal reports

Oct 11 2007 3:01 AM

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


Answers (1)