Crystal With MSDE..>HELP!

I get "Unable to Open Database" when I try to run Crystal Reports with MSDE. Any ideas.
The reports work fine with SQL Server and MS Access.
Thanks in Advance.I'd need more information before I can offer advice.

How is security set up? Integrated, SQL Server?

Using OLEDB or ODBC?

What version of Crystal? MSDE? Are both on the same computer or is access across a network?

etc...|||Thanks for your reply,

I am using MSDE 1.0(SQL Server 7.0) and Crystal Reports Version 8.5. The application that runs the reports is on the same machine as the database for now. I am using ADO (MDAC 2.7) to connect to the database.

The reports are made off a MS Access Database (2000) and I change the driver at run time, as it checks for the database type that the application is running off of. I am using:

Crpe.Tables.ConvertDriver(pssql.dll)

function to convert the driver from Access to SQL Server.

Once I try to run the reports it gives me Crystal Report
[error 533:Unable to Open Database]

But once I run the same reports on MS SQL Server or MS Access Database it works fine or even once I run these reports off of MSDE running on XP Professional it still works fine.

This has become a real chanllenge. Any help would be appreciated.

THANKS IN ADVENCE. :)

Crystal SQLQueryString

I am writing some code that analyses the 700+ Crystal reports we have within our business. I am aiming to have this code evalaute the data access code for each report. I have managed to determine whether the report is using a Command, Stored Procedure or Table access to obtain the data. However, when I am retrieving the SQLQueryString property of the Report I seem to be having an adverse affect on the msdb database on our SQL Server. It appears to be causing some locking issues. Is there any other method of obtaining the SQL Command code from the Crystal Objects?In your Front End application, check if there is any property to get query
Something like

CR.GetQuery

Crystal Reports Version Selection

I have ten users who need to access a single server operating crystal. Currently looking at around 200 reports max being generated (not per day). I was wondering what the latest version available to me would be suitable which can manage atleast 10 concurrently. Also does MSDE come with it and is it sufficient to handle this small solution. Have searched the net but not exactly sure what Im looking for.

CheersSearch here
http://support.businessobjects.com/

Crystal reports problem

I also posted this to the CR newsgroup, but I think it might be an MSDE
problem also.
We recently moved several Access databases to an instance of MSDE. We use
VB .Net for program development. Upon running one of the programs a dialog
box now pops up alerting us to enter a user name and password. I searched
the Business Solutions help and found that the database server needs to be
set up with a trusted connection. I thought I already did this through the
data connection of the VS IDE.
Is there something more than I have to do on the MSDE side?
Thanks for any useful information.
Brad
hi Brad,
"Brad" <ballison@.ukcdogs.com> ha scritto nel messaggio
news:eRE7fiSkEHA.3612@.TK2MSFTNGP12.phx.gbl...
> I also posted this to the CR newsgroup, but I think it might be an MSDE
> problem also.
> We recently moved several Access databases to an instance of MSDE. We
use
> VB .Net for program development. Upon running one of the programs a
dialog
> box now pops up alerting us to enter a user name and password. I searched
> the Business Solutions help and found that the database server needs to be
> set up with a trusted connection. I thought I already did this through
the
> data connection of the VS IDE.
> Is there something more than I have to do on the MSDE side?
> Thanks for any useful information.
MSDE is usually installed allowing *only* trusted connections, and you have
to force the parameter SECURITYMODE=SQL at install time in order to allow
SQL Server authenticated connection..
chek your registry at
HKLM\SOFTWARE\Microsoft\MSSQLServer\MSSQLServer
or
HKLM\SOFTWARE\Microsoft\Microsoft SQL Server\InstanceName\MSSQLServer
at the
LoginMode key
a value of 2 will allow both, where 1 only allows trusted connections
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.9.1 - DbaMgr ver 0.55.1
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Andrea,
Thank you for the response, however in researching this problem I did see a
knowleddge base article about changing the key to 2 which I already did and
I still am having the same problem.
Thanks,
Brad
"Andrea Montanari" <andrea.sqlDMO@.virgilio.it> wrote in message
news:2prjfcFo4pukU1@.uni-berlin.de...
> hi Brad,
> "Brad" <ballison@.ukcdogs.com> ha scritto nel messaggio
> news:eRE7fiSkEHA.3612@.TK2MSFTNGP12.phx.gbl...
> use
> dialog
> the
> MSDE is usually installed allowing *only* trusted connections, and you
> have
> to force the parameter SECURITYMODE=SQL at install time in order to allow
> SQL Server authenticated connection..
> chek your registry at
> HKLM\SOFTWARE\Microsoft\MSSQLServer\MSSQLServer
> or
> HKLM\SOFTWARE\Microsoft\Microsoft SQL Server\InstanceName\MSSQLServer
> at the
> LoginMode key
> a value of 2 will allow both, where 1 only allows trusted connections
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.9.1 - DbaMgr ver 0.55.1
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>
sql

Crystal Reports join question

Hello all.

I am migrating an access report to crystal reports and having trouble. I have two tables that link each other, but they are different data types. This works fine in access because I can cast one of the fields using cstr(). See query below:

==============================================
SELECT Sum(Tax_Detail.Tax_Amt) AS SumOfTax_Amt, Taxer.Collection_Account

FROM Invoice_Header INNER JOIN (((Invoice_Detail LEFT JOIN Tax_Detail ON cstr(Invoice_Detail.Invoice_Detail) = Tax_Detail.Owner_ID) LEFT JOIN TaxCode ON Invoice_Detail.Tax_Code = TaxCode.TaxCode) LEFT JOIN Taxer ON Tax_Detail.Taxer = Taxer.Taxer) ON Invoice_Header.Document = Invoice_Detail.Document

WHERE (((Tax_Detail.Owner_Type)=0) AND ((Invoice_Header.Document_Date) Between '3/1/2007' And '3/31/2007'))

GROUP BY Taxer.Collection_Account;
==============================================

Does anyone know how I can create this join from Crystal?

Thanks,
bubutYou will need to use Crystals add command through the database expert. There you can paste your sql and it should work.
GJsql

crystal reports and recordset

Hello I have done an application that show the records of an access database in a viewer that have movefirst and movelast. I want to create reports of The recordset that match an sql sentence. I have created a report linked to my database and I call it in a form. This report has all the records I want to show in a single page but when I call the report from a recordset selection I want to view all the records in diferent pages in the crystal viewer and print all the pages.
How can I do this? Please help me!you need to increate the height of the details section
or
Goto section expert of Details section
Next to New page After there is button x-2 click that and write this

RecordNumber mod 10 = 0

Crystal Reports access denied error

Hello,
I've been stumped trying to resolve the following error when running Crystal Reports on a new server I'm setting up:

HTTP 500.100 - Internal Server Error - ASP error
Internet Information Services

------------------------

Technical Information (for support personnel)

Error Type:
Seagate Crystal Reports ActiveX Designer (0x80043AC6)
Access denied.
/OrbitRpt/Crystal/AlwaysRequiredSteps.asp, line 57

I'm running a Win2K server (service pack 4) with Crystal Reports 8. I've tried setting the security to "Everyone - Full Control" on all folders but I'm still getting the "Access denied" error. Has anyone seen this before? Any info would be greatly appreciated. Thanks!The following changes fixed my problem:
To properly set up your System Environment Variables:

1. Create the directory "C:\Temp" if it is not already created.
2. Right-click on "My Computer" on the server machine, and choose "Properties".
3. Go to the "Environment" tab.
4. Under "User Variables", select "TEMP", and then click "Remove". Repeat for the variable "TMP".
5. Select any variable under "System Variables".
6. Change the value for "Variable" to "TEMP" (no quotes).
7. Change the value for "Value" to "C:\Temp" (no quotes).
8. Click "Set".
9. Change the value for "Variable" to "TMP" (no quotes).
10. Change the value for "Value" to "C:\Temp" (no quotes).
11. Click "Set".
12. Click "OK".

Be sure to give "Read" and "Delete" access to this TEMP folder so that the Crystal Reports web components can read and write to this directory.

Crystal Reports 4.6 not working in XP

My application uses Crystal Reports 4.6 & Visual Basic 6.0. The database is in MS Access 97.

It works on Windows 95, 98, NT 4.0, 2000. My users just upgraded to Windows XP.
But, in Windows XP the report is not shown and no error with .PrintReport(). When I tried with .Action = 1, it shows 2 errors.

1)
Runtime error '5':
Invalid procedure call or argument

2)
Error Number: 20535
Unable to connect: incorrect session parameters.

And the application terminates!

This is the code.

With crwReport
.Destination = crptToWindow
.WindowTitle = "Bill"
.WindowState = crptMaximized
.ReportFileName = "D:\reports\Bill.rpt"
.DataFiles(0) = "D:\client.mdb"
.Action = 1
End With

I have tried creating setup from Package & Deployment Wizard and Visual Studio Installer 1.1 but neither work for Crystal Reports...

I tried to install Crystal Reports 4.6 on user's machine but still it is not working!

The only ultimate solution I got is to install Visual Studio 6.0 on user's machine. Heck, thats a lame way... and my client can't afford it.

Isn't there any other better way??i had the same problem and i was able to get it to work by doing this: download the update here: http://www.randem.com/support.html
Automatic OS Updater for MDAC/JET/DCOM

this is the update that the computer needs for access runtime files and vb files... i installed this on the other xp computer and it fixxed the errors i was havin openin the reports... i stuggld with this for a long time
hope this works...

Crystal Reports 10 Viewers

I have a report (Crystal Reports 10) that connects to an Access database. The Access database uses a pass-through query to retrieve data. The .rpt file and the Access database will both be stored in the same directory.

What kind of viewer will my end-users need? Where can I get it?

ThanksCan anyone give some feedback on this? I still haven't found a solution...

Crystal Report X & Access 2003 Db

I am running CR X and Access 2003 database.

I have a table defined as Employee and one of the fields is called RESDate and is defined as Date/Time.

The RESDate has a default value Date () - 1. Bascially, I am deriving yesterday's date. When I view the table in Access, I see yesterday's date in the field.

Now in CR X:
I made a new connection and brought in this Access database and this one table. I moved the RESDate to detail line.

I do not see yesterday's date in CR. I did browse of the field in CR X and it shows blanks also. Any ideas ?

Thanks for your help in advance.

Regards
LB1That sounds odd, in CR right click on the field name and select show type,
does the field show up as a string ? or as date / time or ? Also can you create a query, or a view and try reporting off the query / view ?

Crystal Report Query Engine error

Hi,
My project is being done in Vb.Net 2003 and SQL Server2000. When I try to access the Crystal Report thru code only I get the query engine error. the Sql Query however works perfectly in Query Analyser.
The Query uses left outer join operation from 4 tables. Is there any way I can overcome my error?

Thanks in advance
JohnsyIt could be useful to know exactly what error message says, to figure out if we're dealing with connection problem, or there is an error in query.
Also, you could try running Profiler to see what happens on SQL Server when you run your report.|||hi johnsy,

i too got the same problem . please tell me the solution if had solved tat problem.
how to create dataset.xsd for 2 tables

Crystal Report Problem, Please Help

Hai,
Thanks to Mr.WizBang, Sorry for the late reply.Now I'm having another one problem, I'm using Crystal Reports 8 with MS Access as the Back-end. The database is password protected, When i'm creating the report there is no problem during the design time or previewing the report from crystal reports, it connects to the database through the odbc connection where i have supplied the password, and it works fine, but when i'm doing the same from within vb, it is saying "Not a valid password" and then "Server not yet started", but when i remove the password for the database it is working fine, i have tried all sorts of things over the past week but i'm not able to find a solution, please do help me out with this problem, thanks in advance.[ Moved ]

JeffB|||I think JeffB has replied to this topic, but i'm not able to see the reply, it is displaying something like [Moved],what should i do?|||It's just to let you know that I've moved your post in the Crystal Report forum, I did not gave any answer, sorry... :(

JeffB

Crystal Report Performence Issue

Hi All,

I am new in Crystal Report.net2005.
I have used VB.net Application, Access 2003 as back end database.
I am using dataset for viewing crystal report.

My prob is that:

For th first time my reports are taking too much time to show.
But the next time it's not taking so much time.

It's happening every time when i exit the application.

Please give solution

Thank in Advance

Mayukh.What happens if you run the Crystal generated SQL directly in Access? Is it slow the first time and quicker next time?|||First time to make connection and pull data it takes sometime. But next time it would be faster as connection is already there until you refresh the report

Crystal Report for Access

Hello, I want to ask a silly question.
I doubt if this is possible... :rolleyes:
How can I use the CrystalReportViewer tool using an Access Database in Visual Basic.NET (2003)to be a bit more specific - i need 2 populate a crystal report from a database/dataset without it asking me 2 login 2 the data source. i'm sure there's a simple way 2 do this but i'm a newbie so please forgive me. :) the database is a normal .mdb file without any password.|||:D Hey David!

I've figured some things out - I hate Crystla Reports!!

Project, Add New Item, Select Crystal Report. in that wizard we select the drivers (almost similar to DSN box), from there on, we can select the table etc.
The reason why it asks for the login, is because it seems like it's defaulted to SQL Server or the MSDE.
My PC doesn't have Access on XP, so it gave me some trouble, but hopefully we come right with this!|||i'm still not getting it right... help :( i'm populating datasets but no data is showing on the report. i get the column headings but no data. surely someone here should have a solution...|||eish, how dumb am i? :)

assuming i have a report built off a dataset ->

Public rpt1 As New rptTest 'crystal report

rpt1.SetDataSource(dsTest)
CrystalReportViewer1.ReportSource = rpt1

although u folk probably know this already maybe it'll help another newbie.

thanks 4 ur help Hannes. :) i'll buy u that beer soon dude.

crystal report exits on access MS-SQl server 2000 and 2005 with O

Setup details:
Crystal report : 8.5
Ms-Sql server 2000 and 2005
Crystal report uses MSSQL ODBC driver to get the data from database and
displays in crystal report. When i have large number of data the crystal
report exits after 1 hour. In the temp folder of windows file is created onc
e
it crosses 2 GB crystal reports exits.
Why i'am posting this issue here is the same size data i try to access from
sybase/oracle it works fine. So i thought it would be related to ODBC driver
.
Can somebody help me on this.You are really sending that much data across the network? I
would really, really, really look at changing that. Whether
in works in some scenarios or not seems beside the point.
But...if you want to check your MDAC version, you can
download the component checker from:
http://msdn.microsoft.com/data/ref/mdac/downloads/
-Sue
On Mon, 11 Sep 2006 23:39:01 -0700, Sanjeev Kumar <Sanjeev
Kumar@.discussions.microsoft.com> wrote:

>Setup details:
>Crystal report : 8.5
>Ms-Sql server 2000 and 2005
>Crystal report uses MSSQL ODBC driver to get the data from database and
>displays in crystal report. When i have large number of data the crystal
>report exits after 1 hour. In the temp folder of windows file is created on
ce
>it crosses 2 GB crystal reports exits.
>Why i'am posting this issue here is the same size data i try to access from
>sybase/oracle it works fine. So i thought it would be related to ODBC drive
r.
>Can somebody help me on this.

Crystal Report Datas Export to MS Access

Hi All,
Pls assist me....
I want to export the values from Crystal Report(8.0) to Ms Access. Pls me know if the procudes if itz possible..
Cheers
eam007Export drop down box in the Crystal Reports show "Export to Ms Access Database", but once i click the option, it pops up the 'select database option'. Once the database is selected and click OK, te popup windows closes.
If I oen the database, i find no datas exported from crysal report...

pls assist..

Crystal Report and Deployment

I have a winform application that I want to deploy.

It has a password protected Access database in the bin folder where it pulls all its information.
I have set up a crystal report to read the information and all works well when I am debugging it on my machine. Meaning it connects to the password protected database without asking what the server name, database name, or password was.

However when I deploy the application, if I click to view the crystal report, it opens a screen labeled Database Login. Asking for the Server Name, Database, Login ID and Password. However I don't want this box to pop up and just have the crystal report connect to the database deployed with the application.
The problem is that I think it is trying to look in the folder that the database was in on the computer I was developing it on.

I connnect to the database like so for the crystal report

Dim crpt_Attendance As New Attendance
Dim myTable As CrystalDecisions.CrystalReports.Engine.Table

Dim Login As CrystalDecisions.Shared.TableLogOnInfo

For Each myTable In crpt_Attendance.Database.Tables
Login = myTable.LogOnInfo
Login.ConnectionInfo.Password = "RTr@.k"
Login.ConnectionInfo.UserID = ""
myTable.ApplyLogOnInfo(Login)
Next

crptv_Attendance.ReportSource = crpt_Attendance

I have included the Access Database in the Application folder when I deploy it. And before I create the report, I have a datagrid that reads the information from this database. So I don't know why the crystal report is looking at the location from the computer I created it on and not in the application folder.

Any help is greatly appreciated as I am not very familiar with crystal reports!Make sure you don't have the Database Path hardcoded somewhere in VB or Crystal.|||I only have CR 8.5 developer, but in it you have to set the .ReportSource and you can specify the .SetLogOnInfo.
oReport.Database.Tables(1).SetLogOnInfo sServer, sDatabase, sUserName, sUserPwd

Crystal Report 9 and Password Protected Database

Any body who can help me to connect Password Protected MS Access Database from Active X Crystal Report Engine:

I tried as under:

Dim CRApp As New CRAXDRT.Application
Dim CRRpt As New CRAXDRT.Report

Set CRRpt = CRApp.OpenReport(App.Path & "\Reports\" & ReportFileName & ".rpt")
CRRpt.DiscardSavedData
CRViewer.ViewReport

But It causes an error described as under:
----------------
LogOn Failed.
Detials: ADO Error Code 0x80040e4d
Source: Microsoft Jet Database Engine
Description: Not a Valid Password
SQL State: 3031
Native Error: -124782449
----------------

How can I get rid off this error by supplying login info or password?Thnak for all the visitor to my question!
I have solved the problem.

Dim CRApp As New CRAXDRT.Application
Dim CRRpt As New CRAXDRT.Report

Set CRRpt = CRApp.OpenReport(App.Path & "\Reports\Products.rpt")
CRRpt.DiscardSavedData

CRRpt.Database.Tables(1).ConnectionProperties("Jet OLEDB:Database Password") = "My_Password"

CRViewer.ViewReport

Crystal report 8.5 help

i m using access 2000 from there i m calling crystal report 8.5 , every thing working fine except one query havib=ng having Criteria with parameters , how to pass this parameter to the Crystal report.

would some body help me

SELECT Assignment.BNo, Trade.Trade, Assignment.Source, Assignment.MobDate, Project.ProjectID
FROM Trade INNER JOIN (Project INNER JOIN (Orders INNER JOIN (Employees INNER JOIN Assignment ON Employees.[Badge Number] = Assignment.BNo) ON Orders.OrderID = Assignment.OrderNo) ON Project.ProjectID = Orders.ProjectID) ON Trade.[Serial No] = Assignment.Trade
GROUP BY Assignment.BNo, Trade.Trade, Assignment.Source, Assignment.MobDate, Project.ProjectID, Month([Assignment].[mobdate]), Year([Assignment].[mobdate])
HAVING (((Assignment.MobDate)=[enter date]) AND ((Month([Assignment].[mobdate]))=Month(Date())) AND ((Year([Assignment].[mobdate]))=Year(Date())))
ORDER BY Assignment.BNo;

this is the queryWhile writing the query, u may have some option to create parameter.

CR 9 has that option. No idea about CR 8.5

Crystal Report - C#

Hi, everyone
I'm looking for sample codes in C#, using Crystal Report 10 and connecting to database ORACLE (not Access or SQL Server!)
Any help is appreciated,
thank youJust a link to the samples is fine... I'm really in trouble!|||I could find a way to use CrystalReportViewer, but everytime you click something it must refresh the page. I can't use it because it's too slow. I can't believe that actually someone use it...

In classic ASP I can use ActiveX Viewer and it's PERFECT. How can I use it in .NET?|||Hi,
i am using CR 10 and Oracle, but I don't have a direct connection from CR to Oracle. What I am using is a strongly typed dataset, which I link to the reportsource.
Maybe this helps.|||Hi,
i am using CR 10 and Oracle, but I don't have a direct connection from CR to Oracle. What I am using is a strongly typed dataset, which I link to the reportsource.
Maybe this helps.

Hi Reinhold,
I'm using CR 10 and Oracle, too.

As far as I'm a newbie in .NET, can you post me a sample code that explain your solution?
Because that CrystalReportViewer object is useless with that "refresh" problem.

Thanks in advance