Crystal reports on VENDman software

[ralphross]

Trying to pull data from vendman and opera.
want to see if a call is logged against a particular machine, was there one logged before within 7 days.

machine data is store in machine table
linked to call table using cref number.

Call table linked to eng table

company table linked to machine table.

need to group if by the eng

using crystal 11

your help would be most appreciated

thank you so much for your time

 

[lbass]

need to group if by the eng"--What?

Please try to use complete sentences. It is unclear what the problem is that you have run into. What have you tried? What fields are you working with? Do you have a datetime field in the call table? What is the final display you would like to see in the report?

-LB

 

[ralphross]

Hi Ibass

Sorry for the gibberish, didn't get a chance to read what I had written had a personal emergency.

Need a report that Groups by the engineer.
that show his call tickets.
if he has a ticket that has another call logged within 7 days regarding the same machine to flag up.
(Want to see how many times a machine is revisited in 7 days)

each machine has a unique ref called mref in machine table
each ticket has a unique ref called cref in Call table
each eng has a unique ref called eref in Engineer table.

Created a report that:-
1st group: Eng
2nd Group: Machine
3rd Group: Call Ticket
In Details: added ticket, date, problem code, problem memo
also created formulars using the next statement for next ticket, next date, next problem code, next problem memo and next engineer.

Tested this out only on 1 machine ref no
report worked ok.
added rest of the machine ref no's.

the report pulls out the next call,if there is no other ticket to that machine, it then at the end of the machine group pulls out data from the next machine details

i.e

machine 1
call ref1
date, problem code, problem memo. (if there is no more tickets for that machine it pulls the data from the next machine)
it is not leaving it blank.
I would like it to then go to the next machine group and starting a fresh.

Thank you for your time
Ralph

 

[lbass]

If you are otherwise happy with your approach, you can just add clauses like these to your formulas:

if {table.machine} = next({table.machine}) then //etc.

If a machine can appear in multiple engineer groups, you should change it to:

if {table.engineer} = next({table.engineer}) and
{table.machine} = next({table.machine}) then //etc.

This will cause the formula to be blank on the last record in the report, and if that is a problem, change it to:

if not onlastrecord and
{table.engineer} = next({table.engineer}) and
{table.machine} = next({table.machine}) then //etc.

-LB

 

[ralphross]

Thank you Ibass
will have ago with this
thank you for all your time
ralph