parameter properties in report manager - "Has Default"

ok I've designed a report template that uses cascading paramters based
on several sp's. The user selects a value for the first parameter and
that value is passed to the sp that populates the second parameter
list. The value selected for the second param is used to populate the
third param list etc...
I want the first parameter to be required and the other 3 to be
optional - the report should still run if they are not selected. RS
BOL told me to go into the Report manager, select "Properties"
then"Parameters" and then select the "Has Default" check box for the
three optional paramters. This in turn enables the "Null" checkbox, so
I checked that box so null will be the default value passed if these
parameters are not selected.
By all accounts this should allow the report to run with only the first
parameter selected, but when run from Report Manager it still keeps
prompting the user to enter values for the 3 other optional parameters.
Any ideas? help?Never mind! found a workaround...

param into xsl in an xml template query

Is it possible to pass a parameter to the *xsl* in a template query?
- i dont mean to the sql - thats easy - i want to pass a param to the xsl.
TIA
Paul
pauly wrote:
> Is it possible to pass a parameter to the *xsl* in a template query?
> - i dont mean to the sql - thats easy - i want to pass a param to
> the xsl. TIA
> Paul
I have a sneaky feeling i've asked this before... and the answer was 'no' -
the only way of getting other information to the xsl is to get it into the
xml itself, via sql:param.
However if anyone knows a way of doing what i'm asking, i'd love to know!
Paul
|||Hi,
i make this from MSXMLDOM.
i load a XSL stylesheet into an XML DOM object and set param value with
VBScript or VB6 Etc...{use it in extended proc ?!}
an other way is loading XSL in MSXML.template DOM Object with param in url
like this
MySteelsheet.xsl?param1=toto
in the steelshet after the root node steelsheet write one param node named
param1
i dont have testing this but it is in my book "Wrox XSLT second edition"
i hope to help you.
Boss Hog
PS:excuse my english but i'm poor lonesome frenchy...lol
"pauly" <paulyateswithoutthespam@.hotmail.com> wrote in message
news:2rqj73F1cis87U1@.uni-berlin.de...
> Is it possible to pass a parameter to the *xsl* in a template query?
> - i dont mean to the sql - thats easy - i want to pass a param to the
xsl.
> TIA
> Paul
>
|||"pauly" <paulyateswithoutthespam@.hotmail.com> wrote in message
news:2rqj73F1cis87U1@.uni-berlin.de...
> Is it possible to pass a parameter to the *xsl* in a template query?
> - i dont mean to the sql - thats easy - i want to pass a param to the xsl.
Not directly. But why not just pass the values as part of the XML?
Bryant
|||hi,
of course it is possible to set param in XML file transformed by XSL.
@.+
Boss Hog
"Bryant Likes" <bryant@.suespammers.org> wrote in message
news:uRsqykNpEHA.2068@.TK2MSFTNGP09.phx.gbl...[vbcol=seagreen]
> "pauly" <paulyateswithoutthespam@.hotmail.com> wrote in message
> news:2rqj73F1cis87U1@.uni-berlin.de...
xsl.
> Not directly. But why not just pass the values as part of the XML?
> --
> Bryant
>
sql

paging problem

hi sir

i am using datagrid inbulit pageing.my page size 5.i have 100 records.i have one template column checkbox .when i check 4 records of first page then move to next page then prv page checkbox checked removed how i presit the provies state of datagrid.

Regards

Irvendeep

It sounds like you are refreshing the data in your grid for each page that you navigate to. The changes that you make are not sent to SQL Server until you tell your application to send them. If you don't send the changes to SQL Server before you refresh your result set, then anything you changed in the data grid will get thrown away.