Crystal report setup using Package and Deployment Wizard of VB6.0

Hi
I am working on Visual Basic 6.0 and I've use crystal report 9.2 for report printnig.
But when I made the setup using Package and Deployment Wizard.
While installing the setup in the client's machine setup gives error -
An error occured while registering these files...
crtslv.dll
exportModeller.dll
filedialog.dll
crqe.dll

Due to which my report does not show up. when I call my report system gives error - "Load report failed"

Please help.

PuneetInclude these dlls while making setup.|||I've tried that. I've addid these file while making setup but invane its still not working.

Actually the prob is when I run setup on the win 98 machine it gives error
"An error occured while registering these files..."
even after the inclusion of these files while making the setup.

Now what should I do.|||It seems the dll is corrupted

Crosstab qry not upsized

My crosstab query did not get upsized using the wizard. What do I need to do
in Access Project to get the same result?
hi John,
"John" <John@.discussions.microsoft.com> ha scritto nel messaggio
news:ABF753FF-80DC-44D9-BDF3-EE8EDA149F11@.microsoft.com...
> My crosstab query did not get upsized using the wizard. What do I need to
do
> in Access Project to get the same result?
SQL Server does not (still) include CROSSTAB query including PIVOT/TRANSFORM
syntax... SQL Server 2005 will include PIVOT/UNPIVOT feature, btu, till it
releases, you have to resort on alternate solution..
SQL Server MVP Itzik Ben Gan released an excellen article about this
(missing) feature, along with a stored procedure to dynamically return
result sets according to specified pivot settings you can read for free at
http://www.winnetmag.com/SQLServer/A...608/15608.html
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.8.0 - DbaMgr ver 0.54.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||You can also take a look at RAC (http://rac4sql.net). It provides similar
syntax for Access users.
"Andrea Montanari" <andrea.sqlDMO@.virgilio.it> wrote in message
news:2nuarpF4en0iU1@.uni-berlin.de...[vbcol=seagreen]
> hi John,
> "John" <John@.discussions.microsoft.com> ha scritto nel messaggio
> news:ABF753FF-80DC-44D9-BDF3-EE8EDA149F11@.microsoft.com...
to
> do
> SQL Server does not (still) include CROSSTAB query including
PIVOT/TRANSFORM
> syntax... SQL Server 2005 will include PIVOT/UNPIVOT feature, btu, till it
> releases, you have to resort on alternate solution..
> SQL Server MVP Itzik Ben Gan released an excellen article about this
> (missing) feature, along with a stored procedure to dynamically return
> result sets according to specified pivot settings you can read for free at
> http://www.winnetmag.com/SQLServer/A...608/15608.html
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.8.0 - DbaMgr ver 0.54.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>