BusinessObjects Board

XML Data Connection - Enable Send to .aspx Query String

other Xcelsius - Crystal Dashboard Design
#1

Hello,

I have Xcelsius 4.1 w/ Excel 2007.

I’m trying to perform query on a database from Xcelsius. Someone on the internet said it works using the query string through ASP .NET application. I learned to make the .aspx page and got it working with the SQL server side, but am having problems with connecting to Xcelsius smoothly.

Problem: For the .aspx to output an XML that Xcelsius can consume, I need to activate the querystring in a browser. To do that from Xcelsius, my guess was using the XML Data Connection, put the query string (http://example.com/webservice.aspx?PersonID=1) into the XML url. Click check on Enable Send and Enable Load.

I know that Xcelsius Send and Load the data through this format:

<data>
<row>
     <column></column>
</row>

I guess I don’t know how Xcelsius actually sends the data, so that my .NET application can receive the query string and update the xml.

When I test this out, the SWF would not load when I try to preview. Can any expert shred some light and point me to the right direction?

Greatly appreciated!

yungahhh (BOB member since 2014-10-28)

#2

Have you done a search on this forum? I’ve posted lots of sample code in the past couple of years for doing exactly this. If I get chance later, I’ll dig out some links, but have a look and see what you can find.

Debbie

Debbie :uk: (BOB member since 2005-03-01)