, ,

Join The Works program to have access to the most current content, and to be able to ask questions and get answers from Revelation staff and the Revelation community

SYSREPOSREPORTS (OpenInsight 32-Bit)

At 21 MAY 2009 08:20:46AM Martin Drenovac wrote:

Where can I find the record definition for the above file please?

I need to convert our "old" reports to something new and can't quite second guess every data element.

Cheers

At 21 MAY 2009 09:35AM Mike Ruane wrote:

Martin-

Here's a quick description of what is in a report template after it has been ACCESSed from the repository:

p1=field(ReportTemplate, @rm, 1)

p2=field(ReportTemplate, @rm, 2)

p3=field(ReportTemplate, @rm, 3)

sortFields=field(ReportTemplate, @rm, 4)

SelCrit=field(ReportTemplate, @rm, 5)

printerinfo=field(ReportTemplate, @rm,6)

outfileinfo=field(ReportTemplate, @rm,7)

fontdetails=field(ReportTemplate, @rm,8)

reporttype=field(ReportTemplate,@rm,9)

labeltype=field(ReportTemplate,@rm,10)

scriptlist=field(ReportTemplate,@rm,11)

gridson=field(ReportTemplate,@rm,12)

mymargins=Field(ReportTemplate,@rm,14)

* p1

Olist_Statement=p1

LastDate=p1

LastUpdateDate=oconv(LastDate,"D4/")

hfInfo=p1

Headon=hfinfo

Footon=hfinfo

Colheadon=hfinfo

Detailon=hfinfo

Heading=hfinfo

Footing=hfinfo

Description=hfinfo

Scripton=hfinfo

Orient=hfinfo

Labelflag=hfinfo

Set_Property(@Window,"@ORIENT",ORIENT)

Suppresson=hfinfo

SingleMVs= hfinfo

behavior=hfinfo

rowson=hfinfo

Nocolumns=hfinfo

* p2

Table=p2

dictfile=p2

* p3

columns=p31,divdel

columndet=field(p3,divdel,2)

Hope this is enough to get started.

Mike

At 21 MAY 2009 05:00PM Martin Drenovac wrote:

Cheers Mike - certainly is a good start.

View this thread on the Works forum...