Validate if a field value is changing for each record 1

[urgent72]

HI,
I need to display the record for each change in one of the fields in the record and i am using ORACLE stored procedure as backend.HOw can i do this using crystal reports.I am already using select expert using the condition EQUAL to for another field.I am kind of confused how can i check just one particular field is changing or not?? Can any one help me here please??? Thanks in advance for the helping hand and the time.

 

[Katy44]

I'm not sure exactly what you want to do, but would a formula where you compare each record to the previous, and output something if it's not the same help?

 

[urgent72]

HI Katy44,
Thanks for your suggestion.Let me be more clear on what i am looking for.I am generating a report where there are 40 fields using Oracle stored procedure.The thing is i need to validate a field called conference-Id and for each change in Conference-ID ihave to check if there is tax or not on other fields and if there is tax to be applied then i have to display the tax fields else no.there are like 5000 records that are coming in my query. i am trying to validate the Conference -id field and i am not able to.will i be able to check if the conference-id field value is changing and for each change i have to do the above mentioned validation and display the tax fields.All the required fields for validation are being pulled in the Stored procedure ,but will i be able to check if the conference-id is being changed and for each change the tax fields .How i will be able to do this.Please do take ur time to answer me please.I really apperciate ur time and ur concern.Thanks a lot.

 

[Katy44]

Can you be a bit more specific:

"ihave to check if there is tax or not on other fields and if there is tax to be applied then i have to display the tax fields else no"

Which fields? Do you mean you only want to display them if they are not zero?

 

[urgent72]

HI katy44,
OK.I have fields statetax,fedareltax,countytax,loclaltax and surcharge tax.There are other indicator fields like statetax indicator= YES/ NO for every tax like federaltax indicator=YES/NO what i have to do is check these indicator fields and make sure these are YES for each conference_id and if they are set to YES then i have to calculate the
tax=(federaltax+statetax+countytax+localtax) else tax field should not be populated.the tax field should be calculated for each conference_ID.how can i check for each Conference_id in the database being generated out of the Stored procedure?? I am clear enough??

 

[Madawc]

validate a field called conference-Id and for each change in Conference-ID

It sounds like you need to group on conference-Id, and then check the group. You can also do checks like

conference-Id=Previous(conference-Id)

It helps to give your Crystal version, since newer versions have extra solutions, and some extra problems. I use Crystal 8.5

Madawc Williams (East Anglia)

 

[urgent72]

HI Madawc, How can i check on group??
I am using version 10 crystal reports. I tried grouping on conference id but i am unable to figure out how can i check on this?? If the Indicators are set to NO how can i supress these records from being populated??
Thanks a lot for you help. Using the previous do u have any suggestions on to check all the records from begining to to the end and see to make sure the validations are done for only the distinct Conferenceid??
ur help is greatly apperciated.

Thanks

 

[Madawc]

Regarding grouping, you first group on a field and then maybe eliminate some groups, or details within groups. There are limits to what Crystal will allow, though it is very fast and powerful within those limits.

I suggest you do a few experimental reports and get familiar with what Crystal can and cannot do, before trying to use it to solve specific problems.

I don't understand

how can i supress these records from being populated

You can suppress records on your report, using the formula for suppression on the detail format. Or you can adjust the record selection formula, though only on the basis of some feature of the individual record.

Madawc Williams (East Anglia)