COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: joroise on 08 Jul 2010 02:20:20 AM

Title: Help me I want to check out my report on excel file.
Post by: joroise on 08 Jul 2010 02:20:20 AM
I added a javascript function on my COGNOS report
like this method ↓

<script>
function runFormat(format) {
  if(typeof(top.frames['IframeID'].document.forms[0]) == 'object')
  {
     var f = top.frames['IframeID'].document.forms[0];
     top.frames['theiframe']['oCV'+f['cv.id'].value].getRV().viewReport(format);
  }
  else
  {
     alert('select a report first.');
  }
}
</script>

BUT when did I download the excel file, the name of file is too ridiculous.
There is no pattern. I CAN'T FIGURE OUT THAT NAME.

Is there someone who can help me? PLEASE~~~
Title: Re: Help me I want to check out my report on excel file.
Post by: mvjcognos on 13 Jul 2010 02:06:22 AM
while u r downloading the excel report output on to ur desktop the name of file will show as some numnbers by default u need to change it to ur report name or some unique name and save.................
Title: Re: Help me I want to check out my report on excel file.
Post by: joroise on 15 Jul 2010 03:17:00 AM
But, my users want to set the report name automatcally.
that's why it becomes a problem.

Is there way I can change that default name?
Title: Re: Help me I want to check out my report on excel file.
Post by: tupac_rd on 15 Jul 2010 08:50:38 AM
How about you run the report in the background, and when the users download the report from the saved output, they can get the report name instead of the ugly name, when you run it adhoc...Is that an option at all...