• Replies 9 replies
  • Subscribers 338 subscribers
  • Views 67 views
  • Users 0 members are here
Related

Report data not showing when run within Tess

Former Member
Former Member $organization

Hi all,

I have successfully imported a report I found under the Shared Reports section on TASK and everything appears to be working except when I run the report in Tessitura under Report > Utilities it comes up completely blank - with no headings/report name and no data. When I open it in Infomaker, the report output is fine. Also when the procedure is run in SQL it returns data, however the return value is always ‘0’. This is the same for many other reports that do work, so I'm thinking that's not the problem?

I have also added the imp users to the local procedure under > properties > permissions etc and given them rights to execute. Not sure what I’m missing…

Thanks heaps for any suggestions!

Natasha  

 

Parents
  • $organization

    Once you get to using multiple libraries, ensure there are no duplicate entries, as the first one that is found by the application takes precedence.  This quite often mixes up people who spend hours editing something and wondering why it doesn’t show up when they try it in the client.

    J

     

    +Ryan Creps

    +Tessitura Network

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Natasha Purkiss
    Sent: Wednesday, November 23, 2011 3:01 PM
    To: Ryan Creps
    Subject: Re: [Tessitura Technical Forum] Report data not showing when run within Tess

     

    Thanks Dale. I gave this a go and I get all the headings now! But still no data - for a perf that I know has it. I copied the .pbl to a different location to see if that would work, but it didn't seem to make a difference. I think it may have something to do with the fact that I connet to Infomaker via remote desktop. Some libraries seem to be on its C:\ while others are on the T:\. I think I'm a little over my head and will ask out IT Director when he returns next week, unless of course you have any other ideas!

    Thanks again for you help. I have headings!! 

    From: Dale Aucoin <bounce-daleaucoin4707@tessituranetwork.com>
    Sent: 11/23/2011 11:59:57 AM

    Natasha,

    You can list multiple entries in this field, just separate with a comma.

    Dale




    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)

    Ah, I see. I can't see any duplicates in an drive...although there is a strong possibility that in my efforts to fix things I have changed something else! Thanks again :) Time to go back to the beginning and think through all my steps....

  • $organization in reply to Former Member

    Have you definitely relogged in to Tessitura since setting up the report? If you fiddle with something in infomaker and rerun the report without logging out and back in, it often comes up blank.

    I have a vague memory of having a problem with a new report and it kept coming up blank despite being fine previewed in infomaker, and on a whim, I did a save as on the report, in the same pbl, named it something slightly different, changed the report setup to reference the copy, and suddenly it started working, and I had no idea why.

    So as a last ditch effort, you might try that.

  • $organization in reply to Former Member

    I would also double check the Datawindow field in Report Setup. One tiny typo there and you will get a blank gray window (It's happened to me more than once...)

Reply Children