Showing posts with label aspnet. Show all posts
Showing posts with label aspnet. Show all posts

Thursday, March 22, 2012

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 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!

Sunday, February 19, 2012

cross-database query from ASP.NET

How do you write a SQL SELECT statement for a cross-database query in ASP.NET (ADO.NET). I understand the server.database.owner.table structure, but the command runs under a connection. How do I run a query under two connections?You don't need 2 connections. Are your 2 databases on the same server?

If they are on the same server, the syntax would be like this:


SELECT
D1.column1,
D2.column2
FROM
database1.dbo.Table1 D1
INNER JOIN
database2.dbo.Table2 D2 ON D1.ID = D2.ForeignKey

If they are on different servers, the syntax would be like this:


SELECT
D1.column1,
D2.column2
FROM
Server1.database1.dbo.Table1 D1
INNER JOIN
Server2.database2.dbo.Table2 D2 ON D1.ID = D2.ForeignKey

You might encounter this error:Could not find server 'Server2' in sysservers. Execute sp_addlinkedserver to add the server to sysservers. which means that the system stored procedure sp_addlinkedserver would need to be run to allow access to Server2 from Server1. SeeSQL Server Link Server Performance Tips for some information pertaining to linked servers.

Terri