Making a report that I have set up group by client then dates are sorted decending and I have the section suppress if the count is greater than 3 so I get the last 3 records. that works fine. My issue is I need to be able to calculate ( todays date - the newest records date), the newest records...
I have a report that is pulling fields from dictionaries so when the data is showing it has &What& and I'd like it to just print as What. Any ideas on how to convert it?
I have a report that the data collected is driven by the subreport. The report looks like this
detail A is the subreport
Detail B is the data to be displayed based on the subreport returning a value of 1 any other result is to be ignored I can suppress this based on subreport <>1
Group footer...
I have a report that is looking at field "a" ( a date field) for data. Field A initially is blank but when it gets populated and the report is reran it give me 2 pages 1 with the field blank and 1 with the field populated any ideas how I can eliminate the blank field page? as a side note I do...
I have a form that the user answers 1 question (x) or the other (y) and the one they dont answer gets disabled. I have that working. here is my issue I am making a report that calculates an average and I cannot figure out how to make the report ignore the disabled field. any help would be...
trying to do conditional color font on group footer and report footer. These are average fields. I was able to get the fields in the details to conditional color code the way I would like but have not been able to figure out how to do that in the footers.
This is how I'm doing the formatting in...
I have a report that looks similiar to this
customer
date field1 field 2 field 3
it will have new dates with the fields reoccuring what I need to be able to do is have an average showing at the bottom of each field. I was thinking i need to do a group by date but wasnt sure any suggestions?
I have this report
Group Customer with subgroup order number and what i am trying to do is filter this so it will only show a customer that has an item occuring more than 1 time in a given order ( checking for order entry errors.
IE
Customer 5
Order 1
Item a
Item B
Item A
Item C
I want the...
IF (ISNULL({date)) = TRUE
then "00000000"
else {date};
Gives me the error of a string is expected here at the second date ( they are date fields) tried converting to str and when i did that it gives me the bolean str number date error. Any ideas?
I ahve been trying to get this to work based on a start and end date (Past 5 working days) the report needs to show the following
Last 3 dates it happened for J when
6/16/12 Y
6/1/12 Y
5/15/12 y
show J or if 1 of the 3 comes back N then do not print any ideas
I have a report that is grouped by person and I need to show there 3 most current dates. It also needs to eliminate people with LESS than 3 dates.I am using Crystal 2008. Example would be
John Smith:
6/6/12
5/3/12
2/7/12
Thanks!
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.