pdssql.dll

I developed small program VB 6.0 and SQL SERVER 2000 but an error happen in displaying any crystal report file with pdssql.dll not found actually this message appear in some of computer, I tried to find this file and copy it in system file but I couldnt found. What the solution of this problem? And is copying pdssql.dll file solution?May check the CD for this file.|||how??|||From FIND FILES utility on Windows.|||Sorry but I can't get your requst|||On Windows from START --> Programs --> Find files and enter the filename and under the lookin specify the CD drive path.

PDF Downloads & ASP

I have a web application (ASP, COM+, SQLServer2K) that uses my own VB COM
components and a Crystal Reports component (a 5mb component) that takes a CR
report that I designed (about 1mb in size), executes it, and exports it as a
PDF file to the server's hard disk ready for download by my users.
Having just come across Reporting Services, it would appear to me that I
could ditch Crystal and go with Reporting Services exclusively. However, in
my browsing I have not come across how to do this with Reporting Services
without using the Report Manager (my users are "anonymous" web users and do
not have access to the server directly) and I can't seem to find any
examples of how to recreate the process I described above.
Questions:
1) Can Reporting Services run a report, and export it as PDF to server hard
drive without user intervention (or using Report Manager)?
2) Can I expect faster processing of reports with Reporting Services
compared to Crystal on the server (my Crystal reports depends entirely on
SPs in SQLServer)?
3) Are there programming examples of using Reporting Services with VB and
ASP, particularly involving PDF export and download?
Thanks for any tips or directions.1) Yes
2) don't know
3) you need to use the web service interface to interact with RS, so you
will need to look for code with uses ASP and Web services then apply what
you learn to the RS web service interface. Most code I have seen assumes
ASP.NET since the web service integration is "trouble free"
hope this helps.
dlr
"Don Miller" <nospam@.nospam.com> wrote in message
news:%234erUYMnEHA.1564@.TK2MSFTNGP09.phx.gbl...
> I have a web application (ASP, COM+, SQLServer2K) that uses my own VB COM
> components and a Crystal Reports component (a 5mb component) that takes a
CR
> report that I designed (about 1mb in size), executes it, and exports it as
a
> PDF file to the server's hard disk ready for download by my users.
> Having just come across Reporting Services, it would appear to me that I
> could ditch Crystal and go with Reporting Services exclusively. However,
in
> my browsing I have not come across how to do this with Reporting Services
> without using the Report Manager (my users are "anonymous" web users and
do
> not have access to the server directly) and I can't seem to find any
> examples of how to recreate the process I described above.
> Questions:
> 1) Can Reporting Services run a report, and export it as PDF to server
hard
> drive without user intervention (or using Report Manager)?
> 2) Can I expect faster processing of reports with Reporting Services
> compared to Crystal on the server (my Crystal reports depends entirely on
> SPs in SQLServer)?
> 3) Are there programming examples of using Reporting Services with VB and
> ASP, particularly involving PDF export and download?
> Thanks for any tips or directions.
>

Password Protect Crystal Report

Hi, everyone -

This may be a rather simple query, but I'm going to put it out there:

We're using Crystal Report Version 8.5 at work, and I have created several reports that I would like to password protect because of personnel issues. Can someone help me out in terms of how I can password protect a document in Crystal? Thanks so much............. :confused:As far as I know it's not possible.

Passing SQL statement to Dataset of report

Does anyone know how to pass a SQL statement to a dataset of a report? You used to be able to do this with Crystal and found it a really helpful tool.
Any help would be appreciatedAlthough there might be a way to do this you would be leaving a major
security hole open. You can pretty much do whatever you need to do but you
need to switch your thinking around to RS being the place that pulls the
information together to create the appropriate query. You can pass
parameters, you can have conditional code that changes the where clause, you
can have code behind that does things. Plus when you integrate you can send
a URL or use web services. There is a lot of flexibility and you can
probably do what you want but you might need to think about things
differently and utilize the features that RS provides.
Bruce L-C
"PLSH" <PLSH@.discussions.microsoft.com> wrote in message
news:B32D68AB-898C-4B82-86E3-C656091D5A2A@.microsoft.com...
> Does anyone know how to pass a SQL statement to a dataset of a report? You
used to be able to do this with Crystal and found it a really helpful tool.
> Any help would be appreciated
>

Passing specific mdb files to Crystal 8

Hi Guys

I call a few reports from VB6 but always using the mdb file it was created with.

Now I have two mdb databases containing exactly the same fields but holding different data. How do I pass the filename that the report must use to the report? Sometimes I want the data that's in abc.mdb and sometimes the data that's in def.mdb. Maybe later there will be a ghi.mdb and jkl.mdb etc...

Any help greatly appreciated.

BezzieWhich tool or programming language you are using to do so ? Is it VB , .net or Java ?

Thanks|||Hi

I'm calling the Reports (Crystal Reports 8) from a Visual Basic 6 application.

Bezzie|||Hello Bezzie,

Let me reiterate what you are planning to do.

You have a report created in crystal 8.0 using abc.mdb. Now using VB application you want to switch the database at runtime in such a way that if you want to see data from def.mdb or ghi.mdb you need to be able to do that.

To achieve this goal what you need to do is

1. Create report using abc.mdb.
2. Write VB code to reset connection information at runtime.
3. Preview report.

We need to explore step 2 before that I would like to know are we on same page, so far so good ?

THanks|||Hi Dilemma

Yes. The program I'm working on is a genetic calculator for birds. I previously had only one mdb file that held all the info I needed on my reports.

I've started to add additional species to the program so changed my mdb so that I have a mdb with the userdata, and then one mdb for each species of bird.

The userdata.mdb will allways be in use throughout the program but there is a different mdb for each species of bird with the species specific data.

So when the user select to work with species ABC I need to pass the ABC.mdb with the data of species ABC and when he select species DEF I need to pass DEF.mdb etc. Those bird specific databases might become more and more as the species is added to the program so that's why I need to keep them separate, and why I don't want to create a separate report for each species of bird as the report will be exactly the same for each species but with a different set of data!

Bezzie|||You need to code something like this. Let me findout ODBC's example. Meanwhile I would like you to get familiar with this code.

How to connect to an OLEDB data source
This example demonstrates how to connect to an OLEDB (ADO) data source, change the data source, and change the database by using the ConnectionProperty Object, as well as how to change the table name by using the Location property of the DatabaseTable Object,. CrystalReport1 is created using an ODBC data source connected to the pubs database on Microsoft SQL Server. The report is based off the authors table.

' Create a new instance of the report.
Dim Report As New CrystalReport1

Private Sub Form_Load()
' Declare a ConnectionProperty object.
Dim CPProperty As CRAXDRT.ConnectionProperty
' Declare a DatabaseTable object.
Dim DBTable As CRAXDRT.DatabaseTable

' Get the first table in the report.
Set DBTable = Report.Database.Tables(1)

' Get the "Data Source" property from the
' ConnectionProperties collection.
Set CPProperty = DBTable.ConnectionProperties("Data Source")

' Set the new data source (server name).
' Note: You do not need to set this property if
' you are using the same data source.
CPProperty.Value = "Server2"

' Get the "User ID" property from the
' ConnectionProperties collection.
Set CPProperty = DBTable.ConnectionProperties("User ID")

' Set the user name.
' Note: You do not need to set this property if
' you are using the same user name.
CPProperty.Value = "UserName"

' Get the "Password" property from the
' ConnectionProperties collection.
Set CPProperty = DBTable.ConnectionProperties("Password")

' Set the password.
' Note: You must always set the password if one is
' required.
CPProperty.Value = "Password"

' Get the "Initial Catalog" (database name) property from the
' ConnectionProperties collection.
' Note: You do not need to set this property if
' you are using the same database.
Set CPProperty = DBTable.ConnectionProperties("Initial Catalog")

' Set the new database name.
CPProperty.Value = "master"

' Set the new table name.
DBTable.Location = "authors2"

Screen.MousePointer = vbHourglass
' Set the report source of the viewer and view the report.
CRViewer91.ReportSource = Report
CRViewer91.ViewReport
Screen.MousePointer = vbDefault
End Sub

Thanks|||Hi Dilemma

Thanks for the trouble. I got it to work with Datafiles Property.

Bezzie|||Excellent Job.

Thanks
Dilemma