cancel
Showing results for 
Search instead for 
Did you mean: 

How to create a report based on .net c# objects.

04-06-2011 4:39 PM
386 views 1 comments Go to solution
0 Likes
SAP Managed Tags
Subscribe

I'm working on an AddIn for CR2008.

I did already made the addin working the way I want using a previous forum post from myself: [;

In the already working addin, I get a C# DataSet (filled with data) from our own build database layer, and bind this to the report so a report can be designed using this dataset (see the post from myself in [; on Aug 28, 2008 4:45 PM.

But now we have changes our database layer, and this layer is supplying now C# Objects. So plain C# class instances with properties.

I want to change the add-in so it will work with C# Objects. I'm thinking about using a temporary XML file to store the data in (based on the objects), and then load this XML file into the report using the AddIn.

Code should look something like:


PropertyBag logonInfo = new PropertyBag();
logonInfo.EnsureCapacity(1);
logonInfo.Add("XML File Path", tempFileName);
 
PropertyBag attributes = new PropertyBag();
attributes.EnsureCapacity(5);
attributes.Add("Database DLL", "crdb_adoplus.dll");
attributes.Add("QE_DatabaseType", "ADO.NET (XML)");
attributes.Add("QE_ServerDescription", "NewDataSet");
attributes.Add("QE_SQLDB", true);
attributes.Add("QE_LogonProperties", logonInfo);

But maybe there is a much better way of doing this. I did found in the Database Expert screen of Crystal Reports 2008, that it is possible to load an xml file (Create New Connection > XML and Web Service). If this is the best way, how should such an XML file look like?

0 Likes

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Likes

Already find a solution, or maybe a partial solution that I can work with.

[SAP Note 1203980 - How to change the location of the .XSD and .XML files at runtime in a .NET application|http://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/com.sap.km.cm.docs/oss_notes_boj/sdn_oss_boj_bi/sap%28bd1lbizjptawmq==%29/bc/bsp/spn/scn_bosap/notes%7B6163636573733d36393736354636443646363436353344333933393338323636393736354637333631373036453646373436353733354636453735364436323635373233443330333033303331333233303333333933383330%7D.do]

Edited by: Dennis Dam on Apr 14, 2011 11:48 AM

Answers (0)