no selections in report manager

[user]

I did all required in installation and when the Report Manager comes up
I get no options either under "view or scenario", All I see is "none".
No selection in the drop down for any of the 6 out of 20 columns I want
to print.
Is my Report Manager corrupted? I just d/l it today from the MS site.
Running Excel 2002.

 

[Debra Dalgleish]

You'll only see items in those dropdowns if you've created some Custom
Views (View>Custom) or Scenarios (Tools>Scenarios).

Otherwise, you can select a sheet, and add it to the report that you're
creating.

 

[herbzee]

Thanx Debra; I did the tools>scenarios (view>custom did nothing for me)
and after selecting the columns I wanted, I tried "show" and nothing
happens. What should be my next move? BTW I'm an 85 yr old super senior,
so a step by step hands-on assist would be extremely helpful.
cheers-Herb.

 

[Debra Dalgleish]

Does your worksheet have 20 columns of data, and you only want to print
6 of them? Is that what you're trying to control with the Report Manager?

 

[herbzee]

Yes, thats it. It works so well in MS Works, trying to do the same in Excel.

 

[herbzee]

Yes !!!!

Does your worksheet have 20 columns of data, and you only want to print
6 of them? Is that what you're trying to control with the Report Manager?

 

[Debra Dalgleish]

You could create two Custom Views -- one with all the columns visible,
and one with the columns that you don't want to print hidden.

To create the first custom view:

Show all the columns
Choose View > Custom Views
Click the Add button
Type a name for the custom view, e.g.: All Columns
Leave the check marks in the option boxes
Click OK

To create the second custom view:

Hide the columns you don't want to print
Choose View > Custom Views
Click the Add button
Type a name for the custom view, e.g.: Print Columns
Leave the check marks in the option boxes
Click OK

To create the report:
Choose View > Report Manager
Click the Add button
Type a name for the report, e.g. Hidden Columns
Select the Sheet you want to print
Select the Custom view (Print Columns)
Click the Add button, then click OK
Click Close

To print the report:
Choose View > Report Manager
Select the report (Print Columns)
Click the Print button

 

[herbzee]

Hi Debra, Yes, that's excactly what I'm trying to do. The same as I do
in MS WORKS.