Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: Hyperlink Functionality Post Reply Post New Topic
Author Message
TONY JOE
Newbie
Newbie


Joined: 13 Jun 2012
Location: United States
Online Status: Offline
Posts: 1
Quote TONY JOE Replybullet Topic: Hyperlink Functionality
    Posted: 13 Jun 2012 at 9:19am
Hello Crystal Guru's,

I am new to Crystal. I am looking for few functionalities in CR 2011. Please help !!

1. Hyperlink - Clicking on a data should open a new report. I am looking something similar to Master - Detail Report.I tried SubReport, but thats not what i need. I am looking for some functionality which is similar to WebI(BOBJ).

2.I have a cross tab report requirment. I know i can build a cross tab report in Report header or Report footer why is it not possible in Detail section? How do i format a report like fonts, colors, backgrounds as i need. I see an option to do horizontal alignment but not vertical alignment.

3. How to create a formulae with where condition. ex.I need a varibale called Q1, so i need to write something like this.
SalesRevenue Where Month IN ('Jan','Feb','Mar') How to implement this.?


IP IP Logged
rkrowland
Senior Member
Senior Member
Avatar

Joined: 20 Dec 2011
Location: England
Online Status: Offline
Posts: 259
Quote rkrowland Replybullet Posted: 13 Jun 2012 at 9:50pm
1: Right click on the field you want to be a clickable link, hyperlink tab, click the X-2 button - the formula editor will now open, in here you can type the link directly if it's a statis link or if you want it to be dynamic based on your records an example of a hyperlink I use follows;
 
"http://shf01-boxi01/businessobjects/Enterprise115/InfoView/Report/viewrpt.aspx?"
+
"init=actx"
+
"&id=11956931"
+
"&Promptex-user=" + """" + {@user} + """"
+
"&Promptex-date=" + """" + {Command.enddate} + """"
 
2: I don't use cross-tab reports as their functionality is pretty limited in my opinion. Someone else maybe able to assist you better there.
 
3: Depends what you want, you can eiether just select records for the quarter so they're the only thing visible in your report or you can group by quarter so you can view multiple quarters in your report? Let me know which you want and I'll help from there.
 
Regards,
Ryan.
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.027 seconds.