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?
Hi Amanda, I had a similar issue with one of my reports. The report had an optional parameter of customer no (defined as a string field so that users can enter one or more customer no separated by comma). So when users used to run the report with one or more customer no it would return rows but with a blank customer no field the report would return nothing, though it was not supposed to.
Eventually I found out when users were running the report with a blank customer no and were getting a blank output, they were actually running the report with a space in that optional customer no field which they couldn’t realize. Since the field was not totally empty the report procedure was converting that blank space to an un-resolved customer no and was not returning anything. But it would work if they delete the space with the backspace key.
May be it’s not true in your case. Thought I would mention anyway since your scenario sounds familiar.
Mo
Mohiuddin Faruqe
Business Analyst
The National Ballet of Canada
From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Amanda Freeman Sent: Tuesday, November 02, 2010 6:48 PM To: Mohiuddin Faruqe Subject: RE: [Tessitura Technical Forum] Infomaker report blank
Okay, so I'm having a Friday afternoon type momenteven though it's Tuesday, and I'm out of ideas.
I have a report that until two weeks ago, as far as I know worked fine. It has an optional customer_no parameter, and all the other parameters are required, one of which is order_dt. If we run it for a single customer_no, the report comes up as expected. If customer_no is left blank, the report is blank.
BUT this is not true when running just the stored procedure. The procedure runs just fine for multiple people over multiple dates. The exact same parameters through Tessitura and the report comes up blank, not completely blank though. We can see the header, but the body is empty.
It is also inconsistent. Entering certain customer_nos and the report comes up as expected, but not all. It has a reprint ind too, so I can see for whom it has already been run, and try to reprint one of those and some come up blank and some are fine. As of yesterday the problem was only in live, not test, and since the SP gives expected results I thought it might be an Infomaker issue. But I copied the version from the test pbl to the live pbl and live still had the problem. I can't see what's different about the people or the reports. Any ideas about where I should look? I'm stumped.
From: Sandra Ashby <bounce-sandraashby2064@tessituranetwork.com> Sent: 10/11/2010 5:07:18 PM
When it’s completely blank in Tessitura that usually means that the report can’t be found. So make sure you have the right path in LOCAL_LIBRARY_LIST for the pbl and the correct name of the infomaker report in report setup. Another thing I have found from time to time is that if I have been testing the report in Tessitura, made changes and tested it in Tessitura again without completely logging out this can also result in an empty report.
No results in infomaker – check your database connections and make sure that in the extended property you have database=impresario
If this doesn’t help then I suggest that you open a support ticket. But suspect it’s a typo somewhere – it always the culprit for me!
Cheers
Sandra
From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Amanda Freeman Sent: Tuesday, 12 October 2010 6:52 AM To: Sandra Ashby Subject: [Tessitura Technical Forum] Infomaker report blank
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!
It turned out both Ryans were right. The report was passing a zero instead of null, although I have no idea why it started doing that. I have plenty of other reports with optional customer_no parameters set up the same way as this one had been, and in the report parameter window it does display a zero because the parameter is set as a number in report setup, but none of those had this problem. I added logic to the report that changes the customer_no to null if it's passed as zero and now the report works. Since we don't allow general public orders, this bandaid seems to have done the trick.