InfoMaker data issue

Former Member
Former Member $organization

I am having an issue with a custom report field that is returning a 0 instead of the amount returned by the SQL Server stored procedure when it is executed on the server.  All of the fields lineup in the report with the columns in SQL, and the data type is correct in the report,  but we are getting an erroneous value in this one field??  See the example below:

 

SQL 2012
solicitor cur_fy_goal
jlandin  50000
   
Report 2012
solicitor cur_fy_goal
jlandin 0

Parents
  • A few other basic things to check, but are you pointed at the correct DB in Infomaker?

     

    You can also try running a trace to see if there is a difference between how you are executing it in SSMS vs how Infomaker is providing parameter values.

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of James Fairfield
    Sent: Wednesday, June 15, 2011 9:20 AM
    To: Ryan Creps
    Subject: [Tessitura Technical Forum] InfoMaker data issue

     

    I am having an issue with a custom report field that is returning a 0 instead of the amount returned by the SQL Server stored procedure when it is executed on the server.  All of the fields lineup in the report with the columns in SQL, and the data type is correct in the report,  but we are getting an erroneous value in this one field??  See the example below:

     

    SQL

    2012

    solicitor

    cur_fy_goal

    jlandin

    50000

     

     

    Report

    2012

    solicitor

    cur_fy_goal

    jlandin

    0




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!

  • Former Member
    Former Member $organization in reply to Ryan Creps (Past Staff Member)

    Ryan:

    Thank you.  I ran a trace, and the parameters being passed are the same.  A friend of ours installed our SP and created a report, and the problem does not show up on his system. ???

     

    James

Reply Children
No Data