• Replies 7 replies
  • Subscribers 337 subscribers
  • Views 59 views
  • Users 0 members are here
Related

Report missing data but works in Infomaker

Christina Bledsoe
$organization

I've modified a report and when I preview the report in Infomaker it works.  However, when I run it in Tessitura the header data shows up, but everything else is blank.  I use the exact same parameters to run it.  I've checked the report set up and it appears to be correct.  Any advice?

Parents
  • Former Member
    Former Member $organization
    Could be worth checking security as well. Does the user group you're running it as in Tess have access to the right Control Groups?
    Ken McSwain
    +61 (0)418 659 360
    Sent from BlackBerry

    From: Tessitura Technical Forum <forums-technical@tessituranetwork.com>
    To: Ken McSwain
    Sent: Thu Jan 20 08:42:11 2011
    Subject: RE: [Tessitura Technical Forum] Report missing data but works in Infomaker

    I ran a trace before I posted this, but I'm not familiar enough with profiler to know what to look for.  When I execute the stored procedure I get the correct data, and when I preview it in Infomaker I get the correct data.  And any text changes I make to the Infomaker object show up when I try to run the report.  All of this is being done in Test and I've double checked that many times.  It has to be something with the .xml file.  I'll try running the trace again.

    From: Ryan Creps <bounce-ryancreps9649@tessituranetwork.com>
    Sent: 1/19/2011 2:56:22 PM

    I would run a trace in Profiler to see if you are getting the expected values in the stored procedure or SQL statement. 

     

    -Ryan

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Christina Bledsoe
    Sent: Wednesday, January 19, 2011 3:52 PM
    To: Ryan Creps
    Subject: [Tessitura Technical Forum] Report missing data but works in Infomaker

     

    I've modified a report and when I preview the report in Infomaker it works.  However, when I run it in Tessitura the header data shows up, but everything else is blank.  I use the exact same parameters to run it.  I've checked the report set up and it appears to be correct.  Any advice?




    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!




    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!
    Please consider the environment before printing this email.
    =====This message is intended for the addressee(s) named and may contain confidential information.
    If you are not the intended recipient, please delete it and notify the sender.
    Views expressed in this email are those of the individual sender and are not necessarily the views of the Sydney Opera House Trust=====
  • $organization in reply to Former Member

    I replied to the email notification, but apparently it created a brand new post!

    I'll repost here... 

    I'm a member of the sys admin group so that shouldn't be the issue.  It was a standard report we modified (devo performance report) and we created a local procedure and infomaker object  and copied the .xml file.  I changed the window type to Infomaker from System Window and added the datawindow and those were the only changes I made in report setup to the new xml file.  I've double checked the spelling of everything.  In fact earlier today I modified a report with no problem.  It's driving me crazy!

Reply
  • $organization in reply to Former Member

    I replied to the email notification, but apparently it created a brand new post!

    I'll repost here... 

    I'm a member of the sys admin group so that shouldn't be the issue.  It was a standard report we modified (devo performance report) and we created a local procedure and infomaker object  and copied the .xml file.  I changed the window type to Infomaker from System Window and added the datawindow and those were the only changes I made in report setup to the new xml file.  I've double checked the spelling of everything.  In fact earlier today I modified a report with no problem.  It's driving me crazy!

Children
  • $organization in reply to Christina Bledsoe

     

    Hi Christina,

    Good day.

    I think we need to spend some time on this SQL profiler. it is always my first try.

    Because it can tell you what is wrong with your report.

    If sql statement is in trace, and the parameter is correct.

    I think you maybe just need to close Tessitura Application and start it again. this will fix the blank report problem.

    every time you do an update in pbl file, you need to restart (not re-login) Tessitura.

    you can do google to find more resources about profiler.

    SQL Server Profiler Part 1

    http://www.databasejournal.com/features/mssql/article.php/3750161/Introduction-to-SQL-2005-Profiler-Part-1.htm

    SQL Server Profiler Part 2

    http://www.databasejournal.com/features/mssql/article.php/3755911/SQL-Server-Profiler-Part-2.htm

     

    have fun

    Ben

  • $organization in reply to Ben Gu

    Thanks to Brian Pedaci I figured out that it was because the data column in the report setup for Time was ID and should have been short_desc.  Which is weird because I basically just copied everything from the Performance Report which works just fine.  Anyway, it's working now!