Removing unwanted rows of data

[ktrinad]

By: Shashank Uchil - shashank_uchil

Removing unwanted rows of data

2003-03-20 23:15

Hi,

Say i have this

1

2

3

4

5

6

7

8

9

10

 

now i want this to be displayed as such

1 6

2 7

3 8

4 9

5 10

 

further explanation::

i have to make a Income Statement.

so all ledgers between 300-399 will come on the left and

all ledgers between 400-499 will come on the right. Now the ledgers also have subledgers(like 300 will have 1,23..). So i have grouped Ledgers and in details have put Subledger. then i have to make sub totals of the subledgers and grand total of the ledgers.

The main part here is to put them side by side ie. Left all 300-399 and Right all 400-499

 

Thx.

 

 

 

 

 

By: Shashank Uchil - shashank_uchil

RE: Removing unwanted rows of data

2003-03-21 01:56

what i did was have the same fields

$F{ledger} $F{ledger}

and gave each of them a printwhenexpression to check if is 300 or 400...but this fails as it displays blanks like this

300

301

401

402

what i want is

300 401

301 402

....

i am now trying to put the values first in a variable then print the variables....BTW no one on IRC :(

 

 

 

 

By: Shashank Uchil - shashank_uchil

more

2003-03-21 02:16

what i did was have the same fields

$F{ledger} $F{ledger}

and gave each of them a printwhenexpression to check if is 300 or 400...but this fails as it displays blanks like this

300

301

401

402

what i want is

300 401

301 402

....

i am now trying to put the values first in a variable then print the variables....BTW no one on IRC :(

 

 

 

 

By: Giulio Toffoli - gt78

RE: Removing unwanted rows of data

2003-03-22 15:14

Yes, I'm not present ever on IRC :-)... but if you can, try it ....

 

Giulio

 

 

 

 

By: Shashank Uchil - shashank_uchil

RE: Removing unwanted rows of data

2003-03-23 19:12

ok the format was lost...this is what i am doing

 

$F{value} has values 300,301,302.....400,401...500

$F{value}.....................$F{value}

[printwhen <400]..........[printwhen >400]

 

this is what i am getting(the ... are just to keep the format)

300......

301......

302......

303......

......400

......401

......402

 

i want to get rid of the empty spaces and get this

 

300 400

301 401

302 402

303 403

304 404

 

Thx...

 

......403

 

 

 

 

 

By: Ratchapong - jeng

RE: Removing unwanted rows of data

2003-03-30 20:07

How about using subreport? I know this is stupid solution but i'm sure that it will 100% work. :)

 

 

 

 

By: Shashank Uchil - shashank_uchil

RE: Removing unwanted rows of data

2003-03-30 21:17

hehe that is what i did in the end, works fine