sql server reporting services: seperate URL on Concatenated string -- sql server reporting services

RE: seperate URL on Concatenated string

Amarnath
12/19/2006 9:42:04 PM

You cant substring a concatenated string and do a "Action" in a same text
box, What you can do is, to have 3 text boxes and create seperate action. 3
text box can have substring of the concatenated string..

Amarnath

[quoted text, click to view]

Re: seperate URL on Concatenated string

Sue
12/20/2006 5:37:33 AM

Amarnath

Thanks for your response.
But, the problem is I will not know ahead of time as to how many
substrings I would have, there could 1 or 3 or 10.

Is there a way for me to loop through and get the number of substrings
I have and accordingly create the text boxes dynamically?

Would appreciate an answer.

TIA
Sue..

[quoted text, click to view]

Re: seperate URL on Concatenated string

Amarnath
12/20/2006 9:51:01 PM

From the same cell of the table is not possible. But one possibility I can
think of is you can have a subreport in the cell itself. Ie.
create a report with your multiple fields say report2 and create "Actions"
for all the fields you can use matrix as well so that depending on the fields
it expands.
and in your original report say Report1, place this subreport from tool bar
in one of the cells of table and see it works with hyperlinks.

One problem with this is that you cant have 10 fields and I feel that's not
right because you cant expand the breadth of the report.

Try this and let me know.

Amarnath

[quoted text, click to view]

RE: Navigational URL with Field value as Querystring

TuckWong
3/3/2008 9:18:11 AM

Hi all,
Im having problem with navigation URL. I want to pass in a value as a querrysting from a field. Example: http://localhost/myWorld.aspx?planet=Field!Planet.Value.

But when i click the url, it gives me http://localhost/myWorld.aspx?planet=Field!Planet.Value.
and not
http://localhost/myWorld.aspx?planet=3. assuming 3 is from the Field!Planet.value

How can I make the Field value to pass in 3?
Please help ..Thanks

From http://www.developmentnow.com/g/115_2006_12_0_0_867127/seperate-URL-on-Concatenated-string.htm

Posted via DevelopmentNow.com Groups

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server reporting services group.