Your SAS programs, embedded in web apps and elsewhere

Drill Down reports export to Excel

Reply
Occasional Contributor
Posts: 10

Drill Down reports export to Excel

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
SAS Super FREQ
Posts: 8,864

Re: Drill Down reports export to Excel

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
Occasional Contributor
Posts: 10

Re: Drill Down reports export to Excel

Posted in reply to Cynthia_sas
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
SAS Super FREQ
Posts: 8,864

Re: Drill Down reports export to Excel

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
Ask a Question
Discussion stats
  • 3 replies
  • 261 views
  • 0 likes
  • 2 in conversation