Crystal Report WEB ASP (hyperlink).. HELPPPPP!

[wolfieman]

Hi everyone!

I am currently building a webreport using the the
RAS SDK from an asp page.

I am trying to make a "dynamic" hyperlink to a website,
for instance what i would like to do is this:

http://server/file.asp?company={table.id}&name={table.name}

But this statement doesnt work in the following code!

I know how to make a "static" link, that is always the same. I do it like this:

Set NewReportObject = ObjectFactory.CreateObject("CrystalReports.FieldObject&quot
With NewReportObject
.Kind = FieldToAdd.Kind
.FieldValueType = FieldToAdd.Type
.DataSource = FieldToAdd.FormulaForm
.Left = left_start
.width = field_size
.format.EnableCanGrow = true

.Format.HyperlinkType = crHyperlinkTypeWebsiteFieldValue
.Format.HyperlinkText = "

http://site/page.asp"

end with

Can anyone PPPLLEASE help me with an example or so..?
Should i do it another way?!!!

Write as soon as possible

Sincerly
Jan Tovgaard

 

[Naith]

What do you mean by "doesn't work"? Give an example of the symptoms of the error, or unexpected behaviour you're experiencing.

 

[wolfieman]

i think i am doing it with a wrong approach!

should i use condition formulas?!! does anyone have examples of thaT?....

what i am getting is no result!


for instance replacing this
.Format.HyperlinkText = "

http://site/page.asp"

with

.Format.HyperlinkText = "

http://server/file.asp?company={table.id}&name={table.name}"

does not give me the current rows table.id!

 

[Naith]

What's the string passing into your URL?

Also, what datatype is your table.id field? It needs to be converted to a string if it isn't already.

Parameters are passed as '...promptex0={Field1}&promptex1={Field2}...', as opposed to the literal strings 'company' and 'name'.

Naith

 

[wolfieman]

Well ... if i write these 2 lines for instance in my
code...

NewReportObject.Format.HyperlinkType = crHyperlinkTypeWebsite

NewReportObject.Format.HyperlinkText = "

http://page.asp?tekst={ftrans.tekst}"

when i run the asp code and see the result in the browser..
then i can click on a field as a http link...

but it will be a link like this:

http://page.asp/?tekst={ftrans.tekst}

which is NOT what i want...

i want it to be for instance:

http://page.asp/?tekst=textofrow1

and..
next row...

http://page.asp/?tekst=textofrow2

so it should change........

 

[pkohl]

Jan - did you ever get this figured out? I would like to incorporate this same functionality in my report and have not figured out how. If you found a solution, I would appreciate it if you would share! Thanks!

 

[Naith]

Whoa. This is pretty old, and it looks like I just left you hanging, Wolfieman. I'm really very sorry about that. I didn't see your response til now.

If you're trying to pass parameter values, use the promptex or prompt commands. (Promptex for preference.)

The syntax would change so that it becomes like this:

"[URL unfurl="true"]http://page.asp&promptex0={ftrans.tekst}"[/URL]

There's a whitepaper on promptex and prompt on the Crystal site.

Naith