Automatically load columns on to reports

[xiaochris]

Hi ,

Is there a way to do the following?

1. Automatically retrieve columns from the database , instead of manually clicking

2. After retrieving the columns, the columns will then automatically be populated on the reports without having to drag and drop the columns individually

[HighAley]

Hello.

Could you specify specify which our designer you use? HTML5 or Flex?
The both features are available in HTML5 Designer.

Thank you.

[xiaochris]

Hello , sorry for the late reply,

I'm on Stimulsoft Reports.Fx for PHP
version 2015.1.0

Could i also know how to load the columns and their values automatically without me having to do the drag and drop into each columns when a new column is added to the database?

[HighAley]

Hello.

Please, download our latest build.
You could find HTML5 components there that supported necessary features.

Thank you.

[xiaochris]

Hi HighAley,

My latest version would be 2015.3

could you advise which are the html5 components that i should use to get columns from the query automatically and place it on the report? What are the steps to be done?

[HighAley]

Hello.

At first download the latest prerelease build. There was a lot of improvements.
Then look at our JS sample. You could learn how to use JavaScript components there.
There could be some distinctions in designers and viewers. Please, check all your reports.

Thank you.

[xiaochris]

Hi HighAley,

Just wondering , so does that mean for the flash version, i am unable to dynamically create columns and place it on the report ? or is there anywhere i can see a sample that i can follow?

[HighAley]

Hello.

Yes, unfortunately, it's impossible to do in Flash. You should write SQL query there and than you could use Retrieve Columns buttons to get all columns.

Thank you.

[xiaochris]

Hi HighAley,

For flash, i could click on retrieve columns button as well. However, just wondering for the html5 version how do i do this step automatically?

as in , how does the columns be retrieved without me clicking?

[HighAley]

Hello.

You could see how it works in our tutorial video.
https://www.youtube.com/watch?v=33UhSLFybR4
The columns could be retrieved automatically or by the appropriate button when you write SQL query manually.

Thank you.