Search results for query: *

Sometimes the version that comes with other programs isn't the newest version of Crystal. If you have the Peachtree disks, you might have better luck uninstalling the program, since some lower versions did not have uninstall features available on the local computer but may have it if you put...

I've also seen this happen in other versions exporting to PDF. The problem most likely is the custom font. There may be a way to get PDF to recognize this font by checking out the Adobe website. Otherwise, I would say the best idea would be to stick to standard font styles. Christine Crystal...

How about grouping by the month formula, (returns 1 to 12) then creating a formula for the group name to use the following: monthname({@month}) That way you are grouping on the numbers in order but get the names you want for the months to appear on the report. Christine Crystal Training and...

If you can create this summary on the detail level and then do this percent as an insert summary percent option you can then use the Top/N to sort the report by this percent summary. I just tried this in 8.5 and it works well. Christine Crystal Training and Consulting crosenbaum@Strafford.com...

Have you tried this: Check your ormap.ini file and check the location of the repository. I think when you set up Crystal 9 it defaults to a Crystal access repository. I think you need to change the default from Crystal to something else, ie a SQL database. Hope this helps. Christine Crystal...

Have you tried this: whileprintingrecords; global stringvar array weekdaynames; join(weekdaynames,",") Christine Crystal Training and Consulting crosenbaum@Strafford.com www.crystaltraining.com

Hi, I would like to know if there is a way to search an item to figure out if it is all uppercase and just display those items. The reason why is that some items in the database are inserted in mixed case and some in all uppercase. Using Crystal version 8 Thanks, Christine Crystal Training...

Can't you create the report in one version and then convert the database drivers to make it work for the other version? Christine Crystal Training and Consulting crosenbaum@Strafford.com www.crystaltraining.com

Use this formula: local stringvar first := Left ({@name}, instr ({@name}, " ")-1 ); local stringvar last := Mid ({@name}, instrrev ({@name}, " ")+1); first + " " + last Hope this helps Christine Crystal Training and Consulting crosenbaum@Strafford.com...

Here goes, create 3 things; One reset place in group header: whileprintingrecords; global numbervar count_names := 0; 2nd place in details section (can suppress it): Whileprintingrecords; global numbervar count_names := count_names + 1; Create a count by group of the countys Put the group...

Hi, If you want further information about this topic or classes a good place to start would be looking at the Crystal Decisions website to see an outline of the courses that are offered around the country. alley

Sorry: In your group header put the following formula: whileprintingrecords; global numbervar yes_sales := 0; global numbervar no_sales := 0; Place the calculation formula in the details section place the two formulas that give you the amount in the group footer. alley

I'm confused on what you mean by init. alley

Hi, I would use some variables: 1st formula: whileprintingrecords; if {order_completed} = "Y" then global numbervar yes_sales := Yes_sales + 1 else // throwing in "N" just in case there is another possiblity if {Order_completed} = "N" then global numbervar...

Just in Case, If the database you are trying to change to is a different type than your original you may need to change the database driver then set the location. Also, for some bizarre reason, if you change the location, Crystal never seems to change the table name in the report. This can...

Hi, I have version 7 on my computer and I just tested this and it works: Replace isnumeric with numerictext numerictext(Left({@dfdfdfdfdfdf},2)) Not Numerictext(Mid({@dfdfdfdfdfdf},4,3)) Numerictext(Right({@dfdfdfdfdfdf},3)) alley

Did you by chance create the subreport from scratch or copy an existing file? The other day I noticed a bug. I saved a subreport as a report and then created a new subreport from it. The new subreport (that I made changes to), behind the scenes used the same record selection as the original...

Hi, If you know the two dates that you want to look at and find the hours between them you could use the following: datediff("h", {Startdate}, {enddate}) alley

Hi, You have to be careful with null dates because the isnull function doesn't always work. Try this instead: either Date({datetimefield}) = Date(0,0,0) or {datetimefield }< DateTime(0,0,0,0,0,0) Hope this helps, alley

You could exporting the report definition and looking at that. It should list all of the formulas on your report. alley