SYSREPOSREPORTS (OpenInsight 32-Bit) [Revelation On-Line Wiki]

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.
{{tag>category:"OpenInsight 32-Bit" author:"Martin Drenovac" author:"Mike Ruane"}}

[[https://www.revelation.com/the-works|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: ===
 
 
<QUOTE>
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
</QUOTE>
----

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

<QUOTE>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

</QUOTE>

----

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

<QUOTE>Cheers Mike - certainly is a good start.

</QUOTE>


[[https://www.revelation.com/revweb/oecgi4p.php/O4W_HANDOFF?DESTN=O4W_RUN_FORM&INQID=WORKS_READ&SUMMARY=1&KEY=77D738012A48EA6D852575BD0043D1F5|View this thread on the Works forum...]]