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...

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.

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...

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...

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, 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.

Hi, I am using Crystal XI SP1. I am using the formula totext() to convert the amount 5,696.12 and it works for the 5,696 part. The text is missing the cents. I would like it to read as five thousand six hundred ninety six and 12/100. Thanks in advance for your help.

Hi lbass, I should have searched the old threads first before I posted a new one but.. in regards to your reply to this thread from another user, the max works correctly on positive amounts but does not work on negative amounts. How do you summarize on fields that have negative amounts?

Hi, I am using CRXI SP1 I have a running total that's a maximum summary of a variable that I need to sum/accumulate/create a runningtotal on. How can I do this? Thanks much for your input.

I am using CRXI SP1 I really need help badly. My totals on a shared variable from the subreport is not working on my groupings on the main report. On this grouping by subacct: GH4A Travel GF6 Travel Exp1 500 GF6 Travel Exp2 200 GF5B Total Travel 700 The...

I am using CRXI SP1. I have my variables from the subreport showing in the main report. My problem now is summing up/creating a running total on the amount depending on the grouping(I have 5 so far). Do I need to create another variable in the subreport with the same grouping as in the main...

Hi, I am using CRXI SP1 I have a subreport and I am bringing an amount back to the main report. The amount does show in the main report. However, my problem is that if the amount coming from the subreport is null(zero) the amount still carries the value from the previous record read and is not...

Hi, I am using CRXI SP1 I am just wondering why the Join Type "Full Outer Join" is grayed out when I go to the Database Expert/Links. Any reason why thus us not available to me?

Hi, I'm using CRXI SP1 Any ideas on how to create a running total or a summary total in the main for a shared number variable coming from a subreport? I do a right click on the field and there is no insert available for the running or summary totals. I also cannot find the shared variable when...

HI. I' using Crystal XI SP1. I am trying to use a static parameter and dynamic cascading parameter together in a report but I don't know how to pick either the one or the other - not both at the same time. Would very much appreciate any help on this.. Thanks

Hi, I'm using CR XI SP1. Hw do you get the Page Numbers to show correctly in subreports. My main report is a drill down so it does not have paging but my sub report not a drill-down but paging dow not work her. I would appreciate any help on this..

I am using CR XI SP1. Is there any way to disable double-clicking on the fields when drilling down on the report and just limiting the users to using the group tree in order to drill down? Any suggestions will be appreciated.

I am using CRXI SP1. I have a year parameter that's a string and placed an edit mask of 0000. The edit mask took away the comma but I see a comment on top of the parameter "This prompt has an edit mask: 0000". How do you get rid of this comment? Any help will be greatly appreciated..

I use CRXI SP1. I have a dynamic cascading parameter. Its numeric so when it comes up it's in the format x,xxx,xxx. Is there any way to change this so it would get rid of the commas? I also have a year parameter that has commas that I would like to get rid of. Additionally, when I do Refresh...