Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Cell Padding on an Attribute?? 1
- Thread starter zxzzzzzz
- Start date
-
1
- #2
entaroadun
Programmer
What exactly do you mean by cell padding?
Do you want an attribute that has tab characters so when you export from Excel the attribute elements drop into different columns (like a hierarchy)?
If all you need is to insert spaces or other whitespace into the attribute form display, then I would create a new attribute form with an ApplySimple statement.
Do you want an attribute that has tab characters so when you export from Excel the attribute elements drop into different columns (like a hierarchy)?
If all you need is to insert spaces or other whitespace into the attribute form display, then I would create a new attribute form with an ApplySimple statement.
- Thread starter
- #3
entaroadun
Programmer
Add an attribute form to your attribute, using an ApplySimple statement.
Example:
ApplySimple("LPAD(#0,4,'0')",[class_number])
Classify this form as a description form and display it in your report instead of the ID form. This way, the database engine will group by and filter on the ID ([class_number]) and get the padded version (LPAD([class_number],4,'0') in the last pass of the report SQL. You suffer no performance degradation.
Example:
ApplySimple("LPAD(#0,4,'0')",[class_number])
Classify this form as a description form and display it in your report instead of the ID form. This way, the database engine will group by and filter on the ID ([class_number]) and get the padded version (LPAD([class_number],4,'0') in the last pass of the report SQL. You suffer no performance degradation.
- Status