how do i Link CrossTab?

[someshdoshy]

I am using three cross tab queries to view, if i try to put more than 1 row the query total all the rows and leaves a big space between two displayed record to aviod this i put 3 Crosstab queries in one report. everything is fine except that all three Cross tab and not linked with each other the output i should get is in following manner

1 1113 John
2 1112 Scott
3 1111 Tiger

but report displays in following manner

1 1111 John
2 1112 Scott
3 1113 Tiger

Please help
Thank you in advance

 

[synapsevampire]

I don't think that you want a crosstab at all.

Why not just place the 3 columns alongside each other?

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com

 

[someshdoshy]

Thnx synapsevampire
can i Send you the rpt file which would help you to understand my problem better...

 

[synapsevampire]

I would prefer that you post examples of your data, and expected output.

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com

 

[someshdoshy]

Thank you but I got alternative solution i am using Formulas.
Is there any way i can link or sort two or more crosstab queries in the same way because CR has a smart way of sorting the crosstab. I even cannot use sorting in specific order because the out varies. hope you understand this.

Thanks once again.