Report output issue

[HalfBloodPrince]

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 ?

[BigChris]

Are there any render variables in play?

[HalfBloodPrince]

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.

[BigChris]

That really does feel like it's looking for ReportOutput() <> 'HTML' or something like that. No conditional blocks...?

[HalfBloodPrince]

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.  ::) ::) ::)

[bdbits]

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.

[HalfBloodPrince]

Not able to provide report specs. Is SSIS job running on same database tables may cause this issue ?

[navissar]

Any scripts on page?

[HalfBloodPrince]

No script , No variables , No coditional styling. Single list in report

[navissar]

Different computer/browser?

[HalfBloodPrince]

same issue on chrome /other pc

[bdbits]

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.

[MPritchard55]

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.

[ToriBurns]

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?.

[MPritchard55]

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.

[MPritchard55]

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.