>>>>>>>You can also create sharepoint lists that are associated with SQL data - though truthfully, if you can pull off the SharePoint to SSRS integration, that (IMO) is the way to go
>>>>>>
>>>>>>Thank you, Kevin. I think if the customer decides to integrate my app data with a SharePoint, they will be choosing the path and doing the work. But I will "copy and paste" your suggestion to them. Of course, I will take all the credit :).
>>>>>>Seriously though, this customer is currently using my app with VFP data and I am interested that they would upgrade to the SQL Server VFP application. I wrote to them that getting the data from VFP database to SharePoint is not possible (at least I don't know how).
>>>>>
>>>>>You can create an SSRS report that points to VFP data. And then you can deploy the SSRS report to SharePoint. It's definitely a few steps but then you get the functionality of previewing SSRS inside of SharePoint.
>>>>
>>>>I have never done SSRS reports so this would require some learning. I need to think about this approach.
>>>>Thank you very much for the suggestion.
>>>
>>>As a general statement, if you work with SQL Server, and you work with VFP apps, and you're in positions where you need to show data in web pages/web apps and/or SharePoint, I definitely recommend getting involved with SSRS.
>>>
>>>It's a great general purpose reporting tool. It's not perfect...but it usually does the job
>>
>>I will see if I can find a good tutorial on SSRS on youtube or elsewhere. Thank you.
>
>SSRS has a very nice feature - IT'S FREE!
I read in the Time magazine an interview with a writer (or some other "famous" person) who said that when something is free, YOU are the product :).
Thanks.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham