Parsing web URL's in SQL

Hello everyone,
I was wondering if anyone could help me out. Basically I have several
sharepoint sites for applications that I run. Each applications
sharepoint site needs to display information about the application
that is located in a SQL database. So for example:
www.qwerty.com/application1/home.html
www.qwerty.com/application2/home.html
www.qwerty.com/application3/home.html
I need to find a way that SQL, Sharepoint, some code, would take the
web address, parse, and truncate it to only read "Application1."
Then I could write a SQL statement to get the data from Application1's
database to display on the sharepoint site. However I have several
application pages, and I would like to be able to have some type of
code that would automatically do it for all the applications, instead
of manually coding/quiering for the data for each application
page.....it would just take too long.
if anyone has any ideas, feel free to share. Thank you in advance, for
all your time and help it is greatly appreciated!
--A4orce84
If the part you want is always the next to last section, then this
would appear to provide what is needed. A bit convoluted though!
CREATE TABLE Demo (url varchar(100) not null)
INSERT Demo values ('www.qwerty.com/application1/home.html')
INSERT Demo values ('www.qwerty.com/application2/home.html')
INSERT Demo values ('www.qwerty.com/application3/home.html')
INSERT Demo values ('www.qwerty.com/whatever/banana/987.htm')
SELECT REVERSE(
SUBSTRING(REVERSE(url),
charindex('/', REVERSE(url)) +1,
charindex('/', REVERSE(url), charindex('/',
REVERSE(url)) + 1) -
charindex('/', REVERSE(url)) - 1))
FROM Demo
application1
application2
application3
banana
Roy Harvey
Beacon Falls, CT
On Fri, 08 Jun 2007 09:01:28 -0700, Asif_Ahmad@.dell.com wrote:

>Hello everyone,
>I was wondering if anyone could help me out. Basically I have several
>sharepoint sites for applications that I run. Each applications
>sharepoint site needs to display information about the application
>that is located in a SQL database. So for example:
>www.qwerty.com/application1/home.html
>www.qwerty.com/application2/home.html
>www.qwerty.com/application3/home.html
>I need to find a way that SQL, Sharepoint, some code, would take the
>web address, parse, and truncate it to only read "Application1."
>Then I could write a SQL statement to get the data from Application1's
>database to display on the sharepoint site. However I have several
>application pages, and I would like to be able to have some type of
>code that would automatically do it for all the applications, instead
>of manually coding/quiering for the data for each application
>page.....it would just take too long.
>if anyone has any ideas, feel free to share. Thank you in advance, for
>all your time and help it is greatly appreciated!
>--A4orce84
|||Ron,
Is this if you only know the number of applications you have? I think
there are several hundred I am using particularly. It also appears
from your code that you have to enter the physical address into the
code by your:
INSERT Demo values ('www.qwerty.com/application1/home.html')
INSERT Demo values ('www.qwerty.com/application2/home.html')
INSERT Demo values ('www.qwerty.com/application3/home.html')
INSERT Demo values ('www.qwerty.com/whatever/banana/987.htm')
I wanted a way that it would do it automatically, that way if servers
change and things get moved around, or they add more applications it
would be easy to keep maintaining the SQL. Or I may have completely
mis-interpreted your code, either way thank you for your help. Any
additional information you could provide would be helpful!
|||I assumed that the URLs you needed to parse would already be in a SQL
Server database table. (Why else would you be trying to parse a URL
in SQL Server?) So my CREATE TABLE and INSERT statements were simply
there to create some test data for demonstration purposes. The number
of URLs in your table is irrelevant to the parsing process.
What I intended to demonstrate was a way to pick out the next to last
section of the URL, which was what I thought you were aiming for. I
believe the code provided does that.
Good luck!
Roy Harvey
Beacon Falls, CT
On Sun, 10 Jun 2007 15:04:14 -0700, Asif_Ahmad@.dell.com wrote:

>Ron,
>Is this if you only know the number of applications you have? I think
>there are several hundred I am using particularly. It also appears
>from your code that you have to enter the physical address into the
>code by your:
>
>INSERT Demo values ('www.qwerty.com/application1/home.html')
>INSERT Demo values ('www.qwerty.com/application2/home.html')
>INSERT Demo values ('www.qwerty.com/application3/home.html')
>INSERT Demo values ('www.qwerty.com/whatever/banana/987.htm')
>
>I wanted a way that it would do it automatically, that way if servers
>change and things get moved around, or they add more applications it
>would be easy to keep maintaining the SQL. Or I may have completely
>mis-interpreted your code, either way thank you for your help. Any
>additional information you could provide would be helpful!

Parsing web URL's in SQL

Hello everyone,
I was wondering if anyone could help me out. Basically I have several
sharepoint sites for applications that I run. Each applications
sharepoint site needs to display information about the application
that is located in a SQL database. So for example:
www.qwerty.com/application1/home.html
www.qwerty.com/application2/home.html
www.qwerty.com/application3/home.html
I need to find a way that SQL, Sharepoint, some code, would take the
web address, parse, and truncate it to only read "Application1."
Then I could write a SQL statement to get the data from Application1's
database to display on the sharepoint site. However I have several
application pages, and I would like to be able to have some type of
code that would automatically do it for all the applications, instead
of manually coding/quiering for the data for each application
page.....it would just take too long.
if anyone has any ideas, feel free to share. Thank you in advance, for
all your time and help it is greatly appreciated!
--A4orce84If the part you want is always the next to last section, then this
would appear to provide what is needed. A bit convoluted though!
CREATE TABLE Demo (url varchar(100) not null)
INSERT Demo values ('www.qwerty.com/application1/home.html')
INSERT Demo values ('www.qwerty.com/application2/home.html')
INSERT Demo values ('www.qwerty.com/application3/home.html')
INSERT Demo values ('www.qwerty.com/whatever/banana/987.htm')
SELECT REVERSE(
SUBSTRING(REVERSE(url),
charindex('/', REVERSE(url)) +1,
charindex('/', REVERSE(url), charindex('/',
REVERSE(url)) + 1) -
charindex('/', REVERSE(url)) - 1))
FROM Demo
--
application1
application2
application3
banana
Roy Harvey
Beacon Falls, CT
On Fri, 08 Jun 2007 09:01:28 -0700, Asif_Ahmad@.dell.com wrote:
>Hello everyone,
>I was wondering if anyone could help me out. Basically I have several
>sharepoint sites for applications that I run. Each applications
>sharepoint site needs to display information about the application
>that is located in a SQL database. So for example:
>www.qwerty.com/application1/home.html
>www.qwerty.com/application2/home.html
>www.qwerty.com/application3/home.html
>I need to find a way that SQL, Sharepoint, some code, would take the
>web address, parse, and truncate it to only read "Application1."
>Then I could write a SQL statement to get the data from Application1's
>database to display on the sharepoint site. However I have several
>application pages, and I would like to be able to have some type of
>code that would automatically do it for all the applications, instead
>of manually coding/quiering for the data for each application
>page.....it would just take too long.
>if anyone has any ideas, feel free to share. Thank you in advance, for
>all your time and help it is greatly appreciated!
>--A4orce84|||Ron,
Is this if you only know the number of applications you have? I think
there are several hundred I am using particularly. It also appears
from your code that you have to enter the physical address into the
code by your:
INSERT Demo values ('www.qwerty.com/application1/home.html')
INSERT Demo values ('www.qwerty.com/application2/home.html')
INSERT Demo values ('www.qwerty.com/application3/home.html')
INSERT Demo values ('www.qwerty.com/whatever/banana/987.htm')
I wanted a way that it would do it automatically, that way if servers
change and things get moved around, or they add more applications it
would be easy to keep maintaining the SQL. Or I may have completely
mis-interpreted your code, either way thank you for your help. Any
additional information you could provide would be helpful!|||I assumed that the URLs you needed to parse would already be in a SQL
Server database table. (Why else would you be trying to parse a URL
in SQL Server?) So my CREATE TABLE and INSERT statements were simply
there to create some test data for demonstration purposes. The number
of URLs in your table is irrelevant to the parsing process.
What I intended to demonstrate was a way to pick out the next to last
section of the URL, which was what I thought you were aiming for. I
believe the code provided does that.
Good luck!
Roy Harvey
Beacon Falls, CT
On Sun, 10 Jun 2007 15:04:14 -0700, Asif_Ahmad@.dell.com wrote:
>Ron,
>Is this if you only know the number of applications you have? I think
>there are several hundred I am using particularly. It also appears
>from your code that you have to enter the physical address into the
>code by your:
>
>INSERT Demo values ('www.qwerty.com/application1/home.html')
>INSERT Demo values ('www.qwerty.com/application2/home.html')
>INSERT Demo values ('www.qwerty.com/application3/home.html')
>INSERT Demo values ('www.qwerty.com/whatever/banana/987.htm')
>
>I wanted a way that it would do it automatically, that way if servers
>change and things get moved around, or they add more applications it
>would be easy to keep maintaining the SQL. Or I may have completely
>mis-interpreted your code, either way thank you for your help. Any
>additional information you could provide would be helpful!

Parsing web URL's in SQL

Hello everyone,
I was wondering if anyone could help me out. Basically I have several
sharepoint sites for applications that I run. Each applications
sharepoint site needs to display information about the application
that is located in a SQL database. So for example:
www.qwerty.com/application1/home.html
www.qwerty.com/application2/home.html
www.qwerty.com/application3/home.html
I need to find a way that SQL, Sharepoint, some code, would take the
web address, parse, and truncate it to only read "Application1."
Then I could write a SQL statement to get the data from Application1's
database to display on the sharepoint site. However I have several
application pages, and I would like to be able to have some type of
code that would automatically do it for all the applications, instead
of manually coding/quiering for the data for each application
page.....it would just take too long.
if anyone has any ideas, feel free to share. Thank you in advance, for
all your time and help it is greatly appreciated!
--A4orce84If the part you want is always the next to last section, then this
would appear to provide what is needed. A bit convoluted though!
CREATE TABLE Demo (url varchar(100) not null)
INSERT Demo values ('www.qwerty.com/application1/home.html')
INSERT Demo values ('www.qwerty.com/application2/home.html')
INSERT Demo values ('www.qwerty.com/application3/home.html')
INSERT Demo values ('www.qwerty.com/whatever/banana/987.htm')
SELECT REVERSE(
SUBSTRING(REVERSE(url),
charindex('/', REVERSE(url)) +1,
charindex('/', REVERSE(url), charindex('/',
REVERSE(url)) + 1) -
charindex('/', REVERSE(url)) - 1))
FROM Demo
application1
application2
application3
banana
Roy Harvey
Beacon Falls, CT
On Fri, 08 Jun 2007 09:01:28 -0700, Asif_Ahmad@.dell.com wrote:

>Hello everyone,
>I was wondering if anyone could help me out. Basically I have several
>sharepoint sites for applications that I run. Each applications
>sharepoint site needs to display information about the application
>that is located in a SQL database. So for example:
>www.qwerty.com/application1/home.html
>www.qwerty.com/application2/home.html
>www.qwerty.com/application3/home.html
>I need to find a way that SQL, Sharepoint, some code, would take the
>web address, parse, and truncate it to only read "Application1."
>Then I could write a SQL statement to get the data from Application1's
>database to display on the sharepoint site. However I have several
>application pages, and I would like to be able to have some type of
>code that would automatically do it for all the applications, instead
>of manually coding/quiering for the data for each application
>page.....it would just take too long.
>if anyone has any ideas, feel free to share. Thank you in advance, for
>all your time and help it is greatly appreciated!
>--A4orce84|||Ron,
Is this if you only know the number of applications you have? I think
there are several hundred I am using particularly. It also appears
from your code that you have to enter the physical address into the
code by your:
INSERT Demo values ('www.qwerty.com/application1/home.html')
INSERT Demo values ('www.qwerty.com/application2/home.html')
INSERT Demo values ('www.qwerty.com/application3/home.html')
INSERT Demo values ('www.qwerty.com/whatever/banana/987.htm')
I wanted a way that it would do it automatically, that way if servers
change and things get moved around, or they add more applications it
would be easy to keep maintaining the SQL. Or I may have completely
mis-interpreted your code, either way thank you for your help. Any
additional information you could provide would be helpful!|||I assumed that the URLs you needed to parse would already be in a SQL
Server database table. (Why else would you be trying to parse a URL
in SQL Server?) So my CREATE TABLE and INSERT statements were simply
there to create some test data for demonstration purposes. The number
of URLs in your table is irrelevant to the parsing process.
What I intended to demonstrate was a way to pick out the next to last
section of the URL, which was what I thought you were aiming for. I
believe the code provided does that.
Good luck!
Roy Harvey
Beacon Falls, CT
On Sun, 10 Jun 2007 15:04:14 -0700, Asif_Ahmad@.dell.com wrote:

>Ron,
>Is this if you only know the number of applications you have? I think
>there are several hundred I am using particularly. It also appears
>from your code that you have to enter the physical address into the
>code by your:
>
>INSERT Demo values ('www.qwerty.com/application1/home.html')
>INSERT Demo values ('www.qwerty.com/application2/home.html')
>INSERT Demo values ('www.qwerty.com/application3/home.html')
>INSERT Demo values ('www.qwerty.com/whatever/banana/987.htm')
>
>I wanted a way that it would do it automatically, that way if servers
>change and things get moved around, or they add more applications it
>would be easy to keep maintaining the SQL. Or I may have completely
>mis-interpreted your code, either way thank you for your help. Any
>additional information you could provide would be helpful!

Paramter Passing

Is it possible to pass variables/parameters to a report other thank through
a url using ASP, as this will compromise our security ?
Thanks in advanceTwo options. 1. Use web services. 2. Pull the sensitive parameters by using
the global user!userid. This value tells you who is running the report and
you can then use that to query the database to find out the sensitive
parameters. You might need to do something like having a table with the
username, report and sensitive parameters that your write to before your
application calls the report. And, as I said, you can also use web services.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Con" <conh@.melbournehosting.com> wrote in message
news:u8z7eiPvEHA.3276@.TK2MSFTNGP15.phx.gbl...
> Is it possible to pass variables/parameters to a report other thank
through
> a url using ASP, as this will compromise our security ?
> Thanks in advance
>

parameters via url not being seen

Iâ'm having a problem passing parameters to my report thru the url.
Iâ've read the online text, the manuals we have here, and the newsgroup
entries.
I created a "non-queried" parameter in my report: TestParam
I can test this parameter when running this report in Report Manager. I
enter a value, click View Report, and the data displays in a text box that
displays data based on the data entered into the parameter box.
When I call the report from a vb.net client application thru a url, the
report loads up in a Report Manager window, with NO errors, but no data
displays in either the parameter box or the text box. It is waiting for
parameter input, just as it normally would when bringing up the report in
report manager.
http://server/Reports/Pages/Report.aspx?ItemPath=%2fFolderPath%2fReportName&rs:Command=Render&TestParam=test
Iâ've tried this with and without the Command=Render. I've verified the
parameter name is correct and is the correct case.
Am I still missing something? Is there something more that I should do
with the report parameter before it will accept input from a url?Example from BOL
http://<Webservername>/reportserver?/<reportfolder>/employee+sales+summary&ReportYear=2004&ReportMonth=06&EmpID=24&rs:Command=Render&rs:Format=HTML4.0
so does this work?
http://server/Reports/Pages/Report.aspx?/fFolderPath/ReportName&TestParam=test&rs:Command=Render
--
Wayne Snyder MCDBA, SQL Server MVP
Mariner, Charlotte, NC
(Please respond only to the newsgroup.)
I support the Professional Association for SQL Server ( PASS) and it's
community of SQL Professionals.
"David" <David@.discussions.microsoft.com> wrote in message
news:8632D6C4-002C-41E4-9E79-C1C74DC31784@.microsoft.com...
> I'm having a problem passing parameters to my report thru the url.
> I've read the online text, the manuals we have here, and the newsgroup
> entries.
> I created a "non-queried" parameter in my report: TestParam
> I can test this parameter when running this report in Report Manager. I
> enter a value, click View Report, and the data displays in a text box that
> displays data based on the data entered into the parameter box.
> When I call the report from a vb.net client application thru a url, the
> report loads up in a Report Manager window, with NO errors, but no data
> displays in either the parameter box or the text box. It is waiting for
> parameter input, just as it normally would when bringing up the report in
> report manager.
>
http://server/Reports/Pages/Report.aspx?ItemPath=%2fFolderPath%2fReportName&rs:Command=Render&TestParam=test
> I've tried this with and without the Command=Render. I've verified the
> parameter name is correct and is the correct case.
> Am I still missing something? Is there something more that I should do
> with the report parameter before it will accept input from a url?
>|||The second looks like it should work but what happens is exactly what he is
seeing, the parameters do not get filled in. You need to use reportserver
syntax as you show from BOL (the difference is RS portal (Report Manager)
versus ReportServer).
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Wayne Snyder" <wayne.nospam.snyder@.mariner-usa.com> wrote in message
news:%23Z40Ny2RFHA.3288@.TK2MSFTNGP14.phx.gbl...
> Example from BOL
>
http://<Webservername>/reportserver?/<reportfolder>/employee+sales+summary&ReportYear=2004&ReportMonth=06&EmpID=24&rs:Command=Render&rs:Format=HTML4.0
> so does this work?
>
http://server/Reports/Pages/Report.aspx?/fFolderPath/ReportName&TestParam=test&rs:Command=Render
> --
> Wayne Snyder MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> (Please respond only to the newsgroup.)
> I support the Professional Association for SQL Server ( PASS) and it's
> community of SQL Professionals.
> "David" <David@.discussions.microsoft.com> wrote in message
> news:8632D6C4-002C-41E4-9E79-C1C74DC31784@.microsoft.com...
> > I'm having a problem passing parameters to my report thru the url.
> >
> > I've read the online text, the manuals we have here, and the newsgroup
> > entries.
> >
> > I created a "non-queried" parameter in my report: TestParam
> >
> > I can test this parameter when running this report in Report Manager. I
> > enter a value, click View Report, and the data displays in a text box
that
> > displays data based on the data entered into the parameter box.
> >
> > When I call the report from a vb.net client application thru a url, the
> > report loads up in a Report Manager window, with NO errors, but no data
> > displays in either the parameter box or the text box. It is waiting for
> > parameter input, just as it normally would when bringing up the report
in
> > report manager.
> >
> >
>
http://server/Reports/Pages/Report.aspx?ItemPath=%2fFolderPath%2fReportName&rs:Command=Render&TestParam=test
> >
> > I've tried this with and without the Command=Render. I've verified the
> > parameter name is correct and is the correct case.
> >
> > Am I still missing something? Is there something more that I should do
> > with the report parameter before it will accept input from a url?
> >
> >
>

Parameters in url to make GIF question.

What parameter can I send from my app that will render the report and
then instantly convert it into a .GIF file?
thanks,
TrintTrint,
There isn't a parameter you can pass to get an exported parameter as a gif
file.
Take a look at the url below to view supported export formats:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rswork/htm/rwp_workingreports_v1_3nxt.asp
The below link shows the available URL access params:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSPROG/htm/rsp_prog_urlaccess_374y.asp
Adrian M.
"trint" <trinity.smith@.gmail.com> wrote in message
news:1105737359.995271.243600@.z14g2000cwz.googlegroups.com...
> What parameter can I send from my app that will render the report and
> then instantly convert it into a .GIF file?
> thanks,
> Trint
>|||I know TIFF but can you export to GIF also. ?
for TIFF you supply
rsFormat=IMAGE along with other report parameters.
"trint" <trinity.smith@.gmail.com> wrote in message
news:1105737359.995271.243600@.z14g2000cwz.googlegroups.com...
> What parameter can I send from my app that will render the report and
> then instantly convert it into a .GIF file?
> thanks,
> Trint
>|||OK,
I figured out how to render .gif...here it is:
"The Image rendering extension renders a report to a bitmap or
metafile. By default, the Image rendering extension produces a TIFF
file of the report, which can be viewed in multiple pages. When the
client receives the image, it can be displayed in an image viewer and
printed.
The Image rendering extension can generate files in any of the formats
supported by GDI+: BMP, EMF, GIF, JPEG, PNG, and TIFF. For TIFF format,
the file name of the primary stream is ReportName.tif. For all other
formats, which render as a single page per file, the file name is
ReportName_Page.ext where ext is the file extension for the chosen
format.
"
Trint
Vaibhav wrote:
> I know TIFF but can you export to GIF also. ?
> for TIFF you supply
> rsFormat=IMAGE along with other report parameters.
> "trint" <trinity.smith@.gmail.com> wrote in message
> news:1105737359.995271.243600@.z14g2000cwz.googlegroups.com...
> > What parameter can I send from my app that will render the report
and
> > then instantly convert it into a .GIF file?
> > thanks,
> > Trint
> >

Parameters in URL - Problem

Hi,

I am new to Reporting services and have managed to create some reports. I want to pass some parameters in the URL to the report. I know how to do this but some parameters are not passing to the parameter boxes. They are clearly displayed in the URL but are not populating the boxes. I have one report done before i came and this used to work but now it doesnt work.

Any ideas?

Matt

Hi Matt,

i am unable to understand ur prob completely. But still, if the parameter field is a dropdown list, then the value for that parameter passed in the URL should exists in the dropdown list or else the report will throw an error.

Cheers

Chakri.

|||

Try the sample reports available with your installation of SQL Server. They should show you how to do this:

http://msdn2.microsoft.com/en-us/library/ms161542.aspx

Hope that helps,

-Lukasz

|||

Hi All,

I have the similar kind of problem where i can't see the parameters and their values.

I have a simple report where i am passing employeeid as parameter. When i run it on the server it prompt me for employeeid which after giving displays the report but in the url of browser , i cannot see the parameter and it's value .

Anybody has any idea why this is happenning.

Thanks,

Nagul Shaik

|||

We do not show the parameter in the URL when you're using the report viewer. It does not matter, the report is receiving the parameter.

To see what value the report is receiving you can add a textbox to the report and set it's value to:

=ReportParameters!ParameterName.Value

Hope that helps,

-Lukasz

|||

thanks for the reply but i am not using any report viewer. I am trying access the report thru browser giving the parameters in query string instead of in the prompt.

My requirement is to create hyperlink in my aspx page for that report and when the logged in user clicks on it , i have to pass userid to that report to show the contents of the report.

My sql2005 reporting service is running on WIN2K3.

Please help me with it.

|||

This topic in books online provides you the starting point for how to construct URLs understood by the report server.

http://msdn2.microsoft.com/de-de/library/ms155362.aspx

to pass a particular parameter you defined in the report, you can just append <parametername>=<value> to the end of the query string.

The User!UserId global variable is not a parameter - it is determined by who is logged into the report server. You cannot control it on the URL itself.

Hope that helps,

-Lukasz

|||

http://msdn2.microsoft.com/en-us/library/ms153586(SQL.90).aspx

Parameters in URL - Problem

Hi,

I am new to Reporting services and have managed to create some reports. I want to pass some parameters in the URL to the report. I know how to do this but some parameters are not passing to the parameter boxes. They are clearly displayed in the URL but are not populating the boxes. I have one report done before i came and this used to work but now it doesnt work.

Any ideas?

Matt

Hi Matt,

i am unable to understand ur prob completely. But still, if the parameter field is a dropdown list, then the value for that parameter passed in the URL should exists in the dropdown list or else the report will throw an error.

Cheers

Chakri.

|||

Try the sample reports available with your installation of SQL Server. They should show you how to do this:

http://msdn2.microsoft.com/en-us/library/ms161542.aspx

Hope that helps,

-Lukasz

|||

Hi All,

I have the similar kind of problem where i can't see the parameters and their values.

I have a simple report where i am passing employeeid as parameter. When i run it on the server it prompt me for employeeid which after giving displays the report but in the url of browser , i cannot see the parameter and it's value .

Anybody has any idea why this is happenning.

Thanks,

Nagul Shaik

|||

We do not show the parameter in the URL when you're using the report viewer. It does not matter, the report is receiving the parameter.

To see what value the report is receiving you can add a textbox to the report and set it's value to:

=ReportParameters!ParameterName.Value

Hope that helps,

-Lukasz

|||

thanks for the reply but i am not using any report viewer. I am trying access the report thru browser giving the parameters in query string instead of in the prompt.

My requirement is to create hyperlink in my aspx page for that report and when the logged in user clicks on it , i have to pass userid to that report to show the contents of the report.

My sql2005 reporting service is running on WIN2K3.

Please help me with it.

|||

This topic in books online provides you the starting point for how to construct URLs understood by the report server.

http://msdn2.microsoft.com/de-de/library/ms155362.aspx

to pass a particular parameter you defined in the report, you can just append <parametername>=<value> to the end of the query string.

The User!UserId global variable is not a parameter - it is determined by who is logged into the report server. You cannot control it on the URL itself.

Hope that helps,

-Lukasz

|||

http://msdn2.microsoft.com/en-us/library/ms153586(SQL.90).aspx

Parameters in URL

I know that you can amend the URL of a report and set parameters that way but is there a way you can do the reverse? I need users to be able to save reports to their favourites while retaining the currently selected parameters. Therefore I need the URL to display the parameters without the users having to manually type them in. Is there a way of configuring this?Isn't this what 'my reports' is for?

Never used it so maybe someone else can enlighten us.

If they are always using the same params then just set up linked reports.

For a given parameter on a report you can:
- accept the default
- override the default
- hide or show the param with either of the above

To create a linked report, go to properties (on the report) where you'll see a button to do it.
Enter the description for the new report and which folder you would like it to appear in.

Then within the linked report, go to 'properties' 'parameters' where you can set them as you wish.

A faster way to create linked reports is to use the "RS linked report generator" (free from sqldbatips.com)

The user does not realise they are running a linked report, it saves them time and it can give you better control over security (by either using groups on the folder permissions or within a report using the "globals!reportfolder" parameter, which will show the linked report path and not the 'master' report path.|||

Neither of these options meet our requirements.

As I understand it MyReports is an ad-hoc query builder / an area that rdls can be uploaded to for each user. We have lots of non IT literate Reps who will need their own particular set of parameters applied to each report. I can't see them setting these up. I don't want to have to manage linked reports for every user or to set up linked reports either. Both of these options are onerous on the admin side.

The save to favourites would be the easiest solution though thinking it through, I don't think it will be possible. Thanks anyway.

|||'non IT literate reps' if ever there was an oxymoron...

Why can't you just make the report dynamically figure out who it is?

e.g. using the globals!username, pass it through to sql to filter the results, then just give everyone the same report

I have found that using the two RS tools on the sqldbatips site, along with some clever scripting &copy/paste find/replace, can create all the reports you need without having to touch report manager.|||

true say - the moron bit is also applicable

I had considered this option - we also have users who aren't reps but I guess that's not the end of the world. For reps, we'd also need to know their Sales Division which we don't store in AD. I was just looking for a quick fix to be honest.

What kind of things are you doing? Are you scripting the report from scratch using code? How are you delivering them?

|||

You're talking about "saving to favorites" in the browser favorites list, right?

Do the parameters show in the url/address bar/location at the time you want to save them?

I think this may be possible, but I'm not clear on the action sequence you're talking about -- are they sitting in the browser having selected some parameters, are you giving them the URL in an email (or documentation), or what?

I definitely have parameters embedded in URLs that I give to users and they definitely save them that way to favorites. The only problem is constructing the personal values for them, right?

I have done this by using a bit of javascript, in a page that asks them for the stuff I need to add to the base URL, such as Sales Div, constructing it and showing it to them, with instructions in the page to click on the link and then add to Favorites...

But, here's a thought -- assuming that you do have all your parameter values (such as Sales Div) stored *somewhere* , whether active directory or not, it would be cool to set up a meta-report that listed people's names with constructed URLs next to them, each with the properly constructed URL. You could call it something like the "Favorites Center" report, and it could have different columns next to each person for the different reports you wanted to expose in this way.

>L<

|||

I am talking about adding to browser favourites. The situation is that they open the report and then select a set of parameters pertinent to them. The report is accessed by clicking on a link on an html menu page.

Thanks for the ideas. I think I like the solution that you're currenlty running best. I will see what I can pull together based on your tip.

|||

Have fun! You can get the parameters for a report from the Catalog table of the ReportServer database, btw. (or from a SOAP call, probably a better idea, but hadn't thought about automating this part until just now <g>)

>L<

|||Oh yeah - thanks.|||I'm just getting my feet wet with Vista and don't know about parameters; however, I should not need them. I only want to save some web pages to Favorites and I only get unspecified error. and there it stops of course. It seems a simple thing to ask and a very stupid excuse for not doing it!! Sure would like to resolve this problem. Thankx Merri|||

What does the URL look like and what do you see when you get the "unspecified error"? Do you see a report manager page, just a "dead" browser, or what?

>L<

Parameters in URL

I know that you can amend the URL of a report and set parameters that way but is there a way you can do the reverse? I need users to be able to save reports to their favourites while retaining the currently selected parameters. Therefore I need the URL to display the parameters without the users having to manually type them in. Is there a way of configuring this?Isn't this what 'my reports' is for?

Never used it so maybe someone else can enlighten us.

If they are always using the same params then just set up linked reports.

For a given parameter on a report you can:
- accept the default
- override the default
- hide or show the param with either of the above

To create a linked report, go to properties (on the report) where you'll see a button to do it.
Enter the description for the new report and which folder you would like it to appear in.

Then within the linked report, go to 'properties' 'parameters' where you can set them as you wish.

A faster way to create linked reports is to use the "RS linked report generator" (free from sqldbatips.com)

The user does not realise they are running a linked report, it saves them time and it can give you better control over security (by either using groups on the folder permissions or within a report using the "globals!reportfolder" parameter, which will show the linked report path and not the 'master' report path.|||

Neither of these options meet our requirements.

As I understand it MyReports is an ad-hoc query builder / an area that rdls can be uploaded to for each user. We have lots of non IT literate Reps who will need their own particular set of parameters applied to each report. I can't see them setting these up. I don't want to have to manage linked reports for every user or to set up linked reports either. Both of these options are onerous on the admin side.

The save to favourites would be the easiest solution though thinking it through, I don't think it will be possible. Thanks anyway.

|||'non IT literate reps' if ever there was an oxymoron...

Why can't you just make the report dynamically figure out who it is?

e.g. using the globals!username, pass it through to sql to filter the results, then just give everyone the same report

I have found that using the two RS tools on the sqldbatips site, along with some clever scripting &copy/paste find/replace, can create all the reports you need without having to touch report manager.|||

true say - the moron bit is also applicable

I had considered this option - we also have users who aren't reps but I guess that's not the end of the world. For reps, we'd also need to know their Sales Division which we don't store in AD. I was just looking for a quick fix to be honest.

What kind of things are you doing? Are you scripting the report from scratch using code? How are you delivering them?

|||

You're talking about "saving to favorites" in the browser favorites list, right?

Do the parameters show in the url/address bar/location at the time you want to save them?

I think this may be possible, but I'm not clear on the action sequence you're talking about -- are they sitting in the browser having selected some parameters, are you giving them the URL in an email (or documentation), or what?

I definitely have parameters embedded in URLs that I give to users and they definitely save them that way to favorites. The only problem is constructing the personal values for them, right?

I have done this by using a bit of javascript, in a page that asks them for the stuff I need to add to the base URL, such as Sales Div, constructing it and showing it to them, with instructions in the page to click on the link and then add to Favorites...

But, here's a thought -- assuming that you do have all your parameter values (such as Sales Div) stored *somewhere* , whether active directory or not, it would be cool to set up a meta-report that listed people's names with constructed URLs next to them, each with the properly constructed URL. You could call it something like the "Favorites Center" report, and it could have different columns next to each person for the different reports you wanted to expose in this way.

>L<

|||

I am talking about adding to browser favourites. The situation is that they open the report and then select a set of parameters pertinent to them. The report is accessed by clicking on a link on an html menu page.

Thanks for the ideas. I think I like the solution that you're currenlty running best. I will see what I can pull together based on your tip.

|||

Have fun! You can get the parameters for a report from the Catalog table of the ReportServer database, btw. (or from a SOAP call, probably a better idea, but hadn't thought about automating this part until just now <g>)

>L<

|||Oh yeah - thanks.|||I'm just getting my feet wet with Vista and don't know about parameters; however, I should not need them. I only want to save some web pages to Favorites and I only get unspecified error. and there it stops of course. It seems a simple thing to ask and a very stupid excuse for not doing it!! Sure would like to resolve this problem. Thankx Merri

|||

What does the URL look like and what do you see when you get the "unspecified error"? Do you see a report manager page, just a "dead" browser, or what?

>L<

Parameters in SSRS with OLAP

Hi - I have a report that uses an OLAP cube. I cannot figure out how to pass
parameters into the report using URL. I've tried setting the parameter to
the value I desire, but that doesn't work. Here's an example:
http://mysite/reportserver/report.rdl&rc:toolbar=true&rc:LinkTarget=_top&DimParameter=301
When I look at how OLAP passes parameters into reports, it's not the same as
when I use straight SQL tables. So I tried:
http://mysite/reportserver/report.rdl&rc:toolbar=true&rc:LinkTarget=_top&DimParameter=[DimParameter].[MEMBER].[301]
but then I get an error message saying that the text is too long. Any help
would be appreciated.What is the MDX of the statement you are trying to execute based on the
parameter?
This has to be set up as a concatenated string in the DS for the report.
Chris E
"Jim" <Jim@.discussions.microsoft.com> wrote in message
news:2582B5B0-C2AE-4327-8A66-FECA58B19754@.microsoft.com...
> Hi - I have a report that uses an OLAP cube. I cannot figure out how to
> pass
> parameters into the report using URL. I've tried setting the parameter to
> the value I desire, but that doesn't work. Here's an example:
> http://mysite/reportserver/report.rdl&rc:toolbar=true&rc:LinkTarget=_top&DimParameter=301
> When I look at how OLAP passes parameters into reports, it's not the same
> as
> when I use straight SQL tables. So I tried:
> http://mysite/reportserver/report.rdl&rc:toolbar=true&rc:LinkTarget=_top&DimParameter=[DimParameter].[MEMBER].[301]
> but then I get an error message saying that the text is too long. Any help
> would be appreciated.
>|||Thanks for your response, Chris. The MDX statement is:
SELECT NON EMPTY { [Measures].[Responses], [Measures].[Quantity],
[Measures].[Total Cost], [Measures].[Revenue] } ON COLUMNS, NON EMPTY { ([Dim
Expire Group].[Dim Expire Group].[Dim Expire Group].ALLMEMBERS * [Dim
Notice].[Dim Notice].[Dim Notice].ALLMEMBERS * [Dim Notice].[Notice
Order].[Notice Order].ALLMEMBERS * [Dim YOF].[YOF Name].[YOF Name].ALLMEMBERS
* [Dim YOF].[YOF Order].[YOF Order].ALLMEMBERS * [Dim HPC].[HPC Id1].[HPC
Id1].ALLMEMBERS * [Dim HPC].[HPC Name1].[HPC Name1].ALLMEMBERS * [Dim
HPC].[HPC Order1].[HPC Order1].ALLMEMBERS * [Dim YOF].[Dim YOF].[Dim
YOF].ALLMEMBERS * [Dim Package].[Package Type Id].[Package Type
Id].ALLMEMBERS ) } DIMENSION PROPERTIES MEMBER_CAPTION, MEMBER_UNIQUE_NAME ON
ROWS FROM ( SELECT ( STRTOSET(@.DimHPCHPCName, CONSTRAINED) ) ON COLUMNS FROM
( SELECT ( STRTOSET(@.DimExpireGroupDimExpireGroup, CONSTRAINED) ) ON COLUMNS
FROM ( SELECT ( STRTOSET(@.DimPackagePackageTypeId, CONSTRAINED) ) ON COLUMNS
FROM ( SELECT ( STRTOSET(@.DimProgramDimProgram, CONSTRAINED) ) ON COLUMNS
FROM [FactSourceCode])))) WHERE ( IIF( STRTOSET(@.DimProgramDimProgram,
CONSTRAINED).Count = 1, STRTOSET(@.DimProgramDimProgram, CONSTRAINED), [Dim
Program].[Dim Program].currentmember ) ) CELL PROPERTIES VALUE, BACK_COLOR,
FORE_COLOR, FORMATTED_VALUE, FORMAT_STRING, FONT_NAME, FONT_SIZE, FONT_FLAGS
I pass several parameters into the statement. I thought I'd figured it out
by using the codes that represent the [, ] and &. But I'm still getting the
same issue when it tries to pass the parameter in the URL.
"Chris" wrote:
> What is the MDX of the statement you are trying to execute based on the
> parameter?
> This has to be set up as a concatenated string in the DS for the report.
> Chris E
> "Jim" <Jim@.discussions.microsoft.com> wrote in message
> news:2582B5B0-C2AE-4327-8A66-FECA58B19754@.microsoft.com...
> > Hi - I have a report that uses an OLAP cube. I cannot figure out how to
> > pass
> > parameters into the report using URL. I've tried setting the parameter to
> > the value I desire, but that doesn't work. Here's an example:
> >
> > http://mysite/reportserver/report.rdl&rc:toolbar=true&rc:LinkTarget=_top&DimParameter=301
> >
> > When I look at how OLAP passes parameters into reports, it's not the same
> > as
> > when I use straight SQL tables. So I tried:
> >
> > http://mysite/reportserver/report.rdl&rc:toolbar=true&rc:LinkTarget=_top&DimParameter=[DimParameter].[MEMBER].[301]
> >
> > but then I get an error message saying that the text is too long. Any help
> > would be appreciated.
> >
>
>|||I had a similar problem. My solve was:
the konfiguration of report paramters must set
available evaluates = not asked
and
standard value = zero
then it should function with the parameters [DimParameter].[MEMBER].[301]
EggHeadCafe.com - .NET Developer Portal of Choice
http://www.eggheadcafe.com|||I had a similar problem. My solve was:
the konfiguration of report paramters must set
available value = not asked
and
standard value = zero
then it should function with the parameters [DimParameter].[MEMBER].[301]
EggHeadCafe.com - .NET Developer Portal of Choice
http://www.eggheadcafe.com

Parameters I add to URL do not do anything

I am new to reporting services. I'm using 2005. I have some reports
deployed and working. When I go to them directly by URL with some parameters
in the URL, the parameters don't do anything. I've tried some of the built
in rc parameters and my own parameter values. Is there a setting I'm
missing or something? Thanks.My guess is you are going to Reports instead of ResportServer. Reports is
the portal that ships with RS. ReportServer is the asp.net application that
is Report Server.
Books Online has lots of good examples. Look for URL Access (if you are on
RS 2000 then look on the Books Online on the microsoft site (i.e. RS 2005
Books Online, URL integration is the same).
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"jlmjr" <jlmjr@.discussions.microsoft.com> wrote in message
news:74438560-1960-4900-A165-E87B1A94E1F3@.microsoft.com...
>I am new to reporting services. I'm using 2005. I have some reports
> deployed and working. When I go to them directly by URL with some
> parameters
> in the URL, the parameters don't do anything. I've tried some of the
> built
> in rc parameters and my own parameter values. Is there a setting I'm
> missing or something? Thanks.|||That's what I needed to know. Thanks!
"Bruce L-C [MVP]" wrote:
> My guess is you are going to Reports instead of ResportServer. Reports is
> the portal that ships with RS. ReportServer is the asp.net application that
> is Report Server.
> Books Online has lots of good examples. Look for URL Access (if you are on
> RS 2000 then look on the Books Online on the microsoft site (i.e. RS 2005
> Books Online, URL integration is the same).
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "jlmjr" <jlmjr@.discussions.microsoft.com> wrote in message
> news:74438560-1960-4900-A165-E87B1A94E1F3@.microsoft.com...
> >I am new to reporting services. I'm using 2005. I have some reports
> > deployed and working. When I go to them directly by URL with some
> > parameters
> > in the URL, the parameters don't do anything. I've tried some of the
> > built
> > in rc parameters and my own parameter values. Is there a setting I'm
> > missing or something? Thanks.
>
>

Parameters hidden in ReportViewer

We have a report that opens via a URL. We send through the base parameters
and the report renders, but the parameter list is show.
What we really want to happen is to have the report run, but have the
parameter list minized so that it does not occupy so much screen space. The
user can then choose to make it visible if they wish.
Is this Possible? If so, how?
Thanks,
Chris E.On 18 juin, 21:02, "Chris" <cex...@.enableconsulting.com> wrote:
> We have a report that opens via a URL. We send through the base parameters
> and the report renders, but the parameter list is show.
> What we really want to happen is to have the report run, but have the
> parameter list minized so that it does not occupy so much screen space. The
> user can then choose to make it visible if they wish.
> Is this Possible? If so, how?
> Thanks,
> Chris E.
Try adding "rc:Parameters=Collapsed" in the URL|||If you're using the Report Manager to deploy to and view your reports, then the parameters can be shown or hidden via a button on the right hand side of the toolbar. Alternatively, you can hide the parameters completely from within the report definition file
From http://www.developmentnow.com/g/115_2007_6_0_0_984633/Parameters-hidden-in-ReportViewer.ht
Posted via DevelopmentNow.com Group
http://www.developmentnow.com

Parameters are getting hidden while using Jump to report

Hi,
I am trying to have drill down from a report to another report. I am using
"Jump to URL" drill down to another report. Everything works fine except that
the parameters get hidden int he second report. Is there anyway i can have
the parameters visible while using the jump to report?
Thanks
PradyThere are a load of parameters you can add to the URL to control the
appearance of the report. Try tacking "&rc:Parameters=true" to the URL
(without the quotes!). Look for "URL Access" in Books Online for all
the options available.
Just a bit of a pedantic correction, but this sort of drilling is
generally termed "Drill Through", when you expand data to show more
detail, this is termed "Drill down". Semantics lesson over with now! :-)
Cheers
Chris
prady wrote:
> Hi,
> I am trying to have drill down from a report to another report. I am
> using "Jump to URL" drill down to another report. Everything works
> fine except that the parameters get hidden int he second report. Is
> there anyway i can have the parameters visible while using the jump
> to report? Thanks
> Prady|||chris
where exactly do i have to add the 'rc:paramaters=true' bit?
can i still use option 'jump to report' then or do i have to chose jump to
url with the url of my jump-to report with the rc:... bit?
if i take the jump to report possibility, configure my pass parameter
values, my rdl looks like this
<Drillthrough>
<Parameters>
<Parameter Name="startdate">
<value>= Parameters!startdate.Value</Value>
</Parameter>
<Parameter Name="enddate">
<Value>= Parameters!enddate.Value</Value>
</Parameter>
</Parameters>
<ReportName>Availability SLA</ReportName>
</Drillthrough>
can i specify here somewhere to show the parametertoolbar?
thx
stefan
"Chris" wrote:
> There are a load of parameters you can add to the URL to control the
> appearance of the report. Try tacking "&rc:Parameters=true" to the URL
> (without the quotes!). Look for "URL Access" in Books Online for all
> the options available.
> Just a bit of a pedantic correction, but this sort of drilling is
> generally termed "Drill Through", when you expand data to show more
> detail, this is termed "Drill down". Semantics lesson over with now! :-)
> Cheers
> Chris
>
> prady wrote:
> > Hi,
> > I am trying to have drill down from a report to another report. I am
> > using "Jump to URL" drill down to another report. Everything works
> > fine except that the parameters get hidden int he second report. Is
> > there anyway i can have the parameters visible while using the jump
> > to report? Thanks
> > Prady
>
> --
>|||Stefan,
You've probably sussed this by now, if you are using the url access
parameters, then yes you do need to use "jump to url" not "jump to
report". The url should point to the report server NOT the report
manager. The difference is http://myServer/ReportServer is the
"server", http://myServer/Reports is the "manager".
Search for "url access" in BOL for the order you put things in.
Chris
Stefan wrote:
> chris
> where exactly do i have to add the 'rc:paramaters=true' bit?
> can i still use option 'jump to report' then or do i have to chose
> jump to url with the url of my jump-to report with the rc:... bit?
> if i take the jump to report possibility, configure my pass parameter
> values, my rdl looks like this
> <Drillthrough>
> <Parameters>
> <Parameter Name="startdate">
> <value>= Parameters!startdate.Value</Value>
> </Parameter>
> <Parameter Name="enddate">
> <Value>= Parameters!enddate.Value</Value>
> </Parameter>
> </Parameters>
> <ReportName>Availability SLA</ReportName>
> </Drillthrough>
> can i specify here somewhere to show the parametertoolbar?
> thx
> stefan
> "Chris" wrote:
> > There are a load of parameters you can add to the URL to control the
> > appearance of the report. Try tacking "&rc:Parameters=true" to the
> > URL (without the quotes!). Look for "URL Access" in Books Online
> > for all the options available.
> >
> > Just a bit of a pedantic correction, but this sort of drilling is
> > generally termed "Drill Through", when you expand data to show more
> > detail, this is termed "Drill down". Semantics lesson over with
> > now! :-)
> >
> > Cheers
> > Chris
> >
> >
> > prady wrote:
> >
> > > Hi,
> > > I am trying to have drill down from a report to another report. I
> > > am using "Jump to URL" drill down to another report. Everything
> > > works fine except that the parameters get hidden int he second
> > > report. Is there anyway i can have the parameters visible while
> > > using the jump to report? Thanks
> > > Prady
> >
> >
> >
> > --
> >
> >