Recent content by chaverly

Earlier this week, I put out a question about combining DataSources in Crystal XI for an Oracle database and a SQL database. I found out that Crystal Reports XI does not support this. I changed the report design and used the Oracle ODBC for the main report and the SQL Server ODBC to bring the...

I am using Goldmine 6.7 and Crystal Reports version 9. I have created a report in Crystal and placed it in a folder in Goldmine. In Goldmine I run the report, enter the parameters and have the report visible on my screen in Crystal. I press the Export button on the toolbar and nothing...

Crystal Reports Version 9 and SQL Server Database. We just upgraded to 9.0 from 8.5 last week. I am moving fields in Preview mode and I keep getting the "Change in Record Selection Formula detected" asking me to Use Saved Data or Refresh Data. I tried turning off "Display alerts on Refresh"...

I figured it out by myself. I had to open the subroutine and apply the changes in the subroutine including the File -> report Options and checked the Convert Database Nulls and Convert Others. Then I selected each Running Total field and selected Format Objects -> Number, Number, Custom and...

I just upgraded from CR 8.5 to 9.0 this AM. My datasource is SQL Server. In version 8.5 I have Running Totals of the number of Date fields as a Count. Count of VRG VRN VSE Total 0 0 1 1 1 2 2 5 Now my report is coming out as...

This works great, but what is it doing? I have never seen this before and would like it broken down. I understand the Left() part, but not the {address}length({address)) part.

I am using a Contact1 table a ContHistory table a Calendar table and a User Table1 and UserI_1 Table2 (alias Table User) Contact1 links to Calendar Table and ContHistory Table via the Account Number. Calendar Table links to User Table via UserID and ContHistory links to User_1 Table via UserId.

Can someone point me in the direction as to why Database -> Select Distinct Records on the menu bar is disabled? I checked the File -> Report Options and it is also disabled. I am using CR 8.5 and SQL Server database.

I see what you both mean. I ended up having to do 2 subroutines and sending month start date and month end date to 1 subroutine and year start date and parameter date to the other subroutine. Thanks, but I couldn't use suppress as I am doing a count and CR does count suppressed data. What I...

I am using Crystal Reports 8.5 and will be upgrading to 9.0 this week. My database is SQL Server. I have a report that asks the user for a Parameter called Date. I would like to create a group on this {?Date} so it will be Month To Date and Year To Date. I tried a Specified group on the...

I am using Version 8.5 Crystal Reports with an Access Database. Due to database design I am using a Not Equal Join on 2 tables. The Contact History table UserId to the AllUser table UserID. ContactHistory.UserId -> ALLUser>UserId. The -> link is the Not Equal Join. The ALLUser table is...

I am working with Crystal Version 10.0. I created a subreport and imported the subreport into my Main report. In order to create page headers in the subreport I followed another thread's directions. 1) I wrote a formula @all total Investment > 0 2) Grouped by @all 3) Selected Repeat Header on...

Crystal Reports Version 10.0. My mailing labels look great, but they alphabetically read down the first column and then down the second column, then down the third column etc. Is there a way to set the layout so the labels read across a row, then move down to the second row and read across the...

I am working in Crystal Reports Version 10.0. In version 8.5 I could not rename a subreport once I imported it into my Main report. In Crystal 10.0, can I rename the subreports without re-importing them?

I adopted the method found in Thread767-938969. Thanks lbass. It worked great.