index | search | no replies | posting guidelines | help login | register
Index » Products » ASP Report Wizard v2
search this forum:
:: Insert Hyperlink with parameter :: (17)Post a New Message | Post a Reply
Apr 29 2004, 2:09 PM
 Insert Hyperlink with parameter Post a Reply
 Yimei

View this author's profile Send this author a private message

from: Myrtle Creek, OR

id    revenue    expA    expB    expC
71    35.5    16.2    13.1    10.2
6    37.2    15.5    12.1    11
9    29.9    14.4    10.1    4.5

I have a report, would like to link cells under revenue and expA,expB columns to different reports using "Insert Hyperlink" from the field's Text Format, passing parameter from id column.  Since "link to another report" is not available for these fields, I put the url as follow - https://192.168.100.1/ASPReport/ASPReport.asp?rid=cap&rurl1=ind&id=71. cap is the subreport's rid with an user defined parameter ?id in filter.  How do I pass the id paramenter in this URL as a variable?  Thanks.
Yimei

Apr 30 2004, 6:43 AM
 Re: Insert Hyperlink with parameter Post a Reply
 whichman

View this author's profile Send this author a private message Visit author's homepage

from: Laurel, MD

Use #TEMP#

your url might look like this:

https://192.168.100.1/ASPReport/ASPReport.asp?rid=cap&rurl1=ind&id=#TEMP#


-------------------------
Master of the Game
Apr 30 2004, 8:44 AM
 Re: Insert Hyperlink with parameter Post a Reply
 Yimei

View this author's profile Send this author a private message

from: Myrtle Creek, OR

#TEMP# passes the current cell's  value.  But I want to pass the parameter's value from the other column ( id) when revenue cell is clicked.  Any idea?  Thanks.

Apr 30 2004, 4:02 PM
 Re: Insert Hyperlink with parameter Post a Reply
 whichman

View this author's profile Send this author a private message Visit author's homepage

from: Laurel, MD

That functionality just added that as of version 2.0.95.

Use {{FieldName}}

your url might look like this:

https://192.168.100.1/ASPReport/ASPReport.asp?rid=cap&rurl1=ind&id={{ID}}


P/S: If you don't want the ID field to show up simpy set the Text Format to Hidden.







-------------------------
Master of the Game
May 5 2004, 3:10 PM
 Re: Insert Hyperlink with parameter Post a Reply
 Yimei

View this author's profile Send this author a private message

from: Myrtle Creek, OR

1. Applied version 2.0.0.97, now report only shows one record and first 13 fields.  ???
2. Just purchased Single Domain License, how do I get rid of the (Free Version)?


May 5 2004, 3:41 PM
 Re: Insert Hyperlink with parameter Post a Reply
 ghost

View this author's profile Send this author a private message Visit author's homepage

from: Washington, DC

Nothing changed. Just make sure that your tables JOIN relationship is correct. e.g. Suppliers.SupplierID=Products.SupplierID

to get rid of the message, set your license key before your Initialize as follows:

'set your license key
objWiz.LincenseKey = "ABCD-EFGH-IJKL-1234-QERF"
  
objWiz.Init(Connection String)



-------------------------
Ghost
May 5 2004, 4:50 PM
 Re: Insert Hyperlink with parameter Post a Reply
 Yimei

View this author's profile Send this author a private message

from: Myrtle Creek, OR

Report is not changed, but after new dll is copied and registered, only shows aggregated 1st line, and if the view has more than 13 fields, it only display the left 13.  The source is a view, and has not been changed either.  Should I change AWSReportWizard2.dll back to older version?  I have a demo to show and tell reports tomorrow.  Thanks.
Yimei


May 5 2004, 7:36 PM
 Re: Insert Hyperlink with parameter Post a Reply
 ghost

View this author's profile Send this author a private message Visit author's homepage

from: Washington, DC

Can you send me a copy of your view (as text or CSV ) so we can test it and fix the problem.
Send email to

support@aspwebsolution.com
Subject: View fields not showing up






-------------------------
Ghost
May 6 2004, 11:01 AM
 Re: version 2.1.08 releasedPost a Reply
 ghost

View this author's profile Send this author a private message Visit author's homepage

from: Washington, DC

We have just published a new version of the report wizard, version 2.1.08. located at the URL below:
http://www.aspwebsolution.com/products/report_wizard/download.htm
This version features the bug fix of handling NULL values (this is actually why it was crashing at column 13). We hope this fix solves the problem, sorry for the inconvenience.






-------------------------
Ghost
May 18 2004, 3:02 PM
 Re: version 2.1.08 releasedPost a Reply
 Yimei

View this author's profile Send this author a private message

from: Myrtle Creek, OR

Anyway that I can format a field to be currency and insert hyperlink? It would be nice.  Can't seem to do both (to the same column) using DataGrid either.  Thanks for looking into it.

May 19 2004, 6:28 AM
 Re: version 2.1.08 releasedPost a Reply
 ghost

View this author's profile Send this author a private message Visit author's homepage

from: Washington, DC

If you need it, then you get it.
That functionality will be included in the next release scheduled before the end of this week.




-------------------------
Ghost
May 20 2004, 1:01 PM
 Re: version 2.1.08 releasedPost a Reply
 ghost

View this author's profile Send this author a private message Visit author's homepage

from: Washington, DC

This feature has just been added to the new release version 2.1.42
For more information check out this post Version 2.1.42 Released!




-------------------------
Ghost
May 26 2004, 12:22 PM
 Re: Insert Hyperlink with parameter Post a Reply
 Yimei

View this author's profile Send this author a private message

from: Myrtle Creek, OR

When using Insert Hyperlink with #MONEY# (instead of #TEMP#), it displays #MONEY# for that column.  I'm using version 2.1.55.???  
Thanks for the tip on session variable workaround on DataGrid.  I works great!

May 26 2004, 2:41 PM
 Re: Insert Hyperlink with parameter Post a Reply
 ghost

View this author's profile Send this author a private message Visit author's homepage

from: Washington, DC

Mine seems to be working just fine.
Make sure there are no spaces between the # # signs.
Also show me your hyperlink string exactly as it appears in your report.





-------------------------
Ghost
May 27 2004, 8:18 AM
 Re: Insert Hyperlink with parameter Post a Reply
 Yimei

View this author's profile Send this author a private message

from: Myrtle Creek, OR

insert hyperlink -- https://subdomain.mydomain.com/ASPReport/myReport.asp?rid=rptenc&oid={{oid}}
hypertext -- #MONEY#

May 27 2004, 11:18 AM
 Re: Insert Hyperlink with parameter Post a Reply
 ghost

View this author's profile Send this author a private message Visit author's homepage

from: Washington, DC

We are still not able to recreate this bug.
Please send me a sample of your data in text format so that I can test it.

p/s; also try this: add any character after your last '#' character ( #MONEY#X) and see what happens (your vb engine might not be working well)


Regards,


-------------------------
Ghost
Jul 9 2004, 1:45 PM
 Re: Insert Hyperlink with parameter Post a Reply
 Yimei

View this author's profile Send this author a private message

from: Myrtle Creek, OR

The select list used to give me "Percentage: 10%" before (on a numeric field from the asp report wizard).  But now it is not in the select list anymore.  On some other fields, I can still pick Percentage.  Any reason why?

Pages: (1)   [1]

search this forum: