Geting the report url

Hello.

Is there a way in a report to get his url?

I'll explain what i want to do: I want to add an option to export the report to excel format with out useing the menu so i want to add a button (or a table cell) and give him,in the nevigation field, the same url of the rreport with the same parameters but add to him the command "rs:format=excel" and then by pressing the button it will automaticly export my report.

Thanks.I thought it was an easy one :)

If my question is not clear enough, please let me know.

Thanks.|||

Craft a URL like this:

http://localhost/reportserver?/ReportProject1/Report&rs:Command=Render&rs:Format=EXCEL

Documented at http://msdn2.microsoft.com/en-us/library/ms153586.aspx.

Thanks, Donovan

Geting report url inside the report

Hello.
Is there a way in a report to get his url?
I'll explain what i want to do: I want to add an option to export the report to excel format with out useing the menu so i want to add a button (or a table cell) and give him,in the nevigation field, the same url of the rreport with the same parameters but add to him the command "rs:format=excel" and then by pressing the button it will automaticly export my report.
Thanks
From http://www.developmentnow.com/g/115_0_0_0_0_0/sql-server-reporting-services.ht
Posted via DevelopmentNow.com Group
http://www.developmentnow.comi was sure this is an easy one :)
if my question wasn't clear enough, please let me know.
Thanks in advance/

GetImage=8.00.878.00f1_rsc_htmlviewer.html

Hi
I am trying to get the HTML viewer help file to appear. When I click the
help icon I go get a new window with the URL
http://myserver1/ReportServer?rs:Command=Get&rc:GetImage=8.00.878.00f1_rsc_htmlviewer.htm
which is blank ( file exixts on the server )
when I goto another server
http://myserver2/ReportServer?rs:Command=Get&rc:GetImage=8.00.878.00f1_rsc_htmlviewer.htm
the file pops right up.
I have changed some of the report renderings on both servers 1 & 2
( Identical changes ).
THere is no documentation that really helps here ( especially if 8.00.878.00
is getting the english language version)
Do I have to set some language setting in RS ?
TIA
Ray
--
Illusion is the first of all pleasures.I can't really think of a reason why you would not see the file. Here are
some things you can try:
Try a ctrl-F5 refresh, the help page is set to live on the client for 30
days, perhaps the client copy is corrupt.
Ensure each language folder has the help file and that they are not blank.
As for the language, RS will query the browser language and select the help
file based on that. If the language is not supported then you should get
English.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"punchcardRay" <punchcardRay@.discussions.microsoft.com> wrote in message
news:42B3F70D-1383-4789-8CF1-9091C20DAFC7@.microsoft.com...
> Hi
> I am trying to get the HTML viewer help file to appear. When I click the
> help icon I go get a new window with the URL
>
http://myserver1/ReportServer?rs:Command=Get&rc:GetImage=8.00.878.00f1_rsc_htmlviewer.htm
> which is blank ( file exixts on the server )
> when I goto another server
>
http://myserver2/ReportServer?rs:Command=Get&rc:GetImage=8.00.878.00f1_rsc_htmlviewer.htm
> the file pops right up.
> I have changed some of the report renderings on both servers 1 & 2
> ( Identical changes ).
> THere is no documentation that really helps here ( especially if
8.00.878.00
> is getting the english language version)
> Do I have to set some language setting in RS ?
> TIA
> Ray
>
> --
> Illusion is the first of all pleasures.|||Daniel
I did the refresh with no luck, I also checked to make sure the files were
there and they were. I have seen two other posts that were basically the same
as mine, is this issue on a defect list ?
Ray
"Daniel Reib [MSFT]" wrote:
> I can't really think of a reason why you would not see the file. Here are
> some things you can try:
> Try a ctrl-F5 refresh, the help page is set to live on the client for 30
> days, perhaps the client copy is corrupt.
> Ensure each language folder has the help file and that they are not blank.
> As for the language, RS will query the browser language and select the help
> file based on that. If the language is not supported then you should get
> English.
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "punchcardRay" <punchcardRay@.discussions.microsoft.com> wrote in message
> news:42B3F70D-1383-4789-8CF1-9091C20DAFC7@.microsoft.com...
> > Hi
> > I am trying to get the HTML viewer help file to appear. When I click the
> > help icon I go get a new window with the URL
> >
> http://myserver1/ReportServer?rs:Command=Get&rc:GetImage=8.00.878.00f1_rsc_htmlviewer.htm
> > which is blank ( file exixts on the server )
> > when I goto another server
> >
> http://myserver2/ReportServer?rs:Command=Get&rc:GetImage=8.00.878.00f1_rsc_htmlviewer.htm
> > the file pops right up.
> >
> > I have changed some of the report renderings on both servers 1 & 2
> > ( Identical changes ).
> > THere is no documentation that really helps here ( especially if
> 8.00.878.00
> > is getting the english language version)
> > Do I have to set some language setting in RS ?
> >
> > TIA
> > Ray
> >
> >
> >
> > --
> > Illusion is the first of all pleasures.
>
>|||I'm not sure what would cause this behavior. I will investigate this
further and see if I can come up with a resolution.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"punchcardRay" <punchcardRay@.discussions.microsoft.com> wrote in message
news:65BA2102-916C-4879-A99D-EFA6DD59E7F0@.microsoft.com...
> Daniel
> I did the refresh with no luck, I also checked to make sure the files were
> there and they were. I have seen two other posts that were basically the
same
> as mine, is this issue on a defect list ?
> Ray
>
> "Daniel Reib [MSFT]" wrote:
> > I can't really think of a reason why you would not see the file. Here
are
> > some things you can try:
> >
> > Try a ctrl-F5 refresh, the help page is set to live on the client for 30
> > days, perhaps the client copy is corrupt.
> >
> > Ensure each language folder has the help file and that they are not
blank.
> >
> > As for the language, RS will query the browser language and select the
help
> > file based on that. If the language is not supported then you should
get
> > English.
> >
> > --
> > -Daniel
> > This posting is provided "AS IS" with no warranties, and confers no
rights.
> >
> >
> > "punchcardRay" <punchcardRay@.discussions.microsoft.com> wrote in message
> > news:42B3F70D-1383-4789-8CF1-9091C20DAFC7@.microsoft.com...
> > > Hi
> > > I am trying to get the HTML viewer help file to appear. When I click
the
> > > help icon I go get a new window with the URL
> > >
> >
http://myserver1/ReportServer?rs:Command=Get&rc:GetImage=8.00.878.00f1_rsc_htmlviewer.htm
> > > which is blank ( file exixts on the server )
> > > when I goto another server
> > >
> >
http://myserver2/ReportServer?rs:Command=Get&rc:GetImage=8.00.878.00f1_rsc_htmlviewer.htm
> > > the file pops right up.
> > >
> > > I have changed some of the report renderings on both servers 1 & 2
> > > ( Identical changes ).
> > > THere is no documentation that really helps here ( especially if
> > 8.00.878.00
> > > is getting the english language version)
> > > Do I have to set some language setting in RS ?
> > >
> > > TIA
> > > Ray
> > >
> > >
> > >
> > > --
> > > Illusion is the first of all pleasures.
> >
> >
> >sql

Get value from Report

There is a textbox property where I can set the Jump to URL value equal to
any field from the report. I currently have a windows application with an IE
web control embedded in the windows form. How can I get the value of a
selected field in the report outside of reporting services? Is it possible to
create a web service and pass the value over to it and retrieve it that way
or is there a better way to do this? Thanks for any input.I am not sure what you want to do here. If you want the value of a
selected field from your app to be passed to a report you can pass it
as a parameter to the report.
if you want a value from the report to be passed into your app then you
can pass the value from your report into a custom assembly, which you
can use in your app.|||I would like the value passed from the report to the calling app. Can you
point me to any examples (preferably c#) re. passing values from report into
a custom assembly? Thanks.
"RN" wrote:
> I am not sure what you want to do here. If you want the value of a
> selected field from your app to be passed to a report you can pass it
> as a parameter to the report.
> if you want a value from the report to be passed into your app then you
> can pass the value from your report into a custom assembly, which you
> can use in your app.
>|||The custom assembly would be a C# project with a method in it that
accepts the value you want to pass to your app, which you can save in a
global variable or collection and use in your app. Please refer to
Custom Assemblies in books online for information about how to
reference this assembly in your report and how to call methods in it.
El Presidente wrote:
> I would like the value passed from the report to the calling app.
Can you
> point me to any examples (preferably c#) re. passing values from
report into
> a custom assembly? Thanks.
> "RN" wrote:
> > I am not sure what you want to do here. If you want the value of a
> > selected field from your app to be passed to a report you can pass
it
> > as a parameter to the report.
> > if you want a value from the report to be passed into your app then
you
> > can pass the value from your report into a custom assembly, which
you
> > can use in your app.
> >
> >

Get the User Name for a login user

Hi Guys,

How can I get the current loged in UserName in windows in MSSQL?

The problem is:

Users login into their PC (Windows Login)Enter a URL of the intranet applicationThey would then be able to access the web base application (Intranet)The web application has a string connection to make a connection to the databaseI want to have a Trigger for my "products" table so if the table is modified (Insert/Update) all those changes be entered in "products_Audit" tableNow on "products_Audit" table I have a field "ChangedBy" where I want to store the windows loged in User Name (SYSTEM_USER just return the Username for the SQL connection that the web application use)

I would really appreciate all your help and suggestions.

Regards,
Mehdi

Hello,

In case of IntraNet where directory security does not allow anonymous users, then you can retrieve domain user information.

dim user as string = Request.ServerVariables("LOGON_USER")

and pass this variable for your database action query.

get the search term from a URL for reporting purpose

Hi guys,

I have a field called URL in my table. I want to get the SEARCH TERM from a given URL and create a report based on that information. I'm getting difficulties, because the URL have different format depending up on the search engine
that the users use to browse. Some of the search engines are "google",".excite.com", "search.msn.","search.netscape", "search.lycos", "altavista", "search.yahoo" and many more.

Examples of the URLs from google :

http://www.google.com/search?q=S26+Collet+Chuck&hl=en&client=firefox-a&rls=org.mozilla:en-USfficial&start=30&sa=N -- The search term is S26 Collet Chuck
http://www.google.com/search?sourceid=navclient&ie=UTF-8&rls=GGLG,GGLG:2006-02,GGLG:en&q=kt21+kia -- The search term is kt21 kia
http://www.google.com/search?hl=en&q=Slagger+burning+Tables -- The search term is Slagger burning Tables

Does anybody have a sql query or used a CLR functions to get the SEARCH TERM from different search engine (URL).

Thanks in advance.

Here is a blog entry from Chrissy LeMaire that seems to do what you want in both C# and straight SQL:

http://blog.netnerds.net/2007/02/mssql-parse-search-engine-querystrings-for-search-terms/

Larry

|||

10Q Larry, that's what exactly I was looking for.

get the search term from a URL

Hi guys,

I have a field called URL in my table. I want to get the SEARCH TERM from a given URL. I'm getting difficulties, because the URL have different format depending up on the search engine
that the users use to browse. Some of the search engines are "google",".excite.com", "search.msn.","search.netscape", "search.lycos", "altavista", "search.yahoo" and many more.

Examples of the URLs from google :

http://www.google.com/search?q=S26+Collet+Chuck&hl=en&client=firefox-a&rls=org.mozilla:en-USfficial&start=30&sa=N -- The search term is S26 Collet Chuck
http://www.google.com/search?sourceid=navclient&ie=UTF-8&rls=GGLG,GGLG:2006-02,GGLG:en&q=kt21+kia -- The search term is kt21 kia
http://www.google.com/search?hl=en&q=Slagger+burning+Tables -- The search term is Slagger burning Tables

Does anybody have a sql query to get the SEARCH TERM from different search engine (URL).

Thanks in advance.

Sounds like a fairly tricky piece of work that.

All i can really add is that as it's essentially string parsing, you'd be best doing this outside of T-SQL either in your app code or in a CLR function.

|||

RegX (Regular Expressions) is your FRIEND in situations like this.

You really, really want to do this in application code using RegX. It is so much more efficient!!!

If absolutely necessary, you could create a CLR function (in VB or C#), using RegX, and add that CLR function to your server. You could then call it from SQL code.