discoverer crosstab query?
From: Tomer Segal <tsegal_at_netvision.net.il>
Date: Tue, 17 Apr 2001 22:47:34 +0200
Message-ID: <9bi6oj$fkr$1_at_news.netvision.net.il>
Date: Tue, 17 Apr 2001 22:47:34 +0200
Message-ID: <9bi6oj$fkr$1_at_news.netvision.net.il>
hey,
i need to know what query does the discoverer use to produce the crosstab
format.
i believe its something like :
select <data point> from <table> where <axes fileds>=<field values> group by
<axes field>.
for example:
select count(purchases) from sales_log where month=july and q=q1 and
year=1900 group by year,q,month.
does anyone know?
i'll help me figure out wheather some reports i'm planning to display with
it are possible.
thanks. Received on Tue Apr 17 2001 - 22:47:34 CEST