>Thank you.
>The thing is that we are porting our application to work with both SQL Server and VFP back end, maybe later add MySQL. Originally all our reports were written using VFP report writer, but with multiple backend I thought that Crystal Report will work better and will be easier to maintain; create one report and change connections depends on the back end. Or so I thought.... Now, I can see that while SQL ODBC allows me to work with SQL Views and Stored Procedures seamlessly, this is not so easy for VFP. So I cannot create stored procedure in both to get the same result and build report based on it.
>Oh well, will try a different approach or create a second set of reports in VFP
>Thank you again
>
>>>Thank you so much for your sample code. I am not very fluent with Crystal report yet, so please bear with me. When you created your vente_Resident.rpt inside the Crystal report have you added view using data export?
>>
Hi Yelena,
Last night I came across this very interesting article (in Russian)
http://itband.ru/2010/05/reporting-services-2008-r2-visual-foxpro-9/#more-6001We use SSRS, but separately from our application (for now). I only briefly looked at it yesterday, but it looks like a very valuable solution and he explained all the needed steps in details. You also just use SSRS (if you're using SQL Server, it's already installed, not extra dependency of Crystal Reports).
Check it out.
If it's not broken, fix it until it is.
My Blog