How to use the Crystal Report into Xcelsius

building reports crystal reports
1

Hi, Guys

Folks i m having a problem. I m having a report Created in Crystal Report, now what i want is i want the data of Report( Created in crystal report) and want to use in Xcelsius for Live data change…
And i do not want to use Query as web Services…
So Can i do this if yes then please tell me m waiting…

Thanks Guys

santose (BOB member since 2009-06-08)

2

One solution would be to output the crystal data as XML and then use this as the datasource for the Xcelsius dashboard.

OR

Imbed the Xcelsius dashboard in the crystal report and share the data between them (very fiddly if you have complex dashboard).

OR

Potentially define a report part in the Crystal Report and expose this to Live Office and then use the Live Office connector in Xcelsius.

ABILtd :uk: (BOB member since 2006-02-08)

3

Do you know who to format the report so that the XML output is compatible with XCelsius?

mcliffordgoo :us: (BOB member since 2003-02-13)

4

The proper format for XML to be consumed by an Xcelsius dashboard is format as shown in the example below.

The variable name is the name that will be referenced in the XML data connection. Multiple ranges can be included in the same XML provided that the same format and tags are maintained.

<?xml version="1.0" encoding="UTF-8"?> Oct Nov Dec 16292.003 32342 18743 45736.78 34565 92234 56442.5 122367 56045

HSinkwitz (BOB member since 2008-06-17)

5

Hey Heather,

Thanks for the update. What I need to do is create an XML style sheet for Crystal Reports so the output of hte XML file is support by Xcelsius.

Have you seen such a thing built?

mcliffordgoo :us: (BOB member since 2003-02-13)

6

Hi Michael!

Crystal Reports 2008 allows you to use your own XSLT to transform the XML for export.

Check out this post on the SAP forum for sample XSLT.

http://forumsa.sdn.sap.com/thread.jspa?messageID=7934294#7934294

Also, try a tool like XML Spy (there are free versions out there as well) if you need help creating and debugging your code.

I hope this helps!

HSinkwitz (BOB member since 2008-06-17)

7

I’m not sure if this is what you are looking for but I’ve used this video to help me understand how to get Crystal and Xcelisus to work together.

http://www.businessobjects.com/global/flash/product/catalog/crystalreports/demo_xcelsius_int/xcelsius_integration_viewlet_swf.html

Janchenko (BOB member since 2009-10-05)

8

Hi, :wave:

I have a question exporting .xml with crystal 2008. When I export a report which has three columns, it is only creating one column as a .xml file. I tried to create some .xslt files to change the xml report but crystal did it one column repeat. :hb:

Can you help me? :cry:
Thanks…

kene (BOB member since 2009-11-24)