How can we use NVL function/Dataformat to resolve the Blank spaces in our report. Explain with navigation

  • Interview Candidate
  • 6
  • 6658

Showing Answers 1 - 6 of 6 Answers

sivabisani

  • Nov 13th, 2008
 

As per my understanding

we need to put '0' i place of blanks that's correct?
for this we can select the dataitems which have blanks and then goto properties pane then select the dataformat in that selct the type which your select (string,number,date....)and then it displays the properties for that and put '0' in missing value charecter and press ok.

Thanks,
siva

binduandme

  • Mar 10th, 2009
 

Yes this was the aproch in previous version but from Cognos 8 specifically from 8.3 you have no data option provided to handle missing values.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions