Regarding multiple datasources in crystal reports

Question

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 descriptionqty fields.So can i use this multiple datasources for report generation.If anybody know kindly help me in doing that Thanks & Regards Lavanya

sai babu · Answer

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