CrystalDecisions.CrystalReports.Engine.LogOnException: Logon failed.

CrystalDecisions.CrystalReports.Engine.LogOnException: Logon failed.
Please solve this error.verify your report with the database or schema on which it is created. Might be there are more then one data base connections.

crystal32.ocx was not found(after install cr)

hi to all
my name is giridaran
i have some problem with my crystal report 9
after finishing my crystal report installation i create report successfully but in visual basic crystal report control is missing. i have searched in components and win32 folder also but it was not fond.
i want immediate solution for this
thank youAs far as I know, there is not an ocx control in Crystal Reports 9, You should use RDC|||hi
i new userof crystal reports
i di\ont know about RDC
can you expalain for me
with regards
Giri

Crystal32.ocx Missing

When I try to load a VB project, I get the following message:
"Crystal32.ocx Missing"
How can I overcome this problem.
Regards,
SatishOriginally posted by satishbeh
When I try to load a VB project, I get the following message:
"Crystal32.ocx Missing"
How can I overcome this problem.

Regards,
Satish

1. Make sure the Crystal Report Control was installed correctly.

eg. create new vb project add the crystal control, if it's working fine. do the following method

Use Method:

1. Open the project
2. Continue the project with errors
3. After project loaded add the crystal report control in the project (don't save now)
4. close the VB IDE main window [X].
5. This will prompt the changed files, unselect all the files except project .vbp & .vbw, now click yes to save.

open the project now.

yours friendly,
K.Babu

crystal32.ocx in Crystal Reports 8.5

Do we have crystal32.ocx component in crystal 8.5 ? I have installed crystal 8.5, but my VB program complains that "crystal32.ocx" is missing. When i looked for this component on my machine, i found that it is not there.Hi,

Reinstall the crystal reports, In setup select custom option enable the all feature to install.

Thanks & Regards,
K.Babu

Do we have crystal32.ocx component in crystal 8.5 ? I have installed crystal 8.5, but my VB program complains that "crystal32.ocx" is missing. When i looked for this component on my machine, i found that it is not there.sql

Crystal32.ocx - What version of Crystal comes with this?

I have Crystal 8.0, 9.0, 10.0 (Developer Edition). I don't want to use 10.0 as I much prefer the old method using the crystal report control (crystal32.ocx). Which version of Crystal Reports has this? Does it come with 8.0? I am pretty sure by the time 9.0 came out this was phased out. If it doesn't come with 8.0 does anyone know where I can get it or what version prior, it came with?Visit this site
www.businessobjects.com

Crystal XI Runtime DLLs

does anyone know what Runtime DLLs are required to make the CRViewer work properly. I have registered crview.dll. crxdrt.dll and added in whatever didn't do the job on the dependecny walker. I seem to get an invalid tlv error every time I print the report. But if I install crystal XI on to a dev box and print the report through VB it works fine. So it is not the report. nor is it the VB but it is the Runtimes. From that box i Generated an install file for that project and installed on a fresh box and I still get the error. So i tried making a dependency file and again I get the same error.

Does anyone Know the required dependencies for Crystal XI. What am I missing?

Much Appreciated.
RicoWhen faced this problem, i created installer using VS. VS checked the
dependencies, so i could deploy my application without installing CR
at client side.|||I did that It did not solve the problem...
Did you do this with CR XI?|||I did that It did not solve the problem...
Did you do this with CR XI?
No, I did with CR 10.

One more question: Did you put CR deployment *.msm file into your
deployment project? You need to download from CR home page to
deploy them.

Henky|||I will look into that. If anyone has any other things to try let me know..
Rico|||If it is .net you can search -->
http://support.businessobjects.com/communitycs/technicalpapers/crxi_net_deployment.pdf.asp

If it is VS6 then -->
http://support.businessobjects.com/communitycs/technicalpapers/rdcxi_deployment.pdf.asp

Crystal XI forumla syntax

I am trying to write a formula for a report that sums up payments received, both positive and negative amounts.

The issue I am running into is that when I drop the appropriate field as a Summary into the report, it displays a blank field in the details section for each entry that would've appeared if I put that transaction amount field into the report.

Further, I cannot just hide the details and do things in a group section (I tried).

I was wondering if someone could help me with this, I am at my wits end. I can display more information about the fields themselves if necessary

On a similiar note, is there anyway to do a Where clause/command in Crystal formula?

ie sum({x}) where transactioncode = "x"On a similiar note, is there anyway to do a Where clause/command in Crystal formula?

ie sum({x}) where transactioncode = "x"

1. You can create a running total.
Select and add your 'Field to summarize', set the 'type of summaries'.
Evaluate it on the 'Use a formula', click x+2 buton and enter your formula:

transactioncode = "x"

Reset summaries as you need.
-------
or
-------
2. create a formula, kind of this one:

if transactioncode = "x" then {x} else 0

then summarize it

About the issue you have, can you post your formula and some example of your desired result, please?

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 vs Actuate reporting

Guys,

Could anyone tell me how Crystal is different from Actuate reporting? I am basically an Actuate report developer and wondering how flexible is Cystal reporting. My knowledge of Crystal is very limited (with ver 7) We are planning to move away from Actuate possibly to Crystal provided if it is flexible enough to do everything. How easy/difficult to do the following...

1. DB Connection: Can I Connect to different DBs? Read UserID/Password info from a text file or a table instead of defining in the report?
2. Drop-down parameters: Dynamically populating parameter values from DB into the Drop-down.
3. Can I control whats goes into the drop-down box based on the user role.
4. Generate reports where the data comes from multiple DBs.
5. Page-leve security
6. Drill-down reporting - Tree view
7. Dynamic Cross-Tab reports -
8. LDAP Integrating
9. Single Sign-on
10. Output in PDF/Excel
etc...

Please point out if these feature are available out of the box. I looked at the latest version features and it says we can do it all. I would like to hear from you what you think whats possible and what not with out much effort.

Thanks,
PSGuys,

I am very sure some of you have used not all but at least some of these tasks. I would appreciate it if you could respond to only those tasks and comment how easy/difficult to do for a beginner. Whats available out of the box. We can directly talk to sales guys but we do not think we get the correct picture unless you talk to people who is actually using the product.

Thanks a lot for your time.

PSsql

Crystal Viewer 8.5 with vb6

Any body help me that I want to use Crystal Report viewer 8.5 to explore the conditional report. For Example
Show data from date to date, or show data for particular code(s).
Yours cooperation in this regard is highly appreciable
Thanking yours.http://support.businessobjects.com/communityCS/TechnicalPapers/apps_rdc.pdf

http://www.experts-exchange.com/Database/Reporting_/Crystal_Reports/Q_21312684.html

Crystal V9 Range selection

Hi all,

I have installed SP3. whilst in the development environment, I have created a simple report that just lists everything from a single table. This works fine.

I then introduced a range parameter on one of my fields. then go to preview and enter a valid range, but the results still show all records???

Cant believe this is a enuine bug, as it's pretty fundemental. What am I doing wrong?What datatype it is? I tried with date range. It works fine.|||the field type is a character string and the database is an Access 2000 one.

The values are 2 characters like:

LA LB LC LD LE ......and so on.

when I enter a start of LB and and end LD for instane, it returns All|||check ur selection formula.|||I have now removed all parameter fields and will walk you through what I am doing.

I have the field explorer open and have right clicked on the parameter fields and selected new.

this displays a create parameter field dialog box I then enter a value in the name and propting text values leaving value type as string. I change options to range values then press the button set default values. I ensure that the table is correct and then set the browse field with the column from the table that I want to filter on. Then in the left hand pane it displays all values relating to that column. I press the >> button to make all values the default I then set the order to alphabetical ascending i then press ok. it goes back to the previous dialog and I leave allow editing of default values checked and press ok.

My parameter field now exists in the field explorer window under parameters. I drag this to the report header, and press preview I'm them prompted for a start and end of range which I enter, I then press ok, and then I'm returned all values.

???:confused:|||Everythings looks correct.

The last step is, you have to write the record selection formula.

Goto Report menu, select "SelectFourmula" and then "Record..."

This will opens the edit formula window.

Here select your database field and then give in condition which will be suitable for range values and then select ur parameter field.
This looks like

{table.column} in {?parameter}

now save and close this.

Refrsh the report|||Ah....thx the manual doesn't mention the last bit. It works now.

Crystal v9 and SQL stored procedure

I am having a heck of time doing what seems to should be simple. I have a stored Procedure (SQL Server) with one parameter that returns a records set. When I put this into a Crystal ver 9 report it prompts me for the param and produces the report. When I use this report as a subreport in a main report and link a value value from the main report to the subreport param (which is the SQL Stored Procedure param) I get a blank report.

Any clues?

I then decided that I would have the main report run the stored procedure and change the stored procedure to write a table of the result set into the database; I could not manage this as the crystal reports returns the succinct but cryptic 'not allowed when I try to write the table'. (When running this in the query analyzer, it generates the new table as expected).

If you can help it would be greatly appreciated.As a followup to my previous post, I found that if I changed the stored procedure so that it inserted the records into an existing table (as opposed to creating a new table and inserting the data) then the crystal reports interface successfully executed the stored procedure so it was hanging up on the create table part of the process. Can someone tell me if its possile (and if so how) to change the call from crystal reports so that it is permitted to create a table. The same user id and db login executes the create table correctly from QUery Analyzer.|||Not exactly know how to do it in SQL Server. But in Oracle, we can use object type to return
the record from stored procedure and call it from CR.
Other way is, to call this stored procedure from your program and save the result in text delimited
file, then load this file to CR...Just an idea.

Crystal Using DAO

Hi,
Can Some Body Help ?

I was using Crystal Report 7.0, 8.0, 8.5 using CrystalReport control but when i started using 9.0 first of all my old DAO reports are not working, when i am trying to connect it is giving logon error. If i create new one it is ok but working with CRViewer which i do not need, there is a long code i have to write to make any report run, another problem there is no possibility/option of printer seledction like it was there in earlier versions.

Please Help Me.

Thanks in Advancehi, i m also facing problem with DAO can u help me pls.if got soln of urs query.i am just started to work on crystal report 8.5.

so can you?|||See if you are able to find solution here
www.businessobjects.com

Crystal Syntax Problem

I have created a Crystal Report with a section that needs to be suppressed when there is no data. I used an "if then else" statement using the basic syntax of Crystal on the suppress control option of a textbox.

The code is as follows:

if {GetData;1.Complaint} = "" then
formula = True
else
formula = false
end if

Most of the time it works just fine, however on occasion I get the following error:

Error in formula <Object_Visibility>.
if {GetData;1.Complaint} = "" then

Exception Target Site: []N

I am not sure what causes this error. As a note this Report is used in conjuction with Sql Server and a VB.NET application. Any help given is greatly appreciated.Make sure that the condition does not return null value|||It could return a null value. What can I do in the Crystal Report to account for that? Any help given is greatly appreciated.|||Try this

if {GetData;1.Complaint} = "" or isnull({GetData;1.Complaint}) = True then
formula = True
else
formula = false
end if|||It still gave me the same error. Not sure what to do. Any theories?sql

Crystal syntax date query

Does anyone know what the formula is to search for records between 01/04/04 and the end of the last full month?
Thanks.Does anyone know what the formula is to search for records between 01/04/04 and the end of the last full month?

i assume that date1 is ur field at the table1 that need to be search for the formula..at ur report->edit selection formula->record..at this

{table1.date} in date(year,month,day) to date(year,month,day)

regards

Crystal Subreports problem

I could use some help very badly with subreports. I am looking up Bill of Materials part numbers. I have a report that shows the Assembly_Part_Numbers, Component_Part_Numbers, and some other fields. Now, assemblies such as pc boards, cable assemblies, frame assemblies, etc., may comtain components, e.g. - (Component_Part_Numbers) which are themselves assemblies as well. They may be cable subassemblies, daughter boards, etc. If a Component_Part_Number also is listed in the Assembly_Part_Numbers then it is a sub-assembly. I need to be able to show the component parts of these separately, as well.

Now, on the main report I group by Assembly_Part_Number then sort the group by Component_Part_Number. This listing is perfect. But I am having a really hard time figuring out how to do the subreport, or drill-down report. I want the user to be able to click or double-click on a Component_Part_Number listed and, if it is a sub-assembly, display a subreport showing all the components of the sub-assembly. Also, I need to be able to print these out, as well.

Can anybody point me in the right direction? I tried it myself and came up with a very ugly report. I've been using Crystal for over eight years, but have never needed to do a subreport before.

Thanks,
Michael FoxHave you tried Hierarchical Grouping Options in Report menu? This will allow you to establish recursive relation by specifying Instance ID and Parent ID, so the entire tree structure of your assemblies will be displayed. I am not sure, however, if it is possible to actually drill-down into the tree. I tend to think it is not possible, and you would need some frontend application to catch user clicks and re-display the report with selected data.

Subreport is not your friend in this case, because subreport is not recursive (can't have one subreport inside another one).

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 sql caching?

I have been using Crystal Reports for some timw now, but in the last few weeks I have noticed that when I change the qry driving a report and update this on the server, Crystal Reports Viewer still accesses the previous version of the qry, even though this no longer exists. I have tried everything including rebooting, or running it from a different machine, but CRV still accesses the old qry. However, when I run the report outside of CRV, using the report directly, it runs the updated qry.

Has anyone seen this before?Shot in the dark. Is save data with report on in report options. Other thought is this report using a command ?

Crystal Show SQL Query Question

I had a database named X. I renamed it to Y.

My report is mapped to a view named viewX.

After I changed database names, and I choose Show SQL Query in crystal reports, my query from clause says

FROM X.DBO.VIEWX

I want it to say Y.DBO.VIEWX since i changed database names. Is there any easy way to do this. Or is it possible to just eliminate the DB name from the SQL from clause.

thanks,

deep.Open the Report and Do verify databasesql

Crystal Server logon error - Urgent.

Hello,

Can anybody please help me or point me in the right direction here.

The ongoing problem is that I have uploaded my reports to the crystal server at work. Everytime I try to view a report, it tells me I have a logon error as follows, "The database logon information for this report is either incomplete or incorrect." I have tried to make a new report with a new sql database connection on the server at work - I still get the same error message.

The ODBC settings are exactly the same as my own server at home. I have the same username and password as well. I can view the reports at home without any problems. But can't view them from the work server.

If I view the reports through a JDBC connection I can view the reports on the server at work. But if I change the connection to ODBC, no report can be viewed. I can view the same reports on my home server regardless of what type of connection it is, ODBC or JDBC.

For the life of me, I just can't seem to figure out the root of the problem? Please help me.

Best regards
SafIf you don't mind my asking, have you figured out your database logon problem?. We occasionally have the same problem, and still don't know why it happens.|||See if you find solution here
www.businessobjects.com