Search results for query: *

Ah, I have tried: if remainder({report.basic_item_price},0.005) = 0 then Truncate ({report.basic_item_price},2) else ({report.basic_item_price}) and this seems to work. Does that look right?

I want to round a number field to 2 decimal places, but instead of rounding up if the last digit is a 5 i'd like to round down. SO, 123.766 would be 123.77 and 12.521 would be 12.52 but 65.325 would be 65.32 any ideas? I was thinking maybe some kind of formula that looks at the last digit? The...

Thanks for your help, I think that might have been the one that'd push me over the edge... I turned of snap to grid which didn't make any difference, but when I wen in and messed around with a font format property of another field, and then changed it back again, it all sorted itself out!

That's very clever! Thanks again hv

No wait! That still doen't work, as I want the sort to be by allwoance primarily, but if you group by the formula that concatenates ref, name and location, you're forced to sort by this group before allowance, so instead of : 2bSouth 4 6aNorth 5 5cEast 16 1aNorth 40 which I want, you get...

Of course - that's got it I think Cheers all

Nope - they're all the same height.. Cheers HV

Thanks, that's really well explained. I don't really like the idea of concatinating the three fields though - I'm not sure why but it makes me a bit uneasy. I'll think about a bit more.. For example, if you want separate headings in the page header for each of the three concatinated objects...

I've put together a report in version 8.5, and am exporting it to Acrobat PDF. I'm having trouble lining up a field in the details section. All the fields are anchored to the same top guiding line in the details section, and all fields are the same font and text size. On screen in Crystal...

I'm quite confused now! I tried to simply the probelm as it'd take too long to describe the whole report, I don't think the above idea would work (but thanks!). I think I want to know if it's possible to supress records, within a group, where some values match. So a formula to put in the...

Almost, I had Group 1 - Reference Group 2 - Name Group 3 - Location then I wanted to sort by allowance first so I added Allowance and moved it to be group 1, so I have: Group 1 - Allowance Group 2 - Reference Group 3 - Name Group 4 - Location The allowance is a field in a table. After...

Ok, for example you might have the following records: Ref Name Location Allowance 1 a North 5 2 b South 4 1 a North 0 5 c East 16 So, you would want the report to only display: Ref Name Location Allowance 2 b South 4 1 a...

Thanks for your reply. Sorry I didn't explain very well.. The probelm is, I need to sort by a different field on the report that isn't included in checking if it's a duplicate record. So if records are sorted in the required order by the extra field, the records with matching values for the...

(I'm using version 8.5 of Crystal Reports) I'm trying to suppress the details section if the record is a "duplicate", in that certain fields have the same value, but not every field will necessarily match (it's not a true duplicate record). I was using the the following formula to conditionally...

For some inexplicable reason, it works fine this moring - without changing anything! Lost on me, it's obviously another fabulous "feature" of crystal reports....Thanks for all your help anyway

Ah. Where I've used this before is with group sums. Could you group by hold code, then insert a sum of quantity based on that group. The sum will appear in the group footer, which you can surpress. Then if you write a formula, one of the report fields available will be the sum you have created.

The subreport is in the details section. So the formula is two sections higher in the report header. I'm using version 8.5 not sure if that's got anything to do with it? Cheers

Don't you just write a formula referencing the other formula, so if formula 1 is called formula1, write formula2: {@formula1} Place formula2 in the headers etc. then surpress formula1 where you don't want to see it in the footer?

Thanks for your reply.. Yer I was hoping that it would have the date of when the main report was refreshed, but it must be retrieving from the database when you 'request the subreport on demand', as it gives it current date. Those are the formulae I have, i put the first one in the report...

Is this possible? I think i read somewhere that it isn't. Have tried doing it with a shared variable and haven't had any luck, but could be incorrect syntax. Thanks for any help