HI gUYS,
I am facing one strange issue.
When I run the report its showing me no data available. While if i schedule the same report it shows me proper output in every report format. But when I run report no data. If i run the generated sql in db I get the same output as scheduled report.
Even If i chnage the output type to pdf or excel am able to see the data but not in HTML
I am using cognos 10.1 and relational data package.
What could be a cause ?
Are there any render variables in play?
No, No render variable or style variable in report. strange thing is that if I run it in PDF or excel it shows data but not in HTML.
I i take output in HTML which is blank and then convert it to pdf or excle I am able to see the data.
That really does feel like it's looking for ReportOutput() <> 'HTML' or something like that. No conditional blocks...?
No chris No conditional block. funny thing is that if I generate query output it shows blank if i convert that output to pdf it shows rows. ::) ::) ::)
Any chance you could attach a report spec? I am thinking maybe there is some oddball property set somewhere that affects HTML output but not other formats. Perhaps another set of eyes - four in my case - might be able to spot something like this.
Not able to provide report specs. Is SSIS job running on same database tables may cause this issue ?
Any scripts on page?
No script , No variables , No coditional styling. Single list in report
Different computer/browser?
same issue on chrome /other pc
You could check the Cognos server logs. Or run a report trace. Or maybe have your DBAs trace your activity to see if the report is even querying the database.
And if all else fails, open a ticket with IBM.
did you ever resolve this? I am having similar issue but my results are rendering in HTML but not in other formats (excel, pdf, csv). I also have no conditional formatting or render variables or anything, within the report, that would explain.
Thanks.
Can you highlight or Ctrl+A the page that was rendered? I was just wondering if maybe there's an output but you just cannot see it?.
Here is a screenshot of the report in excel as well as a portion of the result in html, of which I've blocked out some confidential info, but gives you confidence that it is returning a full data set in html.
My issue is resolved....
Issue: Report Studio report, F&M Project, will not render results in any other format other than html
Solution: The report contains some sql blocks. Those sql blocks have a Property called SQL Syntax with 3 options: Native (default), Cognos, or Pass-Through. The SQL Syntax was set to the default for this report. When changed to Pass-Through, the report rendered in all outputs.