Recent content by ncchish

Yes it should be net_amt := Gross_amt * .05; I will try this.

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

Thank you LB!

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

Thanks so much LB. That worked like a charm. You are the best!

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

Hi Turkbear, The space is in front of the first char on one field. The database is db2p. I will try the subreport and let you know if it works. Thanks.

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

Thanks, that works!

Yes, it's closer but I'm getting those contracted before '08' and I shouldn't be. Thanks for your help.

What I need is time they are contracted (starting in '08) plus 2 years. So, if they are contracted in 2008 then it will cover the first 2 years of that contract period. If they are contracted in 2009 then it will cover 2 years for them. They roll off after a 2 year period. Is this clear?

Also, the contract date covers a period of 2 years so it would cover those contracted in '08 & '09' and then '09 and '10' and so on. Thanks.