Search results for query: *

The code below produces a compile error in the VBA macro builder window. The "red" error line is line 9 (starts with "ActiveWorkbook.PivotCaches...". I'm about 99% sure the problem is with my SourceData value and the range I'm attempting to set this to. Can anyone see anything wrong with this...

Ok I have zero Oracle experience. I use Crystal Reports and someone once came to my cube and installed some Oracle software on my machine and I could then connect to an Oracle database and build reports. I have no idea what the database version is that I was connecting to. I do know that when...

I'm using Microsoft Excel 2003. I've played with this enought and can't figure it out... Macro code is below. The very first thing my auto run macro does is check to see if a file exists. I'm testing it repeatedly with the file missing so Excel will shutdown (quit). Each time this code...

First question: Does anyone have any recommended (free) sites that do a good job of teaching the object model? Something that starts at the newbie level and advances would be great. More interested in Excel than anything else. I've Googled and found some stuff but was looking for input from...

Hi, I'm really new to Excel VBA programming and have the question below. I'm using Excel 2003 on a laptop. I have the following procedure that is passed an array of worksheet names: Sub EmptyWorksheets(IndWrkShtArr As Variant) For i = 1 To UBound(IndWrkShtArr) Sheets(i).Select...

First question: Does anyone have any recommended (free) sites that do a good job of teaching the object model? Something that starts at the newbie level and advances would be great. More interested in Excel than anything else. I've Googled and found some stuff but was looking for input from...

Hi, I'm really new to Excel VBA programming and have the question below. I'm using Excel 2003 on a laptop. I have the following procedure that is passed an array of worksheet names: Sub EmptyWorksheets(IndWrkShtArr As Variant) For i = 1 To UBound(IndWrkShtArr) Sheets(i).Select...

CR XI and CR Server for batch processing. I have a report that's grouping on account. I use header, footer, and detail formulas to handle some one to many issues. Each account can have many opportunities (opps) associated with it and each opportunity has an estimated close date and a last...

I'm using CR XI. And CR Server to batch run report. I have a simple list report about three columns. The report is dealing with some one-to-many issues by concatenating data into one column. EXAMPLE: An account can have many opportunities associated with it. Each opportunity has an...

I'm using CR XI. And CR Server to batch run report. I have a simple list report about ten columns. And the report is dealing with some one-to-many issues by concatenating data into one column. EXAMPLE: An asset that's downloaded can have many forms I concatenate each into the Asset Forms...

Hi, I have CR Enterprise Server (CRES) XI installed with about 50 reports running on the system. I have to move this instance of CRES from System A to System B. My plan is to 1) Install all CRES on System B. 2) Install all (CRES) patches I've installed on System A to System B. The next...

Hi, I'm using the BO 6.51 webi tool (java report panel). A report I have is sourcing data from two tables that have a one to many relationship (contacts to contact codes). My output has the contact name and the contact code number as below. Contact ContactCodeNumber Joe 1 Joe 5 Dave 3...

Hi, I have no Oracle experience only Teradata however my current project requires me to write some SQL to put in a CR Add Command. I'm using CR XI. I have one report that uses an Add Command to pull data back from Oracle (what version of Oracle I don't know but probably 9i). This report...

Hi, I have Excel 2003 with SP2 running on XP. I have a workbook that imports data from an external database. I refresh the data in the workbook by opening the workbook and running an import query. I'm wondering if there is an automated way to do this. Is there a way to write a macro or...

Hi, I'm using CR XI developer on my PC (latest updates have been applied). I'm connecting to a Teradata database via ODBC. I've created an Add Command SQL statement. The statement is below and when executed it returns the message: Database Connector Error: 'Cannot obtain error message from...

Hi, I'm using CR XI and CR Server. What I need to do is email an Excel report out if the report has some data in it. Don't email it if no data is in the file. In order to do this I'm doing the following via CR Server in the following order: 1) Running the report and outputting to disk a...

Hi all, I am a semi-experienced CR XI person - I have no experience with CR v10. I have been asked to consult with someone that has CR v10 - they publish developed reports to a CR v10 server for access over the web. The CR v10 reports source data from DB2 via ODBC. They are going to change...

Hi, I'm using Crystal Reports XI against a Teradata database. I have a simple report that outputs about 8 fields. Two of the fields are comment fields and can have a significant amount of text in them. I have minimized the width of all non-comment fields in order to maximize the width of the...

Hi, I'm using a report generating program (Crystal Reports) to automatically generate and place on a network drive five Excel workbooks once per week. The reporting application has the ability to email the workbooks to recipients but the problem is it is not smart enough to not email out a...

Hi, I'm using CR XI and XI Server with a Teradata database. ISSUE 1 I just created my first cross tab report using the cross tab wizard. I need to be able to create custom formulas based upon data in the cross tab output (column summary and row summary and detail intersection data) so I can...