If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

[Solved] Save Report output problem

Started by Marcelv, 23 Apr 2006 11:18:30 PM

Previous topic - Next topic

Marcelv

Hi all,

A little problem with a report I am working with in MR3 Reportnet

I have a report with one parameter, which when displayed has some formatting based on output:
If(ReportOutput()='PDF') Then
('PDF')Else
('Other')
From this, I hide or show some information in the report which all works perfectly.

I then make a view, pass it a selected parameter value in the Properties Pane, then run with options and use the save report option to preprocess the report in HTML.Ã,  The report renders correctly in this manner and also if saved as a PDF.
The issue arises when I select both the HTML and PDF options.Ã,  The report then loses the formatting I have based on the PDF AND HTML, in effect not following either output type.

Can anyone assist as its a little frustrating.

Cheers,

Marcel
P.S in NZ, so my replies may be a little out of synch with you Northern Hemisphere types.

sir_jeroen

Have you figured out what the value is for this combination? Perhaps the ReportOutput() value = "PDF,HTML" and therefore your conditions aren't met...
if the value is "PDF,HTML" you can add:
If (ReportOutput() = 'PDF' AND ReportOutput() ='HTML') then (....)

Just doing this by head so excuse me if i'm wrong...

btw.. have you specified the "Other" format??

Marcelv

Thanks for the response, the two conditional formats are seperate;
If( Output() = "PDF" ) Then ("PDF") Else ("Other")Ã,  Ã,  AND
If( Output() = "HTML" ) Then ("HTML") Else ("Other")

There are two headings that I show, one in one format and one in the other, just to make the report look right.
The PDF/HTML setting hides the item's, otherwise it shows the item.
To test your other theory that there is another setting that comes into play, I put output() in a layout variable on the report.  The two saved versions respectively show PDF and HTML when they are supposed to on the saved versions.

So this sounds like a bug yeah?

bdybldr

Marcelv,
Have you tried "IN"?  For example, IF(Output() IN ("PDF","HTML"))  THEN ...

The value for Output() needs to be evaluated at one time.  In your code above, if Output() does not evaluate to "PDF" then the value "Other" is assigned to it, so when you evaluate the Output() value again, it has already been assigned "Other" and it will not evaluate to "HTML" even if the original value was "HTML".

Also, the Output value cannot "equal" both "PDF" and "HTML".  It can only be one or the other at any particular time, not both.  It could possibly be stored as an array though.  Just a thought.

Keep us posted.

Marcelv

Hi all,

In the words of the tech support people at Cognos:
This is a known defect and has been resolved with hotsite 20 for MR3.

So the Feature has been fixed - problem solved :)

Cheers for your ideas :)