Search results for query: *

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.

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

Thanks LB. It works now. Thanks for all your help.

If I do that then it won't be on a page by itself with the details. I need the details, GF3 and GF2 to be on one page. There might be several pages of detail, GF3 data before you hit GF2 data again. Here is an example. Page 1 Data D - Joe Smith D- Jane Smith D- John Smith GF3 - Smith Agency...

Sorry, this should be: Details - SHOW GF8 - SUPPRESSED GF7 - SUPPRESSED GF6 - SUPPRESSED GF5 - SUPPRESSED GF4 - SUPPRESSED GF3 - Show - break after this group GF2 - SHOW - this should show on same page as GF3 and details.

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