Search results for query: *

Hi All, I am using CRXI SP2. I have the following formulas in my main report: // on GH4a WhilePrintingRecords; Shared NumberVar totamtprev:= 0; //on GH4b WhilePrintingRecords; shared NumberVar totamtprev; Global numbervar tot_prev:= tot_prev + totamtprev; totamtprev //on GF3...

Thanks LB. was hoping there was another way.

Hi LB, I figured as much. Is it possible to create a customized grouping that is not based on any fields from a file ? ex. "AC" = "Accessories" "AP" = "Accounts Payable" "AR" = Accounts Receivable" etc...

Hi, I am using CRXI SP2. I have a shared stringvar field that is coming from a subreport. I am not able to see the field when I do a grouping because it comes from the subreport. Is there any work around this? Thanks for your help in advance.

Good idea Ian. Thanks so much for your help.

Parm1 and Parm2 can be any number ranging from 1 to whatever number. So I would like that when the parameter screen comes up, the user is limited to whatever the inputs are in parm1 and parm2 for parm2 value. Not sure if this is viable. The record selection is easy enough to code. It's more the...

Hi All, I am using CRXI SP1. I have a problem with parameters. I am prompting the user to input 3 parameters: parm1 parm2 parm3 I want to limit parm 3 to only the values that they have previously entered in parm1 and parm2. Ex. parm1 = 1 parm2 = 200 parm3 should only be able to accept...

Hi, I am using Crystal XI. I have been reading about how to create a chart based on print-time formulas but I am not sure how to create a OnChangeOf formula. I have 5 fields that I need to be the basis of the change in records - Company, Fiscal Year, Accounting Unit, Account and SubAccount. I...

That worked perfectly! Thanks so much lbass.

subreport is located in GH5. Seq# is just a grouping on data. Grp1 - Company Grp2 - Accounting unit Grp3 - Seq# Grp4 - Account Grp 5 - Subaccount I actually have the shared variable in detail1 and the reset variable in GH1

Hi, I'm using CRXI SP1 I have a shared variable from a sub report. I am using this in GF5 an it displays perfectly. I have the following formulas: GH1 WhilePrintingRecords; Shared NumberVar totamtbud:= 0; GF5 WhilePrintingRecords; Shared NumberVar totamtbud; totamtbud My problem is I want...

Thanks you so much lbass. That was perfect! Thanks to everyone too for your time and attention.

yes, i do need only enough asterisks to fill. the asterisks should expand and contract depending on the size of the amount. Is there any other way to code this?

Hi, I am using Crystal XI SP1. I have a check amount that I need to format. Example - 3,200.00. I would like to format this to print as *****3,200.00 with the asterisk as pad. How can I do this? The amount is numeric from teh database. Thanks for your help in advance.

Hi dgillz, I do have the MICR fonts already. They are in a separate folder by themselves. Where do I place these fonts so that I can access and choose them? I have one font showing in the fonts drop down box as OCR A Extended but I don't think this is it.

Hi, I am using Crystal XI SP1. Has anyone ever worked with micr fonts for printing checks in Crystal? Is this possible in CR XI? How do you set it up? Thanks so much in advance.

sorry LBass. it was set to no decimal. Thanks so much. Now it's working.

the fields are not set to no decimals. it is set to x,xxx.xx Somehow the towords() is coming back with "five thousand and six hundred ninety six" only. i would like it to read as "five thousand six hundred ninety six and 12/100

It's a database amount field. I am try to write a check

sorry. yes, towords()