Search results for query: *

I am trying to figure out how to change the size of the ticks on a line graph. I have changed some of the properties under the X-Axis properties but it does not affect the report.

I am using Crystal Reports v. 8.5. I have created a report in landscape view which prints fine from my side. However, I have users running the report from a compiled executable on a central server and when they run it, it comes up in Portrait view. They can change it on the print setup button...

Thank you both. I am going to use the PL/SQL package.

Can anyone tell me if it is possible to call an FTP from within an Oracle stored procedure. If so, how would this be done. Thank you in advance for any suggestions.

I am using CR 8.5 on an Oracle 8i database. I have a main report which gives me all of the values that I need except for one which is the "Available Credit". I have determined that I need to use 2 subreports and find the difference between these to derive the "Available Credit". Also, one of the...

I have a report that consists of a Page Header, 3 group headers and footers, 1 detail section, and 3 Report Footers. There is a subreport in both Report Footer B and Report Footer C. I want to repeat the Page Header for every page in the main report so I added OnLastRecord to the Suppression...

I compile the reports in Crystal by going to the Report drop down and choosing Compile Report. This creates an executable of the report. The users are mapped to the location where the Crystal report, the crf file, and the executable are located. They run it from thier machine.

We are using Crystal Reports version 8.5 and the users have the runtime client installed on their pcs. The reports are on a shared drive on the server and each user has access to the folder. When they run the compiled exe from their pc, it will not retain their established printer. They are...

I am trying to conditionally suppress text using the instr function. for example the data that I'm testing ends in either W, F, C, or L. The field that I'm testing is called APNO. In the Format Editor, I click on the X+2 box by Suppress and enter this formula to suppress the text for numbers...

Thank you for your reply, however right after I submitted the post I was able to get my formula to work. The formula works as designed, it uses yesterday as the run date if nothing is entered, however it displays today's date. How do I get it to display yesterday's date in the parameter value box?

I have a parameter for run date range in my report. I want the user to be able to enter a specific date range, however I want it to default to current date - 1. The date I'm using is "ACTDTTM". I have tried this with no success: if {?Run Date Range} <> {?Run Date Range} then...

Thank you for your help. I was able to get this to work by changing the database using convert database driver.

I am making sure that I have the ODBC connection to the production database when I compile the report but when I run the compiled executable it still defaults to the original database.

I am using an Oracle 8 ODBC connection.

Thank you for your response. I have tried logging into the production database and compiling it from there but it still defaults back to the database that it was originally created from.

I have some Crystal Reports 8.5 executables that my users will be running. The problem is that when they run the executable the database and login info automatically defaults to the database that was used when the report was created. Since this is a test database and we will be extracting data...

That works perfectly. Thanks so much.

Hi, I have added a column heading in the group header section of a report and conditionally suppressed it if the recordnumber <> 1. This works as expected, however it leaves a blank space if more than one record. How can I suppress the blank space that this leaves when there is more than 1...

Thanks for your response. Could you elaborate just a bit more please?

I have created a view to return values that are similar and I need to add an if then else condition in the where clause of the view. Is it possible to add a pl/sql procedure to a view? If not, what's the best way to do this?