2 Problems with FR.Net
pinbot
Texas
I thought I posted a while ago but don't see my message.
Problem1:
This used to work but seems to be broken now.
Trying to pass a report parameter as a SQL query parameter.
This works:
exec alndata.mktreviewmktstats 'hou', '2009-03-01'
But this does not:
exec alndata.mktreviewmktstats @Mkt2, '2009-03-01'
Even though @Mkt2 is set up as a sql query parameter with default value and expression being a report parameter.
It used to work before updating to 1.0.198.
Funny thing is it does work with another sql query with just 1 parameter:
exec alndata.mktreviewfpbreakdown @Mkt
Video: http://www.pseudoconsulting.com/frproblem4.avi
Problem2:
I have a table showing values from above mentioned stored procedure. Trying to highlight the values <0 in red. It works on 1 cell but not the other. Both have the same format string and highlight conditions.
Video: http://www.pseudoconsulting.com/frproblem5.avi
Values return from stored procedure:
UnitAbsorpChg: -1.1498
PercentConcessChg: -0.10931
The value for PercentConcessChg is <0 so it should highlight in red. These are floating point fields returned as percents (the % formatting multiplies by 100)
Problem1:
This used to work but seems to be broken now.
Trying to pass a report parameter as a SQL query parameter.
This works:
exec alndata.mktreviewmktstats 'hou', '2009-03-01'
But this does not:
exec alndata.mktreviewmktstats @Mkt2, '2009-03-01'
Even though @Mkt2 is set up as a sql query parameter with default value and expression being a report parameter.
It used to work before updating to 1.0.198.
Funny thing is it does work with another sql query with just 1 parameter:
exec alndata.mktreviewfpbreakdown @Mkt
Video: http://www.pseudoconsulting.com/frproblem4.avi
Problem2:
I have a table showing values from above mentioned stored procedure. Trying to highlight the values <0 in red. It works on 1 cell but not the other. Both have the same format string and highlight conditions.
Video: http://www.pseudoconsulting.com/frproblem5.avi
Values return from stored procedure:
UnitAbsorpChg: -1.1498
PercentConcessChg: -0.10931
The value for PercentConcessChg is <0 so it should highlight in red. These are floating point fields returned as percents (the % formatting multiplies by 100)
Comments
Ok.
Figured out Prolem 2.
Need to make highlight expression be "< 0.0" so it won't cast the field to an integer value.
My Bad.
exec MyProc @prm, '1.1.2008'
where @prm is set to
DataType = VarChar
DefaultValue = ab (without quotes)
My default was 'sat' with single quotes.
The stored procedure must have been returning an error.
Thanks for the quick reply.