Excel Report Writer

  • Thread starter Thread starter Rich Mogy
  • Start date Start date
R

Rich Mogy

Hi All,
I may be crazy, but I thought there was an Access like report writer that
you could add-in to Excel. You could then use an Excel "database" and then
create reports like Access does.

Am I going crazy, or, if not, where do I get this. I think it was a free
add-in.

Thanks

Rich
 
In XL97 under the menu item View is a tab call Reports. It might do what
you want...
 
Hi, just thought I'd let everyone know that there is an Excel Report Writer (Beta) via the LinkedIn Group Blackbelts (I can't currently post links).


XLSRW Report Writer Version:01.02

What is this?

This software can be used to generate reports in Excel based on data from an exteral source.

Detail can be dynamically printed side by side. There are up to three grouping levels available.

How do I use it?

There is a user guide availabe at ... - that explains in detail how to use the software.

As a quick overview you will begin by importing data into the spreadsheet using standard Excel functionality. Based on this data you can create a design of the data. You are able to take advantage of Excel's formatting tools, and utilise applicable Excel functions. You can define page breaks and page headers / footers. The final step is generating the report at a click of a button.

Why must I register?

We are offering this for free, but intend to sell an improved version in the future. You will be able to use this software until the end of 2014. In the meantime it is a way for us to track how many users we have.

The process is easy, and is explained in the user guide.
 
Hey Michael,

I am using your beta version 01.04 of XLSRW Report Writer to recreate a fairly simple report but am having problems generating proper breaks between Groups 1 and 2 - Also, how do you maximize the number of print lines per page - I've read the user guide a couple of times and can't find the answers.

Your help would be most appreciated - thx!!!
 
Hi KC Actuary,

Sorry to hear you're struggling with the report writer.

From memory you should be able to set breaks between the groups. How about you send me a sample via email and I'll see if I can make it work for you?

The number of print lines per page is not a current feature. I would be happy to work with you to add that functionality.

Regards, Michael
 
Back
Top