Filters Whith Diferent Values (parameters)

Apr 11, 2006

I want to make a filtering by using a string parameter (a,b).
The initial result of my query is this:

Name Letter
Luis a
Juan b
Michel c

Note: There are 2 columns (Name) and (letter)

So after filtering the result pane should be like this

Name Letter
Luis a
Juan b

If i send a diferent filtering parameter (b), the result should change like this

Name Letter
Juan b

How can I do this??

Thyanks

View 2 Replies


ADVERTISEMENT

Calculating Textboxes Values Grouped In Diferent Lists

May 7, 2007

I have to Lists filtered by the same field. One List shows all records with the field IsClokedIn value = TRUE and the other list =FALSE. I have only one dataset that retrieve the ClockIn and Clock out for one user. In a perfect world, the user MUST clock in and always clock out. So, when i created my dataset i ordered by UserClockingID (whick is primary key). So, this MUST retrieve a dataset with alternate records IN / OUT (TRUE or FALSE)

Ex.

UserClokingID UserID Time IsClockedIN

2323 34 8:32:03 TRUE

2324 34 12:07:02 FALSE

2325 34 13:05:03 TRUE

2326 34 14:53:02 FALSE

2327 34 15:10:03 TRUE

2328 34 17:32:02 FALSE



All i need is to calculate (sum then divide by 60) the minutes returned by the method DateDiff between the first row in my TRUE filtered list and the first row in my FALSE filetered list... and so on for the 2nd, 3rd ..... I can get the minutes by taking the values directly from the Fields!IsClockedIn.Value and using a condition to "grab" the previous record if the current record ClockedIn.Value=FALSE. I already did that.

my problem is that when i try to perform a calculation of textboxes values(those with the ammount of minutes for every pair of records from the datalist) out of the group. It says you can only do that inside the group or dataregion.

Is there any work around?



I really need to get this solved.

View 2 Replies View Related

Query Parameters Vs.Filters

Mar 23, 2008

I am developing a summary report that will have multiple tables, charts and matrixes, all using the same set of data. However, one table may only show one month of data while another will show three months. If they all use the same Dataset with the same data parameters, is the data only pulled once? And then each component can use Filters to further refine the data? If this is true, this would seem to be the best option.

Or does each report component execute the query independantly?

Before I get too far down the road developing this report, I'd like to know the best way to do it from the beginning.

Thank you for your input.

Rob

View 3 Replies View Related

Reporting Services :: Linking Parameters With Filters

Oct 16, 2015

I am creating a dashboard. It has two charts. One will utilize 'calendar year' data and other utilizes 'Fiscal Year' data.

I have 'CY start date', 'CY end date','FY start date', 'FY end date', 'Reference Date' columns in my data set.

I have a report parameter of date type that the user selects. When the user selects the date, I have to display the corresponding 'Fiscal Year' data for the entire year.

My question is, how can i filter the data set based on 'FY start date', 'FY end date' field values when i have only one Date parameter.

How can i get these data set field values based on parameter.

View 6 Replies View Related

Reporting Services :: Passing Parameters Or Filters On Action

Sep 21, 2015

I have a 2 reports A and B.A is a dashboard with graphical objects like graphs and pie charts.B is a simple table with the base data used in A (see it as the factual table data)I would like to click on any of the objects on A and pass them into B BUT I don't want to use extra parameters on B.Is it possible somehow to pass the valued from A to B using action and then use this as filters of the table in B instead of forcing me to create parameters in B?

View 3 Replies View Related

Filters && Parameters Pane Missing In MDX Query Designer

Mar 13, 2007

I'm developing my first Analysis Server report in SRS. Everything was going well when I discovered the filters & parameters pane was missing in the MDX Query Designer in data mode. I have my columns and rows but need to drag a dimension into the filters & parameters pane in MDX Query Designer and set a filter and parameter on it. Any idea how to make it viewable?

View 1 Replies View Related

Filters && Expression With String Values, Should They Work??

Dec 7, 2007

Any idea why this expression would not work in SSRS?

Based on a expression on a group textbox I get 0 records that match:
=Iif(Fields!ACCRUAL_CODE.Value <> "A", CountDistinct(Fields!LOAN_NBR.Value), 0)



I've evaluated in the proc & there should be a count of 29 records.

I found a work around by using this in the stored proc & I get my record count:


ACCRUAL_CODE = CASE WHEN BASE.ACCRUAL_CODE = 'A' THEN 0 ELSE 1 END

and changed the expression in SSRS to this & it works:
=sum(Fields!ACCRUAL_CODE.Value)



Is this a known issue with strings? From searching on this site I see that string evaluations are widely used so I do not see why it wouldn't work. I've also see this when filtering the dataset on anything that is a character. Any suggestions?

View 3 Replies View Related

Reporting Services :: Selecting Multiple Parameters Values For Comma Separated Values In SSRS?

Jun 17, 2012

I am SSRS user, We have a .net UI from where we want to pass multi select values, but these values are comma separated in the database. how can I write a sql query such that when I select multi values on my UI, the comma separated values are take care of.

View 5 Replies View Related

SQL 2012 :: Find Out Values Of Parameters When SP Is Executed With Default Values?

May 30, 2014

I am working with SP. How can we find out values of parameters when the SP is executed with the default values?

View 9 Replies View Related

Default Values Does Not Include All The Values (Cascading Parameters)

Mar 18, 2007

A have a multi-valued parameter (B) which is dependent on a single-valued parameter (A) on my report. When a value is selected in A, I want all matching values in B to be selected by default and the "Select All" option checked. To do this I have set the Default Values section in B to point to the same dataset as the "Available Values" section. Both A and B have default values so the report runs automatically.

One of the values in parameter A (say Value1) yields more values in parameter B than the other (say Value2).

If I run the report the first time with Value1 selected as the default for parameter A, all values in B are checked correctly. If I run the report with  Value2 selected the first time and then change the selected value to Value2 and run my report, all values in B are displayed but only the values that were previously checked (when Value1 was selected), are now checked, leaving the "Select All" unchecked.

What am I doing wrong? Why are all the values in B not checked? The dataset is the same in "Available Values" section and "Default Values" section.

 

View 8 Replies View Related

SQL Compactible Whith Vista?

Apr 26, 2008



hi
Let me know SQL 2005 can be installed on Vista?

View 10 Replies View Related

How To Unzip A File Whith Transact Sql

Feb 19, 2004

Do U know how to unzip a file with T/SQL?
thanks in advance,

View 6 Replies View Related

Problem Whith Insert Into SQL Server From Webservice

Jan 21, 2004

My webservice is suppoed to insert a row into my SQL server database. Al columns are varchar(String). When we insert with digits everything is ok, but when we try letters as parameters i get this error message:

"An unhandled exception of type 'System.Web.Services.Protocols.SoapException' occurred in system.web.services.dll

Additional information: Server was unable to process request. --> The name 'Bob' is not permitted in this context. Only constants, expressions, or variables allowed here. Column names are not permitted."

Any idea?

View 3 Replies View Related

Diferent Between Sql 2005 X86 And X64 ?

Jun 16, 2007

I have  AMD X2 64 bit processor, and try to install sql server 2005 developer edition. Which one should I choose x86 or x64 ?Is there a problems if I migrating file database from x86 platform to x64 and from x64 to x86 ? thanx 

View 3 Replies View Related

SQL Interation Of Diferent Colections

Jul 10, 2007

Hi,



My name is daniel ledesma, I have a little problem here...



How I can make so that two different collation' s in different languages, interact to each other, with no need to change constantly configuration to the PC (Software or Hardware)?

These two collation' s are Moder Spanish and Chinese.



Please... is URGENT I NEED HELP!!!

View 6 Replies View Related

What Are The Diferent Types Of Replication In SQL Terms ?

Mar 7, 2008



I want to know about types of replications used in SQL environment ?

View 3 Replies View Related

Making A Select Between Two Diferent SQL Servers...Urgent Please Help

Mar 16, 2004

Hi there friend...I'm in a midle of a program(vb.net). and i've got this problem, I've got do compare two tables from two diferent sql servers. Is this possible??? How can I do this???

Please, this is really urgent.

Thank you for your attention

View 2 Replies View Related

Dts Parameters, More Values In One Parameter

Feb 21, 2007

hy all,

i'm using the object transform data task from a server (where i'm not dbo) to another server (where i'm dbo).

i'm getting data from a table. i need to select just some records from this table. i need to use a query like this one below...

select * from {table_name} where operationedate in ('20070101', '20070205', '20060524')

... cause everytime i run the dts the operationdate field must be filtered on different date.

so i tried to use the parameter from a global variables. i've tried lots of things but everytime i failed.

i used to try:

select * from {table_name} where operationedate in (?)

but it doesnt work!

any one can understand what i try to explain and even help me?

bye

nicola

View 7 Replies View Related

Assigning Values To Parameters Dynamically

Oct 25, 2006

i using a bound data grid which is using a stored proc. The stored proc needs the ClientID "if logged in" there is no form or control on the page outside of the loginstatus.  I am wanting to pass the Membership.GetUser.ProviderUserKey.ToString()  to the asp:parameter but I cant get it to work.So How do I pass a variable to a stored proc parameter using a bound data grid.I this its very strange that this cant be dont and there are a raft of reason why you wold want to do this with out the need to pass it to a form control.please helpjim

View 2 Replies View Related

Parameters - Multiple Values For One Label - Possible?

Sep 18, 2007



Is it possible to have a parameter with one label but multiple values. For example:

Label Value
---------------------------------------------

Machinist (100,200,300)



Is it possible to set up an expression that when the user selects this label it will look for the job codes 100, 200 and 300
and return all employees in those codes?

Thanks,
A

View 2 Replies View Related

Values In Define Query Parameters Box

Nov 21, 2007

How do I create value from the dropdown list of each parameter within the "Define Query Parameters" box, which appears when I run a query/dataset from the "Data" tab of the SSRS Report Designer ?

It usually list all the "Parameter Name"s I defined, and has another column for "Parameter Value", but it always shows only <Null> or <Blank> even though I have assigned the report parameters with data (from a Query, not hard coded).

The parameter values work fine when in "Preview" mode, but it would be of convenience to have them during design time.

Thanks in advance.

View 7 Replies View Related

Parameters With Multiple Values Error

Apr 4, 2008

Hello,

Using a Report Designer of the SQL Server 2008 connecting to an ORACLE database:

- I want to use Parameters filters with multiple Values but i get the error :

"FilterExpression for the data set 'DATAset1' cannot be performed. Cannot compare data of types System.String and System.Object[]. Please Check the Data Type Returned by the FilterExpression"


without the multiple Values it works but don't resolve my problem.

The filter configuration is =Fields!DT_OPERACAO.Value = =Parameters!FLT_Ano_Lectivo.Value


how can i solve this situation ?

View 3 Replies View Related

Updating/getting Values From Datagrid In C# With Variable Parameters

Oct 24, 2006

HiI am new to the world of aspx, .net and C#.In aspx .net 2.0. I am trying to work out how to get a datagrid to perform an update. Using Visual Developer I have successfully added the control and specifed a select statement to return data via my SQLData Source. This works fine. However having specifed the control as editable I would like to perform an update through the datagrid and SQLDatasource. I see in the properties for the SQLDatasource object I can specify my update statement.However I do not understand how to get that update statement to have variable values and how newly entered values from the grid can be placed into these variables when the update takes place. Can someone please point me in the right direction? I have not found the MS doc very illuminating thus far and have not found any examples.Many ThanksT

View 1 Replies View Related

Passing Multiple Values To A Single Parameters

Dec 28, 2007

I have a SQL query that goes like this
"select * from Product where ProductID in (1,2,3)"
How can i create a stored procedure where a single input parameter can take multiple values?
Can anyone help me with this?

View 4 Replies View Related

Can You Force A Refresh Of The Default Values Of Your Parameters?

Aug 1, 2006

This is regarding Report Services 2005 designing the report in Visual Studio.

Currently I am using a query to populate 2 date selectors in the parameter section at the top of a report.  The start and end dates are determined by a query which returns the values based on yet another parameter.  If I change the value of the paramter which is supposed to be used by the date selectors they don't seem to feel the need to re-calc themselves.  I have 3 other dependent param's in the same report which behave reasonably.

Has anyone seen this before or is there way to somehow force a parameter re-caluclation?

 

jSiegel

 

View 1 Replies View Related

How To Get The Values From Dataset To Parameters On Report Header

Mar 13, 2008



Is it possible to get the reportdataset field values into parameters. dynamically when the report is generated.

Thanks.

View 1 Replies View Related

Store Into Database Report Parameters Values?

Feb 3, 2007

Hallo
is it possible to perform an insert/update query upon the execution of a report, using the report Visual Basic expressions?
I mean, the user enters some values for the report parameters, and i would like to store them, along with the resulting recordset data, into a dedicated table in the database.

View 1 Replies View Related

Cascading Parameters With Values Supplied By Query

Feb 11, 2008



Hi,

I would like to set up cascading report parameters but need to supply the list of values in my dataset query as they are not being pulled from a table or stored procedure.

I would like to set up something like

select 'LS' Source
Union
select 'RH' Source
Union
select 'UK' Source

as the value list for my first parameter, then, I would like the second parameter to default to '1' if the first parameter has 'RH' or 'UK' selected but default to blank if the first parameter has 'LS' selected. I can get all to default to blank or 1 but can not seem to make it dependent.

thanks!

Martha

View 2 Replies View Related

SqlDecimal Function Parameters With NULL Values

Oct 4, 2007

Hi,

I have a CLR function that throws an error if one of the parameters is NULL. Am I using the IsNullable tag correctly or am I supposed to do this another way? The function simply formats decimal values using .NET culture information and returns a string. Thanks very much for any help. -- Erik


[Microsoft.SqlServer.Server.SqlFunction(IsDeterministic=true, DataAccess=DataAccessKind.None)]

[return: SqlFacet(MaxSize = 30, IsNullable=true)]

public static string FormatGeneralDecimal([SqlFacet(Precision = 28, Scale = 8, IsNullable = true)] SqlDecimal sqlDc,

[SqlFacet(MaxSize = 10)] string cultureName)

{


string result = null;

if (!sqlDc.IsNull)

{


CultureInfo ci = CultureInfo.CreateSpecificCulture(cultureName);

result = sqlDc.Value.ToString("G", ci);

}


return result;

}

It works great unless I call it with a NULL value for sqlDc, in which case I get this:


select [dbo].[FormatGeneralDecimal](NULL, 'de-DE')



Msg 6522, Level 16, State 2, Line 1

A .NET Framework error occurred during execution of user-defined routine or aggregate "FormatGeneralDecimal":

System.Data.SqlTypes.SqlNullValueException: Data is Null. This method or property cannot be called on Null values.

System.Data.SqlTypes.SqlNullValueException:

at System.Data.SqlTypes.SqlDecimal.ToDecimal()

at System.Data.SqlTypes.SqlDecimal.get_Value()

at MyFunctions.FormatGeneralDecimal(SqlDecimal sqlDc, String cultureName)

View 1 Replies View Related

Setting The Range Of Values For SSRS Parameters

May 8, 2007

Hoping someone may be able to help with a problem I'm having with SSRS parameters....

My report has 2 parameters - the User Id used to login to the application and the Department(s) within the organisation. Based upon the User's role, the user may have access to data for one or many Departments.

Thus, the first parameter needs to be set in code based upon the User's login, however, the range of the second parameter (i.e. the range of Departments that the user can access) is controlled by the value of the first parameter.

The second parameter is to appear as a drop-down of Departments to which the User has access.

The report is to be produced for the selected Department.

Are you able to advise how to restrict the range of values for the second parameter based upon the value of the first parameter?

Any help is much appreciated.

View 3 Replies View Related

Use Of Parameters To Hide Column Values Of A Report

Oct 10, 2007



HI All,

I want to send a reports to two person. Reports are going to be delivered automatically. I hope to use snapshot option. In my report there is one column which can be seen by only one person. Can I use parameters to hide one column from one person? If its possible, can you explain how to do that please. If its not possible, what are the other option excet creating two different reports.
Also If I use parameters , can reports be executed automatically?
Thanks

View 2 Replies View Related

Urgent... Report Parameters Not Retaining Values

Sep 17, 2007

Hi all,
I've developed few reports
I'm passing values to few parameters in a report from menu report.
when I click on "View Report" button values are changed to default for parameters eventhough I've not changed specifically any values for parameters. thus report is missing few parameters and not able to execute properly..
this error occurs only in web environment.. after publishing reports.. they are working fine in developer suite(Visual Studio)

please suggest any ways to overcome this issue..

seniors.. pls throw some light ..


thanks in advance

View 1 Replies View Related

SQLDataSource - How To Retreive The SQL Select Statement With The Values Of The Parameters

May 1, 2007

Is there a way to retreive the SQL Statement with the values from the parameters merged together? I know how to retreive the SQL Select Statement and the parameters separately but I need to retreive the final SQL.
For example:
SELECT name FROM employee WHERE id = @id
I would like to retreive from SQLDataSource
SELECT name FROM employee WHERE id = 1
 
Thank you

View 4 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved