2 brief things - I'm new to Crystal and am looking for online help forums (I suppose a bit like the Mr Excel.com forums for Excel). Can anyone help? The only one I found apart from here is Experts-Exchange which charges a subscription (I'll never get work to agree to that).
1st thing I've got stuck on is something I use a substring statement for in my database - where I want to return all records where (for example) character 9 in <table.fieldname> = "7". I think its a RIGHT statement but although I've got the right syntax (I think) it doesn't seem to work:-
Right ({trainno.training_number},5 ) = "7"
I realise this kind of thing is easy peasy to people here but if anyone can point me in the right direction on this (or in my request for links) I'd be grateful. Thanks, in advance.A kind soul on another forum gave me this which works perfectly (no RIGHT, LEFT or MID statement in sight).
{trainno.training_number}[9] = "7"
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment