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

Hi All

I am using crystal reports 10 for designing my reports and i am using commands to generate reports. I am using crystal enterprise for showing my reports. When i export my report to crystal enterprise and try to run it it fails with the below exception

Error Message: Unable to connect: incorrect log on parameters. File D:\Program Files\Crystal Decisions\Enterprise 10\Data\procSched\BPSAPPDEV1.reportjobserver\~tmp1bb442fbdc87cd0.rpt.

If i do not use command and use individual tables to generate report it runs fine. Only if i use command it fails. Even if i try giving database information once again it fails.

we are using db2 as database. Is there any solution to avoid this problem?

Thanks in advanceHello,

R u using subreports in ur report...If so u have to provide database information to those reports also...

I gave a small code in my last post of how to provide the Logon information to the subreports also..

regards,
Kolluru.|||I am not using any subreports. I am having this problem for any simple report that uses a command instead of tables. When i export a report to enterprise and try to run it, it gives error.sql

Crystal Report Database Path question

VB 6 Enterprise Edition; Crystal Report XI Developer Edition

I don't understand, did I phrase my previous question wrong?

Let me restate it:

From a VB 6 application, how do you code to tell Crystal Reports where the database tables are located?

This is the code I use to get the report(s)
Set craxreport = craxapp.OpenReport(App.Path & "\" & ReportName)
craxreport.DiscardSavedData
CrystalActiveXReportViewer1.Refresh
CrystalActiveXReportViewer1.ReportSource = craxreport
CrystalActiveXReportViewer1.ViewReport
Set craxreport = Nothing
SamProblem Resolved:
Here is the code in case anyone needs it:

Dim dbTable As CRAXDDRT.DatabaseTable
Set dbTable = craxreport.Database.Tables(1)
craxreport.DiscardSavedData
dbTable.Location = App.Path & "\BOM.mdb"
CrystalActiveXReportViewer1.Refresh
Call CrystalActiveXReportViewer1_RefreshButtonClicked(True)
CrystalActiveXReportViewer1.ReportSource = craxreport
CrystalActiveXReportViewer1.ViewReport
Set craxreport = Nothing

Crystal Enterprise Question

Hello,

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

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

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

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

Crystal Enterprise and massive report distribution to multiple destinations?

Hi,
Before we have used Oracle Reports for our application.
Now, customer wants to move to Crystal Reports.
The Oracle Report Server provided a great and rather simple interface for printing many reports in short time and sending them to multiple destination.
So, we had a function to run report and provided report definition file (.rpt for crystal reports), a destination (printer, mail(s), pdf, etc.) and some auth information as parameters and started distribution easily.
Does Crystal Reports or Crystal Enterprise provides such an interface?!
I've looked into the documentation yesterday and this morning but couldn't find anything simple and appropriate. I see there's Report Job Server and Page Job Server, which I assume provide some kind of queueing, but what is the interface to these servers? Is it simple and easy to use for massive report distribution to different locations?
I'm not interested in preview at all. Just need a lot of 'End of day' reports to printer and to files/emails. Also, I would like to have a central reporting service in my application which would forward print requests to report server and I don't need to use UI controls in my clients (Win and Web Forms). I would like that clients only send the report, auth and destination details and that the central reporting service forward the request to report job server.
How can Crystal Reports/Enterprise help me?Enterprise is a WEB based report server
You can schedule as many reports you want, with different scope fo each of them.
You can add all your user to the enterprise server and decide if they can only view, generate, schedule reports they can access.
You can use Windows authentication or Enterprise authentication, create group, assign privileges per group ( in fact by objects... user, report, group, viewver, scheduler...)

ask your nearest dealer to show you an installed application, I think that's the best...

Luc

Crystal Enterprise 10 - Issue

Hi

Can any one help us to slove the below problems. It is very critical
because all our outlets are having win98 deskstop which is not able
to download activex viewer from CE10 Server (Which is running in Solaris).

If we connect to CE10 from win98 desktop using Explorer 6.0, it is pop up
the message saying that download Crystal Activex Control yes or no. After
pressing Yes button it's waiting for 2/3 mint then throwing out the error
as follows;

THE CRYSTAL REPORT VIEWER IS UNABLE TO CREATE IT'S RESOURCE OBJECTS.

Please let us to know how to slove this problems or we need to apply any
hotfix for this.

Thanks in advance.

Regards,
sashiv.I'm not sure about Crystal Enterprise 10, but Crystal Reports 10 doesn't run on Win98. Check out the minimun installation requirements for the operating systems that Crystal Enterprise 10 does support to see if it does support Win98. This link will take you to the web page where Crystal has their system requirements; http://www.businessobjects.com/products/reporting/crystalreports/sysreq.asp. Hope this helps.

CROSS APPLY doesn't work in some databases

I've run across a weird error trying to use CROSS APPLY. Running SQL2005SP2 developer edition on XP2 (but same error occurs on Enterprise running on W2K3).

A simple CROSS APPLY always works when run from master, but doesn't work when run from most (but not all) of my other user databases. I can't figure out what could be causing the error, or is there some reason it would only work when the current database is master?

Here is the simplest testcase I can come up with:
select a.spid,b.text from master..sysprocesses a cross apply ::fn_get_sql(a.sql_handle) b

If this is run while the current database is master, it returns spid and SQL without a problem. If it's run in the other SQL-delivered databases (model, msdb, tempb), it also works fine. However, if it's run in all but one of the user databases, I get back an error:
Msg 102, Level 15, State 1, Line 1
Incorrect syntax near 'a'.

I'm stumped on how to troubleshoot this. There is no difference in the query; the only difference is the current database. The databases are all owned by sa. I get the same results with sys.sysprocesses instead of master..sysprocesses.

As another datapoint, the employee/department example in the BOL for CROSS APPLY exhibits the same behavior; it works fine if run with master as the current database (regardless of where the tables are created), it fails with
Msg 102, Level 15, State 1, Line 3
Incorrect syntax near '.'.
if run from one of the other user databases.

Any ideas on what could be wrong?

Thanks,

Vince
Sorry to reply in my own thread, but I found the problem. I took drastic measures and created a new, empty database, then deleted all objects out of one of the ones that didn't work. The new one worked, the old one didn't.

Then I started looking at every dialog in SMSS for each database. The difference (which everyone else has probably figured out already) was the compatability level. The old databases were created with 80, the new ones had 90.

My apologies for the noise.
|||Actually, it wasn't necessary to drop these databases - there is a special stored proc to change their compatibility level:

exec sp_dbcmptlevel MyOldDB, 90