Cross-Tabulations with multiple tables
-
Hi all, Is anyone of you know a better way to cross-tabulate within multiple tables. At the moment what I'm going is based on the table selections, select a hard-coded query, which seems lots of work. Because I've to think about all the possibilities.
I appreciate your help all the time... CodingLover :)
-
Hi all, Is anyone of you know a better way to cross-tabulate within multiple tables. At the moment what I'm going is based on the table selections, select a hard-coded query, which seems lots of work. Because I've to think about all the possibilities.
I appreciate your help all the time... CodingLover :)
As I barely understood the question, it does need a lot of clarification - what is a cross tab, why are you joing multiple tables and your last sentence does not compute. I'll take a guess and recommend you look at using dynamic sql to build your query as a string and then execute it.
Never underestimate the power of human stupidity RAH
-
Hi all, Is anyone of you know a better way to cross-tabulate within multiple tables. At the moment what I'm going is based on the table selections, select a hard-coded query, which seems lots of work. Because I've to think about all the possibilities.
I appreciate your help all the time... CodingLover :)
I'll hazard another guess at what you are looking for and suggest a search for pivot tables. :)
Chris Meech I am Canadian. [heard in a local bar] In theory there is no difference between theory and practice. In practice there is. [Yogi Berra] posting about Crystal Reports here is like discussing gay marriage on a catholic church’s website.[Nishant Sivakumar]
-
As I barely understood the question, it does need a lot of clarification - what is a cross tab, why are you joing multiple tables and your last sentence does not compute. I'll take a guess and recommend you look at using dynamic sql to build your query as a string and then execute it.
Never underestimate the power of human stupidity RAH
Thanks for the reply. Actually hard-coded sense I'm designing SQL queries dynamically. But the combination is huge. For example, say I've 2 tables and I wants to consider two columns, one from each. I can cross tabulate column_1 against column_2 or vise verse. So I'm confusing how to handle all the possibilities.
I appreciate your help all the time... CodingLover :)
-
I'll hazard another guess at what you are looking for and suggest a search for pivot tables. :)
Chris Meech I am Canadian. [heard in a local bar] In theory there is no difference between theory and practice. In practice there is. [Yogi Berra] posting about Crystal Reports here is like discussing gay marriage on a catholic church’s website.[Nishant Sivakumar]
Thanks for the reply. I'll look at the pivot tables and let you know. If you could look at my previous post I really appreciate too.
I appreciate your help all the time... CodingLover :)
-
Thanks for the reply. Actually hard-coded sense I'm designing SQL queries dynamically. But the combination is huge. For example, say I've 2 tables and I wants to consider two columns, one from each. I can cross tabulate column_1 against column_2 or vise verse. So I'm confusing how to handle all the possibilities.
I appreciate your help all the time... CodingLover :)
This article[^] has helped a number of people, you need to do the thinking to apply the logic to your specific requirement. One of the beuties of CP is that there may be an article out there with, or close to your specific requirement which makes it dramatically easier to relate it to your problem.
Never underestimate the power of human stupidity RAH