Dynamic DW object(Label Names)

Hi,

I created the dynamic dw object using syntax from SQL with tabular format. Now i need to assign the names to the labels. Label text it is taking same as column name by default. I want to know the name assigned to it or i should be able to assign the name to it.
And also i want grand totals at the end.

Thanks in advance
Srinib
LVL 1
srinibAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
namasi_navaretnamConnect With a Mentor Commented:
Yes. It is possible.  You will need to use modify to create computed fields. Here is the template.

<DW Control Name>.Modify(&
"create compute(band=<Detail, Footer, Header, Header.<group #>, Summary, Trailer.<group #>, Background, Foreground>"  +  &
" color='<a long>' alignment='<0 - Left, 1 - Right, 2 - Center>' border='<0 - None, 1- Shadow, 2 - Box, 3 - Resize, 4 - Underline, 5 - 3D Lowered, 6 - 3D Raised>'" + &
" height.autosize=<Yes or No> pointer='<Arrow!, Cross!, HourGlass!, IBeam!, Icon!, Size!, SizeNESW!, SizeNS!, SizeNWSE!, SizeWE!, UpArrow!, or cursor filename (with path)>' moveable=<0 - False, 1 - True> resizeable=<0 - False, 1 - True> x='<an integer>' y='<an integer>' height='<an integer>' width='<an integer>' format='<constant string containing display format (i.e., [general]) for col (can also be an expression)>'" + &
" name=<string> tag='<string>' expression='<expression>' font.face='<name of type face (i.e., SYSTEM, COURIER)>' font.height='<negative number for points, positive number for PBUs (i.e., -10 = 10 points, 10 = 10 PBUs>' font.weight='<400 - Normal, 700 - Bold>' font.family='<0 - AnyFont, 1 - Roman, 2 - Swiss, 3 - Modern, 4 - Script, 5 - Decorative>' font.pitch='<0 - default, 1 - Fixed, 2 - Variable>' font.charset='<0 - Ansi, 1 - default, 2 - Symbol, 128 - Shift JIS, 255 - OEM>' font.italic='<0 - False, 1 - True>' font.strikethrough='<0 - False, 1 - True>' font.underline='<0 - False, 1 - True>' background.mode='<0 - Opaque, 1 - Transparent>' background.color='<a long>')")

This is how I add page number for example:

ls_exp = "'Report Date: ' + string(today(), 'mm/dd/yyyy') "
ls_desc = "#1.X"
ll_x = long(dw_report.Describe(ls_desc))
dw_1.Modify('create compute(name=pagenumberanddate band=footer expression="' + ls_exp + '" border="0" color="0" x="'+string(ll_x)+'" y="5" height="80" width="800" alignment="0" format="[general]"  font.face="Arial" font.height="-10" font.weight="600" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )' )


regards-
0
 
namasi_navaretnamCommented:
Srinib,

See this issue: It may be bit tricky. lables are usually named columname + '_t'
http://experts-exchange.com/Programming/Programming_Languages/PowerBuilder/Q_20897769.html

Please maintain open questions as well.

regards-
0
 
srinibAuthor Commented:
I need grand totals in the footer.
Is it possible??

Thanks
Srinib
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.