Can anyone think of reasons why an infomaker report would come up totally blank? Previewing the report in Infomaker shows only the header info: report name, column header textboxes, etc. But everything else is blank. Running it in the test system the whole window comes up completely blank; nothing from the header shows, no textboxes, no page x of y, nothing.
The stored procedure returns plenty of data with the exact same parameters. The Infomaker object is in the default library list. Impusers has execute permission. I know this happened to me once before and it turned out to be a reference to a bitmap with an invalid path, but this report doesn't contain any images. I checked the arguments. I made sure it's pointed at the right SP. I'm sure it's something really obvious I'm overlooking...
Suggestions?
Profiler has always helped me in these circumstances. Make sure the parameters from Infomaker/Tessitura are the same as being passed to the stored procedure in your query window.
And back to basics….Could it be that you are testing against the wrong database in Infomaker but NOT in SSMS? (done it a few times before)
-Ryan
From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Amanda FreemanSent: Tuesday, November 02, 2010 7:13 PMTo: Ryan CrepsSubject: RE: [Tessitura Technical Forum] Infomaker report blank
It doesn't stipulate that, but I like that train of thought. If it were trying to run against customer 0 it would made sense that it'd return nothing...but that doesn't explain why certain specific customer_nos still turn up blank when the procedure says they shouldn't.
Plus I can tell the procedure did actually run for all the people in question because it wrote to t_order_seat_hist....just didn't display the report data when it was done.
From: Ryan Rowell <bounce-ryanrowell5634@tessituranetwork.com>Sent: 11/2/2010 5:59:06 PM
Hi Amanda,
Just a thought.Could the report be trying to run against customer "0"?Do you have any kind of stipulation in your procedure that customer_no needs to be greater then zero?
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!