Tutorial on runtime programming of CR? in .NET

[drdad5727]

I'm looking for a tutorial on the run time programming aspects of CR. I am not looking for help on writing CR reports, but rather modifying their behavior at run time. I have an example that uses the COM/ActiveX interface to Crystal, but I want to do it in .NET. So, a tutorial or advice on how to convert from one to the other would be nice.

First, I want to specify the SQL statement at run time. I think I can do this by setting the DataSource of the ReportObject. I wonder what the constraints are. How do I write the SELECT portion of the statement so that the report can find the fields it wants?

I also want to set the grouping dynamically. I think I can do this by modifying the ConditionField of the Group object, but I don't know how to suppress unwanted grouping levels. The reports I'm working with specify lots of grouping levels but expect only some to be used.

I also need to specify the fields to be totalled in the group areas. I have no idea how to do that.

I appreciate any help you can give me. I haven't been able to find anything that talks about this stuff.

 

[Turkbear]

Hi,
What version?

Have you looked at the various help files here:

http://help.sap.com/content/bobj/bobj/index.htm

or ( for XI)\

http://devlibrary.businessobjects.com/BusinessObjectsXIR2/en/devsuite.htm

To Paraphrase:"The Help you get is proportional to the Help you give.."