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

Link for 'Compare the Editions'

Hi,
Does anyone have a link for the 'Compare the Editions' Page for SQL 2000? It
appears Microsoft are now only showing the 2005 version page.
Thanks - Ian.
http://msdn.microsoft.com/library/de...ar_ts_8dbn.asp
HTH. Ryan
"Ian Samuels" <iasamuels@.hotmail.com> wrote in message
news:eMA%23CvBRGHA.4900@.TK2MSFTNGP09.phx.gbl...
> Hi,
> Does anyone have a link for the 'Compare the Editions' Page for SQL 2000?
> It appears Microsoft are now only showing the 2005 version page.
> Thanks - Ian.
>
|||Hi Ryan,
Thanks but I'm after a comparison of the features - I need to compare SQL
2000 Standard Edition to Workgroup Edition and there was a page similar to
the SQL 2005 page
(http://www.microsoft.com/sql/prodinf...-features.mspx) that
seems to have gone.
Thanks.
"Ryan" <Ryan_Waight@.nospam.hotmail.com> wrote in message
news:ewzZnWCRGHA.6084@.TK2MSFTNGP14.phx.gbl...
> http://msdn.microsoft.com/library/de...ar_ts_8dbn.asp
> --
> HTH. Ryan
>
> "Ian Samuels" <iasamuels@.hotmail.com> wrote in message
> news:eMA%23CvBRGHA.4900@.TK2MSFTNGP09.phx.gbl...
>
|||Ian wrote on Fri, 10 Mar 2006 09:38:59 -0000:

> Hi Ryan,
> Thanks but I'm after a comparison of the features - I need to compare SQL
> 2000 Standard Edition to Workgroup Edition and there was a page similar to
> the SQL 2005 page
> (http://www.microsoft.com/sql/prodinf...-features.mspx)
> that seems to have gone.
All I could find in a similar format is this:
http://www.servepath.com/servers/win_sqlserver.htm
I didn't even realise there was a 2000 Workgroup edition.
Dan
|||Daniel wrote to Ian Samuels on Fri, 10 Mar 2006 12:51:45 -0000:
[vbcol=seagreen]
> Ian wrote on Fri, 10 Mar 2006 09:38:59 -0000:
Also found this (forgot all about WebArchive!)
http://web.archive.org/web/200503230...s/choosing.asp
It's slow, but it's the last version of the 2000 comparison page that was
put up in March 2005
Dan
|||Ah yeh - great - cheers Dan.
"Daniel Crichton" <msnews@.worldofspack.co.uk> wrote in message
news:uZLPcHERGHA.4900@.TK2MSFTNGP09.phx.gbl...
> Daniel wrote to Ian Samuels on Fri, 10 Mar 2006 12:51:45 -0000:
>
> Also found this (forgot all about WebArchive!)
> http://web.archive.org/web/200503230...s/choosing.asp
> It's slow, but it's the last version of the 2000 comparison page that was
> put up in March 2005
> Dan
>

Link for 'Compare the Editions'

Hi,
Does anyone have a link for the 'Compare the Editions' Page for SQL 2000? It
appears Microsoft are now only showing the 2005 version page.
Thanks - Ian.http://msdn.microsoft.com/library/d...br />
8dbn.asp
HTH. Ryan
"Ian Samuels" <iasamuels@.hotmail.com> wrote in message
news:eMA%23CvBRGHA.4900@.TK2MSFTNGP09.phx.gbl...
> Hi,
> Does anyone have a link for the 'Compare the Editions' Page for SQL 2000?
> It appears Microsoft are now only showing the 2005 version page.
> Thanks - Ian.
>|||Hi Ryan,
Thanks but I'm after a comparison of the features - I need to compare SQL
2000 Standard Edition to Workgroup Edition and there was a page similar to
the SQL 2005 page
(http://www.microsoft.com/sql/prodin...e-features.mspx) that
seems to have gone.
Thanks.
"Ryan" <Ryan_Waight@.nospam.hotmail.com> wrote in message
news:ewzZnWCRGHA.6084@.TK2MSFTNGP14.phx.gbl...
> http://msdn.microsoft.com/library/d... />
s_8dbn.asp
> --
> HTH. Ryan
>
> "Ian Samuels" <iasamuels@.hotmail.com> wrote in message
> news:eMA%23CvBRGHA.4900@.TK2MSFTNGP09.phx.gbl...
>|||Ian wrote on Fri, 10 Mar 2006 09:38:59 -0000:

> Hi Ryan,
> Thanks but I'm after a comparison of the features - I need to compare SQL
> 2000 Standard Edition to Workgroup Edition and there was a page similar to
> the SQL 2005 page
> (http://www.microsoft.com/sql/prodin...e-features.mspx)
> that seems to have gone.
All I could find in a similar format is this:
http://www.servepath.com/servers/win_sqlserver.htm
I didn't even realise there was a 2000 Workgroup edition.
Dan|||Daniel wrote to Ian Samuels on Fri, 10 Mar 2006 12:51:45 -0000:
[vbcol=seagreen]
> Ian wrote on Fri, 10 Mar 2006 09:38:59 -0000:
>
Also found this (forgot all about WebArchive!)
http://web.archive.org/web/20050323...es/choosing.asp
It's slow, but it's the last version of the 2000 comparison page that was
put up in March 2005
Dan|||Ah yeh - great - cheers Dan.
"Daniel Crichton" <msnews@.worldofspack.co.uk> wrote in message
news:uZLPcHERGHA.4900@.TK2MSFTNGP09.phx.gbl...
> Daniel wrote to Ian Samuels on Fri, 10 Mar 2006 12:51:45 -0000:
>
> Also found this (forgot all about WebArchive!)
> http://web.archive.org/web/20050323...es/choosing.asp
> It's slow, but it's the last version of the 2000 comparison page that was
> put up in March 2005
> Dan
>

Link for 'Compare the Editions'

Hi,
Does anyone have a link for the 'Compare the Editions' Page for SQL 2000? It
appears Microsoft are now only showing the 2005 version page.
Thanks - Ian.http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_ar_ts_8dbn.asp
--
HTH. Ryan
"Ian Samuels" <iasamuels@.hotmail.com> wrote in message
news:eMA%23CvBRGHA.4900@.TK2MSFTNGP09.phx.gbl...
> Hi,
> Does anyone have a link for the 'Compare the Editions' Page for SQL 2000?
> It appears Microsoft are now only showing the 2005 version page.
> Thanks - Ian.
>|||Hi Ryan,
Thanks but I'm after a comparison of the features - I need to compare SQL
2000 Standard Edition to Workgroup Edition and there was a page similar to
the SQL 2005 page
(http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx) that
seems to have gone.
Thanks.
"Ryan" <Ryan_Waight@.nospam.hotmail.com> wrote in message
news:ewzZnWCRGHA.6084@.TK2MSFTNGP14.phx.gbl...
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_ar_ts_8dbn.asp
> --
> HTH. Ryan
>
> "Ian Samuels" <iasamuels@.hotmail.com> wrote in message
> news:eMA%23CvBRGHA.4900@.TK2MSFTNGP09.phx.gbl...
>> Hi,
>> Does anyone have a link for the 'Compare the Editions' Page for SQL 2000?
>> It appears Microsoft are now only showing the 2005 version page.
>> Thanks - Ian.
>|||Ian wrote on Fri, 10 Mar 2006 09:38:59 -0000:
> Hi Ryan,
> Thanks but I'm after a comparison of the features - I need to compare SQL
> 2000 Standard Edition to Workgroup Edition and there was a page similar to
> the SQL 2005 page
> (http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx)
> that seems to have gone.
All I could find in a similar format is this:
http://www.servepath.com/servers/win_sqlserver.htm
I didn't even realise there was a 2000 Workgroup edition.
Dan|||Daniel wrote to Ian Samuels on Fri, 10 Mar 2006 12:51:45 -0000:
> Ian wrote on Fri, 10 Mar 2006 09:38:59 -0000:
>> Hi Ryan,
>> Thanks but I'm after a comparison of the features - I need to compare SQL
>> 2000 Standard Edition to Workgroup Edition and there was a page similar
>> to the SQL 2005 page
>> (http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx) th
>> at seems to have gone.
Also found this (forgot all about WebArchive!)
http://web.archive.org/web/20050323020459/http://www.microsoft.com/sql/evaluation/features/choosing.asp
It's slow, but it's the last version of the 2000 comparison page that was
put up in March 2005 :)
Dan|||Ah yeh - great - cheers Dan.
"Daniel Crichton" <msnews@.worldofspack.co.uk> wrote in message
news:uZLPcHERGHA.4900@.TK2MSFTNGP09.phx.gbl...
> Daniel wrote to Ian Samuels on Fri, 10 Mar 2006 12:51:45 -0000:
>> Ian wrote on Fri, 10 Mar 2006 09:38:59 -0000:
>> Hi Ryan,
>> Thanks but I'm after a comparison of the features - I need to compare
>> SQL
>> 2000 Standard Edition to Workgroup Edition and there was a page similar
>> to the SQL 2005 page
>> (http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx)
>> th
>> at seems to have gone.
> Also found this (forgot all about WebArchive!)
> http://web.archive.org/web/20050323020459/http://www.microsoft.com/sql/evaluation/features/choosing.asp
> It's slow, but it's the last version of the 2000 comparison page that was
> put up in March 2005 :)
> Dan
>

line to extend to edge of page when using a matrix

I have a few lines in my report page headers and

page footers. On the report I have a matrix, which extends the report horizontally across

two pages or more. How can I get the lines to extend to the edge of the

report?

i'm still having trouble with this, does anyone have any ideas?

line to extend to edge of page when using a matrix

I have a few lines in my report page headers and

page footers. On the report I have a matrix, which extends the report horizontally across

two pages or more. How can I get the lines to extend to the edge of the

report?

i'm still having trouble with this, does anyone have any ideas?

Line positions

Hi everyone,

I have kind of trouble with my report controls.I draw the lines and borders and they look OK on Report page at layout screen but on preview screen and trasported pdf documents i see that lines are not on the particular order or on position i designed(especilally control borders....)I've tried to look up reports on other computers too and i keep having the trouble.What could it be?Anyone has any suggestion?

Hi

Did you manage to get a solution with the layout rendering problem? I'm experiencing the same prob. Very annoying.

Help will be highly appreciated.

J

|||I have the same problem too

Line positions

Hi everyone,

I have kind of trouble with my report controls.I draw the lines and borders and they look OK on Report page at layout screen but on preview screen and trasported pdf documents i see that lines are not on the particular order or on position i designed(especilally control borders....)I've tried to look up reports on other computers too and i keep having the trouble.What could it be?Anyone has any suggestion?

Hi

Did you manage to get a solution with the layout rendering problem? I'm experiencing the same prob. Very annoying.

Help will be highly appreciated.

J

|||I have the same problem toosql

Line positions

Hi everyone,

I have kind of trouble with my report controls.I draw the lines and borders and they look OK on Report page at layout screen but on preview screen and trasported pdf documents i see that lines are not on the particular order or on position i designed(especilally control borders....)I've tried to look up reports on other computers too and i keep having the trouble.What could it be?Anyone has any suggestion?

Hi

Did you manage to get a solution with the layout rendering problem? I'm experiencing the same prob. Very annoying.

Help will be highly appreciated.

J

|||I have the same problem too

Line Chart used in Subreport ...

Hi,
I am using a Main report page which has different subreports and depending
on some data selection, I will show different sub reports.
But when I am using a line diagram in a sub report, this report will show
all the time. The same visible expression works fine on a sub report, which
has
only data values on.
Thanks for any help
RichardHi,
I found a solution by my self.
I just modify the database selection (via code) in that way, that the query
will not find data for this graph.
If anybody knows a better way, feel free to let me know .
Ritchie
"Ritchie" wrote:
> Hi,
> I am using a Main report page which has different subreports and depending
> on some data selection, I will show different sub reports.
> But when I am using a line diagram in a sub report, this report will show
> all the time. The same visible expression works fine on a sub report, which
> has
> only data values on.
> Thanks for any help
> Richard

Line between page columns?

Hi all,

My report's body section is split into 2 columns. I need to be able to add a vertical line to the dividing point of these columns so that it is visually more recognisable. How can I do this?

Thank you,

Stephen.

Any ideas? I am having real trouble with this.

Stephen.

Limiting Rows in a Report

I am having a table with 100 rows and i want to prepare a report in a
way that each page in the report want to display 10 rows in a page of
the report please say me the procedur for this .
thanks,
baba.If you have SQL 2K5, use ROW_NUMBER. If you're using SQL 2000, do a
self-join on the table. Here's a sample that runs on the Northwind DB:
SELECT COUNT(*) AS RowNumber, c.CustomerID, c.CompanyName, c.ContactName
FROM Customers c, Customers d
WHERE d.CustomerID <= c.CustomerID
GROUP BY c.CustomerID, c.CompanyName, c.ContactName
ORDER BY c.CustomerID
If you put this in a VIEW you can select where RowNumber between 1 and 10 to
grab the first ten; then RowNumber between 11 and 20 to grab the next 10,
etc.
"lucky" <j.v.s.s.baba@.gmail.com> wrote in message
news:1148564830.990338.67400@.j73g2000cwa.googlegroups.com...
>I am having a table with 100 rows and i want to prepare a report in a
> way that each page in the report want to display 10 rows in a page of
> the report please say me the procedur for this .
> thanks,
> baba.
>|||http://www.aspfaq.com/show.asp?id=2120
http://www.aspfaq.com/show.asp?id=2120
"lucky" <j.v.s.s.baba@.gmail.com> wrote in message
news:1148564830.990338.67400@.j73g2000cwa.googlegroups.com...
>I am having a table with 100 rows and i want to prepare a report in a
> way that each page in the report want to display 10 rows in a page of
> the report please say me the procedur for this .
> thanks,
> baba.
>

Limiting Rows in a Report

Hello,
i am in a problem that i am having a table with 100 rows while i am
presenting in report i want to limit rows to be 10 in a page in the
report like that i want to get 10 pages .Please say me the procedure
for this.
Thanks,
Baba.lucky (j.v.s.s.baba@.gmail.com) writes:
> i am in a problem that i am having a table with 100 rows while i am
> presenting in report i want to limit rows to be 10 in a page in the
> report like that i want to get 10 pages .Please say me the procedure
> for this.

I would suggest that you are better off asking this in a forum for the
report tool you are using. Surely you do not intend to requery the
database foe each page? Surely the report tool must permit you to define
a page size?

If the reporting tool is Reporting Services, tryu
microsoft.public.sqlserver.reportingsvcs.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx

Limiting no of rows in a page

Hi All
We have requirement where a user restrict no of rows which can be displayed
on a page on a report in this report we will be showing invoices for the
check on the top and corresponding check at the bottom. Here a user can set
no of invoices to be displayed on a page. This will always be less or equal
to actual limit which can be displayed.
For example we have 15 invoices but limit set to show on a page is 6 then
report should display only 6 rows in 1st page and another 6 on second page
and remaining on 3rd page.
Can any body let me know how can we restrict no of rows to be displayed on
single page. and also show check at the bottom.
Thanks in advance
Thanks and regds
Rehan Mustafa KhanI have placed several examples of this on www.msbicentral.com Go to
downloads,Reporting Services, RDL
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Rehan Mustafa Khan" <RehanMustafaKhan@.discussions.microsoft.com> wrote in
message news:E46DEAC4-A036-4D6B-9052-C2218B2ED052@.microsoft.com...
> Hi All
> We have requirement where a user restrict no of rows which can be
displayed
> on a page on a report in this report we will be showing invoices for the
> check on the top and corresponding check at the bottom. Here a user can
set
> no of invoices to be displayed on a page. This will always be less or
equal
> to actual limit which can be displayed.
>
> For example we have 15 invoices but limit set to show on a page is 6 then
> report should display only 6 rows in 1st page and another 6 on second page
> and remaining on 3rd page.
>
> Can any body let me know how can we restrict no of rows to be displayed on
> single page. and also show check at the bottom.
>
> Thanks in advance
>
> Thanks and regds
> Rehan Mustafa Khan
>

limited resultset without SP

I have a search query on my page. However, since the resultset may be very large, I want to retreive only those results that are currently shown on the gridview page.
Often a user won't browse through more than a couple of pages, so it's b-*** to send all the records to the client.
I know that with a sp you can define that you want to retrieve the first or second x records, but I want to do this with SQL...is that possible?You could put a TOP 100 or something in your search query and page them at the client side or if you want to use SQL to do the paging, you'd be doing the search over and over again for each page. You *could* get a few duplicate records. since, I am assuming you'd do a top 10 or 20 from the query to show them on the page and when you do the search again, you are starting fresh and there isnt an easy way to remember the previous search. unles you store the result set you first got into some table (you could put the spid in one column) and use the spid to get the next result set. Obviously you'd have to worry about cleaning up the table periodically in such a case.

Limit the number of records returned in Stored procedure.

In my ASP page, when I select an option from the drop down list, it has to get the records from the database stored procedure. There are around 60,000 records to be fetched. It throws an exception when I select this option. I think the application times out due to the large number of records. Could some tell me how to limit the number of rows to be returned to avoid this problem. Thanks.

Query

SELECT @.SQLTier1Select='SELECT * FROM dbo.UDV_Tier1Accounts WHERE CUSTOMER IN (SELECT CUSTOMERNUMBER FROM dbo.UDF_GetUsersCustomers('+CAST(@.UserIDAS VARCHAR(4))+'))'+ @.Criteria+' AND (number IN (SELECT DISTINCT ph1.number FROM Collect2000.dbo.payhistory ph1 LEFT JOIN Collect2000.dbo.payhistory ph2 ON ph1.UID = ph2.ReverseOfUID WHERE (((ph1.batchtype = ''PU'') OR (ph1.batchtype = ''PC'')) AND ph2.ReverseOfUID IS NULL)) OR code IN (SELECT DISTINCT StatusID FROM tbl_APR_Statuses WHERE SearchCategoryPaidPaymentsT1 = 1))'

Select the top 100 records:

SELECT TOP 100 *

Select the top 10% of the total number of records:

SELECT TOP 10 percent *

|||

Or if you want to retrieve a limited number of records, but not necessarily the top X records, you could use the row_number() function. For example, to retrieve records 250-299 you could try

 
1SELECT*
2FROM3(
4SELECT *, row = row_number()OVER (ORDER BY id)
6FROM yourtable
7) a
8WHERE rowBETWEEN 250AND 299
 

Limit rows to 25 in the body

Im trying to limit the body of the report to 25 rows before page break. Any help would be appreciated.

Hi, Erik,

Look for the Page Breaks section in this topic: http://msdn2.microsoft.com/en-us/library/ms157328.aspx

Download the latest Books Online update:
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx

This posting is provided "AS IS" with no warranties, and confers no rights.

Limit query results

Hello, I'm using MSSql and ASP
I need to create an ASP page with record pagination
I'd like to know which is the best technique to get the best performance
The ideal way I think should be something like the LIMIT clause for Mysql
In MSSql there is the TOP clause to get the first top n records but it's not
the same as LIMIT
Is there any other way?
I'm searching for an asp pagination class also, but I can't find it,
do you guys have one? or can you point me to any website?
ThanksCheck out this site for a number of approaches...
http://www.aspfaq.com/show.asp?id=2120
"Deniz" <dzoddi@.mvmnet.com> wrote in message
news:eXAOsi6QGHA.4608@.tk2msftngp13.phx.gbl...
> Hello, I'm using MSSql and ASP
> I need to create an ASP page with record pagination
> I'd like to know which is the best technique to get the best performance
> The ideal way I think should be something like the LIMIT clause for Mysql
> In MSSql there is the TOP clause to get the first top n records but it's
not
> the same as LIMIT
> Is there any other way?
> I'm searching for an asp pagination class also, but I can't find it,
> do you guys have one? or can you point me to any website?
> Thanks
>
>