?
Solved

Business Objects 11.5 Enterprise running Macros against scheduled reports in Excel Format

Posted on 2009-04-02
7
Medium Priority
?
693 Views
Last Modified: 2012-06-27
I have CR 11.5 Enterprise server that runs daily reports with an output format of Excel data only.  Users have to run Macros against the output.  Is it possible to have an Excel macro run against a Crystal report that is run via Enterprise report server?
0
Comment
Question by:PCGroup
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
7 Comments
 
LVL 17

Expert Comment

by:MIKE
ID: 24052717
Not that I'm aware of....

However, I've had "some" success by using Excel TEMPLATES that have the macros built into the Template...whereby this Template is LINKED to and bases it's data on a SET Excel export file.

You may be able to set it up that way, so that your Crystal Report automatically exports into the same set EXCEL EXPORT FILE...so that the EXCEL TEMPLATE..or MAIN FILE will AUTOUPDATE its data, macros and all,...when you open it...

Hope it makes sense...it does work...but you need to have it setup
0
 
LVL 26

Expert Comment

by:Kurt Reinhardt
ID: 24080115
What are the purposes of the macros?  Users often ask for data to be dumped into Excel only to just perform the same repetitive activities (like macros) against the data on a recurring basis.  This is mostly just because "its the way we've always done it". Why not find out what the macros do and then design a report (or reports) that give them what they actually need?  If they're running macros to "scrub" data, why not do it in the report in the first place?  If the macros create pivot tables, why not design a report with crosstabs?

~Kurt
0
 
LVL 101

Expert Comment

by:mlmcc
ID: 24083873
I agree with Kurt.

I always questioned why users needed data exported to Excel.  Generally it was to present the data in a different way or with some columns removed.  We tried to provide special reports but for a system with 5-600 users special was difficult to respond to since once the door is opened the flodd gates also open.

mlmcc
0
Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 

Author Comment

by:PCGroup
ID: 24130208
I agree as well. Unfortunately, the output was difficult to mirror with Crystal.  The end users use the Excel sort and filter functions to manipulate a daily report once the macro is run.  They keep the daily Excel files so I'm not sure the template concept will work but I will give it a go this week.

Thanks
0
 

Author Comment

by:PCGroup
ID: 24502009
No luck getting the template to work due to the need to name the exported file with a unique name every day.  I will close this question if no one objects.
0
 
LVL 101

Accepted Solution

by:
mlmcc earned 2000 total points
ID: 24504774
There is a 3rd-party tool that can export and allow you to change the filename as you desire.

http://www.milletsoftware.com/Visual_CUT.htm

mlmcc
0
 

Author Closing Comment

by:PCGroup
ID: 31565914
This software in combination with a batch file to run the macro did the trick.
0

Featured Post

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I hate sub reports and always consider them the last resort in any reporting solution.  The negative effect on performance and maintainability is just not worth the easy ride they give the report writer.  Nine times out of ten reporting requirements…
Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
In this video we outline the Physical Segments view of NetCrunch network monitor. By following this brief how-to video, you will be able to learn how NetCrunch visualizes your network, how granular is the information collected, as well as where to f…
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…
Suggested Courses

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question