report generation

hi,one and all

i am generating a report with 3 data items as shown below

DataItem Name

Purchase Requisition Header

Purchase Requisition Line

Customer Bank Account

i am generating the report as shown below screen shots named(first,second)

the actual requirement about my client is

while generating the report the values for the particular number is not available in the table ,it must not show the entire report…(header section to footer section)

while generating the report the values for the particular number is available in the table ,it must not show the entire report…

from (header section to footer section)…

is it possible sir,can any one can suggest me ,is their any property or we have to write any code…

i am sending the screen shots with values in the table and without values in the table what i have actually generated.

(the values not yet presented for that particular number it must empty page)

IF I understand correctly that you want particular record should not display in Report ???

ya amol thanks for your reply,

in purchase requisition line i set the property dataitemlink ;- document no=field(no)

based on the document no from purchase requisition line and no purchase requisition header ,we are generating report about 92 pages

but my client requirement is that he doesnt need pages when the values are not yet presented in the table

is it possible ,through any of the predefined properties ,or any piece of code

can suggest me

You can use property DataItemTableView of Report and specify your condition

Or

You can write a code using condtion as follows

IF

Curreport.Skip;

i kept dataitem table view property;

WHERE(Document No.=FILTER(’’)—>null value

when i kept this in dataitem table view property it was showing only empty records in the pages…

i kept dataitem table view property;

WHERE(Document No.=FILTER(>=1))---->greater than or equal to 1

when i kept this in dataitem table view property it was showing empty and non empty records through all the pages

i am not getting sir my actual reqiurement;

i have written the code in presection()

number :=Purchase Requisition Line.count

number :=0;

if “Purchase Requisition Line”.find(’-’)

if “Purchase Requisition Line”.isempty then

current report.skip

repeat

number :=number+1;

until Purchase Requisition Line.next=0;

i have written this code can you suggest me is it write or wrong…or any other modification i have to do

thanks

Put filter in dataitemview as no <>’ ’

You will get those records where no is not blank

I think you required this

thanks amol for your kind reply

it was not helping me,ok thanks lot

this was the code where two records consisting of same values ,after writing this code it was hiding the values in the records

Purchase Requisition Line - OnAfterGetRecord()

IF"Purchase Requisition Line".“Document No.”=“Purchase Requisition Header”.“No.” THEN

CurrReport.SKIP;

but this was not my actual requirement ,

i want to hide the records which doesnt consisting of values in the records ,at the time of report generation

hi all,
i am generating the report i have the dataitems
DataItem Name
Purchase Requisition Header
Purchase Requisition Line
Customer Bank Account

Purchase Requisition Header Purchase Requisition Line

we have a no field:in that we have a values we have a document field:in that we have a values
rq0001
rq0002 rq0002
rq0003 rq0003
rq0004 rq0004
rq0005 rq0005
rq0005
rq0006
rq0007
rq0008
rq0009
rq0010
rq0011
rq0012
let us consider these are the values are presented in the two tables ,
while i am generating the report i am getting the values rq0001 to rq0002
by setting the data item link property=Document No.=FIELD(No.)

but my client needs that,based on the values in Purchase Requisition Line he wants the report,
(i,e rq0001,rq0006,rq0007,rq0008,rq0009…rq00012) the values in Purchase Requisition header are displaying in my report as well as
is it possible to hide the values of records in the report generation
this is my actual requirement,can anybody suggest me please,
thanks

hi all,

can any one suggest me

i am generating report with two tables

one of the table consist of no field,another table consist of document no

no filed consist of values {1,2,3,4,5,6,7,8,9,20)

document no consist of values(2,3,4)

in the case of report generation i used this two tables as data items

and with dataitem link property =Document No.=FIELD(No.)

by this property i am getting all the values generated in the report i.e{1,2,3,4,5,6,7,8,9,10}

but my actual requirement is i want get the values which was matched in the two tables i,e{2,3,4}

is it possible through any of the property ,or any code can any one suggest me please

thanks

Take the second dataitem first and then indent first dataitem and set above link property and try…

hi all,thanks for giving reply

the code below was helped me lot,i got my actual requirement

Purchase Requisition Header - OnAfterGetRecord()

PurReqLine.RESET;

PrintView := FALSE;

PurReqLine.SETRANGE(PurReqLine.“Document No.”,“Purchase Requisition Header”.“No.”);

PurReqLine.SETFILTER(PurReqLine.“No.”,’<>%1’,’’);

IF NOT PurReqLine.FINDFIRST THEN

PrintView := TRUE;

in every section of onpresection we havre to write this code

Purchase Requisition Header, Header (1) - OnPreSection()

IF PrintView = TRUE THEN

CurrReport.SHOWOUTPUT(FALSE);