Custom Reports

kojak43 · Apr 4th, 2002, 12:13 PM

I have searched all Mr Excel for tips and archives and have been unable to find a step by step tutorial on how to create a custom report.
Anyone have any direction about this?

Damon Ostrander · Apr 4th, 2002, 01:43 PM

Hi Kojak,

I'm not sure exactly what you mean by a report. Perhaps this will help: there are two report features built-in to Excel, one for reporting Pivot table and Pivot chart results, and another for worksheets and scenarios. This latter one is called Report Manager, and if you search for this title in the Excel helps you will find a reasonably good explanation of how to use it.

kojak43 · Apr 4th, 2002, 01:57 PM

Thanks for the prompt reply.
I went to Excel. ('97) Help and searched for Report Manager. And yes there are instructions.
The instructions read, goto-Menu>View>Report Manager.
There is no Reports Manager under my View.

However I do have Menu>Accounting>Report Wizard. But when I click on that I get an error message saying I do not have a file named veenlr3.hlp.

Any guidance will be appreciated.
Thanks
K

bhmcpfs · Apr 4th, 2002, 02:18 PM

Go to Tools, AddIns... scroll down and be sure Report Manager is checked. If it is, you should be able to bring up the Report Manager box as you stated (View, Report Mananger...).

kojak43 · Apr 4th, 2002, 02:26 PM

There is no checkbox nor the words Report Manager in Menu>Tools>AddIns in my copy of Excel.
Maybe it is an orphan. At least I am beginning to feel like a motherless child.

Damon Ostrander · Apr 5th, 2002, 09:11 AM

Hi again Kojak,

Yes, I've had that feeling too. I looks like you have a very limited install of Excel. You will need to go back to the Excel or Office installation and add the Report Manager via a custom install. If for some reason you can't do this, post your email address and one of us will email it to you. It is a .xla file that must be put into your Add-Ins or Library folder. The custom install is the best way though, since you may then pick up other things you are missing as well.

Damon

kojak43 · Apr 5th, 2002, 09:19 AM

Thanks, I'll go to IT and ask that they do this.
I have Excel 2000 at home, and was able to do all the things you recommended yesterday.
Now I just have to have the office application match what I can do at home.
Again, my thanks for pointing me in the right direction.

Apr 4th, 2002, 01:43 PM	#2
Damon Ostrander MrExcel MVP Join Date: Feb 2002 Location: Denver, Colorado USA Posts: 4,014	Hi Kojak, I'm not sure exactly what you mean by a report. Perhaps this will help: there are two report features built-in to Excel, one for reporting Pivot table and Pivot chart results, and another for worksheets and scenarios. This latter one is called Report Manager, and if you search for this title in the Excel helps you will find a reasonably good explanation of how to use it. __________________ Keep Excelling. Damon VBAexpert Excel Consulting (My other life: http://damonostrander.com )

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 4th, 2002, 12:13 PM	#1
kojak43 Board Regular Join Date: Feb 2002 Posts: 270	I have searched all Mr Excel for tips and archives and have been unable to find a step by step tutorial on how to create a custom report. Anyone have any direction about this?

Apr 4th, 2002, 01:57 PM	#3
kojak43 Board Regular Join Date: Feb 2002 Posts: 270	Thanks for the prompt reply. I went to Excel. ('97) Help and searched for Report Manager. And yes there are instructions. The instructions read, goto-Menu>View>Report Manager. There is no Reports Manager under my View. However I do have Menu>Accounting>Report Wizard. But when I click on that I get an error message saying I do not have a file named veenlr3.hlp. Any guidance will be appreciated. Thanks K

Apr 4th, 2002, 02:18 PM	#4
bhmcpfs Board Regular Join Date: Apr 2002 Posts: 88	Go to Tools, AddIns... scroll down and be sure Report Manager is checked. If it is, you should be able to bring up the Report Manager box as you stated (View, Report Mananger...).

Apr 4th, 2002, 02:26 PM	#5
kojak43 Board Regular Join Date: Feb 2002 Posts: 270	There is no checkbox nor the words Report Manager in Menu>Tools>AddIns in my copy of Excel. Maybe it is an orphan. At least I am beginning to feel like a motherless child.

Apr 5th, 2002, 09:11 AM	#6
Damon Ostrander MrExcel MVP Join Date: Feb 2002 Location: Denver, Colorado USA Posts: 4,014	Hi again Kojak, Yes, I've had that feeling too. I looks like you have a very limited install of Excel. You will need to go back to the Excel or Office installation and add the Report Manager via a custom install. If for some reason you can't do this, post your email address and one of us will email it to you. It is a .xla file that must be put into your Add-Ins or Library folder. The custom install is the best way though, since you may then pick up other things you are missing as well. Damon

Apr 5th, 2002, 09:19 AM	#7
kojak43 Board Regular Join Date: Feb 2002 Posts: 270	Thanks, I'll go to IT and ask that they do this. I have Excel 2000 at home, and was able to do all the things you recommended yesterday. Now I just have to have the office application match what I can do at home. Again, my thanks for pointing me in the right direction.