Intel,Altiris Group

There was an article called "Where do I find the saved report" asking about this issue.  It has been closed due to inactivity after the posted resolution.  The resolution was to wait because there was just simply a delay in the "Save As" dialog box from popping up.  This was not the case.  The "Save As" never ever appered"

Issue:

Can not do a "Save As" in a custom report  (See Screen Shots)

Environment:

NS:   7.0 SP5

SQL 2005 64 bit Off box

Explanation:

I tried to save a report into a spreadsheet.

1.  The following came as expected

 The next window also came up without any problems.  

After clicking "Save" on the previous window the

This window never pops up.

Resolution:

When joining other tables, the column/field may by default use the same name as an existing column.  in my case [Compouter].[Name] and [AddRemoveProgram].[DisplayName] both defaulted as Name for the column name.  The report runs fine, but the "Save As" window never pops up if the field names are the same.

Simply use a unique Alias when adding fields (screenshot below)

if using RAW SQL make sure you do your statement as

select [Column1_Name] as [unique name1], Column2_Name As [Unique Name 2] etc.

The arrow in the "report builder" screen shot should be pointing at the "Alias" column, not the "Select" column.

Hi,

I suggest you in cases : save as static filtere not working for custom reports, you can automate the report running and email it using a notification policy, but it won't send it as a CVS. If you copy the report results out of the report you can paste it into excell and save as a CVS

Select"File" then " save as", give your report a name like "example Inc.search exception" and click"save"

regards.