Author |
Message |
Takesen
Senior Member
Joined: 29 Dec 2008
Location: United States
Online Status: Offline
Posts: 143
|
Topic: Launch Sub-Report as Field Hyperlink Posted: 29 Jun 2009 at 11:34am |
Does anyone know if it's possible to launch a sub report off of a hyperlink like option?
I have an On Demand subreport. That i would like to be able to have it so
if the field value = "SEE NOTE" then the field has a hyper link. allowing the user to click on "SEE NOTE" and it will generate the sub report.
...I'm not even really sure if this is possible...
-Takesen
|
IP Logged |
|
DBlank
Moderator
Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
|
Posted: 29 Jun 2009 at 12:59pm |
Hey Takesen,
When you say if the field value = "SEE NOTE" are you referencing a field in the mainreport or the subreport? If it is in the mainreport you can conditinally suppress the sub-report on that field or you can use it to conditionally alter the linking field to sever the subreport link (link via a formula field that is altered from original value to a non-linkable value).
If it is a field in the sub-report I think it gets dicier. If possible in the sub-report you can suppress all the field when field value <> "SEE NOTE" then you can suppress the sub-report when it is empty.
IS this where you were headed?
|
IP Logged |
|
Takesen
Senior Member
Joined: 29 Dec 2008
Location: United States
Online Status: Offline
Posts: 143
|
Posted: 29 Jun 2009 at 1:08pm |
Hey Dblank
It's a field in the main-report.
But it's a crosstab report. I was hopeing to be able to launch something more on demand like so it wouldn't disrupt the crosstab report itself.
Ya know?
|
IP Logged |
|
DBlank
Moderator
Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
|
Posted: 29 Jun 2009 at 1:17pm |
So you want the link inside a cell in the crosstab?
|
IP Logged |
|
Takesen
Senior Member
Joined: 29 Dec 2008
Location: United States
Online Status: Offline
Posts: 143
|
Posted: 29 Jun 2009 at 1:44pm |
exactly....
Any ideas? I can't figure it out....
|
IP Logged |
|
DBlank
Moderator
Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
|
Posted: 29 Jun 2009 at 1:51pm |
interesting...
I don't have access to crystal today but maybe setting this up in the rest of the report and then creating it as a MIN or MAX value in the cell. I have never tried it before so I am really guessing at it right now. If you don't have a solution by tomorrow I should be back in the office and can take a look for myself.
|
IP Logged |
|
Takesen
Senior Member
Joined: 29 Dec 2008
Location: United States
Online Status: Offline
Posts: 143
|
Posted: 29 Jun 2009 at 1:57pm |
Alright. See...
I only want it based off where currentfieldvalue = "SEE NOTE" right?
I was thinking about trying some of these hyperlink "Another Report Object" thing.... But.... i can't seem to figure out how the whole object links work....
|
IP Logged |
|
Takesen
Senior Member
Joined: 29 Dec 2008
Location: United States
Online Status: Offline
Posts: 143
|
Posted: 30 Jun 2009 at 11:35am |
Alright... Well i wasn't able to figure out how, but my boss decided to go in a different direction anyway (although if you did figure out a way i would like to know, cuz i've found myself wanting to do something like this for awhile.... on many different situations).
But at any rate... I'm just curious, do any of you know how i could supress a section if the subreport is null?
I have a report footer b with the subreport in it, and it has a page break before so the sub report will come in on a new, and last page.
Does anyone know if i can suppress my RF-b if my subreport is blank?
|
IP Logged |
|
DBlank
Moderator
Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
|
Posted: 30 Jun 2009 at 11:49am |
The sub-report can be set to suppress if blank and then Section RFb can be set to suppress if blank.
Is that what you wanted?
|
IP Logged |
|
Takesen
Senior Member
Joined: 29 Dec 2008
Location: United States
Online Status: Offline
Posts: 143
|
Posted: 30 Jun 2009 at 12:59pm |
Well.... i don't think it'll work.... because there's the page break. there's a new page header and page footer.....
So it's the header with a blank sheet where data would normally go.
I want this page gone, but i'm not really sure how else i could get rid of it
|
IP Logged |
|
|