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

When Export PDF The Prompt Values Not Display in PDF page

Started by Revathi_M, 30 Oct 2014 11:39:44 PM

Previous topic - Next topic
Print
Go Down Pages1
User actions

Revathi_M

30 Oct 2014 11:39:44 PM
HI ,
When I export PDF and Excel The Prompt Value Not Display


Any body Explain me.

MFGF

#1
31 Oct 2014 04:53:55 AM
Quote from: Revathi_M on 30 Oct 2014 11:39:44 PM
HI ,
When I export PDF and Excel The Prompt Value Not Display


Any body Explain me.

Hi,

This has already been explained (rather well) in one of your other threads, along with a mechanism to allow you to see your prompt values in rendering types other than HTML:

http://www.cognoise.com/index.php/topic,26304.msg83643.html#msg83643

MF.
Meep!

Revathi_M

#2
31 Oct 2014 05:41:13 AM
I am Not Given any Condition
just simple report export to PDF or EXcel it not display,all my reports

i given attachment my out please check.


this My Report XML code:

<report xmlns="http://developer.cognos.com/schemas/report/9.0/" useStyleVersion="10" expressionLocale="en-us">
            <modelPath>/content/folder[@name='KPI Report']/package[@name='KPI Report Traditional (Query)']/model[@name='model']</modelPath>
            <drillBehavior modelBasedDrillThru="true"/>
            <queries>
               <query name="Query1">
                  <source>
                     <model/>
                  </source>
                  <selection><dataItem name="REVENUE" aggregate="total"><expression>[KPI detail data].[KPI_FACT].[REVENUE]</expression><XMLAttributes><XMLAttribute name="RS_dataType" value="9" output="no"/><XMLAttribute name="RS_dataUsage" value="fact" output="no"/></XMLAttributes></dataItem><dataItem name="CONTINENT" aggregate="none" rollupAggregate="none"><expression>[KPI detail data].[Country].[CONTINENT]</expression><XMLAttributes><XMLAttribute name="RS_dataType" value="3" output="no"/><XMLAttribute name="RS_dataUsage" value="attribute" output="no"/></XMLAttributes></dataItem><dataItem name="AGENCY_NAME" aggregate="none" rollupAggregate="none"><expression>[KPI detail data].[Agency].[AGENCY_NAME]</expression><XMLAttributes><XMLAttribute name="RS_dataType" value="3" output="no"/><XMLAttribute name="RS_dataUsage" value="attribute" output="no"/></XMLAttributes></dataItem></selection>
               <detailFilters><detailFilter use="optional"><filterExpression>[KPI detail data].[Country].[CONTINENT] = ?CountryParam?</filterExpression></detailFilter></detailFilters></query>
            <query name="Query2"><source><model/></source><selection><dataItem name="CONTINENT" aggregate="none"><expression>[KPI detail data].[Country].[CONTINENT]</expression></dataItem></selection></query></queries>
            <layouts>
               <layout>
                  <reportPages>
                     <page name="Page1"><style><defaultStyles><defaultStyle refStyle="pg"/></defaultStyles></style>
                        <pageBody><style><defaultStyles><defaultStyle refStyle="pb"/></defaultStyles></style>
                           <contents>
                              <block>
         <contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>CountryFilter:</staticValue></dataSource><style><CSS value="width:2cm;height:0cm"/></style></textItem></contents><style><CSS value="width:2cm;height:0cm"/></style></tableCell><tableCell><contents><selectValue parameter="CountryParam" refQuery="Query2" multiSelect="false" selectValueUI="dropdown" required="false"><useItem refDataItem="CONTINENT"/><style><CSS value="width:3cm;height:0cm"/></style></selectValue></contents><style><CSS value="width:3cm;height:0cm"/></style></tableCell></tableCells></tableRow></tableRows></table></contents>
      </block><v2_combinationChart maxHotspots="10000" refQuery="Query1" name="Combination Chart1">
                        <v2_combinationTypeTooltips/>
                        <v2_legend>
                           <v2_legendPosition>
                              <v2_legendPreset/>
                           </v2_legendPosition>
                           <v2_legendTitle refQuery="Query1">
                              <v2_chartTextContents>
                                 
                              <v2_chartTextItems><v2_chartTextItem><dataSource><staticValue>AgencyNames</staticValue></dataSource></v2_chartTextItem></v2_chartTextItems></v2_chartTextContents>
                              <style>
                                 <defaultStyles>
                                    <defaultStyle refStyle="lx"/>
                                 </defaultStyles>
                              </style>
                           </v2_legendTitle>
                           <style>
                              <defaultStyles>
                                 <defaultStyle refStyle="lg"/>
                              </defaultStyles>
                           </style>
                        </v2_legend>
                        <v2_commonAxis>
                           <v2_ordinalAxis>
                              <v2_axisTitle refQuery="Query1">
                                 <v2_chartTextContents>
                                    
                                 <v2_chartTextItems><v2_chartTextItem><dataSource><staticValue>X- axix Values Display</staticValue></dataSource></v2_chartTextItem></v2_chartTextItems></v2_chartTextContents>
                                 <style>
                                    <defaultStyles>
                                       <defaultStyle refStyle="at"/>
                                    </defaultStyles>
                                 </style>
                              </v2_axisTitle>
                              <v2_axisLine lineWeight="0"/>
                              <v2_axisLabels>
                                 <style>
                                    <defaultStyles>
                                       <defaultStyle refStyle="al"/>
                                    </defaultStyles>
                                 </style>
                              </v2_axisLabels>
                           </v2_ordinalAxis>
                        <chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="CONTINENT"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_commonAxis>
                        <v2_topLeftAxis>
                           <v2_combinationChartTypes>
                              <v2_bar borders="show">
                                 <v2_solidPalette>
                                    <v2_solidPaletteEntries>
                                       <v2_solidPaletteEntry>
                                          <v2_fillEffect defaultColor="#8599D3">
                                             <v2_linearGradient gradientAngle="0">
                                                <v2_gradientColor colorPosition="0" gradientColor="#8599D3"/>
                                                <v2_gradientColor colorPosition="100" gradientColor="#5876AE"/>
                                             </v2_linearGradient>
                                          </v2_fillEffect>
                                       </v2_solidPaletteEntry>
                                       <v2_solidPaletteEntry>
                                          <v2_fillEffect defaultColor="#E3AE6C">
                                             <v2_linearGradient gradientAngle="0">
                                                <v2_gradientColor colorPosition="0" gradientColor="#E3AE6C"/>
                                                <v2_gradientColor colorPosition="100" gradientColor="#CD854E"/>
                                             </v2_linearGradient>
                                          </v2_fillEffect>
                                       </v2_solidPaletteEntry>
                                       <v2_solidPaletteEntry>
                                          <v2_fillEffect defaultColor="#839862">
                                             <v2_linearGradient gradientAngle="0">
                                                <v2_gradientColor colorPosition="0" gradientColor="#839862"/>
                                                <v2_gradientColor colorPosition="100" gradientColor="#6C7F56"/>
                                             </v2_linearGradient>
                                          </v2_fillEffect>
                                       </v2_solidPaletteEntry>
                                       <v2_solidPaletteEntry>
                                          <v2_fillEffect defaultColor="#B7C873">
                                             <v2_linearGradient gradientAngle="0">
                                                <v2_gradientColor colorPosition="0" gradientColor="#B7C873"/>
                                                <v2_gradientColor colorPosition="100" gradientColor="#AFB885"/>
                                             </v2_linearGradient>
                                          </v2_fillEffect>
                                       </v2_solidPaletteEntry>
                                       <v2_solidPaletteEntry>
                                          <v2_fillEffect defaultColor="#8484A8">
                                             <v2_linearGradient gradientAngle="0">
                                                <v2_gradientColor colorPosition="0" gradientColor="#8484A8"/>
                                                <v2_gradientColor colorPosition="100" gradientColor="#525E7E"/>
                                             </v2_linearGradient>
                                          </v2_fillEffect>
                                       </v2_solidPaletteEntry>
                                       <v2_solidPaletteEntry>
                                          <v2_fillEffect defaultColor="#C0CCED">
                                             <v2_linearGradient gradientAngle="0">
                                                <v2_gradientColor colorPosition="0" gradientColor="#C0CCED"/>
                                                <v2_gradientColor colorPosition="100" gradientColor="#B0C2E5"/>
                                             </v2_linearGradient>
                                          </v2_fillEffect>
                                       </v2_solidPaletteEntry>
                                       <v2_solidPaletteEntry>
                                          <v2_fillEffect defaultColor="#8C5580">
                                             <v2_linearGradient gradientAngle="0">
                                                <v2_gradientColor colorPosition="0" gradientColor="#8C5580"/>
                                                <v2_gradientColor colorPosition="100" gradientColor="#794067"/>
                                             </v2_linearGradient>
                                          </v2_fillEffect>
                                       </v2_solidPaletteEntry>
                                       <v2_solidPaletteEntry>
                                          <v2_fillEffect defaultColor="#C789BC">
                                             <v2_linearGradient gradientAngle="0">
                                                <v2_gradientColor colorPosition="0" gradientColor="#C789BC"/>
                                                <v2_gradientColor colorPosition="100" gradientColor="#BB72BC"/>
                                             </v2_linearGradient>
                                          </v2_fillEffect>
                                       </v2_solidPaletteEntry>
                                       <v2_solidPaletteEntry>
                                          <v2_fillEffect defaultColor="#D5BAEF">
                                             <v2_linearGradient gradientAngle="0">
                                                <v2_gradientColor colorPosition="0" gradientColor="#D5BAEF"/>
                                                <v2_gradientColor colorPosition="100" gradientColor="#C29FD1"/>
                                             </v2_linearGradient>
                                          </v2_fillEffect>
                                       </v2_solidPaletteEntry>
                                       <v2_solidPaletteEntry>
                                          <v2_fillEffect defaultColor="#83683F">
                                             <v2_linearGradient gradientAngle="0">
                                                <v2_gradientColor colorPosition="0" gradientColor="#83683F"/>
                                                <v2_gradientColor colorPosition="100" gradientColor="#604926"/>
                                             </v2_linearGradient>
                                          </v2_fillEffect>
                                       </v2_solidPaletteEntry>
                                       <v2_solidPaletteEntry>
                                          <v2_fillEffect defaultColor="#DCB05A">
                                             <v2_linearGradient gradientAngle="0">
                                                <v2_gradientColor colorPosition="0" gradientColor="#DCB05A"/>
                                                <v2_gradientColor colorPosition="100" gradientColor="#C09C52"/>
                                             </v2_linearGradient>
                                          </v2_fillEffect>
                                       </v2_solidPaletteEntry>
                                       <v2_solidPaletteEntry>
                                          <v2_fillEffect defaultColor="#F4DF9E">
                                             <v2_linearGradient gradientAngle="0">
                                                <v2_gradientColor colorPosition="0" gradientColor="#F4DF9E"/>
                                                <v2_gradientColor colorPosition="100" gradientColor="#E4CF87"/>
                                             </v2_linearGradient>
                                          </v2_fillEffect>
                                       </v2_solidPaletteEntry>
                                       <v2_solidPaletteEntry>
                                          <v2_fillEffect defaultColor="#5F8A8C">
                                             <v2_linearGradient gradientAngle="0">
                                                <v2_gradientColor colorPosition="0" gradientColor="#5F8A8C"/>
                                                <v2_gradientColor colorPosition="100" gradientColor="#537579"/>
                                             </v2_linearGradient>
                                          </v2_fillEffect>
                                       </v2_solidPaletteEntry>
                                       <v2_solidPaletteEntry>
                                          <v2_fillEffect defaultColor="#96C4B2">
                                             <v2_linearGradient gradientAngle="0">
                                                <v2_gradientColor colorPosition="0" gradientColor="#96C4B2"/>
                                                <v2_gradientColor colorPosition="100" gradientColor="#89B0A0"/>
                                             </v2_linearGradient>
                                          </v2_fillEffect>
                                       </v2_solidPaletteEntry>
                                       <v2_solidPaletteEntry>
                                          <v2_fillEffect defaultColor="#CBE8E7">
                                             <v2_linearGradient gradientAngle="0">
                                                <v2_gradientColor colorPosition="0" gradientColor="#CBE8E7"/>
                                                <v2_gradientColor colorPosition="100" gradientColor="#BDD6D5"/>
                                             </v2_linearGradient>
                                          </v2_fillEffect>
                                       </v2_solidPaletteEntry>
                                       <v2_solidPaletteEntry>
                                          <v2_fillEffect defaultColor="#AE6564">
                                             <v2_linearGradient gradientAngle="0">
                                                <v2_gradientColor colorPosition="0" gradientColor="#AE6564"/>
                                                <v2_gradientColor colorPosition="100" gradientColor="#875352"/>
                                             </v2_linearGradient>
                                          </v2_fillEffect>
                                       </v2_solidPaletteEntry>
                                       <v2_solidPaletteEntry>
                                          <v2_fillEffect defaultColor="#D88C6F">
                                             <v2_linearGradient gradientAngle="0">
                                                <v2_gradientColor colorPosition="0" gradientColor="#D88C6F"/>
                                                <v2_gradientColor colorPosition="100" gradientColor="#C47D61"/>
                                             </v2_linearGradient>
                                          </v2_fillEffect>
                                       </v2_solidPaletteEntry>
                                       <v2_solidPaletteEntry>
                                          <v2_fillEffect defaultColor="#E3C9B0">
                                             <v2_linearGradient gradientAngle="0">
                                                <v2_gradientColor colorPosition="0" gradientColor="#E3C9B0"/>
                                                <v2_gradientColor colorPosition="100" gradientColor="#D2B2A5"/>
                                             </v2_linearGradient>
                                          </v2_fillEffect>
                                       </v2_solidPaletteEntry>
                                       <v2_solidPaletteEntry>
                                          <v2_fillEffect defaultColor="#848484">
                                             <v2_linearGradient gradientAngle="0">
                                                <v2_gradientColor colorPosition="0" gradientColor="#848484"/>
                                                <v2_gradientColor colorPosition="100" gradientColor="#555555"/>
                                             </v2_linearGradient>
                                          </v2_fillEffect>
                                       </v2_solidPaletteEntry>
                                       <v2_solidPaletteEntry>
                                          <v2_fillEffect defaultColor="#a4a4a4">
                                             <v2_linearGradient gradientAngle="0">
                                                <v2_gradientColor colorPosition="0" gradientColor="#a4a4a4"/>
                                                <v2_gradientColor colorPosition="100" gradientColor="#909090"/>
                                             </v2_linearGradient>
                                          </v2_fillEffect>
                                       </v2_solidPaletteEntry>
                                       <v2_solidPaletteEntry>
                                          <v2_fillEffect defaultColor="#C7C7C7">
                                             <v2_linearGradient gradientAngle="0">
                                                <v2_gradientColor colorPosition="0" gradientColor="#C7C7C7"/>
                                                <v2_gradientColor colorPosition="100" gradientColor="#c1c1c1"/>
                                             </v2_linearGradient>
                                          </v2_fillEffect>
                                       </v2_solidPaletteEntry>
                                    </v2_solidPaletteEntries>
                                 </v2_solidPalette>
                                 <!-- v2_solidPaletteRef ref="gDefaultSolid"/ -->
                              <chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="AGENCY_NAME"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_bar>
                           </v2_combinationChartTypes>
                           <v2_axis>
                              <v2_axisTitle refQuery="Query1">
                                 <v2_chartTextContents>
                                    
                                 <v2_chartTextItems><v2_chartTextItem><dataSource><staticValue>y-axis Values Display</staticValue></dataSource></v2_chartTextItem></v2_chartTextItems></v2_chartTextContents>
                                 <style>
                                    <defaultStyles>
                                       <defaultStyle refStyle="at"/>
                                    </defaultStyles>
                                 </style>
                              </v2_axisTitle>
                              <v2_axisLine lineWeight="0"/>
                              <v2_axisRange>
                                 <v2_automaticRange/>
                              </v2_axisRange>
                              <v2_axisLabels>
                                 <style>
                                    <defaultStyles>
                                       <defaultStyle refStyle="al"/>
                                    </defaultStyles>
                                 </style>
                              </v2_axisLabels>
                              <v2_majorGridlines lineWeight="0" lineColor="#CCCCCC"/>
                              <v2_majorBackgroundColors>
                                 <v2_firstBackgroundColor color="#D2D2D2" transparency="50"/>
                                 <v2_secondBackgroundColor color="#E2E2E2" transparency="50"/>
                              </v2_majorBackgroundColors>
                           </v2_axis>
                        </v2_topLeftAxis>
                        <style>
                           <defaultStyles>
                              <defaultStyle refStyle="ch"/>
                           </defaultStyles>
                        </style>
                        <noDataHandler>
                           <contents>
                              <block>
                                 <contents>
                                    <textItem>
                                       <dataSource>
                                          <staticValue>No Data Available</staticValue>
                                       </dataSource>
                                       <style>
                                          <CSS value="padding:10px 18px;"/>
                                       </style>
                                    </textItem>
                                 </contents>
                              </block>
                           </contents>
                        </noDataHandler>
                     <v2_defaultChartMeasure refDataItem="REVENUE"/><XMLAttributes><XMLAttribute name="titlesExpanded" value="true" output="no"/></XMLAttributes></v2_combinationChart>
                           </contents>
                        </pageBody>
                        <pageHeader>
                           <contents>
                              <block><style><defaultStyles><defaultStyle refStyle="ta"/></defaultStyles></style>
                                 <contents>
                                    <textItem><style><defaultStyles><defaultStyle refStyle="tt"/></defaultStyles></style>
                                       <dataSource>
                                          <staticValue/>
                                       </dataSource>
                                    </textItem>
                                 </contents>
                              </block>
                           </contents>
                           <style>
                              <defaultStyles>
                                 <defaultStyle refStyle="ph"/>
                              </defaultStyles>
                              <CSS value="padding-bottom:10px"/>
                           </style>
                        </pageHeader>
                        <pageFooter>
                           <contents>
                              <table>
                                 <tableRows>
                                    <tableRow>
                                       <tableCells>
                                          <tableCell>
                                             <contents>
                                                <date>
                                                   <style>
                                                      <dataFormat>
                                                         <dateFormat/>
                                                      </dataFormat>
                                                   </style>
                                                </date>
                                             </contents>
                                             <style>
                                                <CSS value="vertical-align:top;text-align:left;width:25%"/>
                                             </style>
                                          </tableCell>
                                          <tableCell>
                                             <contents>
                                                <pageNumber/>
                                             </contents>
                                             <style>
                                                <CSS value="vertical-align:top;text-align:center;width:50%"/>
                                             </style>
                                          </tableCell>
                                          <tableCell>
                                             <contents>
                                                <time>
                                                   <style>
                                                      <dataFormat>
                                                         <timeFormat/>
                                                      </dataFormat>
                                                   </style>
                                                </time>
                                             </contents>
                                             <style>
                                                <CSS value="vertical-align:top;text-align:right;width:25%"/>
                                             </style>
                                          </tableCell>
                                       </tableCells>
                                    </tableRow>
                                 </tableRows>
                                 <style>
                                    <defaultStyles><defaultStyle refStyle="tb"/></defaultStyles>
                                    <CSS value="border-collapse:collapse;width:100%"/>
                                 </style>
                              </table>
                           </contents>
                           <style>
                              <defaultStyles>
                                 <defaultStyle refStyle="pf"/>
                              </defaultStyles>
                              <CSS value="padding-top:10px"/>
                           </style>
                        </pageFooter>
                     </page>
                  </reportPages>
               </layout>
            </layouts>
         <XMLAttributes><XMLAttribute name="RS_CreateExtendedDataItems" value="true" output="no"/><XMLAttribute name="listSeparator" value="," output="no"/><XMLAttribute name="RS_modelModificationTime" value="2014-10-28T07:58:15.676Z" output="no"/></XMLAttributes></report>

BigChris

#3
31 Oct 2014 06:17:31 AM
Have you read the thread that MF attached? It answers your question and gives a very neat solution to the issue...I'll be using that in the future.

MFGF

#4
31 Oct 2014 06:46:40 AM
Quote from: Revathi_M on 31 Oct 2014 05:41:13 AM
I am Not Given any Condition
just simple report export to PDF or EXcel it not display,all my reports

i given attachment my out please check.

Hi,

No - that's exactly your issue here - you haven't defined a condition to allow parameter values to render in output types other than HTML, and you need to. The other thread explains that prompts on a report page only render when running as HTML - they don't render with any other rendering type (PDF, csv, Excel etc). It then goes on to explain how to set up a conditional block to show the parameter values in rendering types other than HTML. Have you tried following the approach the other thread suggests?

MF.
Meep!

MFGF

#5
02 Nov 2014 07:10:57 AM
Revathi_M wrote in a personal message:

QuoteHi MFGF,
my question like:http://www.cognoise.com/index.php/topic,26321.0.html
please explain me step by step
just i taken one value prompt and one list
then run it working  in HTML but remaning(PDF and XML) not working please explain me

all my report like that only
i am cresting report in report page only not prompt page.

i am waiting u r replay
thanks
Revathi

Hi,

Did you try the steps outlined in the post I pointed you to earlier in this thread? http://www.cognoise.com/index.php/topic,26304.msg83643.html#msg83643

The steps are detailed in there, but in case you can't get to that post for any reason, here they are again:

1. Go to the Condition Explorer, select Variables, drag in a new Boolean variable from the toolbox, and code the expression as:
IF (  ReportOutput() = 'HTML' ) THEN ( 1 ) ELSE ( 0 )
2. Go back to your report page and drag in a conditional block from the toolbox. Select the conditional block, and in the Block Variable property select your boolean variable.
3. Select the Current Block property and set it to Yes, then drag your prompts into the conditional block.
4. Select the Current Block property and set it to No.
5. Drag a layout Calculation from the toolbox into your conditional block and set the expression to be ParamDisplayValue('your prompt parameter')
where the value in the quotes is the parameter name used in one of your prompts. Repeat this for each prompt you have.

Credit to jayatu for this approach detailed in the thread I linked to.

Cheers!

MF.
Meep!
Print
Go Up Pages1
User actions
BSP Software Documentation
MetaManager Documentation and Knowledgebase
Version Control Documentation and Knowledgebase
BSP Software Resources About Us
MetaManager BSP Software Training BSP Software
Integrated Control Suite YouTube Channel Micro Strategies Inc
Security Migration IBM Cognos
Integrated Management Suite