We have a VB6 application which uses the Crystal RDC (v 8.5) and, using a table driven approach, allows users to select data for inclusion in their reports with a huge amount of flexibility.  The code generates a SQL where clause which we use to modify the SQLQueryString in the crystal report and produce the report output.  We would like to migrate to Crystal XI and .Net but have come up against a brick wall because we can't access the SQLQueryString in .Net with any crystal product.  I have read that this can be done using the RAS SDK but we don't need the facilities of a report application server and so it would be a very costly route.

Edited by BugsySS - 28 Sep 2007 at 9:29am

Thanks Brian - I'll try it over the weekend and let you know.

Sorry to report I haven't got very far with this.  There is a document on the Business Objects web site "Migrating Applications from the RDC to the .NET assemblies" which states on page 62 that SQLQueryString is supported in the ReportClientDocument object model provided with RAS.  I have looked in all the classes which were installed with the Developer version but can't find it anywhere.  Does anyone else know where it might be in the object model?

Yes, I downloaded R2.  BusinessObjects say that SQLQueryString is supported in the RAS object model and pointed me to the online documentation.  The only reference I can find to SQLQueryString is in the Report Designer Component documentation.  It's not mentioned in the RAS documentation at all.  We want to move on from the RDC and use the .Net components but it looks as though that will involve us in a major redesign of our reports interface.   It's both disappointing and frustrating.