Search found 72 matches

by tony.tomov
Fri Aug 24, 2018 2:11 pm
Forum: Stimulsoft Reports.PHP
Topic: datetime field can not be displayed correct
Replies: 5
Views: 3037

Re: datetime field can not be displayed correct

Hello,

Is the new build available? I can't find it into download area.

Kind Regards
by tony.tomov
Fri Aug 03, 2018 12:34 pm
Forum: Stimulsoft Reports.PHP
Topic: datetime field can not be displayed correct
Replies: 5
Views: 3037

Re: datetime field can not be displayed correct

Hello,

Thank you for the fast reaction.
Unfortunately I can't use your suggestion on the existing reports.

From where I can download the build or if not possible when will they available for download.

Thank you.

Kind Regards
by tony.tomov
Tue Jul 31, 2018 9:39 am
Forum: Stimulsoft Reports.PHP
Topic: datetime field can not be displayed correct
Replies: 5
Views: 3037

datetime field can not be displayed correct

Using the Mysql driver the date field is always displayed as 1970-01-01. The data from server comes correct (I see using the debug console ), but it is not displayed correct The version ofused is the last one. With previous version this work fine. Below example using the northwind database I think i...
by tony.tomov
Tue Mar 20, 2018 2:39 pm
Forum: Stimulsoft Reports.PHP
Topic: Run report with parameters
Replies: 5
Views: 5722

Re: Run report with parameters

Hello,

Unfortunately this is not working for me. If you want I can send you a demo report.
by tony.tomov
Tue Mar 20, 2018 9:31 am
Forum: Stimulsoft Reports.PHP
Topic: Run report with parameters
Replies: 5
Views: 5722

Re: Run report with parameters

Hello, Thank you for the replay. I think you do not have understand the problem. To explain it again: I have a php report with parameters requested from the user. This report uses SQL datasource to get the data. When run the report at first time the report make a database query to get initila data b...
by tony.tomov
Mon Mar 19, 2018 3:10 pm
Forum: Stimulsoft Reports.PHP
Topic: Some notes
Replies: 3
Views: 3036

Re: Some notes

Hello, Tony. 1. Thank you for the notice. We will check it and make an improvement. 2. Sure. We are working on adding PDO driver. It will be added later. 3. We have made some improvements. Please, check our latest prerelease build that available on our site. 4. This feature is added to out to-do li...
by tony.tomov
Fri Mar 16, 2018 9:41 am
Forum: Stimulsoft Reports.PHP
Topic: Run report with parameters
Replies: 5
Views: 5722

Run report with parameters

Hello, I have not find a way to perform this: Basically is it possible when lunch the report for the first time with parameter(s) with user interaction NOT to get the initial data. The idea is not to perform a database query with the initial parameters, since they always are changed every time. This...
by tony.tomov
Wed Mar 14, 2018 2:52 pm
Forum: Stimulsoft Reports.PHP
Topic: Format date paramer
Replies: 7
Views: 6957

Re: Format date paramer

Hello,


Thanks. It is working.
The correct way to write it is with double brackets like this

Code: Select all

SELECT ... FROM ... WHERE .. AND OrderDate >=  '{Variable4.ToString("yyyy-MM-dd")}' ....
since the date in MySql is treated as string and we need to pass a string

Kind Regards,
Tony
by tony.tomov
Tue Mar 13, 2018 2:30 pm
Forum: Stimulsoft Reports.PHP
Topic: Format date paramer
Replies: 7
Views: 6957

Re: Format date paramer

Setting the culture changes the display of the date in the report, but does not change the date format of the parameter for use with datepicker I have do this into the viewer. php and designer php <?php $options = StiHelper::createOptions(); $options->handler = "handler.php"; $options->tim...
by tony.tomov
Tue Mar 13, 2018 9:26 am
Forum: Stimulsoft Reports.PHP
Topic: Format date paramer
Replies: 7
Views: 6957

Re: Format date paramer

You can use the convert function in the query. Thank you for the response. Any advice haw to implement this? The problem I see is: How to detect the datetime format of the culture, since different browsers have different language setting. With simple words - how to get the datetime formatting of th...