problem importing old reports inlatest version

rbuser

the report designer doesn't always offer the choice "open" to open an rtm
( I don't know why...).
When you have it, you already something on screen and when you open the
following text reports it fails
stating that there is already a footer6 and this is obviously false.

it uses nexus Dade extender (delivered with the product).

object rpt: TppReport
AutoStop = False
DataPipeline = T_Item
PrinterSetup.BinName = 'Default'
PrinterSetup.DocumentName = 'Report'
PrinterSetup.PaperName = 'A4'
PrinterSetup.PrinterName = 'Default'
PrinterSetup.mmMarginBottom = 6350
PrinterSetup.mmMarginLeft = 6350
PrinterSetup.mmMarginRight = 6350
PrinterSetup.mmMarginTop = 6350
PrinterSetup.mmPaperHeight = 297000
PrinterSetup.mmPaperWidth = 210000
PrinterSetup.PaperSize = 9
SaveAsTemplate = True
Template.DatabaseSettings.DataPipeline = ppItem
Template.DatabaseSettings.Name = 'Retours flash?s'
Template.DatabaseSettings.NameField = 'Name'
Template.DatabaseSettings.TemplateField = 'Template'
Template.FileName = 'D:\lienard\sources_cli\scg\reportsd4\exped du
jour.rtm'
Template.Format = ftASCII
Units = utMillimeters
AllowPrintToFile = True
DeviceType = 'Screen'
ShowAutoSearchDialog = True
TextFileName = 'G:\Gissigheim\Exped Gissigheim.TXT'
TextFileType = ftTab
Left = 232
Top = 144
Version = '5.51'
mmColumnWidth = 0
object ppHeaderBand1: TppHeaderBand
mmBottomOffset = 0
mmHeight = 13229
mmPrintPosition = 0
end
object ppDetailBand1: TppDetailBand
mmBottomOffset = 0
mmHeight = 13229
mmPrintPosition = 0
object ppDBText1: TppDBText
UserName = 'DBText1'
DataField = 'IdItem'
DataPipeline = T_Item
Font.Charset = DEFAULT_CHARSET
Font.Color = clBlack
Font.Name = 'Arial'
Font.Size = 10
Font.Style = []
Transparent = True
mmHeight = 4233
mmLeft = 2910
mmTop = 3440
mmWidth = 28575
BandType = 4
end
object ppDBText2: TppDBText
UserName = 'DBText2'
DataField = 'IdStatus'
DataPipeline = T_Item
Font.Charset = DEFAULT_CHARSET
Font.Color = clBlack
Font.Name = 'Arial'
Font.Size = 10
Font.Style = []
Transparent = True
mmHeight = 4233
mmLeft = 32544
mmTop = 3704
mmWidth = 17198
BandType = 4
end
object ppDBText3: TppDBText
UserName = 'DBText3'
DataField = 'DateStatus'
DataPipeline = T_Item
Font.Charset = DEFAULT_CHARSET
Font.Color = clBlack
Font.Name = 'Arial'
Font.Size = 10
Font.Style = []
Transparent = True
mmHeight = 4233
mmLeft = 50800
mmTop = 3969
mmWidth = 17198
BandType = 4
end
end
object ppFooterBand1: TppFooterBand
mmBottomOffset = 0
mmHeight = 13229
mmPrintPosition = 0
end
object daDataModule1: TdaDataModule
object danxQueryDataView1: TdanxQueryDataView
Report = rpt
UserName = 'Query_T_Item'
Height = 333
Left = 10
NameColumnWidth = 105
SizeColumnWidth = 35
SortMode = 2
Top = 10
TypeColumnWidth = 52
Width = 200
AutoSearchTabOrder = 0
object T_Item: TppChildDBPipeline
AutoCreateFields = False
UserName = 'T_Item'
object ppField1: TppField
FieldAlias = 'Iditem'
FieldName = 'IdItem'
FieldLength = 13
DisplayWidth = 10
Position = 0
TableName = 't_item'
end
object ppField2: TppField
FieldAlias = 'Zate'
FieldName = 'Zate'
FieldLength = 10
DisplayWidth = 10
Position = 1
TableName = 't_item'
end
object ppField3: TppField
FieldAlias = 'Zare'
FieldName = 'Zare'
FieldLength = 10
DisplayWidth = 10
Position = 2
TableName = 't_item'
end
object ppField4: TppField
FieldAlias = 'Cdpaysa'
FieldName = 'CdPaysA'
FieldLength = 2
DisplayWidth = 10
Position = 3
TableName = 't_item'
end
object ppField5: TppField
FieldAlias = 'Cdpaysn'
FieldName = 'CdPaysN'
FieldLength = 2
DisplayWidth = 10
Position = 4
TableName = 't_item'
end
object ppField6: TppField
FieldAlias = 'Noarticle'
FieldName = 'NoArticle'
FieldLength = 8
DisplayWidth = 10
Position = 5
TableName = 't_item'
end
object ppField7: TppField
FieldAlias = 'Noserie'
FieldName = 'NoSerie'
FieldLength = 10
DisplayWidth = 10
Position = 6
TableName = 't_item'
end
object ppField8: TppField
FieldAlias = 'Nomainbody'
FieldName = 'NoMainBody'
FieldLength = 8
DisplayWidth = 10
Position = 7
TableName = 't_item'
end
object ppField9: TppField
FieldAlias = 'Descriptionde'
FieldName = 'DescriptionDE'
FieldLength = 64
DisplayWidth = 10
Position = 8
TableName = 't_item'
end
object ppField10: TppField
FieldAlias = 'Descriptionfo'
FieldName = 'DescriptionFO'
FieldLength = 64
DisplayWidth = 10
Position = 9
TableName = 't_item'
end
object ppField11: TppField
FieldAlias = 'Idstatus'
FieldName = 'IdStatus'
FieldLength = 8
DisplayWidth = 10
Position = 10
TableName = 't_item'
end
object ppField12: TppField
FieldAlias = 'Accessoiresback'
FieldName = 'AccessoiresBack'
FieldLength = 0
DataType = dtInteger
DisplayWidth = 10
Position = 11
TableName = 't_item'
end
object ppField13: TppField
FieldAlias = 'Idstatusde'
FieldName = 'IdStatusDE'
FieldLength = 4
DisplayWidth = 10
Position = 12
TableName = 't_item'
end
object ppField14: TppField
FieldAlias = 'Datestatusde'
FieldName = 'DateStatusDE'
FieldLength = 0
DataType = dtDateTime
DisplayWidth = 10
Position = 13
TableName = 't_item'
end
object ppField15: TppField
FieldAlias = 'Dateachat'
FieldName = 'DateAchat'
FieldLength = 0
DataType = dtDateTime
DisplayWidth = 10
Position = 14
TableName = 't_item'
end
object ppField16: TppField
FieldAlias = 'Noclient'
FieldName = 'NoClient'
FieldLength = 10
DisplayWidth = 10
Position = 15
TableName = 't_item'
end
object ppField17: TppField
FieldAlias = 'Datestatus'
FieldName = 'DateStatus'
FieldLength = 0
DisplayWidth = 10
Position = 16
TableName = 't_item'
end
end
object daSQL1: TdaSQL
databaseName='nxdatabase1'
DataPipelineName = 'T_Item'
LinkColor = clMaroon
MaxSQLFieldAliasLength = 25
SQLText.Strings = (
'SELECT t_item.IdItem, t_item.Zate, t_item.Zare, '
' t_item.CdPaysA, t_item.CdPaysN, '
' t_item.NoArticle, t_item.NoSerie, '
' t_item.NoMainBody, t_item.DescriptionDE, '
' t_item.DescriptionFO, t_item.IdStatus, '
' t_item.AccessoiresBack, t_item.IdStatusDE, '
' t_item.DateStatusDE, t_item.DateAchat, '
' t_item.NoClient, t_item.DateStatus'
'FROM t_item t_item'
'WHERE ( t_item.IdStatus LIKE '#39'RET%'#39' )'
'ORDER BY t_item.NoArticle')
SQLType = sqSQL1
object TdaCriteria
ChildType = 7
Level = 0
Operator = dacoLike
Value = 'RET%'
object TdaField
Alias = 'Idstatus'
DisplayWidth = 10
FieldAlias = 'Idstatus'
FieldLength = 8
FieldName = 'IdStatus'
SQLFieldName = 'IdStatus'
TableAlias = 'T Item'
TableName = 't_item'
TableSQLAlias = 't_item'
end
end
object TdaCriteria
ChildType = 7
Level = 0
object TdaField
Alias = 'Datestatus'
AutoSearch = True
DisplayWidth = 10
FieldAlias = 'Datestatus'
FieldLength = 0
FieldName = 'DateStatus'
SQLFieldName = 'DateStatus'
TableAlias = 'T Item'
TableName = 't_item'
TableSQLAlias = 't_item'
end
end
object TdaField
Alias = 'Iditem'
DisplayWidth = 10
FieldAlias = 'Iditem'
FieldLength = 13
FieldName = 'IdItem'
SQLFieldName = 'IdItem'
TableAlias = 'T Item'
TableName = 't_item'
TableSQLAlias = 't_item'
end
object TdaField
Alias = 'Zate'
DisplayWidth = 10
FieldAlias = 'Zate'
FieldLength = 10
FieldName = 'Zate'
SQLFieldName = 'Zate'
TableAlias = 'T Item'
TableName = 't_item'
TableSQLAlias = 't_item'
end
object TdaField
Alias = 'Zare'
DisplayWidth = 10
FieldAlias = 'Zare'
FieldLength = 10
FieldName = 'Zare'
SQLFieldName = 'Zare'
TableAlias = 'T Item'
TableName = 't_item'
TableSQLAlias = 't_item'
end
object TdaField
Alias = 'Cdpaysa'
DisplayWidth = 10
FieldAlias = 'Cdpaysa'
FieldLength = 2
FieldName = 'CdPaysA'
SQLFieldName = 'CdPaysA'
TableAlias = 'T Item'
TableName = 't_item'
TableSQLAlias = 't_item'
end
object TdaField
Alias = 'Cdpaysn'
DisplayWidth = 10
FieldAlias = 'Cdpaysn'
FieldLength = 2
FieldName = 'CdPaysN'
SQLFieldName = 'CdPaysN'
TableAlias = 'T Item'
TableName = 't_item'
TableSQLAlias = 't_item'
end
object TdaField
Alias = 'Noarticle'
DisplayWidth = 10
FieldAlias = 'Noarticle'
FieldLength = 8
FieldName = 'NoArticle'
SQLFieldName = 'NoArticle'
TableAlias = 'T Item'
TableName = 't_item'
TableSQLAlias = 't_item'
end
object TdaField
Alias = 'Noserie'
DisplayWidth = 10
FieldAlias = 'Noserie'
FieldLength = 10
FieldName = 'NoSerie'
SQLFieldName = 'NoSerie'
TableAlias = 'T Item'
TableName = 't_item'
TableSQLAlias = 't_item'
end
object TdaField
Alias = 'Nomainbody'
DisplayWidth = 10
FieldAlias = 'Nomainbody'
FieldLength = 8
FieldName = 'NoMainBody'
SQLFieldName = 'NoMainBody'
TableAlias = 'T Item'
TableName = 't_item'
TableSQLAlias = 't_item'
end
object TdaField
Alias = 'Descriptionde'
DisplayWidth = 10
FieldAlias = 'Descriptionde'
FieldLength = 64
FieldName = 'DescriptionDE'
SQLFieldName = 'DescriptionDE'
TableAlias = 'T Item'
TableName = 't_item'
TableSQLAlias = 't_item'
end
object TdaField
Alias = 'Descriptionfo'
DisplayWidth = 10
FieldAlias = 'Descriptionfo'
FieldLength = 64
FieldName = 'DescriptionFO'
SQLFieldName = 'DescriptionFO'
TableAlias = 'T Item'
TableName = 't_item'
TableSQLAlias = 't_item'
end
object TdaField
Alias = 'Idstatus'
DisplayWidth = 10
FieldAlias = 'Idstatus'
FieldLength = 8
FieldName = 'IdStatus'
SQLFieldName = 'IdStatus'
TableAlias = 'T Item'
TableName = 't_item'
TableSQLAlias = 't_item'
end
object TdaField
Alias = 'Accessoiresback'
DataType = dtInteger
DisplayWidth = 10
FieldAlias = 'Accessoiresback'
FieldLength = 0
FieldName = 'AccessoiresBack'
SQLFieldName = 'AccessoiresBack'
TableAlias = 'T Item'
TableName = 't_item'
TableSQLAlias = 't_item'
end
object TdaField
Alias = 'Idstatusde'
DisplayWidth = 10
FieldAlias = 'Idstatusde'
FieldLength = 4
FieldName = 'IdStatusDE'
SQLFieldName = 'IdStatusDE'
TableAlias = 'T Item'
TableName = 't_item'
TableSQLAlias = 't_item'
end
object TdaField
Alias = 'Datestatusde'
DataType = dtDateTime
DisplayWidth = 10
FieldAlias = 'Datestatusde'
FieldLength = 0
FieldName = 'DateStatusDE'
SQLFieldName = 'DateStatusDE'
TableAlias = 'T Item'
TableName = 't_item'
TableSQLAlias = 't_item'
end
object TdaField
Alias = 'Dateachat'
DataType = dtDateTime
DisplayWidth = 10
FieldAlias = 'Dateachat'
FieldLength = 0
FieldName = 'DateAchat'
SQLFieldName = 'DateAchat'
TableAlias = 'T Item'
TableName = 't_item'
TableSQLAlias = 't_item'
end
object TdaField
Alias = 'Noclient'
DisplayWidth = 10
FieldAlias = 'Noclient'
FieldLength = 10
FieldName = 'NoClient'
SQLFieldName = 'NoClient'
TableAlias = 'T Item'
TableName = 't_item'
TableSQLAlias = 't_item'
end
object TdaField
Alias = 'Datestatus'
DisplayWidth = 10
FieldAlias = 'Datestatus'
FieldLength = 0
FieldName = 'DateStatus'
SQLFieldName = 'DateStatus'
TableAlias = 'T Item'
TableName = 't_item'
TableSQLAlias = 't_item'
end
object TdaField
ChildType = 2
Alias = 'Noarticle'
DisplayWidth = 10
FieldAlias = 'Noarticle'
FieldLength = 8
FieldName = 'NoArticle'
SQLFieldName = 'NoArticle'
TableAlias = 'T Item'
TableName = 't_item'
TableSQLAlias = 't_item'
end
object TdaTable
ChildType = 5
Alias = 'T Item'
JoinType = dajtNone
SQLAlias = 't_item'
TableAlias = 'T Item'
TableName = 't_item'
end
end
end
end
end

regards

Didier

nicocizik

Hi Didier,

Which version of ReportBuilder are you using? I was able to load your
template below without any problems (granted I do not have the NexusDB
plugin but I just ignored those lines). Please try downloading a trial copy
of RB 7 and test with that.

--

rbuser

I have the latest version available (upgrade 2004/01/05) the server one. The
old reports were ok with FF2 2.13.
regards
Didier

nicocizik

This conversation has been continued in a later post.

--