mibuso.com

Microsoft Business Solutions online community
It is currently Wed May 22, 2013 9:39 pm

All times are UTC + 1 hour [ DST ]




Post new topic Reply to topic  [ 3 posts ] 
Author Message
 Post subject: How do I sort idented data item in a report
PostPosted: Mon Nov 15, 2004 2:41 pm 
Offline

Joined: Tue Jul 20, 2004 3:01 pm
Posts: 7
Location: Birkekrogen 19
Country: Denmark (dk)
I am new to C/AL and need help in modifying a report.

The report uses two tables - the first table, Contracts and a second indented table called Comments.

The DataItemLink between the two tables is No.=FIELD(No.) so I know that only Comments whose No. = Contract. No. is extracted.

I need to extract only Comments

WHERE(Table Line No.=CONST(0),Document Type = CONST(Pool))

My questions

Where do I insert this code ?

Do I have to use C/AL code like SETRANGE in the PreDataItem trigger in the Comments table ?

Thanks in advance - all suggestions are welcome!


Top
 Profile  
 
 Post subject:
PostPosted: Mon Nov 15, 2004 7:25 pm 
Offline
MVP Microsoft Dynamics NAV
Site Supporter

Joined: Fri Jun 06, 2003 9:01 pm
Posts: 6979
Location: L.I., New York
Country: United States (us)
dataitem properties

DataItemTableView

use assist button to set up sorting & filters

http://www.mbsonline.org/forum/topic.asp?TOPIC_ID=12522

_________________
Harry Ruiz
http://www.cosmeticsolutions.com
http://www.autismspeaks.org


Top
 Profile E-mail WWW  
 
 Post subject:
PostPosted: Wed Nov 17, 2004 9:25 am 
Offline

Joined: Tue Jul 20, 2004 3:01 pm
Posts: 7
Location: Birkekrogen 19
Country: Denmark (dk)
Thanks!

Am trying it out now.


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 3 posts ] 

All times are UTC + 1 hour [ DST ]


Who is online

Users browsing this forum: No registered users and 12 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum


Search for:
Jump to: