I am bringing a value (which is a link to a product on a external web page and it depends on a product user wants to see) from a database. It's presented in a data box on which user can click and open that web location in a new window. That is working fine.

I have a question about one thing. How to make this field to have a "label" saying "Website" but to keep it to be a link to the page depending on a value that comes from database? In a way to embed a value from a db so the user have a nicer text in front of him (saying something like "Product on the Web", but still to have it running as a link.

Are you using the Hyperlink property? What does the expression look like?

Jason

On 12/14/2011 8:27 AM, nlajka wrote:
> Hi,
>
> I am bringing a value (which is a link to a product on a external web
> page and it depends on a product user wants to see) from a database.
> It's presented in a data box on which user can click and open that web
> location in a new window. That is working fine.
> I have a question about one thing. How to make this field to have a
> "label" saying "Website" but to keep it to be a link to the page
> depending on a value that comes from database? In a way to embed a value
> from a db so the user have a nicer text in front of him (saying
> something like "Product on the Web", but still to have it running as a
> link.
>
> Thanks!

On 12/14/2011 12:38 PM, Jason Weathersby wrote:
> Are you using the Hyperlink property? What does the expression look like?
>
> Jason
>
> On 12/14/2011 8:27 AM, nlajka wrote:
>> Hi,
>>
>> I am bringing a value (which is a link to a product on a external web
>> page and it depends on a product user wants to see) from a database.
>> It's presented in a data box on which user can click and open that web
>> location in a new window. That is working fine.
>> I have a question about one thing. How to make this field to have a
>> "label" saying "Website" but to keep it to be a link to the page
>> depending on a value that comes from database? In a way to embed a value
>> from a db so the user have a nicer text in front of him (saying
>> something like "Product on the Web", but still to have it running as a
>> link.
>>
>> Thanks!
>

I was so embarrassed when I figured it out about my question that I put into my comment

Answer was right there in my question, use label Type URI, and put into Location: row["website"] from dataset that contains the link Type: Blank and voila! You click on a label and it opens it new window, exactly what I need!

First I was trying with text object, but that one doesn't have a hyperlink feature, then I jumped on data object skipping label (thinking that it's simpler than text, how can it have a hyperlink if text doesn't have?) but data object would bring a value from db which would work but I couldn't change the name on it(label). Somehow I went back to label and there it was.... So simple.

As I mentioned before, I am just a starter in BIRT so I need to learn more. Any books that can be found online, since here where I am it's hard to buy or order online? For free, of course

For online info, check birt-exchange.org. There are a lot of examples
and webinars available in the dev share. In the designer, if you select
help-contents you will see the BIRT Report Developer Guide which should
be very helpful. You also may want to follow on the
birtworld.blogspot.com blog.

Jason

On 12/15/2011 3:45 AM, nlajka wrote:
> Hello Jason,
>
> I was so embarrassed when I figured it out about my question that I put
> :blush: into my comment :)
> Answer was right there in my question, use label Type URI, and put into
> Location: row["website"] from dataset that contains the link Type: Blank
> and voila! You click on a label and it opens it new window, exactly what
> I need!
> First I was trying with text object, but that one doesn't have a
> hyperlink feature, then I jumped on data object skipping label (thinking
> that it's simpler than text, how can it have a hyperlink if text doesn't
> have?) but data object would bring a value from db which would work but
> I couldn't change the name on it(label). Somehow I went back to label
> and there it was.... So simple.
>
> As I mentioned before, I am just a starter in BIRT so I need to learn
> more. Any books that can be found online, since here where I am it's
> hard to buy or order online? For free, of course :lol:
> Thank you Jason once again for your help.