Open the link in new window in crystal report

sql-server-2008 crystal-reports sql-server-2008-r2 crystal-reports-xi
user1599392 picture user1599392 · Nov 30, 2012 · Viewed 9.3k times · Source

I have crystal report. There is the column containing the hyperlink. I want whenever click that link that page should open in new window. All this should be done in crystal reports.

Can I get any help?

Answer

Hariharan Anbazhagan picture Hariharan Anbazhagan · Dec 1, 2012

Your Field contains a URL and if you want to make that URL as hyperlink in crystal report, it can be done.

Consider the following sample report, which contains search engine's names and their links

enter image description here

Now your requirement is to open Google by clicking www.google.com.
Right Click the field which you want to make Hyperlink, and select Format Field.
You will get the Format Editor as like the following image. Select Hyperlink tab and select Hyperlink Type as A Website on the Internet
Select the formula field in Hyperlink Information and use your column which has URL in it and save formula. Now press OK and Preview the report.

enter image description here

You could see the link opens when you press the Field. You can also change the font color of the field to show that is a LINK.

EDIT
{link}+'?sWindow=New'
Using '?sWindow=New' after your link may open your link new tab
Try this and get back with your results !

Related questions

Cannot load file or assembly 'crystal decisions.windows.forms,version=13.0.2000.0'

I'm working on windows application. In this I designed Report module. I get error whenever I wanted to view report in Windows 7, Windows XP & Windows Vista, but it works in Windows 8. Following steps I took before deploying setup I …

Read More
How can I get column names from a table in SQL Server?

I want to query the name of all columns of a table. I found how to do this in: Oracle MySQL PostgreSQL But I also need to know: how can this be done in Microsoft SQL Server (2008 in my case)?

Read More
How to Delete using INNER JOIN with SQL Server?

I want to delete using INNER JOIN in SQL Server 2008. But I get this error: Msg 156, Level 15, State 1, Line 15 Incorrect syntax near the keyword 'INNER'. My code: DELETE FROM WorkRecord2 INNER JOIN Employee ON EmployeeRun=EmployeeNo WHERE Company = '1' …

Read More