awesome thank you!! now I was thrown a curve which I hope can be corrected easily with this is there a way to do a count on the records so they can see how many were done "on first record" and the previous record?
Ok it works awesome thank you for that the only issue I have and here is my formula is the second date comes out as a negative number can you tell why?
If onfirstrecord or
({Name})<> previous({Name}) then
Currentdate-{data.Data_Entry_Date} else...
so to make sure I'm understanding you right ( and thank you) theres no way to do the cr formatting on each one separately? ie the number of days between the 1st and second date isn't > the no of days?
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 did a little testing and the subreport section is what is generating my blank pages. All the sections of the subreport are suppressed ( no drill down) the subreport itself is formatted to suppess blank subreport and all the sections ( except the one the subreport is in are suppressed if Count...
Hi I went and looked at what you suggested and this is how it is set up but it still generates a blank page for a record that doesnt meet the criteria.
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 tried using this to set the question to 0 but nothing happened.
IF x = '1' then '0'
else if x='2' then '0'
else if x='3' then '0'
else to number y
that didnt do anything either.
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...
I made formulas to lay out like filler fields and such where they may not be data present but the spacing has to be. The issue Im having is I need all the fields touching as to not create undo and unwanted spaces in the report at suggestions?
Is there a way to designate field lengths? all of this is a report that has fields that may or may not have data and filler fields that have to be there to be read by the recieveing party? The zero filled ones I have figured out the blanks I think I know what im doing but wasnt sure if there was...
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.