Where is the connection made from?

[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

[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.

[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?

[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.

[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:

Code: Select all

    
         blah
         blee
     

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?

[Vladimir]

Hello,

To get the columns you need to prepare XML data in the following format:

Code: Select all

    
        
        
        
        .....
    
    
        
        
        
        .....
    
    .....

As the type of column can be used the following values​​:

Code: Select all

int
decimal
boolean
string
dateTime
base64Binary

Thank you.

[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?

[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.

[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?

[iain.mckay]

Aha, this time it was me

Thanks for fixing that issue, solved my problems.