problems with URL

Hello

When you click on a name in my report you can send a email with the link of the report with the reports parameters for that person

but i have a problem with that
the report parameter consist of several words with spaces between and because of this the link isn't shown correct

anyone have a solution for this, i already tried a lot possibilities

here is the code of the jump to url expression

="mailto:"+Fields!Email.Value + "?subject=Action(s) not completed for "+Fields!ToUsersName.Value + "&body=You have unfinished task(s) %0A%0A Copy the link below into your browser to see your task(s) %0A%0A http%3A//fs-bru-etl01/ReportServer/Pages/ReportViewer.aspx%3F%252freport+1+KD%252fReport3%26rs%3ACommand%3DRender%26Users%3D"+Fields!ToUsersName.Value

So the problem is with Fields!ToUsersName.Value

http://server/ReportServer/Pages/ReportViewer.aspx?%2freport+1+KD%2fReport3&rs:Command=Render&Users=ALAINLA: alain Lannoo

like you see the link stops because of the spaces in the username

Hello Kenny,

See if this works for you.

="mailto:"+Fields!Email.Value + "?subject=Action(s) not completed for "+ Replace(Fields!ToUsersName.Value, " ", "%20") + "&body=You have unfinished task(s) %0A%0A Copy the link below into your browser to see your task(s) %0A%0A http%3A//fs-bru-etl01/ReportServer/Pages/ReportViewer.aspx%3F%252freport+1+KD%252fReport3%26rs%3ACommand%3DRender%26Users%3D"+Fields!ToUsersName.Value

Hope this helps.

Jarret

|||

Sorry, this one...

="mailto:"+Fields!Email.Value + "?subject=Action(s) not completed for "+ Fields!ToUsersName.Value + "&body=You have unfinished task(s) %0A%0A Copy the link below into your browser to see your task(s) %0A%0A http%3A//fs-bru-etl01/ReportServer/Pages/ReportViewer.aspx%3F%252freport+1+KD%252fReport3%26rs%3ACommand%3DRender%26Users%3D"+Replace(Fields!ToUsersName.Value, " ", "%20")

Hope this helps.

Jarret

|||

thanks for the reply
but it doesn't work

does anyone else have an other suggestion?

|||

It may not work if you have a sequence of spaces, I mean more than one space (continuously) in your field value. You can use this expression to achieve just 1 space:

IIf(InStr(Replace(<yourfield>, Space(2), "&"), "& ") > 0, Replace(Replace(<yourfield>, "&", ""), Space(1), "%20"), Replace(<yourfield>, Space(1), "%20"))

Hope this helps.

Shyam

|||

I just tried it with parameters with more than one space and more than one consecutive space, and it worked fine for me.

I think the issue may be with your link. Can you try this in an IE window:

http://fs-bru-etl01/ReportServer/Pages/ReportViewer.aspx?%2freport+1+KD%2fReport3&rs:Command=Render&Users=ALAINLA:%20alain%20Lannoo

Does this work? If so, try this just to get the link. This is how I have it in my successful test, the only difference is your servername, report path, and report name.

="http://fs-bru-etl01/ReportServer/Pages/ReportViewer.aspx?%2freport+1+KD%2fReport3&rs:Command=Render&Users="+Replace(Fields!ToUsersName.Value, " ", "%20")

Once you get this working, go back and add your mailto code. If this doesn't work, can you post an example of a link that is generated?

Jarret

|||

Kenny,

In Internet Explorer, go to Tools -> Internet Options -> Advanced Tab and check if "Always send URLs as UTF-8" is checked?

Shyam

problems with report

Hello,

I have a report in Matrix form. Now i need a report in a way that when i click on any item in my column ,another report should be generated with all the data related to it.

For example below is a matrix report

A B C

X x1 x2 x3

Y y1 y2 y3

Z z1 z2 z3

Now when i click on 'X' i need a report with data x1,x2,x3 .

So my question is how do i do that. Should i create another report with with this data and just link it or can i dynamically create a report by clicking on X or Y or Z .

This matrix report takes parameters of startdate and enddate so i need to pass those to the report produced by clicking on X or Y or Z.

Please help me out with this

Thank you,

I do not know if this is the correct way to go about it but I am thinking that you could create the other report as you mentioned, then use the "Jump to report" to jump to the other report when it is clicked on.|||thx for the reply kimberly. But how do i handle the parameters. The matrix report is generated for a date range for example 'jan 1st 2005' to 'dec 31 2005". when i click on X and suppose i created another report and apply the 'jump to' property can i pass this start and end date parameters to that report so that i get X report form 'jan 1st 2005' and 'dec 31 2005' which out entering the parameters again.|||I tried it and it seemed to work. Properties of text box that you want it to work on when clicked-Navigation-Jump to report-(ReportName) and then it gives you the option to set the parameters- on the value side-go in to expression- pick parameters and you will see the parameters that you are using in the first report- that should feed the parameters chosen in the first report in to the second. (there may be an easier way for what you want to achieve)|||

Thx kim, its working now.

thx for ur help

|||You are welcome. I'm glad that it helped. There probably was an easier way, but I'm not sure how else to do it.

Problems with installing SQL Server 2000

I am trying to install SQL Server 2000 from the MSDN DVDs on Windows Server 2003 Web Edition.

When I click on Install Database Server, the "Created with Demoshield" box comes up and then disappears. Nothing else happens. I have also tried to install by running from ENT\x86\SETUP\SETUPSQL.EXE. This gives me a message saying "Windows cannot open this program since it has been disabled".

I tried a Google search for that error message, and found two results, this at http://dbforums.com/arch/4/2003/9/925380 :

"hi,

Try installing as an administrator."

I am trying to install as an administrator.

The other was in German, but was only a list of error codes anyway.

Does anyone know how I can get this to work? I am supposed to have IIS6 up and running before my boss gets back on Monday, and I can't even get SQL installed, which is a prerequisite for IIS.

ANY help would be greatly appreciated.You are going to need Standard or Enterprise version of Windows 2003 Server... Web Edition is exactly that, a stripped down version for web server use, not for application server use (such as SQL Server)

http://www.microsoft.com/sql/evaluation/sysreqs/2000/default.asp

only thing you can run on the Web Edition is MSDE

also... SQL Server shouldn't be a prerequisite for IIS... unless you have an application that requires IIS AND SQL Server, it is not a requirement for IIS alone|||Thanks, I will do that.