October 15, 2005 at 6:02 pm #11476
I am currently printing a set of reports using the procedure Report.
I have to use daily resolution;
I print 6 months at a time (Jan,Feb, Mar,..,Jun) and then (Jul, Aug, .., Dec)
I have to do this for 3 full years
I have to do the BS and IS separately
I have created 2 x 3 x 2 = 12 date range settings and saved them.
Now, I have to do the same thing in over 10 set of books.
Is there any way to export the settings from one set of books and import them in the next set in the Report procedure?October 15, 2005 at 6:18 pm #13122
I noticed, using ViewRec that the info seems to be in ~EPORT.13
Could I use @RecRead and @RecWrite?
I do not want to spend too much time on this.
If someone would have done it before, it would be good to help me with thisOctober 20, 2005 at 2:35 pm #13125EPumpParticipant
I do not know how to export and import headings for the REPORT procedure, but if you are only doing 6 months at a time then I would use the analysis view which gives you 6 columns.
I then use the old procedure WRITEANA (from New Views version that preceeded 1.41b) which writes the header to the procedure area of the program – the “new” WRITEANA procedure writes to a buffer and I don’t know how to access the buffer.
I then export the headers (use one for BS & one for IS) using PUTPROCS and then import the headers into another set of books by using GETPROCS. You can then load the headers into each report by going to each report and running the saved header as a procedure, ie. ~gr”BS”. – this will run the header BS (Balance Sheet) and install the saved header on whatever report you are on.
ALternatively, like you I have over 10 books every month where I use the same headings. To speed up the process I use the following procedure.
First I create one set of headings for Balance Sheet (BS) nad Income Statement (IS).
I then run the old Writeana
Then I go to the procedure area and block in the 2 headers which I have saved as “BS” and “IS”. Then run PUTPROCS – this will export the 2 headers out of the books to whatever folder(directory) you designate.
Then I go to another set of books and run the following procedure :
Note the first time this procedure is run you must create the 2 headers (BS & IS)in the procedures area, otherwise you will get an error message when the procedure tries to delete the headers.
Also – the name of the balance sheet in my books is “BAL SHEET” and the income statement is “INC STMNT”
Monthly Report Headings
~gh~gi”bs”.~deheOctober 20, 2005 at 2:58 pm #13126
I have to use report. The periods I have to print are no longer available on screen.
I have to use the daiky resolution feature of the report procedure.October 21, 2005 at 9:45 pm #13129MSchapplerModerator
Write a procedure that performs an @recread of ~eport.13 and then performs an @write to a notes view of a procedure. Block Export the notes view of this procedure to the target set of books (or PUTPROCS).
In the target set of books, after bringing in the notes of the procedure (or GETPROCS), write a procedure that performs the opposite of the above which performs an @read of the notes of the procedure (above) and then performs and @recwrite to ~eport.13 of the target books.
- You must be logged in to reply to this topic.