crosstab queries 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.

 

[MGFoster]

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.

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Using an .adp file means you no longer have the ability to use Access
cross-tab queries. SQL Server 2000 doesn't have Cross-Tab ability.
Here is a URL that shows a stored procedure that will create a Cross-Tab
in SQL Server (I've not tested it yet):

http://www.sqlteam.com/item.asp?ItemID=2955

--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQd7UUYechKqOuFEgEQL7kQCffLe1vOzoiLYkMu/QeB4/G3tNr9MAoJDg
kd/4XQnU7TM31fwNgM/opyg1
=4nkS
-----END PGP SIGNATURE-----

 

[Pike]

Check out the RAC utility for S2k.Same idea as Access
crosstab but much more powerful with many features/options.
And like Access xtab, it's easy to use

www.rac4sql.net