UBS Inventory Software » Report

ID #1298

UBS Report to Microsoft Excel worksheet

 

Description

This solution below show te steps  to customize UBS Report  to Microsoft Excel worksheet.

 

Solution

1.    Example of print inventory physical worksheet 

2.    Press  “Excel“ button (refer  to Figure A)

3.    You can see  the  two default formats  (refer  to Figure B)

4.    Right click on “Exit“ button, you can see  the  picture box (refer  Figure C)

5.    If you want  to customize your format,  just press  “Copy“ button, because the  default format only for display purpose

6.    After the  copy command has done  successfully, all the  command boxes  allow you to edit and insert new command

 

No.

Items

Description

Remark

 

1.

Title 1

Report  heading 1

-

 

2.

Title 2

Report  heading 2

Key in date

command ,for example

 

“‘ “+str(day(rptdate),2)

+ ’  ’  + cmonth(rptdate)

+’ ’  +

str(year(rptdate),4)

(refer to fig E)

 

3.

Title 3

Report  heading 3

Company  name  , street, brand  name, & etc.

 

4.

Level

Select either 0 or 1

For total sum amount by group

 

(refer to fig F)

5.

Orientation

Select either 1 or 2

1 for portrait, 2 for landscape

 

6.

Adjust to (%)

The output preview screen resolution

From range  25%  3

100 %

 

7.

Set report layout

Number  of field to be exported

Maximum up to 50

 

8.

Set grouping

Item  sorting 1

Select any one of the field

 

9.

Set parameter

item sorting 2

Select any one of the field

 

10.

Set report header

The title name

 

 

11.

Set body field

Field name

Press  browse  initfile to check each  field

12.

Set body field type

C       character , &Q         quantity , N

numeric

 

13.

Set group  total

F        Without sub total

 

T        With sub total

 

Refer to fig G

14.

Set column width

You can assign each  column width

O      follow excel default 7.25

 

15.

SQL statement

SQL script command

 

Tags: UBS Report to Microsoft Excel worksheet

Related entries:

Last update: 2010-11-16 03:23
Author: Noor Diyana
Revision: 1.1

Digg it! Share on Facebook Print this record Send FAQ to a friend Show this as PDF file
Propose a translation for Propose a translation for
Please rate this FAQ:

Average rating: 0 (0 Votes)

completely useless 1 2 3 4 5 most valuable

You cannot comment on this entry