 |
Welcome to the EMuUsers discussion forums. All registered users are
encouraged to post new topics and also to participate in existing
discussions.
* You must register first if you wish to make postings.
* You can subscribe to one or more forums to receive email notification when new messages are posted.
* Click on a correspondent’s name to find out their title and institution.
|
| Author |
Messages |
|
Alva Maguire
Posts:3
 |
| 02-11-2007 5:16 PM |
 Alert
|
Hello EMu users
I am trying to create a new report in PowerPoint. I have been able to get as far as giving it a title and selecting it from the Report list, however I am not able to open the report file - the "Open" button is greyed out and I get a message "report file has not been specified. Do you want to start a new report?". I select "Yes" and a blank PowerPoint file opens. Is anyone please able to advise where I am going wrong?
regards
Alva
|
|
|
|
|
yanwei
Posts:0
|
| 14-11-2007 3:44 PM |
Alert
|
Hi Alva
Sorry for the delay reply. (I thought I have replied to this post already.)
When you say you want to create a new PowerPoint report, you are not trying to use a report that is available in the Client. In this case it is like creating a new Crystal Report. You will need to:
1. Create a new Reports entry by selecting the fields.
2. Create a new PowerPoint file (.ppt or .pps) as you would for a new Crystal report (.rpt). As PowerPoint is not a normal reporting tool like Crystal report, you will need to use VBA scripts (macro). This is similar to the Word and Excel reports. This is why you get a blank PowerPoint file when you click on "Yes".
3. After you created the PowerPoint file, then you click on Save and save the .pps or .ppt file into EMu.
In step 2, the VBA script will do two things:
1. Connect to ODBC.
2. Arrange the data on the slids and notes page.
For an example of how to connect to the ODBC, you can look at the Word and Excel examples in EMu Help. For example: Contents page -> Working with EMu Records -> Reporting -> Microsoft Excel -> Creating an Excel report using Visual Basic -> Step 2: Create the report in MS Excel -> 1. Write the VB code.
The other place where you can find an example is the existing PowerPoint reports on your Catalogue and Multimedia modules.
Hope this helps
Yanwei |
|
|
|
|
|
| You are not authorized to post a reply. |
|
|
|
ActiveForums 3.6
|
|
 |