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

I believe I figured it out.

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

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

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.

I had to put quotes around the bracket variables. Might be making progress.. I'll get back to you soon.

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

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

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

How can I send the test report? I can't send here as it contains proprietary data.