Mailing Label Report for the Avery 5160 label creeps
Hello All!
I have a report, version 10.03, that I am running in my Delphi 2007
Enterprise application.
This "report" is used to populate our Avery 5160 labels.
The report consists of only a detail band with 3 dbtext components. There
are two
dbtexts up top for the customer name and number seperated by an underscore.
Under that,
the remainder of the detail band is used by a dbtext for a "calculated
value" which is returned
from one of our user defined functions. The function does nothing more than
concatenated the supplied data.
The function call looks like the following (just in case it is needed for
point of referenct).
(CUST_NAME + CHAR(13) +
convert(varchar(1000), AR_SHIP2.ADDR) + CHAR(13) +
[MyDBName].dbo.shipto_city_state_zip(vw_location_control.zip,
vw_location_control.city,
vw_location_control.state,
ar_ship2.zip4,
vw_location_control.country)
) as CUSTNAME_ADDR_CITY_STATE_ZIP
The problem is that sometimes, the data on the label seems to "creep"
upward. The height of the "detail band"
is set to "static", but I am getting the same result even when switching it
to "dynamic". I would like to know if there is
anything that I can do to insure that the data does not creep so that the
integrity of the labels remain in tact?
Any suggestions or help would be appreciated.
Regards,
Everett
I have a report, version 10.03, that I am running in my Delphi 2007
Enterprise application.
This "report" is used to populate our Avery 5160 labels.
The report consists of only a detail band with 3 dbtext components. There
are two
dbtexts up top for the customer name and number seperated by an underscore.
Under that,
the remainder of the detail band is used by a dbtext for a "calculated
value" which is returned
from one of our user defined functions. The function does nothing more than
concatenated the supplied data.
The function call looks like the following (just in case it is needed for
point of referenct).
(CUST_NAME + CHAR(13) +
convert(varchar(1000), AR_SHIP2.ADDR) + CHAR(13) +
[MyDBName].dbo.shipto_city_state_zip(vw_location_control.zip,
vw_location_control.city,
vw_location_control.state,
ar_ship2.zip4,
vw_location_control.country)
) as CUSTNAME_ADDR_CITY_STATE_ZIP
The problem is that sometimes, the data on the label seems to "creep"
upward. The height of the "detail band"
is set to "static", but I am getting the same result even when switching it
to "dynamic". I would like to know if there is
anything that I can do to insure that the data does not creep so that the
integrity of the labels remain in tact?
Any suggestions or help would be appreciated.
Regards,
Everett
This discussion has been closed.
Comments
First I would suggest updating your version of ReportBuilder to the latest
(10.09) and testing with that. If you are still seeing the problem, please
put together a simple example that demonstrates the behavior and send it in
.zip format to support@digital-metaphors.com and I'll take a look at it for
you.
--
Regards,
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com
file earlier. I am actually using version 10.07 in the
report in which I described my problem. Unfortunately, we working towards a
release so I cannot upgrade at this time. In the meantime,
is there anything else that I may be able to try to correct my issue?
Regards,
Everett
Please send a simple example that demonstrates the issue to
support@digital-metaphors.com in .zip format that I can run on my machine.
I will test it with RB 10.09.
--
Regards,
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com