crosstab quieris and reports

[Guest]

Hello,

I have just setup my first sql 2000 server database with adp client front
end. In Access 2000 I had no problems with queries and reports.

With Access data project, I am having problems with crosstab queires, and
crosstab queires with parameters. Can anyone point me in the right direction
to ease the pain of creating these queries. Please bear in mind any solution
will need to be workable at the clients office.

Thanks in advance.

 

[Sylvain Lafontaine]

SQL-Server doesn't offer a direct support for crosstab queries.

For the simple cases, where the number and the range of columns is known
beforehand, you can use the Case ... End statement to build your query.

For more complex queries, the simplest way might be to write a stored
procedure that will store and compute intermediary results in temporary
tables before returning the desired output.

You will find a full discussion of this topic at the following link:
http://www.ftponline.com/archives/premier/mgznarch/vbpj/2001/10oct01/sqlpro0110/rj0110/rj0110-1.asp

S. L.

 

[Guest]

if you're serious about doing crosstabs, then check out 'Analysis Services'

it does crosstab reporting against SQL Sever; and it gives you a lot more
flexible frontend-- and beancounters love it!!

 

[ctcraig]

also check out rac4sql.net. Another very good product for crosstabs