Forum Discussion

abpgupta's avatar
abpgupta
Icon for Continued Contributor rankContinued Contributor
5 years ago

Paginated Report: Conditionally Show or Hide based on report output type

Hi All,   I want to hide header when report is exported in Excel format but continue to display it in PDF format.  Is there any way to achieve this functionality in Paginated report?   Thanks in...
Need Help
Tips and Tricks
abpgupta's avatar
abpgupta
Icon for Continued Contributor rankContinued Contributor
5 years ago

Hi lbendlin , 
There is only Page available in Paginated Report so not sure if I understand the solution correctly. Can you please also tell what will be parameter/function is to determine Export Type (Excel/PDF)? Thanks!

v-janeyg-msft's avatar
v-janeyg-msft
Icon for Community Support rankCommunity Support
5 years ago

Hi, abpgupta 

 

It’s my pleasure to answer for you.

According to your description,I think there is no existing function that can directly meet your needs.

You need to save two version reports (hide header/not hide header),one for excel,another for PDF.

Like this:

If it doesn’t solve your problem, please feel free to ask me.

 

Best Regards

Janey Guo

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • abpgupta's avatar
    abpgupta
    Icon for Continued Contributor rankContinued Contributor
    5 years ago

    Thanks v-janeyg-msft !
    I am looking for way similar to Cognos where we can control it with Conditional Variables based on report output types without need to create multiple reports for each output type.