Search results for query: *

Not sure if Great Plains uses its own registry key for Crystal, but I have Crystal 8.5 and Crystal XI on my machine and was able to find the registry key that you are looking for. I'm not sure which version of Crystal GP 8.0 uses but in the registry if you go under HKEY_CURRENT_USER and then...

You will need to have that barcode font registered on your machine. If you already have the EAN-13 barcode font on your machine then it should appear as one of the font selections within Crystal. If you do not have this font, a simple internet search should point you in the right direction of a...

not sure if your are trying to get the first of the month based upon the current date or from an actual field from within your report, but this should give you what you are looking for. --Will get you the first of the month based upon the current date DateTime (Year(CurrentDate())...

Right click on the date field and choose format field. You should see a date tab and from within there you should be able to format your date with the name of the day included.

Go into the section expert and in your page header section click on the formula editor for the suppress option. Within there just put PageNumber = 1 That should do it for you.

Have you tried putting NOT ONLASTRECORD in the conditional formula editor?

There are two freeware products that I know of which will email reports to a user. If you do a search for either Crystal Delivery or Crystal Passage you should find links to various download sites.

You could also change it in the report settings, but this would convert all datetime fields on the report to just a date. Just go to File/Report Options and then change the Convert Date-Time field option to Date.

I have a problem where our system stores employee vacations with only a start date and end date. So if an employee takes off for five days I only have two fields to work with, start date and end date. The problem is I need to look at each date within this range to determine by day of week what...

Insert a group for your date field. When you setup this group in the section that says 'This section will be printed' choose for each month instead of for each day. This will allow you to subtotal by month.

You should be able to create a formula and put it in the report header in place of the actual parameter. If you just want the words "All Physicians" to show instead of zero then create the following formula IF {?doc_numb} = 0 Then "All Physicians" Else {?doc_numb}

I wouldn't use the temporary table itself. Are you able to create stored procedures in SQL Server? If so, I would create a SP that then calls the temp table. This is the method I use whenever I have to create a temp table.

You can try this script, this is what I use when I need to find names within a stored procedure. It should list every stored procedure which contains the text entered. select distinct so.name from syscomments sc inner join sysobjects so on sc.id = so.id where xtype = 'P' AND charindex('...

I'm using CR 9 with SQL Server 2000. I need to build a benchmark report that will be sent to a client and will display the total number of calls they took for the past 12 months in comparision with other clients we have. The only problem is that we cannot release the names of the other...

You will also need the sscsdk80.dll and pg32conv.dll in order for the charts to appear on a user machine.

If you always want the parameter to be a string and you have access to the stored procedure you can easily change it there. If that is not an option you could always create a formula in crystal like CStr({?@YourParameter}). This will convert the parameter to a string.

I had the same exact problem. Never happened to me until I upgraded to XP SP2. Locate your crw32.exe file, right click and select properties. Go to the compatibility tab, check 'Run this program in compatibility mode for' and select Windows 2000. Open up your report again and then try to save.

A simple solution to this would be to run your report and then export using the report definition format. This will write the report to a txt file and will show you the internal makeup of the report. It may not contain everything that you listed, but it will be really close to what you are...

Do you know if anyone else has access to the report on the network? If someone else has the report open then you will not be able to save the report. Also, right click on the report and look at the properties to make sure that the report is not read-only. If it is you will be unable to the...

I am having to setup 8 new sales people on our ACT database. 6 of them are going to be remote users that are going to connect to a shared folder through a VPN. I am a little confused on what the synchronization settings should be for the Admin and the rest of the the remote users. Each user...