Disabling report processing

Hi
I have to disable report processing at certain times for some reports. It's
like when you don't have selected a value in a combo parameter. I have a
function that returns true if you can view the report or false if don't.
Any ideas?
AndrésWhen you configure your parameter, ensure you do not allow null.
-Lukasz
This posting is provided "AS IS" with no warranties, and confers no rights.
"afontan" <andres.fontan@.alcuadrado.com> wrote in message
news:%23Itbbo1eEHA.2848@.TK2MSFTNGP10.phx.gbl...
> Hi
> I have to disable report processing at certain times for some reports.
> It's
> like when you don't have selected a value in a combo parameter. I have a
> function that returns true if you can view the report or false if don't.
> Any ideas?
> Andrés
>

Disabling One Input Parameter...?

Hi All,
I am creating a report which calls for four input parameters A, B, C, and D.
How can I disable D if A, B, and C are selected or disable C if A, B, and D
are selected?
Thx, ChuckThis is not supported. The only way to achieve this right now is to
implement your own front end application which handles the parameter UI and
then e.g. uses SOAP or URL-access to pass the "validated" parameters to the
report server.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Chuck" <Chuck@.discussions.microsoft.com> wrote in message
news:32F07069-7C11-4608-9E86-68796ED25A99@.microsoft.com...
> Hi All,
> I am creating a report which calls for four input parameters A, B, C, and
> D.
> How can I disable D if A, B, and C are selected or disable C if A, B, and
> D
> are selected?
> Thx, Chuck|||Set a table up in your database called "NILL" with a column called "NILL"
as well. Use the from query section in the report parameters and create a
query which points to this table. Set your Non-queried Default value to
NILL.
Create a dataset for each report parameter. Some duplication, but is quick
and it works. Have done it for database table and columns names where one
or more can be selected and the column info is passed back as a results
alias and is returned independently of the other report parameters.
Eg. DBTableNames
Select Name, Id
From sysobjects where xtype ='U'And ID <> 197555541
Order by Name
DBTablesColNames relys on a tablename to be selected before the report will
allow the selection of a column
Select Name
From syscolumns
Where id = (Select Id
From sysobjects
Where xtype = 'U' AND Name = @.DBName)
** @.DBName = Parameters!TableParameter.Value **
I had to implement custom code in order for this to be of benefit.
Eg. Dataset CustomSQL
= Code.GetSQL(Parameters!TableParameter.Value, Parameters!
ColumnParameter.Value, Parameters!EndDate.Value, Parameters!Interval.Value,
Parameters!NoOfIntervals.Value)
As you can see from the dataset CustomSQL this is one of my so called
"Adhoc Reports" which allows the user to choose a database table and one of
its columns with a given date, an iterval (ie. Daily, Monthly etc), and the
No. of intevals. I have three tables on the report page that each call this
dataset passing in their own report parameters.
Note you have to manually set the name and database feild under "Fields" to
Results to get any data back

Disabling AutoRendering for Reports with Default Parameters

I have a report with default parameters. Every time the report is selected,
it automatically renders the report using the defaults. Is there any way to
disable the AutoRendering feature so my users can choose to override the
report's defaults and then render the report manually?
--
Jay P. Meredith
Senior Software Engineer
Columbia Helicopters, Inc.
PO Box 3500
Portland, OR 97208Just a stab, but maybe worth trying... What if you add a hidden parameter
which has no default value, and is not used... That might prevent
auto-render, and force the user to select the view report button... ( I
don't know what potential bad side effects might occur tho...)
--
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
"Jay Meredith" <JayMeredith@.discussions.microsoft.com> wrote in message
news:5E0D389A-8EE3-417B-A658-8DFCBD01D483@.microsoft.com...
>I have a report with default parameters. Every time the report is
>selected,
> it automatically renders the report using the defaults. Is there any way
> to
> disable the AutoRendering feature so my users can choose to override the
> report's defaults and then render the report manually?
> --
> Jay P. Meredith
> Senior Software Engineer
> Columbia Helicopters, Inc.
> PO Box 3500
> Portland, OR 97208|||Wayne,
A hidden parameter with no default value will cause the report not to render
at all. After all, if it has no default, it has to be told what its value
is. And if the user can't see it to choose a value, then the report will
just sit there, waiting for input.
The only way I've found against AutoRender when the report is first open is
to leave one of my parameters with no default, forcing the user to make a
choice on it.
BLARGH... It would be nice if RS was old enough that someone else had all
the answers and we didn't have to be the ones to find out the answers the
hard way. @.=/
Catadmin
--
MCDBA, MCSA
Random Thoughts: If a person is Microsoft Certified, does that mean that
Microsoft pays the bills for the funny white jackets that tie in the back?
@.=)
"Wayne Snyder" wrote:
> Just a stab, but maybe worth trying... What if you add a hidden parameter
> which has no default value, and is not used... That might prevent
> auto-render, and force the user to select the view report button... ( I
> don't know what potential bad side effects might occur tho...)
> --
> 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
> "Jay Meredith" <JayMeredith@.discussions.microsoft.com> wrote in message
> news:5E0D389A-8EE3-417B-A658-8DFCBD01D483@.microsoft.com...
> >I have a report with default parameters. Every time the report is
> >selected,
> > it automatically renders the report using the defaults. Is there any way
> > to
> > disable the AutoRendering feature so my users can choose to override the
> > report's defaults and then render the report manually?
> > --
> > Jay P. Meredith
> > Senior Software Engineer
> > Columbia Helicopters, Inc.
> > PO Box 3500
> > Portland, OR 97208
>
>|||Leaving one or more unhidden parameters without defaults seems to be the best
compromise. In defaulting all parameters, I was trying to save the user a
few keystrokes. Thanks.
--
Jay P. Meredith
Senior Software Engineer
Columbia Helicopters, Inc.
PO Box 3500
Portland, OR 97208
"Catadmin" wrote:
> Wayne,
> A hidden parameter with no default value will cause the report not to render
> at all. After all, if it has no default, it has to be told what its value
> is. And if the user can't see it to choose a value, then the report will
> just sit there, waiting for input.
> The only way I've found against AutoRender when the report is first open is
> to leave one of my parameters with no default, forcing the user to make a
> choice on it.
> BLARGH... It would be nice if RS was old enough that someone else had all
> the answers and we didn't have to be the ones to find out the answers the
> hard way. @.=/
> Catadmin
> --
> MCDBA, MCSA
> Random Thoughts: If a person is Microsoft Certified, does that mean that
> Microsoft pays the bills for the funny white jackets that tie in the back?
> @.=)
>
> "Wayne Snyder" wrote:
> > Just a stab, but maybe worth trying... What if you add a hidden parameter
> > which has no default value, and is not used... That might prevent
> > auto-render, and force the user to select the view report button... ( I
> > don't know what potential bad side effects might occur tho...)
> >
> > --
> > 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
> >
> > "Jay Meredith" <JayMeredith@.discussions.microsoft.com> wrote in message
> > news:5E0D389A-8EE3-417B-A658-8DFCBD01D483@.microsoft.com...
> > >I have a report with default parameters. Every time the report is
> > >selected,
> > > it automatically renders the report using the defaults. Is there any way
> > > to
> > > disable the AutoRendering feature so my users can choose to override the
> > > report's defaults and then render the report manually?
> > > --
> > > Jay P. Meredith
> > > Senior Software Engineer
> > > Columbia Helicopters, Inc.
> > > PO Box 3500
> > > Portland, OR 97208
> >
> >
> >|||Always glad to be of assistance. @.=)
Catadmin
"Jay Meredith" wrote:
> Leaving one or more unhidden parameters without defaults seems to be the best
> compromise. In defaulting all parameters, I was trying to save the user a
> few keystrokes. Thanks.
> --
> Jay P. Meredith
> Senior Software Engineer
> Columbia Helicopters, Inc.
> PO Box 3500
> Portland, OR 97208
>
> "Catadmin" wrote:
> > Wayne,
> >
> > A hidden parameter with no default value will cause the report not to render
> > at all. After all, if it has no default, it has to be told what its value
> > is. And if the user can't see it to choose a value, then the report will
> > just sit there, waiting for input.
> >
> > The only way I've found against AutoRender when the report is first open is
> > to leave one of my parameters with no default, forcing the user to make a
> > choice on it.
> >
> > BLARGH... It would be nice if RS was old enough that someone else had all
> > the answers and we didn't have to be the ones to find out the answers the
> > hard way. @.=/
> >
> > Catadmin
> > --
> > MCDBA, MCSA
> > Random Thoughts: If a person is Microsoft Certified, does that mean that
> > Microsoft pays the bills for the funny white jackets that tie in the back?
> > @.=)
> >
> >
> > "Wayne Snyder" wrote:
> >
> > > Just a stab, but maybe worth trying... What if you add a hidden parameter
> > > which has no default value, and is not used... That might prevent
> > > auto-render, and force the user to select the view report button... ( I
> > > don't know what potential bad side effects might occur tho...)
> > >
> > > --
> > > 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
> > >
> > > "Jay Meredith" <JayMeredith@.discussions.microsoft.com> wrote in message
> > > news:5E0D389A-8EE3-417B-A658-8DFCBD01D483@.microsoft.com...
> > > >I have a report with default parameters. Every time the report is
> > > >selected,
> > > > it automatically renders the report using the defaults. Is there any way
> > > > to
> > > > disable the AutoRendering feature so my users can choose to override the
> > > > report's defaults and then render the report manually?
> > > > --
> > > > Jay P. Meredith
> > > > Senior Software Engineer
> > > > Columbia Helicopters, Inc.
> > > > PO Box 3500
> > > > Portland, OR 97208
> > >
> > >
> > >

Disable and/or Hide Parameters

Is it possible to conditionally disable or hide parameter prompts, depending
on other already selected parameter values? For example, if I have two
parameters p1 and p2, is it possible to somehow disable or hide p2 if
P1="Yes"? Also, is it possible to conditinally set the default value of a
parameter, based on the user-selected value of another parameter? for ex: If
P1="YES", set default value of P2
to "2005"
Thanks in advanceSorry, conditionally hiding parameters dependent on other parameters values
is not supported natively at this point. The closest you can get right now
is to write your own custom parameter application that knows about your
business logic and once all parameters are satisfied, you use a SOAP call
(or URL access) to trigger the rendering of the report.
Adding the ability to conditionally hide parameters is a good suggestion and
it is under consideration for future releases.
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"isaak" <isaak.peretsman at usa.dupont.com (no spam)> wrote in message
news:F0F8CE1D-6A38-4821-AEBA-30EA647CA913@.microsoft.com...
> Is it possible to conditionally disable or hide parameter prompts,
> depending
> on other already selected parameter values? For example, if I have two
> parameters p1 and p2, is it possible to somehow disable or hide p2 if
> P1="Yes"? Also, is it possible to conditinally set the default value of a
> parameter, based on the user-selected value of another parameter? for ex:
> If
> P1="YES", set default value of P2
> to "2005"
> Thanks in advance