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
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 PurkissSent: Wednesday, November 23, 2011 3:01 PMTo: Ryan CrepsSubject: 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!
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....
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.
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...)
Hi,
Just wanted to let you know that I went back to the start, did it all again (taking into consideration all that was said here) and...SUCCESS!!
Thanks so much for your help,