Showing posts with label parameters. Show all posts
Showing posts with label parameters. Show all posts

Friday, March 23, 2012

Radio button

Hi,

I have one report,in my report i need to display parameters like this:

one radio button :Age and another radio button is Age Ranges

For the Age,I have to dispaly like two text boxes named 'From' and 'To'

For the Age Ranges,I have to display one drop down list contains values :20s,30s ..

In Reporting Services,Putting the Radio button is not possible,i think,If possible how to achive this.

Other workaround is i think Multivalued parameter which displays the Age and Age ranges

When we click on Age we need to display 2 textboxes

When we select Age Ranges we have to display Drop down list

If we select both :both 2 text boxes and drop down list.

Putting multi valued parameters for this requirement is not good and this is not the multi valued parameter concept.Please clarify me whether iam correct or not.

Thanks in advance

Your requirements go beyound the standard parameter prompts. Consider implementing a custom application to handle the parameters and use the ReportViewer controls to render reports.|||

Hi,

How to implement the custuom application,Please provide me the links.

Thanks in advance

|||http://www.devx.com/dotnet/Article/30424/0|||

Hi,

The article describing about the WinForms Report Viewer control. not the creation of custom application.

Thanks

|||By custom applications I meant WinForms or web-based applications you write. You can use the ReportViewers controls to render reports in custom .NET-based applications.

Tuesday, March 20, 2012

Quick start

What is the parameters for starting?&?stoping sqlserver?2005 from start/run or from the command prompt
i tried 'sqlservr' & it didn't work

You need the sqlcmd utility to connect to SQL Server 2005, the links below will take you in the right direction, but I know most companies will not let you run that utility on a production server because it is not needed. Hope this helps.

http://www.databasejournal.com/features/mssql/article.php/3566401

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

Friday, March 9, 2012

Quick question to check NULL values in input parameters in a stored procedure

Hi:

I have a stored procedure that calls 3 stored procedures. If some of my input parameters are NULL, I would like to skip the call to another stored procedure. Can you someone please help me with this? I would like to find out what is NULL, before I execute the other stored procedures. Thanks so much.

MA

check with is not null

example

If @.Var1 is not null
begin
exec proc1 @.Var1
end

If @.Var2 is not null
begin
exec proc2 @.Var2
end

If @.Var3 is not null
begin
exec proc3 @.Var3
end


Denis the SQL Menace
http://sqlservercode.blogspot.com/

|||Is there a way loop thru the parameters in one go, because in some instances I am dealing with a set of 50 or more parameters. Thanks.|||

something like this perhaps

declare @.v int
declare @.v2 int
declare @.v3 int


select @.v =1,@.v2 =3

if exists (select * from (select @.v as a union all
select @.v2 union all
select @.v3) z where a is null)
begin
print 'at least one parameter has a null value'
end

Denis the SQL Menace

http://sqlservercode.blogspot.com/

|||

Going back to your initial response, which I think I will respond as an Answer to my question, because it is my best bet at this moment. I do have a quick question in reference to your first response, here it is:

If I have more than parameters, that I need to check for NULL, and if its NULL then dont execute the SP, and vice versa, how would i do that? Can i do something like this, my goal is to check/validate that if all values passed in are NULL, then dont call the sp:

IF @.CitizenshipStatusCode is null and
@.GovtIDTypeCode is null and
@.AlienID is null and
@.EmploymentStatusCode is null and
@.EmployerName is null and
@.EmployerAddress1 is null and
@.EmployerAddress2 is null and
@.EmployerAddress3 is null and
@.EmployerCity is null and
@.EmployerStateCode is null and
@.EmployerZipCode is null and
@.EmployerCountryCode is null and
@.Position is null and
@.WorkForeignPhoneExchange is null and
@.WorkAreaCode is null and
@.WorkPhoneNumber is null and
@.WorkExtension is null and
@.WorkEmail is null and
@.EmploymentYears is null and
@.EmploymentMonths is null and
@.MonthlySalaryAmount is null and
@.MonthlyRentAmount is null and
@.OtherMonthlyIncome is null and
@.ResidenceTypeCode is null and
@.CreatedPersonID is null and
@.UpdatedOn is null and
@.CreatedPersonID is null and
@.UpdatedOn is null
BEGIN
Set @.IsNull = 1
END
ELSE
Set @.IsNull = 0

|||

you could use coalesce since coalesce returns the first non null value

examples

declare @.v varchar(40)
declare @.v2 int
declare @.v3 int

select @.v ='1',@.v2 =3
if coalesce(@.v,@.v2,@.v2,null) is null
begin
select 'is null'
end
else
begin
select 'is NOT null'
end
go

declare @.v varchar(40)
declare @.v2 int
declare @.v3 int

--will be null
if coalesce(@.v,@.v2,@.v2,null) is null
begin
select 'is null'
end
else
begin
select 'is NOT null'
end

Denis the SQL Menace

http://sqlservercode.blogspot.com/

|||thanks I think this is what I can use. Also, why do you have the word null at the end, inside the parantheses. Is that necessary? Whats the purpose of that?|||It is not necessary to have NULL at the end. If all of the inputs to COALESCE is NULL then it will return NULL anyway.

Wednesday, March 7, 2012

Quick custom security question

I am trying to implement some type of security based on the user, the
report, and what parameters the are supplying.
So lets say that I have a report called "Salary Report" that shows
employees salary and bonus data. The people who can run the report
with Department = 1 are not allowed to run the report as Department = 2.
Previously I believe the answer was to use the "UserId" in my reports,
which would be populated with the current users Username, but we
already have a very complex system for determining peoples rights to
different things on our intranet site.
People can delegate rights to others, people get rights based on their
project assignments, people get rights based on their position in the
company, people get rights based on who they report to, and who reports
to them, and on and on.
So all I need to know to validate is username (or userID), what report
they are running, and what parameters they are supplying.
Is there any way to do this?Would a query based parameter work for you where you use a stored procedure
to return a list of valid parameters that they can use for that report based
on who they are and what rights they have inherrited?
Steve MunLeeuw
"cmay" <cmay@.walshgroup.com> wrote in message
news:1161293948.030847.304270@.m73g2000cwd.googlegroups.com...
>I am trying to implement some type of security based on the user, the
> report, and what parameters the are supplying.
> So lets say that I have a report called "Salary Report" that shows
> employees salary and bonus data. The people who can run the report
> with Department = 1 are not allowed to run the report as Department => 2.
> Previously I believe the answer was to use the "UserId" in my reports,
> which would be populated with the current users Username, but we
> already have a very complex system for determining peoples rights to
> different things on our intranet site.
> People can delegate rights to others, people get rights based on their
> project assignments, people get rights based on their position in the
> company, people get rights based on who they report to, and who reports
> to them, and on and on.
> So all I need to know to validate is username (or userID), what report
> they are running, and what parameters they are supplying.
> Is there any way to do this?
>

Monday, February 20, 2012

Questions on Report Delivery

I am currently moving a client from Crystal Reports to SSRS. Is it possible
with Report Delivery to have a report run with different parameters each
time and then emailed to a remote office?
ex. A batch listing of all deposits. In January it prints a listing of all
deposits for the month of January. In February, March etc. Can a report be
used for Report Delivery, be based on different parameters each time it is
printed? Or to have a report for January sent to the Houston showing all
deposits for the Office "HN" and a report sent to the Detroit office showing
all deposits for the Office "DT' etc?
Billhave a default parameter with query based on current month,
Go to Parameters, Default value > Query or Nonqueried > Month(Now)
On Apr 20, 1:14 am, "BillG" <billgo...@.charter.net> wrote:
> I am currently moving a client from Crystal Reports to SSRS. Is it possible
> with Report Delivery to have a report run with different parameters each
> time and then emailed to a remote office?
> ex. A batch listing of all deposits. In January it prints a listing of all
> deposits for the month of January. In February, March etc. Can a report be
> used for Report Delivery, be based on different parameters each time it is
> printed? Or to have a report for January sent to the Houston showing all
> deposits for the Office "HN" and a report sent to the Detroit office showing
> all deposits for the Office "DT' etc?
> Bill