Search results for query: *

Hello, using Crystal 9, is it possible to turn a text field to a number WHILE preserving the original format. for example, the text field below is a customer number "024625" and I wish to turn this into a number, if I apply the ToNumber command to the field, I get 24625 which is not what I...

Is there a way to write a stored procedure using SQL Query analyzer for a Crystal Report that will prompt for the user for the number of records to retreive? In the past we have gotten away by using Select top 10... but they would like more flexibility. The end-user would like the...

below is entire code With ActiveSheet.PageSetup .PrintTitleRows = "$1:$1" .PrintTitleColumns = "" End With ActiveSheet.PageSetup.PrintArea = "$A:$U" 'ActiveSheet.CenterHeader.Paste With ActiveSheet.PageSetup Range("A1").Select...

I created a macro in which I had to set the print settings using: With ActiveSheet.PageSetup .PrintTitleRows = "$1:$1" .PrintTitleColumns = "" ActiveSheet.PageSetup.PrintArea = "$A:$U" End users complained that after the macro finishes, the Vertical scroll bar is slow, and in fact...

I have a report that needs to be sorted by different columns depending on the end user. I wrote a macro that shows the column name and a button so the end user can select the column they wish to sort on - Descending or Ascending Value My problem is that I want to select everything between row...

I have a report that needs to be sorted by different columns depending on the end user. I wrote a macro that shows the column name and a button so the end user can select the column they wish to sort on - Descending or Ascending Value My problem is that I want to select everything between row...

Hi, By default most (if not all reports) created require multiple parameters to be entered in order to run the report. For example: to run sales, the report prompts the user to enter a period (@pe) '0104' and the department (@dept) 'San Francisco'. If I schedule the report, I need to not...

I hope this helps you. In format editor/Font/Color type in the formula below: IF {@formula} < 0 then crRed else crBlack. You can find more information under the formula Function Tree under Color Constants.

Does anyone have an example of sorting based on a parameter field. I would like the user to select how the report will be sorted. Either by Customer, or by Region, or by Sales, etc... The book Crystal Reports Professional Results has example that I just do not understand. Any help is greatly...

Thanks for validating my question MJRBIM, unfortunalty our users are 'unwilling' to 'deal' with the scheduler - my guess is that v8.5 spoiled them. In any case, thanks for the feedback. now if i can only get a hold of SynapseVampire...

We are using Crystal Enterprise. User log into e-portfolio to run reports which they then extract to excel or PDF. The plug in External Window Handler for Acrobat is installed - this allows users to view PDF files in their web browsers. This is enabled in v8.5 but apparently it is not enabled...

We are in the process of updgrading from v8.5 to v9. In v8.5, when users export to PDF, Crystal Opens a Web-based PDF viewer from which the user can email the document they are viewing (by selecting 'Send Page' from the Email option on the browser. In v9, Crystal Exports the report to the...

You can set the password for the report in the management console, under databases.

We are in the process of switching from v8.5 to 9. Our endusers are concerned that v9 does not keep the same formatting in excel as do v8.5 reports. In version 9, when we export to Excel 2000 97-2000, the text control function of the worksheet Wraps text and Merges cells arbitrarily. When we...