Page 1 of 2
Where is the connection made from?
Posted: Fri Apr 22, 2011 4:15 am
by iain.mckay
We're currently evaluating Reports.Fx for use in our app and I have a small question.
When the report runs, where is the connection to the data source (XML or SQL) made from? Is it from the client (browser) or from the server (where the PHP files are).
Thanks
Where is the connection made from?
Posted: Fri Apr 22, 2011 8:32 am
by Vladimir
Hello,
Working with databases (MSSQL, MySQL, PostgreSQL, Oracle, ODBC) is carried out on the PHP server side. When working with XML files, specifies the path to the XML file. Reading of the XML file carried out on the client, but can be carried out on the server side.
Thank you.
Where is the connection made from?
Posted: Wed Apr 27, 2011 8:32 am
by iain.mckay
Thanks for the response. You say it is made from the client but can be made to do it from the server. How do I go about forcing this?
Where is the connection made from?
Posted: Thu Apr 28, 2011 1:44 am
by Vladimir
Hello,
To do this you need:
1. Set the FlexAdapterXmlData option to False in the 'config.xml' file
2. Configure an XML data provider as you need in the 'database_xml.php' file
Thank you.
Where is the connection made from?
Posted: Thu Apr 28, 2011 6:59 am
by iain.mckay
That's great. We had some rules to apply to the XML source before generating the XML output so that's allowed us to do that now.
I've customized the get_columns function to take our schema and turn it in to the same format that the other connectors use and I can hit "Retrieve Columns" and have them appear in Reports.Fx. I'm having some problems with the actual XML data however. My reports are coming up empty, they used to work fine when loading XML from the client.
From what I can see the mssql, mysql, etc. connectors send their data in the format of:
I've modified our XML to be sent in this format but can't seem to get anything appearing in the designer any more.
Am I missing something?
Where is the connection made from?
Posted: Thu Apr 28, 2011 7:48 am
by Vladimir
Hello,
To get the columns you need to prepare XML data in the following format:
As the type of column can be used the following values:
Code: Select all
int
decimal
boolean
string
dateTime
base64Binary
Thank you.
Where is the connection made from?
Posted: Thu Apr 28, 2011 8:10 am
by iain.mckay
Thanks but that's not where my problem is. I have the columns being brought in to the designer correctly. It's the report data itself.
I can see I'm conforming to the format of the other connectors but my report just ends up empty. Is there a log or anything I can view to see if there's any errors?
Where is the connection made from?
Posted: Fri Apr 29, 2011 2:54 am
by Vladimir
Hello,
We rechecked the work of this function and found a bug. Send you a fixed version of the product, please see the attached file.
Thank you.
Where is the connection made from?
Posted: Fri Apr 29, 2011 7:36 am
by iain.mckay
Thanks for the update but it doesn't seem to have made a difference, still getting zilch in my report.
I've confirmed all the data is being sent to the report.
Is there a log of errors or problems I can view?
Where is the connection made from?
Posted: Fri Apr 29, 2011 9:11 am
by iain.mckay
Aha, this time it was me
Thanks for fixing that issue, solved my problems.