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 reports_oracle

Can we execute/Run crystal reports with PL/SQL code in Oracle?yes u can use oracle stored procedures ,using ref cursors to report.|||shareem Thnks for reply,
but my question is can we run crystal reports in pl/sql code. instead of schedule to run crystal reports|||Why do you want to run CR from ORACLE?sql

Crystal reports with java

Hello all,
I am new with Crystal Reports.
I have strange problems.
I created report with parameters and run it from Tomcat.

When i use default parameters window - parameters value which i add don't affect on report result - it uses previous parameters.
If i use custome jsp and add parameters programmatically it's work.

When i try to perform "Search for text" with some text i get:
"ERROR Some parameters are missing values".
If i leave search control empty and perform "Search for text" all work fine - i get parameters window and after this i get report.

Thanks in advance, VitalyWhen assigning value to the parameter make sure you spelled the name correctly and send the proper data that matches to the parameter datatype

Crystal reports v9 parameter problems

I have a V9 Crystal report with 2 parameters. It runs fine when I run the report 'directly', however, when I use the same report as a subreport, I cannot pass the two parameters to the subreport -- it comes up blank wihtout an error. 1 parameter works fine, but 2 is a problem.

Any ideas?Did you link the subreport?
If you did, do the parameters between report and subreport have same
type of data?|||The report is not linked -- its imported. I will double check next week (I'm on vacation this week) but am pretty sure var types are matched.sql

crystal reports on mas90 database

i am having a problem with a crystal report that at one point would run and now is giving me an error
odbc error:canada][pvx odbc driver][fileio] table is not accesible
after you hit ok on that
the second error is
error detected by database dll
what i am trying to run is a crystal report from a mas90 database with an access table. if anyone can shed some light it would be greatly appreciated.
thanks ralphHave you made any changes to that computer since the last time is ran properly? Try looking up the error number on www.google.com or some other search engine.|||i did change machines. and i think it has something to do with the data sources on the new machine but i am not sure what.
but i will give google a try
thanks i appreciate it
ralph

Crystal reports newbie - be nice

Hi,

I don't know the first thing about Crystal reports so bear with me a sec...

I need to create a report generation "utility" to run on another person's machine who does not have msAccess on it.

a) Can I export an MsAccess application to an .EXE?

If not, then I would want to make my "utility" in VB.

b) Is crystal reports built into VB, or is it a seperate package we must purchase?

c) If it must be purchased, and installed on my developer's machine, does it become a part of Visual Studio?

d) Can you briefly describe what crystal reports is, how to use it and what it is capable of?

Answering my questions with URLs to web sites with answers works great for me too!

Thanks!

Davea) Can I export an MsAccess application to an .EXE?
[/quote
No, as far as I know
[quote
If not, then I would want to make my "utility" in VB.

Yes, and you can have an Mdb as database even if Access is not installed on client machine.

b) Is crystal reports built into VB, or is it a seperate package we
must purchase?

Now, with Visual Studio you get a rather old version for free (V 4.5).
If you want a newer Crytsal Report, you have to purchase.
But you could use also dataEnvironment and Datareport --
not as good as Crystal, but all is related on your requirements...

c) If it must be purchased, and installed on my developer's machine, does it become a part of Visual Studio?

No: it is still a separate environment, but you could reference the
com+ components (=the report engine)

d) Can you briefly describe what crystal reports is, how to use it and what it is capable of?

It is a tool to get a report from data. It helps you in making fine reports, and will make them exportable.
The good part is:
you can make almost everithing in a visual way
The bad one is:
look at the biggest thread (http://www.dev-archive.com/forum/showthread.php?s=&threadid=24213) inside this forum, and you will see how
many are finding matters in obtainig what they want...|||Thanks for the reply.

I think I want to use crystal reports to create my utility. Now a new question:

How is this _normaly_ done? When you buy CR, does it come with a kind of report builder like an IDE?

Or, is it more popular to drop a CR object on a VB form and then distribute the program.

The reason I ask is cause my gut wants me to distribute a VB app with a CR object on it, but I looked for books on how to do this and it does not seem popular enough to warrant someone making abook about it...

So then, if there is a more popular method of distributing a CR I just want to know more about it to see what I would need to invest in.

Basically to get approval for purchasing something here I have to know exactly what is is (the name of the product) before I can get a quote on the price and then approval on it...

Thanks!

Dave|||some Basic infos:
http://www.vbexplorer.com/VBExplorer/vb_feature/august2000/using_crystal_reports.asp

some code exmple (Vb, Mysql and Crystal report)
http://www.vbmysql.com/samplecode/cr9vbmysql.html

What you may already have:
http://support.microsoft.com/default.aspx?scid=kb;en-us;193336

Now, As I said it is a lot I do not play with Crystal Report, and my
small knowledge of it is stopped around version 8.0 (while last
version should be 10 or more).
If I remember correctly, installing Crystal should result in habving some more components that you could add to your Vb projects. Those components (Ocx) should help you in managing reports
through Vb.
hope someone else herearound could say a bit more on this...|||Great links, thanks for the help!sql

Crystal Reports Group By and MySQL mediumtext field

Hello Friends,

I have connected Crystal Reports to MySQL database 4.x.
Now I want to run a query using the group by option on a mediumtext data type field. But as Crystal Reports does not allow to do a Group by on a mediumtext field is there any way i can convert the field to String and then do a group by ?

Thanks for your help in advance.
Shanker.Do you have unique id value for that column?
If so group by itsql

Crystal Reports for VS 2005 - Passing SQL Stored Procedure Parameters

I have a report which uses a stored procedure with several parameters which gets loaded into the Report Viewer control. When I run this report on the development machine everything works correctly, but after I publish it to another machine (or even another website on the development machine), I get the message:

Failed to open a rowset. Details: ADO Error Code: 0x Source: Microsoft OLE DB Provider for SQL Server Description: Procedure or Function 'uspReport_IncidentBrowse' expects parameter '@.departmentid', which was not supplied. SQL State: 42000 Native Error: Failed to open a rowset. Error in File C:\WINDOWS\TEMP\rptincidentbrowse {5F03A03D-6BF9-4121-B68C-06D9C89283A1}.rpt: Failed to open a rowset.

I have other reports which do not have SQL parameters which run fine. All the reports have a parameter for the title line of the report and this is getting set correctly.

I have searched and found numerous examples of how to programatically set parameters... all of which work fine on the development machine, but all produce the result above once the website is published ANYWHERE.

Is this a limitation of Crystal Reports for Visual Studio 2005?IIRC, the license for Crystal Reports included with Visual Studio is for no-production use ONLY. (It's been a while since I have used Crstal, much preferring SQLServer Reporting Services.....)|||According to their license agreement you are allowed to deploy to a production server.

In addition, regardless of licensing issues, I would not be willing to purchase an enterprise (or any other) CR license unless we are able to solve this problem in a proof of concept deployment.

Does anyone have an authoritative answer?

Crystal Reports 8.5/ASP 3.0 - report not shown in browser

Hi

I am trying to run a web application which is done using asp 3.0 which uses crystal reports 8.5 for reporting. I am not able to view the report in the browser, it is just showing the Crystal reports viewer control.

Please help me in trobleshooting this...

Thanks,
R.K.T. AshokaAnybody can answer this ?

Hi

I am trying to run a web application which is done using asp 3.0 which uses crystal reports 8.5 for reporting. I am not able to view the report in the browser, it is just showing the Crystal reports viewer control.

Please help me in trobleshooting this...

Thanks,
R.K.T. Ashokasql

Crystal reports 8 problem after running

hi,
i couldnt explain in title clearly.
the problem is i have used CR in project and when ever the project exe is run and open the reports then close everything including the report it gives runtime error .if i run the exe without opening CR it doesnt give error could there be any DLL problemWhat is the error you are getting?
Open the report and do verify database and try again

crystal reports 7.0 with vb6.0

hello

How i run vb application using a crystal report on any other machine on which crytsal report isn ot installed ?

how can we embedd crystal report in visual basic to make trake ur reports.. ?

Is it possible that we make a crystal report in Crystal report and direct call it on the setup time when other computer not contain crystal report..?

What is the run Time dll required for crystal Report in our application....???

please help me .. if some one know about the process , please alos let me know... thank you

ankur bhatnagarIf you have referenced the crytal reports in your project, then just make a setup of the project and install it in other systems that do not have crystal reports.

The setup will take care of installing the DLLs and OCXs required for crytal reports to run on the system.

Crystl32.OCX is the OCX file for the crystal report control
crviewer.dll is the dll for crystal viewer

Crystal REport run time error 6 over flow

In win98 se..i get run time error 6 over flow..when i try to open crystal report through a vb application on the client machine...i try to isolate the problem..what i found is that while displaying images..there is no problem..integers no problem but when data in string format (for example product name) is put onto the report..it prompts this error...the applicaiton works fine on xp..i dont know how to fix this problem..could any one please help meCheck if there are any viruses on that system
What does that string look like?
Does it have special characters?

Crystal Report problem???

hello all gurus...
i have complied my program in vb 6 and crystal report 7 and when i install the set up and run in the computer it gives problem to open crystal report .Giving the following error:

Runtime Error 20533

Unable to open Database

So please help me Gurus.

thanks

Kesang Ti also get that error in WindowsXP, so i try to fixed it by point then location of the databases directly.
u can try it.

Crystal Report

I would like to automate the printing of some Crystal reports that I run daily and was thinking about setting up a scheduled task to automate the printing. Any suggestions?

Cheryl

I think you are in the wrong forum. This is for microsoft reporting services (similar to Crystal Enterprise).

Crystal Enterprise Question

Hello,

I have a report that I have put in Crystal Enterprise so that users can go and run the report as necessary. The report has 3 parameters that the users will choose when they run the report. One is a location, the other is a date (picks from a calendar), and the other is a boolean to choose if they want a graph printed with the report or not.

Here's my question. I would like to set up this same report as a scheduled job to automatically email to two people each day. I know which facility to put in and true for the boolean parameters, but how can I tell it to do it for the previous date when it's expecting someone to pick from a calendar? Each day's email will have stats from the day before.

I really don't want to have to maintain two reports for this if at all possible.

Thanks for any suggestions!
NMellickPass your date of birth as the date parameter and in the selection formula add code to check the parameter and if it's your b-day then change to todays date minus 1.

crystal class regenerate in vs.net

how shall i regenerate the report class in vs.net
as i have added a new parameter to the report and run the project that parameter is not visible in proxy( - i dont correct name how do you call this) class automatically generated by the vs.net?
can someone help me in this problem?crystal class regenerate in vs.net|||crystal class regenerate in vs.net

Crystal 9 crosstab export to excel (peoplesoft 8.9)

Hi

We are on Crystal 9 (9.2). I am running the report from PeopleSoft 8.9 (People Tools 8.46).

My crystal uses crosstab. When I run the report online (peoplesoft) choosing the output option 'xls', report is generated with the following formatting issues. Please help me if you figured this out already.

1) Report column width is too big. How to reduce it? Same problem with Row height.

2) The label 'Total' for each group is displayed in the column next to it. I want to print this label in the same column.

3) Row headings are repeated on every page. But they are diplayed after one row of data. Is there any way to suppress these two headings that are displayed through out the report.

4) If I have a 3 columns under a comomn group name and if one of those columns has no data, is there a way to suppress that column? Or is there a way to keep the column headers as in their place?

5) column data spans in multiple columns. How do i keep them in one column?

Your help is greatly appreciated.

Thanks
Sreedevihi,

Do u have any idea about how we can import data's from Excel Pivot table to crystal report (cross-tabs).

Thanks|||Sreedevi, read them in CR help file
Also read
http://support.businessobjects.com/

Crystal 4.6 connection to Access 2000?

I have a VB6 package that uses CR 4.6 and has installed successfully on numerous PCs under all versions of Windows (97 to XP).
Now I when I run the package on my new laptop and try to print a report, I get error error 2147417848 - disconnected from client.
Moreover, although the CR report designer recognises the rpt files, the preview window gives an error. I'm assuming connecting to the database is the problem. The new laptop has no problem with any other software or with printing in general.
I have tried re-installing VB6 and Crystal Reports, re-registering crystl32.ocx, tried the Dependency Walker from Crystal, spent hours trawling the web, all to no avail.
Any bright ideas out there?Are you able to open the report?
Do verify database

Cryatal Viewer

I need to test if the user had clicked the print button on the crystal viewer in my design (not in run time) this button is disable how can I by code know if the user had clicked this button on any else button of the crystal reportLet me get this straight...

You want to determine if the Crystal Viewer was clicked in design time

Do you want to add custome events to any of those controls
I can't see why you want to do this, they already have functionality, they already function as they should :confused:

Or..

You can in any case loop through the Form's controls, determine if the current control is a
CrystalDecisions.Windows.Forms.PageView then loop further through that container to (for example) change the caption of the Tabpage.

Can you explain your problem a bit more please!|||I need to know when he clicked the print button I need to know if he choosed to print as Landscape or portrait

Crosstab?

Hi,
I run the following query "SELECT * FROM tbl_A", and get the following
result set:
Surname Firstname
Smith John
Smith Richard
Smith Simon
What I want to see in my result set is:
Surname Firstname
Smith John, Richard, Simon
How do I achieve this?
Thanks
Jon Derbyshire
Can you do it in the client? This kind of thing is extremely inefficient in
SQL Server.
If you must do it in SQL Server, refer to the following:
http://www.aspfaq.com/show.asp?id=2529
Adam Machanic
Pro SQL Server 2005, available now
www.apress.com/book/bookDisplay.html?bID=457
"Jon Derbyshire" <JonDerbyshire@.discussions.microsoft.com> wrote in message
news:E476C459-477C-4882-A705-674A19D20198@.microsoft.com...
> Hi,
> I run the following query "SELECT * FROM tbl_A", and get the following
> result set:
> Surname Firstname
> Smith John
> Smith Richard
> Smith Simon
> What I want to see in my result set is:
> Surname Firstname
> Smith John, Richard, Simon
> How do I achieve this?
> Thanks
> Jon Derbyshire
|||Thats brilliant - Thanks
"Adam Machanic" wrote:

> Can you do it in the client? This kind of thing is extremely inefficient in
> SQL Server.
> If you must do it in SQL Server, refer to the following:
> http://www.aspfaq.com/show.asp?id=2529
>
> --
> Adam Machanic
> Pro SQL Server 2005, available now
> www.apress.com/book/bookDisplay.html?bID=457
> --
>
> "Jon Derbyshire" <JonDerbyshire@.discussions.microsoft.com> wrote in message
> news:E476C459-477C-4882-A705-674A19D20198@.microsoft.com...
>
>