Search results for query: *

I need help setting this up as a formula in Crystal Reports 2013. Any help is appreciated. Gross_amt .05 = net_amt Net_amt/ .05 = New_Gross_amount

I need a parameter that displays a date range but only shows month and year. I need to be able to go back at least 2 years or run it for say a month. May 2017 to June 2018 or April 2018 to April 2018 are 2 examples. Crystal dates show the day in the parameter and we can’t allow the user to...

I’m having trouble getting a count. I’m using crystal 11. I have totals in the group footer and the detail line has the breakdown of what is in my footer. What is in the detail section adds up to what is in the GF. The problem is I need to get a count of the producers in the detail section who...

I need help with this report if anyone has any ideas – thanks in advance. I’m using Crystal Reports 11. I have parameter driven report. The report currently has a main report and a subreport. They wanted me to add another parameter for a new ranking. Currently, we have ranking by sales and they...

Can anyone tell me the correct syntax for this for the r/s? I'm using CR11. I need to get the date from 2 different sources to get accurate results. Before I was using table.DAY_REPT_DATE = {?DateRange} but in certain situations we are not getting all the data at first of month or end of month...

I’m working on a report in Crystal (vs CR11) using a left outer join to link 2 tables. I want to see the sales of all producers. I’m using an odbc connection and db2p tables. It doesn’t seem to pick up the non-producers when I set this up; only those who have sales. Let me know if you need more...

I'm using CE11. I'm trying to join a table where the tax number on one of the tables has spaces in front of it. The other table uses a regular tax number - no spaces. Can you tell me how to join these tables? So far, I'm not getting an data at all. The join is inner and I've added this to my R/S...

I'm using Crystal 11. Can you tell me how to set up the record selector for this? I need to check the contract date and get all of those contracted for 24 months from their initial contract date. I tried to use this but I get a boolean error. Any help is appreciated. Thanks. {contract_date} in...

I'm using Crystal 11. I have a report that needs to show the details section and group footer 3 on one page. I have a page break after each GF3. This part is working correctly. I need GF 4 to print on the same page as GF3 but it's printing alone on the next page before the details section...

I'm using Crystal 11. I have a report with a subreport in a page header section. I'm trying to suppress the dd to the subreport. They only want the report to show in the main report but not have the user click into the report (it's a summary). I've tried using drilldowngrouplevel in the section...

I'm using Crystal 11 and I’m having trouble with a formula/parameter. I have a parameter called Mkt_Code. The user can choose “LIFECOMP”, “LCOMP-OTHER", “LIFECOMP-ALL”,etc. LIFECOMP-ALL is made up of all the codes LC,LCOT,LCAS,LCCP or they can choose just one to run. The problem I’m having with...

I'm using CE11. I have a parameter in my record selection. ( If Minimum({?AgencyRange}) = "All" Then True Else {DB.AGY_AGCY_NBR} = {?AgencyRange} ) The field on the database is string and has the numbers 112ZZ, 112TT, 11211, etc. When I run the report it doesn't pick...

I'm using CR11. Currently, I have 2 reports that bring back the same data. The reports are on the intranet and the user enters either ssn or agent number (parameters) to retrieve the report. I'm trying to combine the reports into one report where they enter either ssn or agent number on one...

I need help summing a formula. I'm using CR10. I have 3 formulas; the first 2 are init and eval formulas. I have these supressed in the GH. The last formula displays the total for each agt_rpt_nbr in the GF. I need a grand total for the @YTDQualProd. Can anyone help with this? I can't sum this...

I'm using CR 11. I have a formula: //@QTRVAR If {@QPlan} = 0 Then 0 Else (({@QTD}-{@QPlan})/{@QPlan}) * 100 Then I have another formua that evaluates @QTRVAR //@QTRVAR2 if {@QtrVar} > 999 then "NM" else {@QtrVAR} I get 'string required here for the second formula. I need to display NM if...

Crystal 11 - Is it possible to hide an ole object on a report when viewed over the web but still have it show when the report is printed? If so, how is it done? Thanks in advance.

I'm using CR10. Currently, I have this in my R/S: ( {DAY_RPT_DTE} >= {?SelectedDate} and {DAY_RPT_DTE} <= {?EndSelectedDate} ) or {DAY_RPT_DTE} >= dateserial(year({?SelectedDate})-1,month({?SelectedDate}),day({?SelectedDate})) and {DAY_RPT_DTE} <=...

I have a report that has multiple drill downs and I created fake headers. The user wants the fake header to show beyond the first page of detail. I tried checking 'repeat group header on each page' but it doesn't apper to change anything. I'm using Crystal reports 10. Thanks in advance for any...

synapsevampire gave me help with this earlier thread767-1214692 for a record selector question. This is in regards to this thread. The user wants to see agents contracted from July of last year until July of this year (starting over every July). If they are contracted in December '06 then they...

I have a report and I need to show a listing of producers for a period of a year before it starts over. I have that date criteria in the record selector. For producers on that list I need to show their sales for the first 6 months of their starting date with the company. That start date can fall...