Show the two table fields value in single data item body

dheebans

Dear All,

I am using two data item Line table in report.

I want to show the both data item fields values in single data item based on date field.

While i am using two dataitem body... it showing when completed the first dataitem value then start the second one.

Kindly give the guideline for this.


Advanced thanks


Thanks and Regards
DheebanS

mohana_cse06

Create an Integer dataitem and show the values of above dataitem values in the integer sections

dheebans

Thanks for your grate replay.

Now i am put third dataitem as integer, show the two dataitem values.

but it showing second data item value correctly... first dataitem last value only showing.

can i make any modification.





Thanks and regards
DheebanS

mohana_cse06

Are there any indentations between the dataitems?

can tell us exactly what is the design

dheebans

No indent beetween two data item, integer only indent data item.

Now i am showing two data item fields value in integer dataitem....


Thanks Regards
DheebanS

mohana_cse06

If there is no indentation between first 2 dataitems, first dataitem vl run for all records and then 2 dataitem starts execution..
so you will get last entry of first dataitem and all entries of 2 Dataitem

dheebans

No links beetween two data item, both are different data item , any possible to show the values.


Please guide me.



Thanks and regards
DheebanS

mohana_cse06

You have to insert 2 dataitem values into temp table and repeat the loop in integer dataitem and show

dheebans

thanks

i have one doubt,

Now i am make indent between first two data item.

third data item integer. this integer data item indent based on two or no need indent.

that only explain to me.


Thanks and regards
DheebanS

mohana_cse06

Indent integer under second dataitem

dheebans

Designed the report like this

Transfer recipt line
Purchase inv line
Integer


Now the repetation data showing
the repetation showing based on second data item.

second data item have 4 values ...
its dispaly first dataitem first field 4 times like that second and so on.........




Thanks and regards
DheebanS

mohana_cse06

It 1 st dataitem and 2nd dataitem has 1-1 records, then it will sjow 1 time only
if it has 1-4 records, it shows 4 times..

Alagar

Hi Dheepan,

Use only one date Dataitem intead of two dataitems it should have No of records Based on datefilter in the request option form. Create two record variables for two tables. show Records from two record variables based on every record of Date Dataitem.

Alagar

Hi Dheepan,

Use only one date Dataitem intead of two dataitems it should have No of records Based on datefilter in the request option form. Create two record variables for two tables. show Records from two record variables based on every record of Date Dataitem.

dheebans

Thanks for your valuable replay


while using record variable, only one field value displayed, that is last record

kindly give some ideas.


Thanks regards
DheebanS

Alagar

can u show code for Date "Data Item" OnPreDataItem and OnAfterGetRecord.