Hi,
is it possible to start a Report via Link (from Desktop) with start
parameter like an
ASP-Script
For example:
...report.rdl?Year=2007&Month=6...
Thank you
HansThat's what URL access in RS is for.
Amarnath
"Hans" wrote:
> Hi,
> is it possible to start a Report via Link (from Desktop) with start
> parameter like an
> ASP-Script
> For example:
>
> ...report.rdl?Year=2007&Month=6...
>
> Thank you
> Hans
>|||That what I mean ist to start the report from Desktop inclusive
parameters.
Hans|||ok,
so this is a sample you can use to see how it works if you have implemented
the samples and hosted the reports on localserver. copy this url from
desktop.. also you can write asp.net to mask this url and give just a
hyperlink from the page.. see the parameters also passed.
http://server/reportserver?/Sales/Northwest/Employee Sales
Report&rs:Command=Render&EmployeeID=1234
Amarnath
"Hans" wrote:
> That what I mean ist to start the report from Desktop inclusive
> parameters.
> Hans
>|||I tried this, but it doesn=B4t work. The report opens, but there=B4s not
selected parameter value.
Thanks,
Hans|||Hans,
Have you pasted my sample link as a whole URL because it is wraped in the
post.
Incase you have done this pl ignore, you said there is no parameter value,
so I thought you have not pasted the whole URL.
Amarnath, MCTS
"Hans" wrote:
> I tried this, but it doesn´t work. The report opens, but there´s not
> selected parameter value.
>
> Thanks,
> Hans
>
Showing posts with label parameters. Show all posts
Showing posts with label parameters. Show all posts
Friday, March 30, 2012
Wednesday, March 28, 2012
Link to a report with parameters
I need to create a report with some parameters for filtering data.
This report must be called by URL link on an Html page.
This link must contains the values of these parameters; I don' want
specify the values when I see the report by clicking on View report button.
Is it possible? How?
What is the format of link for passing parameters to filter data?
Many thanks1. Try leaving the parameter Prompt blank... This should prevent the
parameter from displaying, (but you must provide a default value...)
2. Search for URL Access in Books on line and you will get an entire list
of all of the things you can do via URL in reporting services.
Hope this helps..
--
Wayne Snyder MCDBA, SQL Server MVP
Mariner, Charlotte, NC
I support the Professional Association for SQL Server ( PASS) and it''s
community of SQL Professionals.
"Pasquale" wrote:
> I need to create a report with some parameters for filtering data.
> This report must be called by URL link on an Html page.
> This link must contains the values of these parameters; I don' want
> specify the values when I see the report by clicking on View report button.
> Is it possible? How?
> What is the format of link for passing parameters to filter data?
> Many thanks|||I tried passing parameters in URL address successfully,
but I see some parameters that the user hasn't change!
Moreover, if I change the parameter property "User request"
by setting to false value, the call of report dumps!
The issue is partially solved! I need to pass a parameter by Url
and these parameters cannot change by a user.
Can I solve this problem URGENTLY?
Many thanks
"Wayne Snyder" wrote:
> 1. Try leaving the parameter Prompt blank... This should prevent the
> parameter from displaying, (but you must provide a default value...)
> 2. Search for URL Access in Books on line and you will get an entire list
> of all of the things you can do via URL in reporting services.
> Hope this helps..
> --
> Wayne Snyder MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> I support the Professional Association for SQL Server ( PASS) and it''s
> community of SQL Professionals.
>
> "Pasquale" wrote:
> > I need to create a report with some parameters for filtering data.
> > This report must be called by URL link on an Html page.
> > This link must contains the values of these parameters; I don' want
> > specify the values when I see the report by clicking on View report button.
> > Is it possible? How?
> > What is the format of link for passing parameters to filter data?
> >
> > Many thanks|||Read the rest of Wayne's post. He is telling you how to hide a parameter so
the user doesn't see it.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Pasquale" <Pasquale@.discussions.microsoft.com> wrote in message
news:471AB25B-E6A6-4E1A-9756-CA42FB10DB66@.microsoft.com...
>I tried passing parameters in URL address successfully,
> but I see some parameters that the user hasn't change!
> Moreover, if I change the parameter property "User request"
> by setting to false value, the call of report dumps!
> The issue is partially solved! I need to pass a parameter by Url
> and these parameters cannot change by a user.
> Can I solve this problem URGENTLY?
> Many thanks
>
> "Wayne Snyder" wrote:
>> 1. Try leaving the parameter Prompt blank... This should prevent the
>> parameter from displaying, (but you must provide a default value...)
>> 2. Search for URL Access in Books on line and you will get an entire
>> list
>> of all of the things you can do via URL in reporting services.
>> Hope this helps..
>> --
>> Wayne Snyder MCDBA, SQL Server MVP
>> Mariner, Charlotte, NC
>> I support the Professional Association for SQL Server ( PASS) and it''s
>> community of SQL Professionals.
>>
>> "Pasquale" wrote:
>> > I need to create a report with some parameters for filtering data.
>> > This report must be called by URL link on an Html page.
>> > This link must contains the values of these parameters; I don' want
>> > specify the values when I see the report by clicking on View report
>> > button.
>> > Is it possible? How?
>> > What is the format of link for passing parameters to filter data?
>> >
>> > Many thanks|||I have executed several tries modifying the parameter settings.
I have followed your suggests, but the solution isn't complete:
or I see the parameter or I cannot modify the parameter
that I pass via URL (an error occurs!!!)!
Many thanks
"Bruce L-C [MVP]" wrote:
> Read the rest of Wayne's post. He is telling you how to hide a parameter so
> the user doesn't see it.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Pasquale" <Pasquale@.discussions.microsoft.com> wrote in message
> news:471AB25B-E6A6-4E1A-9756-CA42FB10DB66@.microsoft.com...
> >I tried passing parameters in URL address successfully,
> > but I see some parameters that the user hasn't change!
> > Moreover, if I change the parameter property "User request"
> > by setting to false value, the call of report dumps!
> >
> > The issue is partially solved! I need to pass a parameter by Url
> > and these parameters cannot change by a user.
> >
> > Can I solve this problem URGENTLY?
> >
> > Many thanks
> >
> >
> > "Wayne Snyder" wrote:
> >
> >> 1. Try leaving the parameter Prompt blank... This should prevent the
> >> parameter from displaying, (but you must provide a default value...)
> >>
> >> 2. Search for URL Access in Books on line and you will get an entire
> >> list
> >> of all of the things you can do via URL in reporting services.
> >>
> >> Hope this helps..
> >> --
> >> Wayne Snyder MCDBA, SQL Server MVP
> >> Mariner, Charlotte, NC
> >>
> >> I support the Professional Association for SQL Server ( PASS) and it''s
> >> community of SQL Professionals.
> >>
> >>
> >> "Pasquale" wrote:
> >>
> >> > I need to create a report with some parameters for filtering data.
> >> > This report must be called by URL link on an Html page.
> >> > This link must contains the values of these parameters; I don' want
> >> > specify the values when I see the report by clicking on View report
> >> > button.
> >> > Is it possible? How?
> >> > What is the format of link for passing parameters to filter data?
> >> >
> >> > Many thanks
>
>|||Two different things. First is getting the parameters to work. Then making
them hidden. Do you have them working properly so you know your URL is
correct. Be sure that your parameter is with the correct case since RS is
case sensitive with parameters. Once you know your URL is correct because
your report works properly then you can deal with hidding the parameters.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Pasquale" <Pasquale@.discussions.microsoft.com> wrote in message
news:E50B32E5-DCC3-448C-A679-75233BBA3F8D@.microsoft.com...
>I have executed several tries modifying the parameter settings.
> I have followed your suggests, but the solution isn't complete:
> or I see the parameter or I cannot modify the parameter
> that I pass via URL (an error occurs!!!)!
> Many thanks
>
> "Bruce L-C [MVP]" wrote:
>> Read the rest of Wayne's post. He is telling you how to hide a parameter
>> so
>> the user doesn't see it.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "Pasquale" <Pasquale@.discussions.microsoft.com> wrote in message
>> news:471AB25B-E6A6-4E1A-9756-CA42FB10DB66@.microsoft.com...
>> >I tried passing parameters in URL address successfully,
>> > but I see some parameters that the user hasn't change!
>> > Moreover, if I change the parameter property "User request"
>> > by setting to false value, the call of report dumps!
>> >
>> > The issue is partially solved! I need to pass a parameter by Url
>> > and these parameters cannot change by a user.
>> >
>> > Can I solve this problem URGENTLY?
>> >
>> > Many thanks
>> >
>> >
>> > "Wayne Snyder" wrote:
>> >
>> >> 1. Try leaving the parameter Prompt blank... This should prevent the
>> >> parameter from displaying, (but you must provide a default value...)
>> >>
>> >> 2. Search for URL Access in Books on line and you will get an entire
>> >> list
>> >> of all of the things you can do via URL in reporting services.
>> >>
>> >> Hope this helps..
>> >> --
>> >> Wayne Snyder MCDBA, SQL Server MVP
>> >> Mariner, Charlotte, NC
>> >>
>> >> I support the Professional Association for SQL Server ( PASS) and
>> >> it''s
>> >> community of SQL Professionals.
>> >>
>> >>
>> >> "Pasquale" wrote:
>> >>
>> >> > I need to create a report with some parameters for filtering data.
>> >> > This report must be called by URL link on an Html page.
>> >> > This link must contains the values of these parameters; I don' want
>> >> > specify the values when I see the report by clicking on View report
>> >> > button.
>> >> > Is it possible? How?
>> >> > What is the format of link for passing parameters to filter data?
>> >> >
>> >> > Many thanks
>>|||My issue has two aspects:
1. passing a parameter via URL to call my report filtering data by the
parameter;
2. hide or protect parameter inside report manager to avoid any user's
changes.
The first step is solved. The report is called correctly and I see the
correct value
of parameter (the same written in the URL). I have written correctly the
name of parameter.
Now, when I set user request for the parameter, inside report manager, to
false
in order to hide the parameter, this message error occurs:
"sReadOnlyReportParameter" and I cannot the value of parameter by the value
in the URL.
This strange behaviour represents a limit of RS!
Moreover, I have specified a default value of parameter with a particular
value.
Now, is it really possible to solve completely this issue?
Do I have a particular SP (SP1, SP2, ...)?
Many thanks
"Bruce L-C [MVP]" wrote:
> Two different things. First is getting the parameters to work. Then making
> them hidden. Do you have them working properly so you know your URL is
> correct. Be sure that your parameter is with the correct case since RS is
> case sensitive with parameters. Once you know your URL is correct because
> your report works properly then you can deal with hidding the parameters.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
> "Pasquale" <Pasquale@.discussions.microsoft.com> wrote in message
> news:E50B32E5-DCC3-448C-A679-75233BBA3F8D@.microsoft.com...
> >I have executed several tries modifying the parameter settings.
> > I have followed your suggests, but the solution isn't complete:
> > or I see the parameter or I cannot modify the parameter
> > that I pass via URL (an error occurs!!!)!
> >
> > Many thanks
> >
> >
> > "Bruce L-C [MVP]" wrote:
> >
> >> Read the rest of Wayne's post. He is telling you how to hide a parameter
> >> so
> >> the user doesn't see it.
> >>
> >>
> >> --
> >> Bruce Loehle-Conger
> >> MVP SQL Server Reporting Services
> >>
> >> "Pasquale" <Pasquale@.discussions.microsoft.com> wrote in message
> >> news:471AB25B-E6A6-4E1A-9756-CA42FB10DB66@.microsoft.com...
> >> >I tried passing parameters in URL address successfully,
> >> > but I see some parameters that the user hasn't change!
> >> > Moreover, if I change the parameter property "User request"
> >> > by setting to false value, the call of report dumps!
> >> >
> >> > The issue is partially solved! I need to pass a parameter by Url
> >> > and these parameters cannot change by a user.
> >> >
> >> > Can I solve this problem URGENTLY?
> >> >
> >> > Many thanks
> >> >
> >> >
> >> > "Wayne Snyder" wrote:
> >> >
> >> >> 1. Try leaving the parameter Prompt blank... This should prevent the
> >> >> parameter from displaying, (but you must provide a default value...)
> >> >>
> >> >> 2. Search for URL Access in Books on line and you will get an entire
> >> >> list
> >> >> of all of the things you can do via URL in reporting services.
> >> >>
> >> >> Hope this helps..
> >> >> --
> >> >> Wayne Snyder MCDBA, SQL Server MVP
> >> >> Mariner, Charlotte, NC
> >> >>
> >> >> I support the Professional Association for SQL Server ( PASS) and
> >> >> it''s
> >> >> community of SQL Professionals.
> >> >>
> >> >>
> >> >> "Pasquale" wrote:
> >> >>
> >> >> > I need to create a report with some parameters for filtering data.
> >> >> > This report must be called by URL link on an Html page.
> >> >> > This link must contains the values of these parameters; I don' want
> >> >> > specify the values when I see the report by clicking on View report
> >> >> > button.
> >> >> > Is it possible? How?
> >> >> > What is the format of link for passing parameters to filter data?
> >> >> >
> >> >> > Many thanks
> >>
> >>
> >>
>
>|||I have controlled all settings of the report; then I try to set to blank
the user request string inside report manager (maintaning a default
value for the parameter): so, I can modify the parameter by passing it
via URL and simultaneously hide it in order to avoid any user's changes.
Finally, the issue is solved!!!
Many thanks
"Bruce L-C [MVP]" wrote:
> Two different things. First is getting the parameters to work. Then making
> them hidden. Do you have them working properly so you know your URL is
> correct. Be sure that your parameter is with the correct case since RS is
> case sensitive with parameters. Once you know your URL is correct because
> your report works properly then you can deal with hidding the parameters.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
> "Pasquale" <Pasquale@.discussions.microsoft.com> wrote in message
> news:E50B32E5-DCC3-448C-A679-75233BBA3F8D@.microsoft.com...
> >I have executed several tries modifying the parameter settings.
> > I have followed your suggests, but the solution isn't complete:
> > or I see the parameter or I cannot modify the parameter
> > that I pass via URL (an error occurs!!!)!
> >
> > Many thanks
> >
> >
> > "Bruce L-C [MVP]" wrote:
> >
> >> Read the rest of Wayne's post. He is telling you how to hide a parameter
> >> so
> >> the user doesn't see it.
> >>
> >>
> >> --
> >> Bruce Loehle-Conger
> >> MVP SQL Server Reporting Services
> >>
> >> "Pasquale" <Pasquale@.discussions.microsoft.com> wrote in message
> >> news:471AB25B-E6A6-4E1A-9756-CA42FB10DB66@.microsoft.com...
> >> >I tried passing parameters in URL address successfully,
> >> > but I see some parameters that the user hasn't change!
> >> > Moreover, if I change the parameter property "User request"
> >> > by setting to false value, the call of report dumps!
> >> >
> >> > The issue is partially solved! I need to pass a parameter by Url
> >> > and these parameters cannot change by a user.
> >> >
> >> > Can I solve this problem URGENTLY?
> >> >
> >> > Many thanks
> >> >
> >> >
> >> > "Wayne Snyder" wrote:
> >> >
> >> >> 1. Try leaving the parameter Prompt blank... This should prevent the
> >> >> parameter from displaying, (but you must provide a default value...)
> >> >>
> >> >> 2. Search for URL Access in Books on line and you will get an entire
> >> >> list
> >> >> of all of the things you can do via URL in reporting services.
> >> >>
> >> >> Hope this helps..
> >> >> --
> >> >> Wayne Snyder MCDBA, SQL Server MVP
> >> >> Mariner, Charlotte, NC
> >> >>
> >> >> I support the Professional Association for SQL Server ( PASS) and
> >> >> it''s
> >> >> community of SQL Professionals.
> >> >>
> >> >>
> >> >> "Pasquale" wrote:
> >> >>
> >> >> > I need to create a report with some parameters for filtering data.
> >> >> > This report must be called by URL link on an Html page.
> >> >> > This link must contains the values of these parameters; I don' want
> >> >> > specify the values when I see the report by clicking on View report
> >> >> > button.
> >> >> > Is it possible? How?
> >> >> > What is the format of link for passing parameters to filter data?
> >> >> >
> >> >> > Many thanks
> >>
> >>
> >>
>
>|||Making parameters hidden is much more straight forward in RS 2005. I don't
hide parameters so I have not had that issue.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Pasquale" <Pasquale@.discussions.microsoft.com> wrote in message
news:8DE20C29-CBB1-4020-93BD-6D8C71361AD2@.microsoft.com...
>I have controlled all settings of the report; then I try to set to blank
> the user request string inside report manager (maintaning a default
> value for the parameter): so, I can modify the parameter by passing it
> via URL and simultaneously hide it in order to avoid any user's changes.
> Finally, the issue is solved!!!
> Many thanks
>
> "Bruce L-C [MVP]" wrote:
>> Two different things. First is getting the parameters to work. Then
>> making
>> them hidden. Do you have them working properly so you know your URL is
>> correct. Be sure that your parameter is with the correct case since RS is
>> case sensitive with parameters. Once you know your URL is correct because
>> your report works properly then you can deal with hidding the parameters.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>>
>> "Pasquale" <Pasquale@.discussions.microsoft.com> wrote in message
>> news:E50B32E5-DCC3-448C-A679-75233BBA3F8D@.microsoft.com...
>> >I have executed several tries modifying the parameter settings.
>> > I have followed your suggests, but the solution isn't complete:
>> > or I see the parameter or I cannot modify the parameter
>> > that I pass via URL (an error occurs!!!)!
>> >
>> > Many thanks
>> >
>> >
>> > "Bruce L-C [MVP]" wrote:
>> >
>> >> Read the rest of Wayne's post. He is telling you how to hide a
>> >> parameter
>> >> so
>> >> the user doesn't see it.
>> >>
>> >>
>> >> --
>> >> Bruce Loehle-Conger
>> >> MVP SQL Server Reporting Services
>> >>
>> >> "Pasquale" <Pasquale@.discussions.microsoft.com> wrote in message
>> >> news:471AB25B-E6A6-4E1A-9756-CA42FB10DB66@.microsoft.com...
>> >> >I tried passing parameters in URL address successfully,
>> >> > but I see some parameters that the user hasn't change!
>> >> > Moreover, if I change the parameter property "User request"
>> >> > by setting to false value, the call of report dumps!
>> >> >
>> >> > The issue is partially solved! I need to pass a parameter by Url
>> >> > and these parameters cannot change by a user.
>> >> >
>> >> > Can I solve this problem URGENTLY?
>> >> >
>> >> > Many thanks
>> >> >
>> >> >
>> >> > "Wayne Snyder" wrote:
>> >> >
>> >> >> 1. Try leaving the parameter Prompt blank... This should prevent
>> >> >> the
>> >> >> parameter from displaying, (but you must provide a default
>> >> >> value...)
>> >> >>
>> >> >> 2. Search for URL Access in Books on line and you will get an
>> >> >> entire
>> >> >> list
>> >> >> of all of the things you can do via URL in reporting services.
>> >> >>
>> >> >> Hope this helps..
>> >> >> --
>> >> >> Wayne Snyder MCDBA, SQL Server MVP
>> >> >> Mariner, Charlotte, NC
>> >> >>
>> >> >> I support the Professional Association for SQL Server ( PASS) and
>> >> >> it''s
>> >> >> community of SQL Professionals.
>> >> >>
>> >> >>
>> >> >> "Pasquale" wrote:
>> >> >>
>> >> >> > I need to create a report with some parameters for filtering
>> >> >> > data.
>> >> >> > This report must be called by URL link on an Html page.
>> >> >> > This link must contains the values of these parameters; I don'
>> >> >> > want
>> >> >> > specify the values when I see the report by clicking on View
>> >> >> > report
>> >> >> > button.
>> >> >> > Is it possible? How?
>> >> >> > What is the format of link for passing parameters to filter data?
>> >> >> >
>> >> >> > Many thanks
>> >>
>> >>
>> >>
>>sql
This report must be called by URL link on an Html page.
This link must contains the values of these parameters; I don' want
specify the values when I see the report by clicking on View report button.
Is it possible? How?
What is the format of link for passing parameters to filter data?
Many thanks1. Try leaving the parameter Prompt blank... This should prevent the
parameter from displaying, (but you must provide a default value...)
2. Search for URL Access in Books on line and you will get an entire list
of all of the things you can do via URL in reporting services.
Hope this helps..
--
Wayne Snyder MCDBA, SQL Server MVP
Mariner, Charlotte, NC
I support the Professional Association for SQL Server ( PASS) and it''s
community of SQL Professionals.
"Pasquale" wrote:
> I need to create a report with some parameters for filtering data.
> This report must be called by URL link on an Html page.
> This link must contains the values of these parameters; I don' want
> specify the values when I see the report by clicking on View report button.
> Is it possible? How?
> What is the format of link for passing parameters to filter data?
> Many thanks|||I tried passing parameters in URL address successfully,
but I see some parameters that the user hasn't change!
Moreover, if I change the parameter property "User request"
by setting to false value, the call of report dumps!
The issue is partially solved! I need to pass a parameter by Url
and these parameters cannot change by a user.
Can I solve this problem URGENTLY?
Many thanks
"Wayne Snyder" wrote:
> 1. Try leaving the parameter Prompt blank... This should prevent the
> parameter from displaying, (but you must provide a default value...)
> 2. Search for URL Access in Books on line and you will get an entire list
> of all of the things you can do via URL in reporting services.
> Hope this helps..
> --
> Wayne Snyder MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> I support the Professional Association for SQL Server ( PASS) and it''s
> community of SQL Professionals.
>
> "Pasquale" wrote:
> > I need to create a report with some parameters for filtering data.
> > This report must be called by URL link on an Html page.
> > This link must contains the values of these parameters; I don' want
> > specify the values when I see the report by clicking on View report button.
> > Is it possible? How?
> > What is the format of link for passing parameters to filter data?
> >
> > Many thanks|||Read the rest of Wayne's post. He is telling you how to hide a parameter so
the user doesn't see it.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Pasquale" <Pasquale@.discussions.microsoft.com> wrote in message
news:471AB25B-E6A6-4E1A-9756-CA42FB10DB66@.microsoft.com...
>I tried passing parameters in URL address successfully,
> but I see some parameters that the user hasn't change!
> Moreover, if I change the parameter property "User request"
> by setting to false value, the call of report dumps!
> The issue is partially solved! I need to pass a parameter by Url
> and these parameters cannot change by a user.
> Can I solve this problem URGENTLY?
> Many thanks
>
> "Wayne Snyder" wrote:
>> 1. Try leaving the parameter Prompt blank... This should prevent the
>> parameter from displaying, (but you must provide a default value...)
>> 2. Search for URL Access in Books on line and you will get an entire
>> list
>> of all of the things you can do via URL in reporting services.
>> Hope this helps..
>> --
>> Wayne Snyder MCDBA, SQL Server MVP
>> Mariner, Charlotte, NC
>> I support the Professional Association for SQL Server ( PASS) and it''s
>> community of SQL Professionals.
>>
>> "Pasquale" wrote:
>> > I need to create a report with some parameters for filtering data.
>> > This report must be called by URL link on an Html page.
>> > This link must contains the values of these parameters; I don' want
>> > specify the values when I see the report by clicking on View report
>> > button.
>> > Is it possible? How?
>> > What is the format of link for passing parameters to filter data?
>> >
>> > Many thanks|||I have executed several tries modifying the parameter settings.
I have followed your suggests, but the solution isn't complete:
or I see the parameter or I cannot modify the parameter
that I pass via URL (an error occurs!!!)!
Many thanks
"Bruce L-C [MVP]" wrote:
> Read the rest of Wayne's post. He is telling you how to hide a parameter so
> the user doesn't see it.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Pasquale" <Pasquale@.discussions.microsoft.com> wrote in message
> news:471AB25B-E6A6-4E1A-9756-CA42FB10DB66@.microsoft.com...
> >I tried passing parameters in URL address successfully,
> > but I see some parameters that the user hasn't change!
> > Moreover, if I change the parameter property "User request"
> > by setting to false value, the call of report dumps!
> >
> > The issue is partially solved! I need to pass a parameter by Url
> > and these parameters cannot change by a user.
> >
> > Can I solve this problem URGENTLY?
> >
> > Many thanks
> >
> >
> > "Wayne Snyder" wrote:
> >
> >> 1. Try leaving the parameter Prompt blank... This should prevent the
> >> parameter from displaying, (but you must provide a default value...)
> >>
> >> 2. Search for URL Access in Books on line and you will get an entire
> >> list
> >> of all of the things you can do via URL in reporting services.
> >>
> >> Hope this helps..
> >> --
> >> Wayne Snyder MCDBA, SQL Server MVP
> >> Mariner, Charlotte, NC
> >>
> >> I support the Professional Association for SQL Server ( PASS) and it''s
> >> community of SQL Professionals.
> >>
> >>
> >> "Pasquale" wrote:
> >>
> >> > I need to create a report with some parameters for filtering data.
> >> > This report must be called by URL link on an Html page.
> >> > This link must contains the values of these parameters; I don' want
> >> > specify the values when I see the report by clicking on View report
> >> > button.
> >> > Is it possible? How?
> >> > What is the format of link for passing parameters to filter data?
> >> >
> >> > Many thanks
>
>|||Two different things. First is getting the parameters to work. Then making
them hidden. Do you have them working properly so you know your URL is
correct. Be sure that your parameter is with the correct case since RS is
case sensitive with parameters. Once you know your URL is correct because
your report works properly then you can deal with hidding the parameters.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Pasquale" <Pasquale@.discussions.microsoft.com> wrote in message
news:E50B32E5-DCC3-448C-A679-75233BBA3F8D@.microsoft.com...
>I have executed several tries modifying the parameter settings.
> I have followed your suggests, but the solution isn't complete:
> or I see the parameter or I cannot modify the parameter
> that I pass via URL (an error occurs!!!)!
> Many thanks
>
> "Bruce L-C [MVP]" wrote:
>> Read the rest of Wayne's post. He is telling you how to hide a parameter
>> so
>> the user doesn't see it.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "Pasquale" <Pasquale@.discussions.microsoft.com> wrote in message
>> news:471AB25B-E6A6-4E1A-9756-CA42FB10DB66@.microsoft.com...
>> >I tried passing parameters in URL address successfully,
>> > but I see some parameters that the user hasn't change!
>> > Moreover, if I change the parameter property "User request"
>> > by setting to false value, the call of report dumps!
>> >
>> > The issue is partially solved! I need to pass a parameter by Url
>> > and these parameters cannot change by a user.
>> >
>> > Can I solve this problem URGENTLY?
>> >
>> > Many thanks
>> >
>> >
>> > "Wayne Snyder" wrote:
>> >
>> >> 1. Try leaving the parameter Prompt blank... This should prevent the
>> >> parameter from displaying, (but you must provide a default value...)
>> >>
>> >> 2. Search for URL Access in Books on line and you will get an entire
>> >> list
>> >> of all of the things you can do via URL in reporting services.
>> >>
>> >> Hope this helps..
>> >> --
>> >> Wayne Snyder MCDBA, SQL Server MVP
>> >> Mariner, Charlotte, NC
>> >>
>> >> I support the Professional Association for SQL Server ( PASS) and
>> >> it''s
>> >> community of SQL Professionals.
>> >>
>> >>
>> >> "Pasquale" wrote:
>> >>
>> >> > I need to create a report with some parameters for filtering data.
>> >> > This report must be called by URL link on an Html page.
>> >> > This link must contains the values of these parameters; I don' want
>> >> > specify the values when I see the report by clicking on View report
>> >> > button.
>> >> > Is it possible? How?
>> >> > What is the format of link for passing parameters to filter data?
>> >> >
>> >> > Many thanks
>>|||My issue has two aspects:
1. passing a parameter via URL to call my report filtering data by the
parameter;
2. hide or protect parameter inside report manager to avoid any user's
changes.
The first step is solved. The report is called correctly and I see the
correct value
of parameter (the same written in the URL). I have written correctly the
name of parameter.
Now, when I set user request for the parameter, inside report manager, to
false
in order to hide the parameter, this message error occurs:
"sReadOnlyReportParameter" and I cannot the value of parameter by the value
in the URL.
This strange behaviour represents a limit of RS!
Moreover, I have specified a default value of parameter with a particular
value.
Now, is it really possible to solve completely this issue?
Do I have a particular SP (SP1, SP2, ...)?
Many thanks
"Bruce L-C [MVP]" wrote:
> Two different things. First is getting the parameters to work. Then making
> them hidden. Do you have them working properly so you know your URL is
> correct. Be sure that your parameter is with the correct case since RS is
> case sensitive with parameters. Once you know your URL is correct because
> your report works properly then you can deal with hidding the parameters.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
> "Pasquale" <Pasquale@.discussions.microsoft.com> wrote in message
> news:E50B32E5-DCC3-448C-A679-75233BBA3F8D@.microsoft.com...
> >I have executed several tries modifying the parameter settings.
> > I have followed your suggests, but the solution isn't complete:
> > or I see the parameter or I cannot modify the parameter
> > that I pass via URL (an error occurs!!!)!
> >
> > Many thanks
> >
> >
> > "Bruce L-C [MVP]" wrote:
> >
> >> Read the rest of Wayne's post. He is telling you how to hide a parameter
> >> so
> >> the user doesn't see it.
> >>
> >>
> >> --
> >> Bruce Loehle-Conger
> >> MVP SQL Server Reporting Services
> >>
> >> "Pasquale" <Pasquale@.discussions.microsoft.com> wrote in message
> >> news:471AB25B-E6A6-4E1A-9756-CA42FB10DB66@.microsoft.com...
> >> >I tried passing parameters in URL address successfully,
> >> > but I see some parameters that the user hasn't change!
> >> > Moreover, if I change the parameter property "User request"
> >> > by setting to false value, the call of report dumps!
> >> >
> >> > The issue is partially solved! I need to pass a parameter by Url
> >> > and these parameters cannot change by a user.
> >> >
> >> > Can I solve this problem URGENTLY?
> >> >
> >> > Many thanks
> >> >
> >> >
> >> > "Wayne Snyder" wrote:
> >> >
> >> >> 1. Try leaving the parameter Prompt blank... This should prevent the
> >> >> parameter from displaying, (but you must provide a default value...)
> >> >>
> >> >> 2. Search for URL Access in Books on line and you will get an entire
> >> >> list
> >> >> of all of the things you can do via URL in reporting services.
> >> >>
> >> >> Hope this helps..
> >> >> --
> >> >> Wayne Snyder MCDBA, SQL Server MVP
> >> >> Mariner, Charlotte, NC
> >> >>
> >> >> I support the Professional Association for SQL Server ( PASS) and
> >> >> it''s
> >> >> community of SQL Professionals.
> >> >>
> >> >>
> >> >> "Pasquale" wrote:
> >> >>
> >> >> > I need to create a report with some parameters for filtering data.
> >> >> > This report must be called by URL link on an Html page.
> >> >> > This link must contains the values of these parameters; I don' want
> >> >> > specify the values when I see the report by clicking on View report
> >> >> > button.
> >> >> > Is it possible? How?
> >> >> > What is the format of link for passing parameters to filter data?
> >> >> >
> >> >> > Many thanks
> >>
> >>
> >>
>
>|||I have controlled all settings of the report; then I try to set to blank
the user request string inside report manager (maintaning a default
value for the parameter): so, I can modify the parameter by passing it
via URL and simultaneously hide it in order to avoid any user's changes.
Finally, the issue is solved!!!
Many thanks
"Bruce L-C [MVP]" wrote:
> Two different things. First is getting the parameters to work. Then making
> them hidden. Do you have them working properly so you know your URL is
> correct. Be sure that your parameter is with the correct case since RS is
> case sensitive with parameters. Once you know your URL is correct because
> your report works properly then you can deal with hidding the parameters.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
> "Pasquale" <Pasquale@.discussions.microsoft.com> wrote in message
> news:E50B32E5-DCC3-448C-A679-75233BBA3F8D@.microsoft.com...
> >I have executed several tries modifying the parameter settings.
> > I have followed your suggests, but the solution isn't complete:
> > or I see the parameter or I cannot modify the parameter
> > that I pass via URL (an error occurs!!!)!
> >
> > Many thanks
> >
> >
> > "Bruce L-C [MVP]" wrote:
> >
> >> Read the rest of Wayne's post. He is telling you how to hide a parameter
> >> so
> >> the user doesn't see it.
> >>
> >>
> >> --
> >> Bruce Loehle-Conger
> >> MVP SQL Server Reporting Services
> >>
> >> "Pasquale" <Pasquale@.discussions.microsoft.com> wrote in message
> >> news:471AB25B-E6A6-4E1A-9756-CA42FB10DB66@.microsoft.com...
> >> >I tried passing parameters in URL address successfully,
> >> > but I see some parameters that the user hasn't change!
> >> > Moreover, if I change the parameter property "User request"
> >> > by setting to false value, the call of report dumps!
> >> >
> >> > The issue is partially solved! I need to pass a parameter by Url
> >> > and these parameters cannot change by a user.
> >> >
> >> > Can I solve this problem URGENTLY?
> >> >
> >> > Many thanks
> >> >
> >> >
> >> > "Wayne Snyder" wrote:
> >> >
> >> >> 1. Try leaving the parameter Prompt blank... This should prevent the
> >> >> parameter from displaying, (but you must provide a default value...)
> >> >>
> >> >> 2. Search for URL Access in Books on line and you will get an entire
> >> >> list
> >> >> of all of the things you can do via URL in reporting services.
> >> >>
> >> >> Hope this helps..
> >> >> --
> >> >> Wayne Snyder MCDBA, SQL Server MVP
> >> >> Mariner, Charlotte, NC
> >> >>
> >> >> I support the Professional Association for SQL Server ( PASS) and
> >> >> it''s
> >> >> community of SQL Professionals.
> >> >>
> >> >>
> >> >> "Pasquale" wrote:
> >> >>
> >> >> > I need to create a report with some parameters for filtering data.
> >> >> > This report must be called by URL link on an Html page.
> >> >> > This link must contains the values of these parameters; I don' want
> >> >> > specify the values when I see the report by clicking on View report
> >> >> > button.
> >> >> > Is it possible? How?
> >> >> > What is the format of link for passing parameters to filter data?
> >> >> >
> >> >> > Many thanks
> >>
> >>
> >>
>
>|||Making parameters hidden is much more straight forward in RS 2005. I don't
hide parameters so I have not had that issue.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Pasquale" <Pasquale@.discussions.microsoft.com> wrote in message
news:8DE20C29-CBB1-4020-93BD-6D8C71361AD2@.microsoft.com...
>I have controlled all settings of the report; then I try to set to blank
> the user request string inside report manager (maintaning a default
> value for the parameter): so, I can modify the parameter by passing it
> via URL and simultaneously hide it in order to avoid any user's changes.
> Finally, the issue is solved!!!
> Many thanks
>
> "Bruce L-C [MVP]" wrote:
>> Two different things. First is getting the parameters to work. Then
>> making
>> them hidden. Do you have them working properly so you know your URL is
>> correct. Be sure that your parameter is with the correct case since RS is
>> case sensitive with parameters. Once you know your URL is correct because
>> your report works properly then you can deal with hidding the parameters.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>>
>> "Pasquale" <Pasquale@.discussions.microsoft.com> wrote in message
>> news:E50B32E5-DCC3-448C-A679-75233BBA3F8D@.microsoft.com...
>> >I have executed several tries modifying the parameter settings.
>> > I have followed your suggests, but the solution isn't complete:
>> > or I see the parameter or I cannot modify the parameter
>> > that I pass via URL (an error occurs!!!)!
>> >
>> > Many thanks
>> >
>> >
>> > "Bruce L-C [MVP]" wrote:
>> >
>> >> Read the rest of Wayne's post. He is telling you how to hide a
>> >> parameter
>> >> so
>> >> the user doesn't see it.
>> >>
>> >>
>> >> --
>> >> Bruce Loehle-Conger
>> >> MVP SQL Server Reporting Services
>> >>
>> >> "Pasquale" <Pasquale@.discussions.microsoft.com> wrote in message
>> >> news:471AB25B-E6A6-4E1A-9756-CA42FB10DB66@.microsoft.com...
>> >> >I tried passing parameters in URL address successfully,
>> >> > but I see some parameters that the user hasn't change!
>> >> > Moreover, if I change the parameter property "User request"
>> >> > by setting to false value, the call of report dumps!
>> >> >
>> >> > The issue is partially solved! I need to pass a parameter by Url
>> >> > and these parameters cannot change by a user.
>> >> >
>> >> > Can I solve this problem URGENTLY?
>> >> >
>> >> > Many thanks
>> >> >
>> >> >
>> >> > "Wayne Snyder" wrote:
>> >> >
>> >> >> 1. Try leaving the parameter Prompt blank... This should prevent
>> >> >> the
>> >> >> parameter from displaying, (but you must provide a default
>> >> >> value...)
>> >> >>
>> >> >> 2. Search for URL Access in Books on line and you will get an
>> >> >> entire
>> >> >> list
>> >> >> of all of the things you can do via URL in reporting services.
>> >> >>
>> >> >> Hope this helps..
>> >> >> --
>> >> >> Wayne Snyder MCDBA, SQL Server MVP
>> >> >> Mariner, Charlotte, NC
>> >> >>
>> >> >> I support the Professional Association for SQL Server ( PASS) and
>> >> >> it''s
>> >> >> community of SQL Professionals.
>> >> >>
>> >> >>
>> >> >> "Pasquale" wrote:
>> >> >>
>> >> >> > I need to create a report with some parameters for filtering
>> >> >> > data.
>> >> >> > This report must be called by URL link on an Html page.
>> >> >> > This link must contains the values of these parameters; I don'
>> >> >> > want
>> >> >> > specify the values when I see the report by clicking on View
>> >> >> > report
>> >> >> > button.
>> >> >> > Is it possible? How?
>> >> >> > What is the format of link for passing parameters to filter data?
>> >> >> >
>> >> >> > Many thanks
>> >>
>> >>
>> >>
>>sql
Monday, March 19, 2012
Limits on parameters and query complexity?
I have a huge SQL statement with subqueries in the From and Where clauses.
When I run it in SQL Query Analyzer, it runs fine, but if I put it into the
Data tab of a report, Visual Studio just hangs.
I've been able to create the parameter list manually (adding them to the
Report Parameters dialog), and then when I paste the query in without the
Where clause, it works ok. I can then start adding lines to the Where
clause, but as soon as I get enough lines for about 10 parameters or so, it
hangs up again.
I know nothing's wrong with the SQL itself since it runs in Query Analyzer
without a hitch; am I looking at a bug in RS?Sounds like a bug. If you have a good repro, please send it to me at
bradsy@.microsoft.com
--
| From: "DJM" <msnews@.puddlestheshark.com>
| Subject: Limits on parameters and query complexity?
| Date: Mon, 14 Feb 2005 16:53:09 -0700
| Lines: 14
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
| X-RFC2646: Format=Flowed; Original
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
| Message-ID: <uG8e6AvEFHA.548@.TK2MSFTNGP14.phx.gbl>
| Newsgroups: microsoft.public.sqlserver.reportingsvcs
| NNTP-Posting-Host: 64.140.73.34
| Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP14.phx.gbl
| Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.reportingsvcs:35923
| X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
|
| I have a huge SQL statement with subqueries in the From and Where
clauses.
| When I run it in SQL Query Analyzer, it runs fine, but if I put it into
the
| Data tab of a report, Visual Studio just hangs.
|
| I've been able to create the parameter list manually (adding them to the
| Report Parameters dialog), and then when I paste the query in without the
| Where clause, it works ok. I can then start adding lines to the Where
| clause, but as soon as I get enough lines for about 10 parameters or so,
it
| hangs up again.
|
| I know nothing's wrong with the SQL itself since it runs in Query
Analyzer
| without a hitch; am I looking at a bug in RS?
|
|
|
When I run it in SQL Query Analyzer, it runs fine, but if I put it into the
Data tab of a report, Visual Studio just hangs.
I've been able to create the parameter list manually (adding them to the
Report Parameters dialog), and then when I paste the query in without the
Where clause, it works ok. I can then start adding lines to the Where
clause, but as soon as I get enough lines for about 10 parameters or so, it
hangs up again.
I know nothing's wrong with the SQL itself since it runs in Query Analyzer
without a hitch; am I looking at a bug in RS?Sounds like a bug. If you have a good repro, please send it to me at
bradsy@.microsoft.com
--
| From: "DJM" <msnews@.puddlestheshark.com>
| Subject: Limits on parameters and query complexity?
| Date: Mon, 14 Feb 2005 16:53:09 -0700
| Lines: 14
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
| X-RFC2646: Format=Flowed; Original
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
| Message-ID: <uG8e6AvEFHA.548@.TK2MSFTNGP14.phx.gbl>
| Newsgroups: microsoft.public.sqlserver.reportingsvcs
| NNTP-Posting-Host: 64.140.73.34
| Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP14.phx.gbl
| Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.reportingsvcs:35923
| X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
|
| I have a huge SQL statement with subqueries in the From and Where
clauses.
| When I run it in SQL Query Analyzer, it runs fine, but if I put it into
the
| Data tab of a report, Visual Studio just hangs.
|
| I've been able to create the parameter list manually (adding them to the
| Report Parameters dialog), and then when I paste the query in without the
| Where clause, it works ok. I can then start adding lines to the Where
| clause, but as soon as I get enough lines for about 10 parameters or so,
it
| hangs up again.
|
| I know nothing's wrong with the SQL itself since it runs in Query
Analyzer
| without a hitch; am I looking at a bug in RS?
|
|
|
Friday, February 24, 2012
Limitation on Number of Parameters??
Hi,
I would like to know, while running the report in the Report Manager, do we
have any limitation on number of parameters or specifically in number of drop
down parameters?
One of my report is having 35 parameters for the user to enter, it is
working fine in Designer's Preview mode, but when i deploy it to server and
when i run the report from the server, its not showing the output and no
errors also. If i reduce the number of parameters its working fine. Why is
this strange behaviour, your help is highly appreciated in this.
TIA,
Sen KHi
it seems to me that the limitation is not in the number of parameters but in
the length of the calling sql statement. I don't know how to explain
exactly... I had about 14 parameters with dependencies among them. And one
value in the combobox was extremely long. Report behaved in the same way. The
only workaround i found - place a shorter name for this long value and in the
main stored procedure simply "decode" it to its longer variant.
Ailil
"Sen K" wrote:
> Hi,
> I would like to know, while running the report in the Report Manager, do we
> have any limitation on number of parameters or specifically in number of drop
> down parameters?
> One of my report is having 35 parameters for the user to enter, it is
> working fine in Designer's Preview mode, but when i deploy it to server and
> when i run the report from the server, its not showing the output and no
> errors also. If i reduce the number of parameters its working fine. Why is
> this strange behaviour, your help is highly appreciated in this.
> TIA,
> Sen K
I would like to know, while running the report in the Report Manager, do we
have any limitation on number of parameters or specifically in number of drop
down parameters?
One of my report is having 35 parameters for the user to enter, it is
working fine in Designer's Preview mode, but when i deploy it to server and
when i run the report from the server, its not showing the output and no
errors also. If i reduce the number of parameters its working fine. Why is
this strange behaviour, your help is highly appreciated in this.
TIA,
Sen KHi
it seems to me that the limitation is not in the number of parameters but in
the length of the calling sql statement. I don't know how to explain
exactly... I had about 14 parameters with dependencies among them. And one
value in the combobox was extremely long. Report behaved in the same way. The
only workaround i found - place a shorter name for this long value and in the
main stored procedure simply "decode" it to its longer variant.
Ailil
"Sen K" wrote:
> Hi,
> I would like to know, while running the report in the Report Manager, do we
> have any limitation on number of parameters or specifically in number of drop
> down parameters?
> One of my report is having 35 parameters for the user to enter, it is
> working fine in Designer's Preview mode, but when i deploy it to server and
> when i run the report from the server, its not showing the output and no
> errors also. If i reduce the number of parameters its working fine. Why is
> this strange behaviour, your help is highly appreciated in this.
> TIA,
> Sen K
Limitation on Multiple parameters with Multi-Select and default values
Dear Anyone,
I created 6 parameters in my report. Each of these parameters are multi-select enabled. Each of their available values comes from a data set. Their default values also comes from a data set in order to have the select all check box selected by default.
My problem is only the first 2 parameters gets to have the select all selected. And the rest just have blank values. I was wondering if RS parameters have some sort of limitation that I cannot enable data set default values in all of my parameters.
Thanks,
JosephThere seems to be a bug in RS2005 in the parameters section. Filter the data set your using for the parameters to not include blanks. This is aparently whats causing your problem.|||
Hello,
I need to create reports with parameters that allow for multi-selection values.
How can I make them multi-select enabled?
Appreciate your reponse.
SK
Limitation on Multiple parameters with Multi-Select and default values
Dear Anyone,
I created 6 parameters in my report. Each of these parameters are multi-select enabled. Each of their available values comes from a data set. Their default values also comes from a data set in order to have the select all check box selected by default.
My problem is only the first 2 parameters gets to have the select all selected. And the rest just have blank values. I was wondering if RS parameters have some sort of limitation that I cannot enable data set default values in all of my parameters.
Thanks,
JosephThere seems to be a bug in RS2005 in the parameters section. Filter the data set your using for the parameters to not include blanks. This is aparently whats causing your problem.|||
Hello,
I need to create reports with parameters that allow for multi-selection values.
How can I make them multi-select enabled?
Appreciate your reponse.
SK
Monday, February 20, 2012
limit parameters
is there anyway to limit the date ranges that a user can enter?
my reports have a start date and end date as parameters and I would
like to limit the date range to 6 months so that a user cannot enter a
huge date range or something and slow down the database.Just build a custom prompting mechanizm on your own web page, validating
user input there , disable built-in param prompts in RDL,
construct a custom URL query string on your own web page , than simply
redirect.
--
Oleg Yevteyev,
San Diego, CA
It is OK to contact me with a contracting opportunity.
"myfirstname"001atgmaildotcom.
Replace "myfirstname" with Oleg.
--
"bevarg" <benovarghese@.gmail.com> wrote in message
news:1142261128.051458.241930@.v46g2000cwv.googlegroups.com...
> is there anyway to limit the date ranges that a user can enter?
> my reports have a start date and end date as parameters and I would
> like to limit the date range to 6 months so that a user cannot enter a
> huge date range or something and slow down the database.
>
my reports have a start date and end date as parameters and I would
like to limit the date range to 6 months so that a user cannot enter a
huge date range or something and slow down the database.Just build a custom prompting mechanizm on your own web page, validating
user input there , disable built-in param prompts in RDL,
construct a custom URL query string on your own web page , than simply
redirect.
--
Oleg Yevteyev,
San Diego, CA
It is OK to contact me with a contracting opportunity.
"myfirstname"001atgmaildotcom.
Replace "myfirstname" with Oleg.
--
"bevarg" <benovarghese@.gmail.com> wrote in message
news:1142261128.051458.241930@.v46g2000cwv.googlegroups.com...
> is there anyway to limit the date ranges that a user can enter?
> my reports have a start date and end date as parameters and I would
> like to limit the date range to 6 months so that a user cannot enter a
> huge date range or something and slow down the database.
>
Subscribe to:
Comments (Atom)