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

Crystal Running Group Total equivilent in Report Services

I'm trying to use Reporting Services Developer edition with SQL Server 2000
and Visual Studio 2003. Net to create a report that already existed in
Crystal Reports 8.5 so that the report can be distributed via email and other
things that Report Services allows.
The Crystal Report uses something called a 'Running Total' field that
summarizes a field and evaluates a value for each chance of the field and
resets the value on the change of a group.
Who would you go about solving this problem in Report Services?
Thanks,
JimCheck out the RunningValue value function in BOL...
"Jim" <Jim@.discussions.microsoft.com> wrote in message
news:8DDF9D20-B55F-4DD1-8B69-937AD2ACD859@.microsoft.com...
> I'm trying to use Reporting Services Developer edition with SQL Server
> 2000
> and Visual Studio 2003. Net to create a report that already existed in
> Crystal Reports 8.5 so that the report can be distributed via email and
> other
> things that Report Services allows.
> The Crystal Report uses something called a 'Running Total' field that
> summarizes a field and evaluates a value for each chance of the field and
> resets the value on the change of a group.
> Who would you go about solving this problem in Report Services?
> Thanks,
> Jim|||What is BOL and how do you get access to it?
"Jim" wrote:
> Check out the RunningValue value function in BOL...
> "Jim" <Jim@.discussions.microsoft.com> wrote in message
> news:8DDF9D20-B55F-4DD1-8B69-937AD2ACD859@.microsoft.com...
> > I'm trying to use Reporting Services Developer edition with SQL Server
> > 2000
> > and Visual Studio 2003. Net to create a report that already existed in
> > Crystal Reports 8.5 so that the report can be distributed via email and
> > other
> > things that Report Services allows.
> >
> > The Crystal Report uses something called a 'Running Total' field that
> > summarizes a field and evaluates a value for each chance of the field and
> > resets the value on the change of a group.
> >
> > Who would you go about solving this problem in Report Services?
> >
> > Thanks,
> > Jim
>
>|||BOL is Reporting Services Books On Line.
You can also find them on MSDN:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rscreate/htm/rcr_creating_expressions_v1_1l6b.asp
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Jim" <Jim@.discussions.microsoft.com> wrote in message
news:74ABD5D6-72D0-43E5-97C7-BD433A7F6876@.microsoft.com...
> What is BOL and how do you get access to it?
> "Jim" wrote:
> > Check out the RunningValue value function in BOL...
> >
> > "Jim" <Jim@.discussions.microsoft.com> wrote in message
> > news:8DDF9D20-B55F-4DD1-8B69-937AD2ACD859@.microsoft.com...
> > > I'm trying to use Reporting Services Developer edition with SQL Server
> > > 2000
> > > and Visual Studio 2003. Net to create a report that already existed in
> > > Crystal Reports 8.5 so that the report can be distributed via email
and
> > > other
> > > things that Report Services allows.
> > >
> > > The Crystal Report uses something called a 'Running Total' field that
> > > summarizes a field and evaluates a value for each chance of the field
and
> > > resets the value on the change of a group.
> > >
> > > Who would you go about solving this problem in Report Services?
> > >
> > > Thanks,
> > > Jim
> >
> >
> >

Crystal Rpt 10 - currentdate + 6 months

Hey all I am trying to use Crystal Reports 10 and have a date that I need to use from my table. I want to take that date and if it is greater than the CURRENTDATE + 6 months I need to display a message. I have part of it but not sure how to do the "6 month" thing.

if ({mytable.mydate}) > CurrentDate ("+6 months") then
'Length-Promo-Rate = 0'

I have tried this:
CurrentDate + Month({mytable.mydate},6) but it doesn't like it. Suggestions? Thanks.Hi,
for that you have to insert a formula field like :

dim msg as string
if {Report Date/date from table} >= DateAdd ("m",6 , CurrentDate) then
msg ="6 month old"
else
msg = "new"

end if

formula = msg

-Jayesh Mendpara

Crystal Reports+CPU Performance

Hi all
I am to actually integrate different sub reports into the main report.
I was able to solve the problem of linking the sub report parameter fields to the main report.This particular link of msdn helped me

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/crystlmn/html/crtskinsertingsubreports.asp

I am linking the parameter field value of the main report to that of the sub report using the above method.
But my application's performance is going very slow..The cpu usage of the application is almost 100%.I think its because of the double reference that this happens.Reference I mean,the main reports parameters should link to the subreport and then print the data,I guess its this reason that makes the performance go poor.
Can anyone help mein giving any ideas of improving the CPU performance ?

Thanks in advance.How long does it take to print the data?

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: passing DATA to main report

hey everyone:

I have a report with a number of subreports which basically contain ranking data with ranks stores in certain catagories. What I would like to be able to do is at the end of the report, take all of the store_ids that show up on the subreports, and total up their rankings for one aggregate score.

This involves sending data back from the subreports to the main reports, and I would need to pass both the store_id and ranking number.

Is there a way to accomplish this with the current report setup? The one idea I had is to use a shared array for each subreport, and at the end of the report I can handle each array, but that would involve looking for matching store id's, and since i am NOT a programmer, that would take me a long time to accomplish.

so if anyone has any simpler solutions, i would really appreciate it.

edit: Crystal reports 8.5, fwiwWhat is the difficulty you are facing with comparison?
Give more details

Crystal Reports: Displaying percentages of total qty?

I'm creating a .NET crystal report sales report that lists the total # of each item sold and the percentage of total sales that the item contributed towards however, before I can calculate the percentage for each row, I need to know the total qty of the report, which I don't know how to retrieve.

So a sample report of 500 items sold may look like this:
------------------
Category | Qty Sold | Percentage
------------------
Electronics | 200 | 40%
Books | 100 | 20%
Movies | 150 | 30%
Games | 50 | 10%
------------------
Total | 500 | 100%
------------------

How can I calculate a percentage for something like this?
Thanks.

-Goalie35http://forums.belution.com/en/crystal/000/061/54.shtml

crystal reports XI with ascii file

hello CR users,
i'am nearly completely new in the CR field, so sorry for my question...

i have a big ascii file about 300mb. how can i use this file within CR?
is there any way to convert this ascii file into a excel file ore wathever so i can use it.
smaller pieces of this file i can convert into a 'comma separately' csv file.
but there is no well formatet column separation...

i would be very happy if there is somebody out there how wuold post a short solution for this...
thanks HagenSo do you want to show the Ascii values in the report?

crystal reports XI and VBA

Hi folks..
I am using crystal reports created in version XI with Excel(VBA).
i have the following code to display the report..
********************
Private Sub CommandButton2_Click()
Dim rep As New CrystalReport
rep.ReportFileName = "c:\apcg\test\report1.rpt"

CRViewer1.ReportSource = rep
CRViewer1.ViewReport
End Sub

************
But i am facing an error
Runtime error:430 - Class does not support Automation or does not support expected interface..

Could you any one solve this problem..

i knew that the problem is with CRViewer.dll
when i tried to register that file, it failed..
also i am getting an error "Error accessing Registry" when i click references in VB project menu...

Thanks in advance
salaiTry to reinstall CR X1 and see what happens

Crystal Reports XI and Sql Server

Hello everyone,
I am new to crystal reports. Ive been through some of the sample reports and have been learning. All of the samples use the Extreme Database that comes with Crystal Reports. Now I want to practice connecting to my SQL Server database but I havnt been able to figure that out. In the database expert there is every possible database type from MS Access to Oracle, DB2, Informix, Sybase.whatever, but there is no way I have found to connect to an SQL Server directly. The only way I have been able to connect is by creating a DSN for my SQL Server Database and connecting via DSN. Even though I have set my DSN to use integrated security, Im still prompted to enter a user name and password when I refresh the report. The report initially opens without prompting for user name and password.

Has SQL Server been completely left out of the loop in Crystal Reports? Can anyone let me know how to connect to SQL Server directly?

Thanks
GEMCreating the DSN is the way to go. I started by adding an ODBC connection, and adding a system connection, CR will prompt you for a password unless you embed it into the report. (If you embed the password, others with CR may be able to see it) I created a ODBC DSN on my computer, and a matching one (Name Case must match) on my SQL box. ivr_report is the DSN name in this case. Then, open CR, add a ODBC (RDO) connection, select your DSN from the list, (In this case ivr_report), once you have the connection, you can select your tables or views. Hope this helps.sql

Crystal Reports with VS2005

Does anybody have issues with Crystal leaving 'sleeping' connections in SQL
Server even after closing the report and viewer? -On Mar 7, 5:08 am, David Whitt, MCSD, MCSD.NET
<DavidWhittMCSDMCSD...@.discussions.microsoft.com> wrote:
> Does anybody have issues with Crystal leaving 'sleeping' connections in SQL
> Server even after closing the report and viewer? -
I have not experienced that personally; however, if you are using
VS.NET, you may want to make sure that you are closing the database
connection, etc and destroying it in your application. Hope this
helps.
Regards,
Enrique Martinez
Sr. SQL Server Developer|||Thank you for the reply - we are doing that but it doesn't make any difference.
"EMartinez" wrote:
> On Mar 7, 5:08 am, David Whitt, MCSD, MCSD.NET
> <DavidWhittMCSDMCSD...@.discussions.microsoft.com> wrote:
> > Does anybody have issues with Crystal leaving 'sleeping' connections in SQL
> > Server even after closing the report and viewer? -
>
> I have not experienced that personally; however, if you are using
> VS.NET, you may want to make sure that you are closing the database
> connection, etc and destroying it in your application. Hope this
> helps.
> Regards,
> Enrique Martinez
> Sr. SQL Server Developer
>|||On Mar 7, 6:30 am, David Whitt, MCSD, MCSD.NET
<DavidWhittMCSDMCSD...@.discussions.microsoft.com> wrote:
> Thank you for the reply - we are doing that but it doesn't make any difference.
> "EMartinez" wrote:
> > On Mar 7, 5:08 am, David Whitt, MCSD, MCSD.NET
> > <DavidWhittMCSDMCSD...@.discussions.microsoft.com> wrote:
> > > Does anybody have issues with Crystal leaving 'sleeping' connections in SQL
> > > Server even after closing the report and viewer? -
> > I have not experienced that personally; however, if you are using
> > VS.NET, you may want to make sure that you are closing the database
> > connection, etc and destroying it in your application. Hope this
> > helps.
> > Regards,
> > Enrique Martinez
> > Sr. SQL Server Developer
The only other thing that I can think of is that Crystal Reports is
holding the connection open. You can try calling 'sp_who' from the
application and searchnig for some Crystal Reports descriptor in the
resulting table and then use 'kill' to kill the appropriate
process(es); ofcourse, this could cause an error in the application,
if there is still a dependency on the process.
Regards,
Enrique Martinez
Sr. SQL Server Developer|||Yes - I think you are right - Crystal does appear to be holding the
connections open for some reason - I am running a web app written in VS2005
and the behaviour of crystal/sql server is different on different platforms /
installations of SQL Server.
Our production server seems to be managing the connections as expected
though - not sure if this is good or bad - as it could be something waiting
to catch me out later - Thanks for the reply
"EMartinez" wrote:
> On Mar 7, 6:30 am, David Whitt, MCSD, MCSD.NET
> <DavidWhittMCSDMCSD...@.discussions.microsoft.com> wrote:
> > Thank you for the reply - we are doing that but it doesn't make any difference.
> >
> > "EMartinez" wrote:
> > > On Mar 7, 5:08 am, David Whitt, MCSD, MCSD.NET
> > > <DavidWhittMCSDMCSD...@.discussions.microsoft.com> wrote:
> > > > Does anybody have issues with Crystal leaving 'sleeping' connections in SQL
> > > > Server even after closing the report and viewer? -
> >
> > > I have not experienced that personally; however, if you are using
> > > VS.NET, you may want to make sure that you are closing the database
> > > connection, etc and destroying it in your application. Hope this
> > > helps.
> >
> > > Regards,
> >
> > > Enrique Martinez
> > > Sr. SQL Server Developer
>
> The only other thing that I can think of is that Crystal Reports is
> holding the connection open. You can try calling 'sp_who' from the
> application and searchnig for some Crystal Reports descriptor in the
> resulting table and then use 'kill' to kill the appropriate
> process(es); ofcourse, this could cause an error in the application,
> if there is still a dependency on the process.
> Regards,
> Enrique Martinez
> Sr. SQL Server Developer
>|||I've seen this extensively with SQL Server RS 2005 against SQL Server
2000 Relationally.
I reccomend bouncing the SQL Server services once a night; I think
that was a fashionable strategy back in the 90s; and I think that it's
still necessary
On Mar 7, 3:08 am, David Whitt, MCSD, MCSD.NET
<DavidWhittMCSDMCSD...@.discussions.microsoft.com> wrote:
> Does anybody have issues with Crystal leaving 'sleeping' connections in SQL
> Server even after closing the report and viewer? -

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 Viewer [2003]

Hello,

I have a load of crystal reports which have been created previously, and what I'd like to do is print / preview these from my VB.NET application.

Ideally I'd want a form in VB which will list all of the crystal reports in a particular location on my hard drive. Then I'd like to be able to click onto the reports and print / preview them in the Crystal Viewer.

I have found something called Crystal Reports Viewer on the toolbox, but I can only seem to link 1 report to that.

Can anyone help me with this please, or point me in the direction of some documentation which will help me do this?

Thanks,
J.use filedialogbox and set default path to ur local hard drive folder.

whattever file user selects map it to, reportsourse property of crystalreportviewer.

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 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 using .net objects

hi

I am using VS 2005 c#.net, in that crystal reports 10.

In my requirements i have to bind the databse with two data base objests.
With using one object i am able to get that data.

CrystalReport2 cryst = new CrystalReport2();
cryst.SetDataSource(cand.GetGeneralInfo());
crystalReportViewer1.ReportSource = cryst;

this GetGeneralInfo() method is of type list.
I am binding that list to my report.

Thanks
Raghudo you want to get data from two different servers?

Crystal reports to SQL Server Reports

Hi
Present we are using Crystal reports 9.0 in application.
we like to convert crystal reports to SQL server reports.
Do we need to rewrite all crystal reports into SQl reports again
Would you appreciate if any one give suggestion for hot toconverting
crystal reports to SQL Server Reports .
Regards
VenuI do not know of a conversion tool. We just went through same and re-wrote
our reports. It was fun! RS is a powerful reporting tool and out-classes
crystal.
good luck
--
U. Tokklas
"venu gopal" wrote:
> Hi
> Present we are using Crystal reports 9.0 in application.
> we like to convert crystal reports to SQL server reports.
> Do we need to rewrite all crystal reports into SQl reports again
> Would you appreciate if any one give suggestion for hot toconverting
> crystal reports to SQL Server Reports .
> Regards
> Venu

Crystal Reports to SQL Reporting Services Migration

Does anyone have any recommendations for the best approach to migrating
Crystal Reports to SQL Reporting Services?There isn't a "quick" convert option - Crystal being a proprietary report
format limits you from stripping out information about the report. You could
use the "report defintion" option to find out details about the report,
etc...but this is purely for informational purposes
The reality is you will have to re-build your reports. The only reusable
components would be the SQL statement, if optimized, or other source info
(stored proc's, etc...). The rest would be fresh.
--
MGM
"CaskeyRW" wrote:
> Does anyone have any recommendations for the best approach to migrating
> Crystal Reports to SQL Reporting Services?|||Thanks for the reply. That's what I expected, but thought it was worth asking.
"MGM" wrote:
> There isn't a "quick" convert option - Crystal being a proprietary report
> format limits you from stripping out information about the report. You could
> use the "report defintion" option to find out details about the report,
> etc...but this is purely for informational purposes
> The reality is you will have to re-build your reports. The only reusable
> components would be the SQL statement, if optimized, or other source info
> (stored proc's, etc...). The rest would be fresh.
> --
> MGM
>
> "CaskeyRW" wrote:
> > Does anyone have any recommendations for the best approach to migrating
> > Crystal Reports to SQL Reporting Services?|||There is help on the way. A Microsoft Partner Readiness seminar covers, in
part, migration from Crystal Reports to SQL RS
http://www.msreadiness.com/
http://www.msreadiness.com/WS_abstract.asp?eid=15003226
--
Cheers,
'(' Jeff A. Stucker
\
Senior Consultant
www.rapidigm.com
"CaskeyRW" <CaskeyRW@.discussions.microsoft.com> wrote in message
news:CB4241D5-5972-46ED-A3D8-B84EEB72E3AD@.microsoft.com...
> Does anyone have any recommendations for the best approach to migrating
> Crystal Reports to SQL Reporting Services?|||Jeff,
Thanks for the reply. We've already moved forward doing it manually and
have actually completed the migration. Once we developed kind of a process
or pattern for doing the conversion, it wasn't too bad.
Regards,
Rick
"Jeff A. Stucker" wrote:
> There is help on the way. A Microsoft Partner Readiness seminar covers, in
> part, migration from Crystal Reports to SQL RS
> http://www.msreadiness.com/
> http://www.msreadiness.com/WS_abstract.asp?eid=15003226
> --
> Cheers,
> '(' Jeff A. Stucker
> \
> Senior Consultant
> www.rapidigm.com
> "CaskeyRW" <CaskeyRW@.discussions.microsoft.com> wrote in message
> news:CB4241D5-5972-46ED-A3D8-B84EEB72E3AD@.microsoft.com...
> > Does anyone have any recommendations for the best approach to migrating
> > Crystal Reports to SQL Reporting Services?
>
>

Crystal reports to Reporting Services

Crystal reports to Reporting Services
Is there any way I can convert Crystal reports to Reporting Services instead
of creating reports again in Reporting Services?JIM. H. wrote:
> Crystal reports to Reporting Services
> Is there any way I can convert Crystal reports to Reporting Services instead
> of creating reports again in Reporting Services?
Aside from using a Migration partner, there is not much else that can
be done outside of maybe designing some sort of custom migration
application. A few of the migration partner links are as follows.
Sorry that I could not be of greater assistance.
http://www.hitachiconsulting.com/downloadPdf.cfm?ID=251
http://www.rpttordl.com/
http://www.microsoft.com/sql/technologies/reporting/partners/crystal-migration.mspx
Regards,
Enrique Martinez
Sr. Software Consultant

Crystal reports to Reporting Services

Crystal reports to Reporting Services

Is there any way I can convert Crystal reports to Reporting Services instead of creating reports again in Reporting Services?

From http://blog.hundhausen.com/ConvertingCrystalReportsRptToReportingServicesReportsRdl.aspx (and I have no idea whether this is true):

There are way too many Crystal Reports out there in the world and I would love to see more of them converted to Reporting Services. Therein lies the problem. I had heard that Crystal (now BusinessObjects) had blocked companies, like Hitachi, from building converters, because they would be reverse engineering (or using the APIs to reverse engineer) the .rpt files, and that would violate the license agreement.

Microsoft only provides migration guidance, but I see that one company, KTL Solutions, has a conversion product available, and another company, Jeff-Net is offering a $25/report conversion service at rpttordl.com.

There do seem to be a lot of "migration partners" (gack!) listed in various places.

>L<

sql

Crystal reports to Reporting Services

Crystal reports to Reporting Services

Is there any way I can convert Crystal reports to Reporting Services instead of creating reports again in Reporting Services?

HI, JIM.H.

You can check out this great article. Hope it helps

Converting Crystal to Reporting Services

http://blogs.msdn.com/gsnowman/archive/2005/10/12/480305.aspx

If i misunderstand you about your question, please feel free to correct me and i will try to help you with more information.

I hope the above information will be helpful. If you have any issues or concerns, please let me know. It's my pleasure to be of assistance

|||

Hi Jim,

Microsoft created one Migration guide for Migrating Your Crystal Reports to SQL Server 2005 Reporting Services -

http://www.microsoft.com/sql/techinfo/whitepapers/migrate-crystal-to-reporting-services.mspx

And the webcast for this -

http://msevents.microsoft.com/cui/WebCastEventDetails.aspx?culture=en-US&EventID=1032298257&CountryCode=US

Got this info from this blog -

http://blogs.msdn.com/bwelcker/archive/2006/05/31/612637.aspx

Crystal Reports Syntax

I am not really a programmer but I am writing a report in CR XI and I am having syntax issues. I need some sort of operator after my 'then' statement (See code below) "Else" only works on the first line. I tried "And" or "Or" does not work. Can someone please help!!!!

If {REPORT_LINE.SECTION_NUMBER} = 1 and {REPORT_LINE.LINE_NUMBER} IN 100 TO 199 Then 'Cash' - need function

If {REPORT_LINE.SECTION_NUMBER} = 1 and {REPORT_LINE.LINE_NUMBER} IN 200 TO 299 Then 'Short Term Investments' need fuction

If {REPORT_LINE.SECTION_NUMBER} = 1 and {REPORT_LINE.LINE_NUMBER} in 300 To 399 Then 'Account Receivables'

If {REPORT_LINE.SECTION_NUMBER} = 1 and {REPORT_LINE.LINE_NUMBER} In 500 To 599 Then 'Fixed Assets'

If {REPORT_LINE.SECTION_NUMBER} = 1 and {REPORT_LINE.LINE_NUMBER} In 600 To 699 Then 'Long Term Investment'okay I figured it out, instead of using If.... Then statements there is a command call "switch" that you can use for all true values. My report is now done YEAH!!!!!|||u can also use :
If .... then

elseif ...... then

else

endif

Crystal Reports SQL 2005

What version of Crystal Reports would be suggested to create reports out of
SQL 2005?This newsgroup is for the competitor to Crystal Reports, MS SQL Server
Reporting Services. If you have a license for SQL Server 2005 you have a
license for Reporting Services (if it is run on the same box). If you run RS
on a different box you need another license. So, depending on if your
company will allow RS to run on the same box the most cost effective (i.e.
no additional cost) is RS. If you have to purchase a license then whether RS
is cheaper depends on your company. At my company every PC has a CAL and so
all I need to purchase is the server license so it is extremely cheap for
me.
I'd suggest checking out Crystal Reports website for more info on their
product line.
http://www.businessobjects.com/jump/xi/g/crystal/default.asp?s_kwcid=crystal%20reports|1337034014
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"J" <J@.discussions.microsoft.com> wrote in message
news:AB1D6367-ADEE-4B7E-992C-D31B5A466652@.microsoft.com...
> What version of Crystal Reports would be suggested to create reports out
> of
> SQL 2005?

Crystal Reports Schedulers

Can anyone recommend a good, reasonably low-priced (say, $500 or below) Crystal reports scheduling application that would be compatible with Crystal Reports version 8.0.1.0, running reports that are using Fox Pro tables (in native form) as their data source?

I need to run 16 or so sets of the same 18 reports on a monthly basis.

All help and ideas would be greatly appreciated.

Thanks!Do a google searchsql

crystal reports running slow ?

All,

I have been tapped to help with fixing a reporting tool. We have a Sql Server database/crystal reports(10) setup. I havent had the chance to look at the tables in the DB yet, but I was told that aggregate tables were used. In my past experience with crystal reports, we used database views to feed crystal reports (in Oracle). I was thinking that I could somehow use views instead of tables and then try to re-index the base tables and compile satitics (if theres such a thing with Sql Server). I was also going to look into bottlenecking and locking (table locking as opposed to row or page locking for the lookup tables...to reduce overhead on the main tables) but, I'm not sure if it'll make a difference since this is just a demo server with no major traffic hitting it yet.

The question is, does anyone have any experience with crystal reports running slow with Sql Server, what should I look out for??

'WaleCrystal reports sucks.

Now that we have gotten the obligatory disparaging remark out of the way, you should push as much processing as possible onto the server, and use Crystal only for displaying the data. This means having Crystal call either a Procedure, View, or Table.

If your tables are pre-aggregated, then that is about as fast as you are going to get, because all the processing work is done during nightly batch processing (usually). That said, if your so-called pre-aggregated tables are actually being created on the fly each time the report is requested, well, that's about the lease efficient method.

With the (possible) exception of data aggregated for specific reports, it is seldom a good idea to reference tables directly. Reference views or (preferably) procedures instead, so that if the database schema needs to be changed you will just need to update your procedures rather than redesigning all your reports.

Make sure the aggregated tables are indexes on any columns used for filtering, and your dataset will be generated very fast. If the reports are still slow, take a close look at your network and figure out how much data is actually being passed back to Crystal. Maybe additional filters are possible.|||I couldn't agree with you more blindman, unfortunately, I don't make the decisions. I like the idea of having Crystal calling stored procedures, so it'll be a simple call and we'll have the procedure take care of any processing. I'll also looking into indexing etc.....|||a stored procedure for every report...sounds like a maintenance nightmare...and also, defeats the purpose of the tool.

you will want to look at all the WHERE clauses in the reports and index all the columns included.

the best solution would be to look into restructuring the data into a reporting friendly format (i.e. star schema).|||We decided to use DTS to create aggregate tables for us. And we added some indexes. The reports have picked up speed.|||A stored procedure for every dataset, not every report. And the result is reduced maintenance. Business logic that would have to be duplicated in every report only has to be implemented in the procedure, and you can be sure that the results of all reports based upon the same procedure will yield compatible results.

The purpose of the Crystal Reports tool is to present data, and that is what it should be used for. The purpose of the Database Server is to store and manipulate the data, and that is what it should be used for.

And Star Schemas are vastly overrated. They are the poor-man's database design.|||I disagree...

business logic should be handled at the meta-data layer for the reporting tool not at the report level. (i.e. one place)

crystal is not just for presentation...it's meant to facilitate business questions to be answered while shielding the user from the complexities of SQL.

star schemas vastly overrated? well, no...it's the best possible reporting structure....and a little thing called OLAP!|||OLAP and Star Schemas are not synonymous. A Star Schema is just a glorified pivot table. For functionality, it is just one step beyond a flatfile.

You can let your business model drive your schema, or you can let your schema drive your business model.|||For functionality, it is just one step beyond a flatfile.

I suppose...other than the functionality of robust and high performance reporting.

You can let your business model drive your schema, or you can let your schema drive your business model.

haha...Copernicus...I love it!! ;-)|||Ok, I admit it. You got me on "Copernicus". What's the reference? His planetary model?

crystal reports row count

bebe lush posted at 20-Sep-06 05:58
How can i add a column in the report to count the rows, and to auto increment.
Like:
1. | line 1
2. | line 2
3. |
to show me the current number.Friend,

Do one thing create one Formula Field named @.SlNo, and insert into detail section. Formula is given below:

//------------------

numberVar numSlno = 0;

IF PREVIOUSISNULL(<Name of Any Field>) THEN
numSlno := 1
ELSE
numSlno := numSlno + 1

//------------------|||why use formula
just include record number itself :wave:|||why use formula
just include record number itself :wave:
Thats correct way|||I tried this one but I got error at the part (<Name of Any Field>). I am a newbie, could you please elaborate on it? Thanks a lot!

Friend,

Do one thing create one Formula Field named @.SlNo, and insert into detail section. Formula is given below:

//------------------

numberVar numSlno = 0;

IF PREVIOUSISNULL(<Name of Any Field>) THEN
numSlno := 1
ELSE
numSlno := numSlno + 1

//------------------|||Well, that code has a bug anyway.
As said before, in the Field Explorer, just use the special field Record Number.|||as one of the repliers said,
the best way to me is to add a special field recordNumber.
OR you can also use a running total field.
In fields Explorer, Create new Running Total Field, Choose any of the fields (Preferably numeric) Summerize.
and select Count .
Allow it to execute for Each Record
One of these things should solve the problem.
The Last Solution i would suggest will be to use shared variables.|||as one of the repliers said,
the best way to me is to add a special field recordNumber.
OR you can also use a running total field.
In fields Explorer, Create new Running Total Field, Choose any of the fields (Preferably numeric) Summerize.
and select Count .
Allow it to execute for Each Record
One of these things should solve the problem.
The Last Solution i would suggest will be to use shared variables.

Why to make things complicated?

Just use Record Number field.

crystal reports records above 16384 are left out

Can anyone suggest me how to tackle this problem

In crystal reports records above 16384 are left out while exporting to excel and it is becuase the .PrintFileType = crptExcel50 supports upto 16384 records to export.I am using Office 2000. Is there any other way to export more than 16384 .Is there is any other printfiletype above crptexcel50 like crptexcel70 or crptexcel80

thnx
shaliniSearch in this site
http://support.businessobjects.com

Crystal Reports Question for BABU/any GURU

Can some one please help me with the below.

I need to write a formula in crystal reports to give the birth dates for this week. For Example: If I am running the report on a Tuesday I need to see the results from Tuesday to Saturday. I know that we can acheive this in 7 conditional steps, but I am looking for a precise formula. Can some one please help me with this.

Thanks
BTry this logic

Date=Date+5

CR.selectionFormula="{DateField=Date}"

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 problem

I have a problem when I try to work with alias.
It takes the report 15min to load.
I'm working with 16 aliases and I think thet might be the problem.
Has anybody got any ideas?Do you mean you've got 16 tables joined together in the report?
Does the SQL itself run any faster outside of Crystal?
I had a report that had a driver table joined to another table 3 times. It performed well with 2 tables, just about OK with 3 and terribly with 4. Turned out that the query plan on the database server was rubbish even though all the filter conditions were using indexed columns. Changing the SQL to prevent the indexes being used caused the query to run quickly again!|||Do you mean you have 16 tables joined in the report?
Does the Crystal generated query run as slowly outside of Crystal, or is Crystal itself doing lots of post-processing on the returned data?|||Thet is correct I have 1 table but it has 16 diferent names, because in the table that this one is connected to, has 16 diferent names (but each name gets its value from the same table). So I tryed doing it with only 10 aliases and it works fine (the report loads in 9s).

So what I'm trying to figure out is, does the crystal have a constrain to how many aliases you can use?|||No constraint that I'm aware of - it's just another table after all. My example was similar but I only aliased the same table 3 times with each alias joined to one other table.
Check the query plan - it may be doing a whole load of nested loops that get worse with each new alias you add.|||Thax

I changed my query, and you were wright, I had some sub querys, I changed it a bit and now it works prity fine.

Crystal Reports Printing from SSL

I have a tough problem in debugging the following problem..

When I try to print or export to .pdf from crystal reports from a SSL certified (https://..) it throws IE error saying file cannot be found..

From normal servers (http://...) it works fine..

Server: windows 2000
Crystal reports 9.x
Scripting :ASP

If any one have any solution for this... please do help..

Thanks,I too have this problem on a Win2K3 using CrystalReports .NET ... Instead of a "404 File Not Found" error, I get a blank page and a little picture icon.

Have you had any progress?|||up to version 8, CR didn't support relative paths, so that might help axisperfect, who didn't state CR version........
The test for this is to try to create a text file to the same location.
If it succeeds, your problem relates to CR.
If it fails, too, then you should look to your web server as the source of the problem.

Dave|||Thanks for the suggestion, Dave.

Oddly enough the probem seemed to be confined to my PC and the local (!) server. The symptoms:
1. Able to view Crystal Report
2. When exporting to PDF (e.g. clicking a button that writes the PDF to current window) , the browser will either blank out or crash (as it eventually did on my computer).

After 2 hours of scratching my head, I tried it on a few other computers and found nothing wrong. *roll eyes* Just for the record, I'm using the Crystal Report that comes with VS.Net 2002.

I've decided to leave it as-is since the problem was so isolated.

Crystal Reports print 3 copies

I am looking for a way to add a code to my Crystal report that will tell the report to print three copies of each work order and send an end of document so the printer will staple the 3 copies together. Then do the same for each work order. The report generates multiple work orders. Is there a VBA script I could add?CRAXDRT.report contains a method named PrintOut which takes number of copies as parameter.

crystal reports pciture resolution

Hi All,
I have a quesiton about picture quality in the crystal reports. It seems that picture which insert to the crystal report will be degraded.
Do you guy have any solutions of it? I will be appreciate it
my email is : myee@.lyctech.com
Thank youxqpeng@.tsinghua.org.cn

TIA|||vzsoft@.walla.com

Thanks

Crystal Reports over network

Hi all,

I have received the following error message when tring to load a report which is accessing data over a network from sql server.

The table " could not be found.

Here is the code to try and access a number of reports;

Any help is much appreciated.
Thanks

Private Sub btnRunReport_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnRunReport.Click

Try

MyBase.Cursor = Cursors.WaitCursor

If Me.cboReports.SelectedIndex = 0 Then
crvReports.ReportSource = DataAccess.getLevyDirectory & "\1.rpt"
ElseIf Me.cboReports.SelectedIndex = 1 Then
crvReports.ReportSource = DataAccess.getLevyDirectory & "\2.rpt"
ElseIf Me.cboReports.SelectedIndex = 2 Then
crvReports.ReportSource = DataAccess.getLevyDirectory & "\L3.rpt"
ElseIf Me.cboReports.SelectedIndex = 3 Then
crvReports.ReportSource = DataAccess.getLevyDirectory & "\4.rpt"
ElseIf Me.cboReports.SelectedIndex = 4 Then
crvReports.ReportSource = DataAccess.getLevyDirectory & "\5.rpt"
ElseIf Me.cboReports.SelectedIndex = 5 Then
crvReports.ReportSource = DataAccess.getLevyDirectory & "\6.rpt"
ElseIf Me.cboReports.SelectedIndex = 6 Then
crvReports.ReportSource = DataAccess.getLevyDirectory & "\7.rpt"

End If


'MsgBox("Please load pre-printed stationary into the printer.")

crvReports.PrintReport()
crvReports.RefreshReport()

MyBase.Cursor = Cursors.Arrow

Catch ex As Exception
MsgBox(ex.Message)
End Try


End Sub


End ClassOpen the report and do verify database and make sure it is pointing to the correct databasesql

Crystal Reports on Web Host

Hi There,

I've built an asp.net application with visual studio 2003. The asp.net application has three crystal reports, they all work fine when i run them on the development machine(my computer) but when I run my program thats on the web I recieve a "Cannot find KeyCodev2.dll or invalid keycode error". Anyway my question is this, the webhost obviously has the .net framework installed, will it ever be possible for my crystal reports to work on the web? Do I need to get my webhost to somehow install crystal reports on the web in order for my reports to work?

Your help would be greatly appreciated.

Thanks.

SimonTry registering that dll and check

Crystal Reports on VB.Net 2003

Is crystal reports XI compatible with VB.Net or is there a specific version forv it? How can I use CR 11 for VB.net?Yes u can use CR XI with visual studio 2003,u can use CRXI Developer version|||Thanks for the reply, but how do I integrate those two and use the runtime design?

I'm using crdev XI.

Thanks~|||u can design reports in CR XI and then call that in VB.Net|||Ahwww ok! now I've figured it out. I used the RDC reference instead of CR for VS.Net. Thanks ~

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 not exporting to Word & Excel

Hi People

I have a unique problem exporting crystal reports to Word and excel.
Its exporting perfectly in the local environment. On the server it wasn't working earlier. Then we installed Ms-office on the server. Now it works only when accessed from some computers.
I don't have a clue as to why the reports are not opening in word and excel when accessed from some computers when they work perfectly on others. The report window simply closes.
(The reports are opening in pdf & crystal from all computers).

Can anyone help me find a solution to this problem.
Thanks!!

cheers
AnandIt could be that the report contains a formula that divides by zero. Crystal will display it, but when exporting the report it will simply be cut off.

Problems on certain machines may be caused by their local settings (date/time or number notation)

Good luck!|||Tell me sir,
How to export the report I try your work in my system .I am getting Invalid
Post back Event :{0} when I trying to export report in Excel using jav a.

why this error is coming ..Still I am unable to export the report in PDF Also.
After the error has gone I wil see your error...

Regards
Naltu|||Hi there,

The same problem i have with crystal reports 8.5 and exporting to excel.
Word / acrobate reader / etc. works fine, but when exporting to excel the report 'crashes'. Drwatson.log file gives me the access violation error c000005 error.

In my report there are no formula's which can be devided by zero (..there are no formulas at all!..).

It doesn't matter if parameter values are filled in or not, it doesn't matter if there is a big selection or a small selection. The crash always comes.

I am using crystal reports 8.5 (including servicepack 3) and connecting to a progress database through the ODBC Merant 3.60 driver.

Can anyone help us?

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 manual

Can anyone help me in finding a good crystal reports 10 manual which gives step by step procedure for creating simple and complex reports. Thanks in advanceI use ISBN 0-07-223166-1 (Crystal Reports 10, the complete reference, published by McGraw-Hill) www.osborne.com

I would suggest trying to check one out at the local library. (if possible) also I have found most of the "SAM'S" publications to be usefull|||I use ISBN 0-07-223166-1 (Crystal Reports 10, the complete reference, published by McGraw-Hill) www.osborne.com

I would suggest trying to check one out at the local library. (if possible) also I have found most of the "SAM'S" publications to be usefull

I have the same book. It's been very helpful.|||I also am looking for a how to book for crystal reports, but I am a total beginner, and was wondering if you would still recommend this book, or if you know of a better book/guide/tutorial type book for beginner's to learn Crystal Reports.

Crystal Reports LIcensing

Hi.

I am trying to establish which version of Crystal Reports I need to use.

I wish to use Crystal Reports within a Visual Basic 6 application. The report(s) will be viewed and printable from the application. I also need to distribute the VB6 application for 5 users.

I understand that in one version, the licensing for runtime requirements changed. I am trying to find out at which version it changed.

I really need to be able to do this with no runtime licensing requirements for the distributable DLLs, OCXs etc.

I have an inclination that it's either version 7, 8 or 8.5 ??

Can anyone please help and advise me as to which version I should be using?

Thanks in advance,
Darren

email: darren@.darrenbrook.fsnet.co.ukIn my Crystal Reports 8.5 book (one I bought from the bookstore, not the users manual), it said something about new licensing in version 8.5. I don't have the book with me right now, but from what I remember, it only involves paying royalties to Crystal if you use the embeddable designer that allows the user to create reports at runtime. I'm also pretty sure that you need to purchase the developer edition in order to distribute it to you clients.

Please keep in mind that this infomation may not be completely accurate, it's just what I remember reading. Your best bet is to contact Crystal and ask them.

Here's Crystal's website:
http://support.businessobjects.com

Crystal Reports- last receipt date

Here is the situation: I have 3 tables.
Table 1: part number, unit of measure, standard cost
Table 2: last price paid, and Date of last price paid (same as last receipt date)
Table 3: PO# of last price paid (same as last receipt date)

When I insert these fields into the details section in Crystal Reports, I get duplicate part numbers listed on the report. Each part number may have several vendors attached to it, so this is expected.

This is what I am getting:

ItemNumber UM Std Cost LastCost LastReceiptDate PONumber
88888 Each 1.00 1.50 7/19/04 11111
88888 Each 1.00 1.80 7/22/04 22222
88888 Each 1.00 2.00 7/20/04 33333

What I want:

ItemNumber UM Std Cost LastCost LastReceiptDate PONumber
88888 Each 1.00 1.80 7/22/04 22222

I want the report to only show the most recent receipt date, price paid, and PO. Basically I need to do some sort of "comparison" between multiple vendors and its last receipt date within each part number.

Please help~~~~ Thank you!Hi,

I had faced same problem but I think if u used Command Object insted of tables
u can get solution.

write SQL query in Command Object and use MAX function on Receipt Date

-Yags

Crystal Reports Landscape printer setup

I'm using crystal reports 4.6, any idea how to setup the report page to landscape setting?Oh no, I know I am not helpful but I think it is really time for an upgrade. There are lots of new, sometimes actually useful features in new versions, lots of old features were enhanced and lots of bugs squashed. Stick to CR8 or CR85 if you want to preserve compatibility with old RPTs, or if you have an application that uses OCX or CRPE. Otherwise, go for CRXI.|||ok thanks. so what other version of CR supports landscape printing?|||Report orientation can be changed via File->Printer Setup menu.
It has been so since (at least) CR6, when I saw Crystal for the first time.

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 in C# - doesnt show data

Hi @.ll,

I'm new to Crystal Reports... using VS 2005 Beta

I need a simple Report from my simple database - one table.
I created a Crystal Reports-Report and used a "Crystal Reports Viewer" in my Winform and everything seems to work.

When my program starts the Report is displayed, the header is displayed but no Detail-Data. That means: My Data isn't displayed.

You might now think: I haven't got any data in my table... But that isn't true, there are 2 datasets in my table...

What should I do?
Is there any Initializing that i haven't done? Why doesn't the Report showing my data automatically?

Thanks for help!

ITSEOpen the database Do verify Database
Uncheck the option "Save Data with Reports"|||Thanks for your answer !

Open the Database with which Program?
In VS 2005 there is the Tool "DataSources" for the Project-DataSources and at the tool for generating CrystalReports there is the "FieldExplorer".

But in none of them is a checkbox "Save Data ..."

Can you please explain where the checkbox is?

Thanks,

cya|||Open the database Do verify Database
Uncheck the option "Save Data with Reports"

I mean open that report and do that not the database|||ok ;-) then I should open the Report. I open it with VS and where is the checkbox? I looked in every dialog I can find, but I think you are using a other program?|||Well
Through coding give
CR.DiscardSavedData=True|||ok I wan't to try it.

In my Project I only got a WinForm, a CrystalReportViewer in it and a CrystalReport. (a "crystalReport1.rpt" File)

Where should I write the "DiscardSavedData"-Thing? I tried to find this Attribute in my classes but couldn't find it.

I know it looks like I'm stupid, but can you or someone show me in which File in which Class I should write your code?

Thanks... Please give me more input not only a simple "one-line" answer... it's really annoying that my Report doesn't work.

To overcome that problem I had to use an Access-Database, create a Access-Report and it worked... It could be sooooo simple...
But why o why... I think I begin to hate the programmers of crystalReports...!!!!

Hope somebody helps me out of this ****.

Thanks

Crystal Reports Images

I am currently using CrystalReports 9.0 and I was wondering if there is a way to make a picture appear if certain parameters are met. For example, if an employee ID = John Smith, a picture appears. I know how to put a picture on a report as well as how to use a blob field, but I can't seem to find a syntax that when a certain parameter is met, the image appears. The image is a system file. Any help would be appreciated! Thank you!Right click on the image field
Goto Format object and in the suppress click x-2 button and write this code

Parametefield="yourvalue"

Crystal Reports help!

I am connecting to an AS400 via ODBC using Crystal Reports 9.0. I have a date that is coming out in a 7 digit number format. I need a formula for Crystal Reports that will convert this to a date format.

For example 1051111 would return 11/11/05.

The formula will have to get rid of the first "1" and put the other numbers in the correct format.

If someone can provide me with this formula and where I need to put it in Crystal Reports V9.0 that would be great.

ThanksSomething like this should do it. Just place it in your detail section.

StringVar ConvertDate := Right (ToText({your_number_field),6 );
StringVar YY := ConvertDate [1 to 2];
StringVar MM := ConvertDate [3 to 4];
StringVar DD := ConvertDate [4 to 5];

DD & "/" & MM & "/" & YY;

Brian
http://www.briankuipers.com|||Thanks alot, that helped a little. Except I told you wrong. The original format actually comes down as 1,051,111.00 with the commas and the decimal point.

When I use your formula it is counting the commas as text. I need a formula that would pull out the commas and decimal points and just use the text string of 1051111 that I originally stated was being used.

Thanks

Crystal reports grouping time stamps by hour

I made a report in crystal reports and its cross tabbed with Times on top, what i need to do is be able to group the times by hour but I have no clue how to do that

right now it looks like this:

8:01 8:11 8:15 8:45 9:15 9:34 and so on

it needs to be like this
8:00 9:00 and so on having everything in the 8-9 range under 8 and 9-10 under 9 and so on

I am using a Ms sql database and taking info from a number field numbers are in the format 800 for 8 oclock 930 for 9 thirty and so on

how would I group them like thisI'm not sure whether this folg is a right solution. but it'll work.

Try to create a formula and check the numeric value. Form a group using code
Like

If {table.field} in [800 to 830] then
1
else if {table.field} in [831 to 900] then
2
etc

Then group the report using this formula. To display the time interval create one more formula. Refer the previous formula here

i.e
if {@.prev} = 1 then
"8.00 - 8.30"
etc

Hope this will work.|||Thanx I will try that out,

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 from VC++

Hi All,

I am creating crystal reports(version 8.5) using VC++ code.
Its working fine on the the machines which have crystal reports installed .
however same is not the case with non crystal machines even after registring the Crystl32.OCX used by the Crystal Reports Object.

I am getting error " Unable to logon to server" while trying to run the report.
DSNs are same on both type of machines.
(one with crystal reports and one without it )

I have already distributed crystal dlls with the application.
(Crystl32.OCX,Craxdrt.dll, CRViewer.dll,CRDesignerCtrl.dll,Craxddrt.dll)

Do I need to do some thing in addition to this ?

kindly help.

thanks
SanjayCoule you please provide me with your code, it helps me build my own app...

Rob

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 for VS 2005

Hi, currently I am using Visual Studio 2005 to create a Crystal reports for my application, when i choose the data source from a list of driver, normally we will use OLE DB Provider for SQL Server,

but I saw other provider in the list, which is SQL Native Client, can I use this instead of OLE DB?Hi johnlim,

Yes, you can use the SQL Native client, but it does involved extra supporting files being inlcuded in your setup project. Basically, I would not use it unless you specifically need to access the SQL MDF/LDF data files directly. This is not normally the case with reporting.
I use the ADO provider. It works well and is supported on lots of forums, like this one.
cheers,
Mark Chimes

Quote:

Originally Posted by johnlim20088

Hi, currently I am using Visual Studio 2005 to create a Crystal reports for my application, when i choose the data source from a list of driver, normally we will use OLE DB Provider for SQL Server,

but I saw other provider in the list, which is SQL Native Client, can I use this instead of OLE DB?

Crystal reports Export problem, asp.net VS2005

Using report viewer on aspx (VS2005) page and calling enterprise crystal report 10 vertion, but when we trying to export using export button to PDF all characters in englisg exporting properly, but Chinese letters are not exporting correctly, exporting like squares, can any one advice what needs to do.

Thanks
Phaneendra.Are Chinese fonts installed on the client and server? Does Crystal or Adobe require a separate or special Chinese fonts install?|||Thanks for response TripperDay,

Using font type PMingLiu for report chinese fields, Yes font type allrady installed in bothe local and UAT machines, it is like

Font Name : MingLiu & PMingLiu (TrueType)
Filename : mingliu.ttc
in C:\WINDOWS\Fonts, but still can't see chinese fonts in PDF,

is there any other way to get correct.

Crystal Reports Export Problem

Hi, Im using crystal reports integrated with visual studio.net 2005. Currently, i have a 3 page report, it shows perfectly in the crystal report viewer, but it has problems when i export it.
When i export to word format, only the first page is exported along with a blank page and when i export to PDF format, total 6 pages are exported 3 being the report pages and 3 being blank pages after each report page. I require to export to word format but i have no idea wats causing this problem...any help will b greatly appreciated...its urgent!You could try exporting to RTF, then open that with word...sql

Crystal Reports Export error 8.5

Our web server was running windows 2000 iis5 for several years including crystal 8.5. We just migrated to windows 2003 iis6 and all applications work great. EXCEPT exporting to PDF with (asp) using crystal reports Session("oRpt").Export.
I installed all SP & hotfixes for exporting and still no luck. Called tech support and they don't support version 8.5 so they would not help me.
Can somebody please help me! I have just 2 applications left that use crystal reports 8.5 and they are well heavily.

This is the error:
Microsoft VBScript runtime error '800a01fb'

An exception occurred: 'Export'Hi Dough,
Just wondering if you ever found a fix to the crystal report export. I am having the exact same issue with Windows Server 2003 / ASP 3.0 / IIS 6.0.

Thanks,
Troye Stonich|||I may have a solution for you to try.

I found it may be necessary to set the Display Progress Dialog to False. Most likely due to security restrictions on the IIS 6 Win2003 server.

Right before the Session Export line, Enter the following line,

Session("oRpt").DisplayProgressDialog = False

This helped me, doing a simple PDF Export (no viewer). Crystal does not present this dispaly in sample ASP they provide, (9.0 and below). For me it was pretty much a trial and error to resolve this issue.

If the above does not work, try the following 4 lines:

Dim strContentType
strContentType = "application/pdf"
Session("oRpt").DisplayProgressDialog = False
Response.ContentType = strContentType

Hope this helps.

Steve|||You guys are GREAT !

Thank you so mutch, i was getting crazy because of this problem :-)

Crystal Reports Exception in ASP.NET

Hi All...!!!
Im new() here :cool:
Well, ive been working on Crystal Reports in ASP.Net (using vb.net). While genrating reports (@. runtime) i encountered few problems... Im not able to make head or tails of these exceptions. Can anyone explain to me wht r these exceptions n y these occur?

1. CrystalDecisions.CrystalReports.Engine.LogOnException: Logon failed.
2. QueryEngineFailure

ThanX in advance...

Regards,
ReiO :Dhi,
freind.
You may not installed crystal report components while installing .NET.
Please reinstall all components.
I hope it will work

regard
RKK|||Try this

remove @. in .net code where u set parameter field

hope this helps you|||i am getting the same error. i have seperately installed the components as said above and still no luck

whats weird is dat it works fine in a windows app bt not asp

y this occurs is beyond human understanding bt losing my job over it is not!

Crystal Reports Exception

Hi,

I'm getting the following exception:

CrystalDecisions.CrystalReports.Engine.LoadSaveReportException: Load report failed.

I'm loading the same report with different data based on user selection from a listbox. This works just fine ordinarily. The user can select an item, view it, close the viewer, load the next, etc.

The exception only occurs after the report has been exported. Doesn't matter what the export format is ... PDF, doc, xls, etc. The only way to regain funtionality is to quit and restart the app.

It can't be that the report is getting locked. I have 4 separate reports, all very similar, but with slight differences. None will load after the export.

Any ideas?

Thanks,
MattMatt,

I am experiencing the same problem. Did you ever resolve your issue?

Eric|||So am I! Did you ever find a solution?

Regards!|||Open the Report and Do verify Database|||And if that dont work then drop the connection and build it again.

Crystal Reports error

Hello: :wave:
I have a C# project which contains a web form, which has a button calling a web page containing a crystalreportviewer, which contains a CrystalReport report; when I call this page through Response.Redirect("WebForm2.aspx"); WebForm2 is not opening, instead it is sending me an error: [Null]Reference Exception: Reference to object does not stated as object's instance.]
Somebody know what is reason of this error?
I'll thank you for your help.
A.L.Hello.
At last I found the way to solve it. Something wrong was in it.
I reinstalled Visual Studio .NET.
Regards.
A.L.
:wave:

Crystal Reports End-User Designer

Does anyone know if Crystal Reports has an end-user designer for .NET?hi,

Do you got any answer? i am also interested for that. Let me know if you got any answers.

Thanks in advance|||I dont think so. Check out here
http://support.businessobjects.com/sql

Crystal Reports E10 and Data warehouse

Hi, there,

Is there anybody here who is working with data warehouse with Crystal Reports as a tool? Would you please share some experience with me?

I used to work with Oracle reports. It seems to me that Crystal needs to bring all the table data back to client before I may link the tables to get query right.

Another question is how to implement the following requirements:
List all the detail account information for all the accounts under firm A.

Here Firm A might have over 100,000 accounts. The fact tables will holds all accounts for all firms data.

In Oracle reports, we can define 2 path query to get the account number for firm A first then get each account detail by using parent child query. How crystal achieve this kind of query ?

Thanks,Design the report using parent and child tables
Group by the report by key column

Crystal Reports driver for SQL Server 2005

I use Crystal Reports with SQL Server 2005. Which driver (ODBC or OLEDB) should be used when connecting Crystal Reports to SQL Server 2005. Business Object support forum has an article (which is old) says to use ODBC. That it is faster than OLEDB. They have a more recent article which state to also use ODBC when upgrading Crystal Reports 8.5 to XI and connecting to SQL Server.

But then I read the OLEDB is the new interface and should be used instead of ODBC which is going away.

Which is preferred for Crystal Reports XI?

ODBC is not going away.

In general, there is no preferred interface - though 3rd party suppliers may have their own good reasons for making recommendations for users of their applications. Both APIs have their strong points. ODBC is the most widely used, but there are places where OLE DB can be a better choice. The choice depends on the needs of the application