Search found 16 matches
- Thu Feb 09, 2023 2:50 am
- Forum: Stimulsoft Dashboards.PHP
- Topic: Concatenate in expressions
- Replies: 1
- Views: 8038
Concatenate in expressions
I am having a problem where I can't seem to pass two parameters to a SQL Server stored procedure. In the data source I am using a Query exec sp_doquery1 @Name, @ForDate and have Name and ForDate setup as parameters (without the @). This works if I just pass one variable, but if I try passing two, it...
- Fri Nov 04, 2022 6:25 pm
- Forum: Stimulsoft Dashboards.PHP
- Topic: Change Background color of Indicator based on value
- Replies: 2
- Views: 8344
Re: Change Background color of Indicator based on value
I believe I figured it out.
- Fri Nov 04, 2022 5:40 pm
- Forum: Stimulsoft Dashboards.PHP
- Topic: Change Background color of Indicator based on value
- Replies: 2
- Views: 8344
Change Background color of Indicator based on value
Can the background color of an Indicator be change based on the value? I want the background color to be red, white or green based on the value and some limits that I setup per indicator. For example, for a particular indicator I might want the background color to be Green if the value is more than ...
- Tue Nov 01, 2022 10:41 pm
- Forum: Stimulsoft Dashboards.PHP
- Topic: SQL Server stored procedures
- Replies: 11
- Views: 11736
Re: SQL Server stored procedures
One of my parameters is a text value and the other is a date.
If I run the View Query and don't have a quote around the parameters, I get an error. I suspect that most of the testing was done with numeric values.
Again, this works perfectly in the Designer but doesn't work in the php script.
Alan
If I run the View Query and don't have a quote around the parameters, I get an error. I suspect that most of the testing was done with numeric values.
Again, this works perfectly in the Designer but doesn't work in the php script.
Alan
- Tue Nov 01, 2022 10:08 pm
- Forum: Stimulsoft Dashboards.PHP
- Topic: SQL Server stored procedures
- Replies: 11
- Views: 11736
Re: SQL Server stored procedures
With the quotes around the variables like '{parm1}' it works in the designer but not the php script. In the PHP script you doesn't replace the {parm1} with the value when it executes the stored procedure.
But if I leave the quote off, I get an exception in the designer.
But if I leave the quote off, I get an exception in the designer.
- Tue Nov 01, 2022 10:01 pm
- Forum: Stimulsoft Dashboards.PHP
- Topic: SQL Server stored procedures
- Replies: 11
- Views: 11736
Re: SQL Server stored procedures
I had to put quotes around the bracket variables. Might be making progress.. I'll get back to you soon.
- Tue Nov 01, 2022 9:45 pm
- Forum: Stimulsoft Dashboards.PHP
- Topic: SQL Server stored procedures
- Replies: 11
- Views: 11736
Re: SQL Server stored procedures
I am using 2022.4.3 and php.
When I remove the parameters and use exec sp_Report1 {parm1}, {parm2} and try to Preview I get an exception.
Alan
When I remove the parameters and use exec sp_Report1 {parm1}, {parm2} and try to Preview I get an exception.
Alan
- Tue Nov 01, 2022 8:04 pm
- Forum: Stimulsoft Dashboards.PHP
- Topic: SQL Server stored procedures
- Replies: 11
- Views: 11736
Re: SQL Server stored procedures
Ok, here is what I know. Been trying to get this to work for the last 6 hours. I think I know what the issue is, just not sure how to fix it. In the Designer, it works when I have the following setup. I have sp_Report1 as the stored procedure that I am running. It has two parameters. They are named ...
- Tue Nov 01, 2022 4:54 pm
- Forum: Stimulsoft Dashboards.PHP
- Topic: SQL Server stored procedures
- Replies: 11
- Views: 11736
Re: SQL Server stored procedures
I have sent test to support. It looks to me as though no parameters are being sent when the stored procedures are being run.
Any idea what I'm doing wrong>
Alan
Any idea what I'm doing wrong>
Alan
- Tue Nov 01, 2022 4:17 pm
- Forum: Stimulsoft Dashboards.PHP
- Topic: SQL Server stored procedures
- Replies: 11
- Views: 11736
Re: SQL Server stored procedures
How can I send the test report? I can't send here as it contains proprietary data.