Who's On?

	Membership:
	Latest: Kezia West
	Past 24 Hours: 0
	Prev. 24 Hours: 1
	Overall: 5246

	People Online:
	Visitors: 400
	Members: 0
	Total: 400

Name	Points
Greg Moeller	4184
David Williams	3349
JonA	3291
Kat V	2984
Woozy	1973
Jimmy Chiu	1883
Kwane McNeal	1437
Ragu Raghavan	1375
Roger French	1315
mark.cook	1244

Importance of .dtl file for a report

7 Replies

0 Subscribed to this topic

17 Subscribed to this forum

Sort:

Author

Messages

srikanth

Advanced Member Send Private Message

Posts: 28

11/24/2008 10:46 AM

Hello, Can someone tell me what is the importance of the .dtl file when the report is created? How the .dtl file is created? and what is the use of it? thanks in Advance. Srikanth

Cindy Anderson

New Member Send Private Message

Posts: 1

12/1/2008 12:54 PM

I know one thing it does is allow you to send your report to a csv file from the print manager. Without that dtl file, you cannot create a csv file output.

Norm

Veteran Member Send Private Message

Posts: 40

12/2/2008 9:52 PM

The .dtl file mirrors the .prt file, at least in number of records. The records in the .dtl file indicate the format/type of the corresponding record in the .prt file. This is used by prtmgr and other utilities to help facilitate report drill-around and CSV file creation among others

srikanth

Advanced Member Send Private Message

Posts: 28

12/3/2008 3:13 AM

one of my custom report doesnt show the send to csv option. I verified the .dtl file and it is created. The only difference i see is that the records in .dtl file are not vertical lines. There is only one line with all the data scrolling till the end. when I manually changed the records in .dtl file to vertical lines. I could see the send to csv option. can anyone tell me what would be the reason behind creating the .dtl file with only one horizontal record?

Norm

Veteran Member Send Private Message

Posts: 40

12/3/2008 9:34 PM

It sounds like you're saying there are no line-feed (hex 0A) characters in the .dtl file? That kind of makes sense if Lawson thinks the .prt and .dtl files aren't in synch, there coul dbe all sorts of issues. Is this a standard 4GL report program or is the something special about this report? Finally, how did you 'convert' the .dtl so that it worked

srikanth

Advanced Member Send Private Message

Posts: 28

12/4/2008 4:44 AM

its a simple custom 4GL program report program. There is nothing special with this program. I changed the .dtl file which printed a single horizontal line to n number of vertical lines... Please see the attached files for the before .dtl and after .dtl. before file is the file before changes..

Attachments

srikanth

Advanced Member Send Private Message

Posts: 28

12/11/2008 4:11 AM

some breakthrough for the issue.... the problem is with standard footer in the report. when i removed the standard footer i could see the Send to CSV option enabled. But the same thing was working in 7.2.4 but not in 8.10 applications. Is it a constraint in 8.10?

John Henley

Posts: 3351

12/12/2008 2:30 AM

I think it stopped working with the 8.0.3 environment, when the 'xtra' components were added; it also messed up PDF generation. Lawson removed all of their usage within their standard programs. You have to count lines if you need that functionality.