Using different datasets in matrix

Question

Post reply

Using different datasets in matrix

jvElecenter

SSCarpal Tunnel

Points: 4502
More actions
June 6, 2007 at 7:09 am

#176974

Hi
We have build a matrix in a report that counts number of orders, number of orderlines
In a next column we must have the number of orderlines where number of orderlines/order > 5
So for exemple
Code Orders Orderlines Orderlines > 3 Orderlines > 5
IBC 2 12 6 2
Raw data is :
Order 1 has 7 orderlines
Order 2 has 5 orderlines
So the Orderlines > 3 is sum((7 orderlines - 3) + (5 orderlines - 3)) = 6
We already have Code, Orders, Orderlines in one dataset
the > 3 and > 5 in another dataset.
When we want to add the second dataset in the matrix reporting gives an alert that it is impossible to use two different datasets in one matrix. U can use the sum though.
Anyone got a clue ?
Kind regards
El Jefe

JV

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Jeff Moden SSC Guru Points: 1004340 More actions · Answer 1

What is the Primary Key for the Orders table and where does Code come from?

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

jvElecenter SSCarpal Tunnel Points: 4502 More actions · Answer 2

Jeff

The code is a field in the orderlinetable.

Primary key is, i thnik so, not important for this.

Thx in advance

El Jefe

JV

David McFarland SSChampion Points: 11815 More actions · Answer 3

I could be wrong, but I'm pretty sure Jeff is asking those questions so that he can come up with a method to generate your report data as a single dataset, thus solving your problem.

jvElecenter SSCarpal Tunnel Points: 4502 More actions · Answer 4

Indeed he is asking this for helping me, which I am thankfull for.

We just resolved this matter using union queries and using 0 values.

Perhaps not the most powerfull result, but we have a match.

thx anyway !

JV