2 Problems with FR.Net

pinbotpinbot Texas
edited 7:09PM in FastReport .NET
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)





Comments

  • pinbotpinbot Texas
    edited 7:09PM

    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.
  • edited 7:09PM
    I have tried to reproduce this error, but it works for me. I've used the following sql:

    exec MyProc @prm, '1.1.2008'

    where @prm is set to
    DataType = VarChar
    DefaultValue = ab (without quotes)

  • pinbotpinbot Texas
    edited 7:09PM
    I'll try without the quotes.

    My default was 'sat' with single quotes.

    The stored procedure must have been returning an error.

    Thanks for the quick reply.


Leave a Comment