Skip to Content
0
Former Member
Apr 21, 2009 at 04:22 AM

SQVI report..

79 Views

Dear All,

I have developed a report in SQVI for getting the serial numbers and order numbers in a single screen...

As the users are proficient with the serial numbers than the order numbers, and as they need to get the time and date of confirmation of individual operations,I need the report to be as followed...

Order num..serial number.. operation number.. conf.start time..conf finish time

10000042...ps649....0010....12:00:12....12: 45:00

10000042...ps649....0020 ....02:00:35...03:40:04..like this i need to get..what are the tables I need to join.. please try at your end in SQVI and let me know the tables.

please try to help me out in this issue..