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
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
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.