Thank you Sultan for replying.
I have tried this and when I am running report directly its generating Excel output but when I am calling same report in Drill Through from Dashboard its opening in browser instead of generating the Excel.
Thanks,
Danish
------------------------------
Danish Iqbal
------------------------------
Original Message:
Sent: Tue October 20, 2020 02:12 PM
From: Sultan Malik
Subject: Generating Excel Report Driectly by Cognos Drill Through from Dashboard
Hi Danish - how about if you create a copy of this target report and set default output format as excel in report properties and try calling this copy report from your dashboard.
Thanks,
Sultan
Original Message:
Sent: 10/18/2020 8:05:00 AM
From: Danish Iqbal
Subject: Generating Excel Report Driectly by Cognos Drill Through from Dashboard
Hi,
I want to call report from Cognos Dashboard through Drill Through and want to generate Excel Output directly. I have changed the format from report properties to Excel and when I run the report directly its generating the output in Excel. But when i am calling the same report from Dashboard Drill Through its opening in browser (as HTML) instead of Excel. I did not find any option at Dashboard level to set the property. Can you please suggest on it.
Thanks,
Danish
------------------------------
Danish Iqbal
------------------------------
#CognosAnalyticswithWatson