topic Drill Down reports export to Excel in Developers

Drill Down reports export to Excel

MetaLib — Fri, 03 Sep 2010 10:08:35 GMT

Hi

On our web server we have drill down reports for some of our users and one of the features the users would like to use is to drill down to a specific level then export the results.
The export function is an Internet Explorer function that works with any table on a web page.

While trying to export it prompts you for a username (metadata). Then for a Web-Logic username.
Which username is this?
I've tried everything I can think of but none of the obvious (including Weblogic Admin) work.

Regards
Metalib

Re: Drill Down reports export to Excel

Cynthia_sas — Fri, 03 Sep 2010 14:45:40 GMT

Hi:
Are you using SAS Stored Processes for your reports??? What is your client application?? The Information Delivery Portal??? Web Report Studio??
What version of Internet Explorer are you using??? I have IE8 and when I open an HTML page that contains a table, there is no export function?? However, when I use Web Report Studio, I do have the choice to export to Excel.

cynthia

Re: Drill Down reports export to Excel

MetaLib — Sat, 04 Sep 2010 07:39:29 GMT

Hi Cynthia

Sorry for not providing enough info.
Yes, we are using Stored Process for the drill down reports and the users access it through the Delivery Portal.

I have tried it using IE 7 & 8 although some of the users are still on IE6 and it is consistent on all three versions.

I haven't tried the export from WRS yet.

Is there a way I can attach screen shots?

Regards

Re: Drill Down reports export to Excel

Cynthia_sas — Sat, 04 Sep 2010 15:26:22 GMT

Hi,
If you work with TechSupport on this you can show them your code and your screen shots and they can help you resolve your issue.

There are a lot of different ways you could be doing drill downs ... From OLAP cubes, from graphs to static reports, from graphs to dynamic drill down reports, from summary tables to static or dynamic detailed reports, etc, etc and the code and method will make a difference in the answer.

Tech Support is your best resource.

Cynthia