Why I Cannot Easily Change The Value Of Parameter?
Aug 19, 2006
Hi all,
I read the Tang and Lennan's book 'SQL Server 2005 Data Mining'. It frequently says
about changing the value of the algorithm's parameter. I tried changing values for
MINIMUM_PROBABILITY in one occasion. However, the dialog box refuses to
change the value; for any of 'Value', 'Default', and 'Range'. Similar thing happens
when I tried to change the value.
What I can do is delete the parameter, then add it again. Even so, I can only supply
the value, not the default value and range (of values).
What happen? Again, is this because I'm using evaluation copy?
Thank you,
Bernaridho
View 3 Replies
ADVERTISEMENT
Dec 19, 2001
Hiya!
I'm developing an app. using SQL Server 7 (as the back end) for a company supporting approx. 200 unrelated clients, all in different locations. There is no LAN or WAN connection between them, so we'd probably need to use TCP/IP. The problem is as follows: We have dynamic reports in our app. which are run based on data in two tables. Whenever we add a new report we'd like to send it to all of our clients i.e. update their tables to reflect the additional rows of new report info. How would this best be handled, by DTS or Replication or BCP? And how could it be done with either?
Thanks,
Sarah
View 3 Replies
View Related
Jan 15, 2003
Based on the discussion at:
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=23038
and BSmith's idea (no relation), I came up with this silly stored proc to compare any two tables or views. Supply the table names and the columns you wish to compare and have fun!
The key to the GROUP BY approach is that it handles NULLS quite well which JOINS have trouble with.
CREATE PROCEDURE CompareTables(@table1 varchar(100),
@table2 Varchar(100), @T1ColumnList varchar(1000),
@T2ColumnList varchar(1000) = '')
AS
-- Table1, Table2 are the tables or views to compare.
-- T1ColumnList is the list of columns to compare, from table1.
-- Just list them comma-separated, like in a GROUP BY clause.
-- If T2ColumnList is not specified, it is assumed to be the same
-- as T1ColumnList. Otherwise, list the columns of Table2 in
-- the same order as the columns in table1 that you wish to compare.
--
-- The result is all records from either table that do NOT match
-- the other table, along with which table the record is from.
declare @SQL varchar(8000);
IF @t2ColumnList = '' SET @T2ColumnList = @T1ColumnList
set @SQL = 'SELECT ''' + @table1 + ''' AS TableName, ' + @t1ColumnList +
' FROM ' + @Table1 + ' UNION ALL SELECT ''' + @table2 + ''' As TableName, ' +
@t2ColumnList + ' FROM ' + @Table2
set @SQL = 'SELECT Max(TableName) as TableName, ' + @t1ColumnList +
' FROM (' + @SQL + ') A GROUP BY ' + @t1ColumnList +
' HAVING COUNT(*) = 1'
exec ( @SQL)
- Jeff
View 13 Replies
View Related
May 19, 2008
hi,
I have a dropdownlist parameter like Today, 1 week ago, 2 weeks ago
and I have 2 datetime parameters.
What I want is when I select 1 week ago in the dropdownlist parameter
I want other date parameters to be today-7 and today respectively.
Is that possible?
Thanks
View 4 Replies
View Related
Aug 12, 1998
If I want to easily and quickly grant all permissions to a group of objects
for one user (or group), how can I do this with the tools provided?
In 6.5, I could right-click the user or group and click the "Grant All" button.
In 7.0 this is either missing or has been moved.
Thanks!
Jim
View 1 Replies
View Related
Jul 23, 2005
I have this query that I would rather not turn into a stored proc.because the client really has no budget. I was hoping there would be away to add this statement inline to the following sql with some kind ofIF statement without writing it all out. The problem is either totalcost or conversions will have some zeros in the table.SUM([total cost]/[cost per conversion])Any help would be appreciated - Happy New YearSELECT [Search Term], SUM([total cost]/[cost per conversion]) as calcw,SUM([impressions]) AS impress, SUM([Total Cost]) AS totalcost,SUM([Total Clicks]) AS totalclicks, SUM(Conversions) AS totalconv,SUM([Cost Per Conversion]) AS costconv FROM csv where [start date][color=blue]>='01/01/04' and [end date] <='12/31/04' GROUP BY [Search Term] ORDER[/color]BY [Search Term] ASC
View 5 Replies
View Related
Jul 23, 2005
i suspect i know the answer to this already, but here goes anyway....i have a table that has field of varchar(2048), which once in a blue moon ineed to edit the data manually (until a bad character parser validates thedata before it's written ;-) )at the moment i'm doing this through enterprise manager (sql server 2000),opening the table then filtering using where clauses etc to see the recordsi'm interested in. i then edit the data direct in the results pane (purelybecause it's quicker than entering the UPDATE transact SQL). this is fineuntil i hit a record that has 1024 or more characters in the field. all ican do is delete all the data. if i try and paste the same data into thefield again, it'll truncate the record to the first 1024 chars (unconfirmed)despite the field being able to take double that.i've googled this and the result basically said "don't be lazy, do itthrough UPDATE transact SQL in the query analyser".anyone know if that's my only option or is there a patch / whatever to allowme to keep using entman as i lazily do at the mo?cheers!
View 2 Replies
View Related
May 22, 2008
Hello.
I have a gridview that is connected to a sql datat srource witch gets a few columns to populate the GV with. I also have a drop down list where i enable the user to fill the gridview with the values that only match a specific category. What iv done is that i have a selected index changed event on my drop down list that does the following.string kategori = DropDownListKategori.SelectedValue.ToString();
Label1.Text = kategori;
SqlDataSource1.SelectCommand = "SELECT [ARTNR], [ARTTYP], [AKTIVITET], [DATUM], [KUND], [PLATS], [KOMMENTAR] FROM [ARTIKEL] WHERE [ARTTYP] = @ARTTYP";
SqlDataSource1.SelectParameters.Add(@"ARTTYP", kategori);
SqlDataSource1.DataBind();
Now when i launch the webpage and select a category (kategori) the gridview chanes and displays only the values that match that category but when i slect a new category Visual Studio throes me the following.
The variable name '@ARTTYP' has already been declared. Variable names must be unique within a query batch or stored procedure.
I thought that the parameter would get a new value but aparently when its set i cant declare a new value inside. What id like to know is how i can modify the above code so i can pass a new value to my select as soon as the drop down changes.
View 3 Replies
View Related
Sep 24, 2007
Hi
I have below sql procedure
CREATE PROCEDURE Qty
@make as nvarchar(32)
AS
select department as category from tblproducts where department = @make
GO
Parameter (@make) will get the value from asp.net page
My Question: Is any possibilities to change the value of parameter when the procedure trigger. Examlpe like below
If @make = 'Sealed Lead Acid' then I need to pass parameter to the database as 'SLA'
elseIf @make = 'Photographic' then 'Multimedia'
elseif @make = 'cctv and accessories' then 'security'
and so on. I only have six categories. Please help
Advance Thanks
View 3 Replies
View Related
Jan 8, 2008
Am I correct in assuming that installing a SQL EE application on to a local runtime desktop would require a lot of experienced user intervention to install the SQL to each local cpu? Can a SQL app be installed automatically w/o a user intervening?
View 1 Replies
View Related
May 27, 2014
Our client is asking to display the 'parameter panel in right side of the report' insted of top.
how can I do this?
View 2 Replies
View Related
May 31, 2007
One of our Sales Reps is having issues with a report I've made and as far as I know he's the only one (Out of about 50) who has had this issue. He's running IE 7. What happens is he'll enter in the parameters and run the report and it works fine. But when he goes to change the dates he entered as parameters and then clicks "View Report" again to run the report again, the browser just redisplays the same results and doesn't even generate a new report. It appears as if the browser has cached his previously ran report and then just redisplays it instead of going back to the server and re-generating the report. Has anyone seen this before or have any ideas? I appreciate it.
JD
View 1 Replies
View Related
Oct 13, 2015
I have located the Server where Reporting Services has been installed and I believe I have found the Report Server Database. Is there any way from the Report Server Tables that I can try and figure out where the Report Manager URL might be?
View 6 Replies
View Related
May 13, 2007
I have created an ASP.NET website with a ReportViewer on. The report renders fine, but when I change one of the parameters (manually), the report seems to invalidate itself and a blank while area is drawn. I would like the same behaviour as in the WinForms variant, where rhe rendered report remains the same until the 'View Report' button is pressed.
Is this possible?
Regards Andreas
View 1 Replies
View Related
Jan 24, 2007
Hi all,
I have couple of paramters with operator 'range(inclusive)' in my report(Agains datacube), and I always get failure when I choose value with them. here's a example( 3 such parameters on my report).
...
From date To Date
...
From age To Age
...
From Salary To Salary
@salary is the last one.
when i choose a value for 'From Salary' or 'To Salary' from the dropdown list, it runs correctly. But if I choose value for 'from age' or 'To age' or 'From Date' or 'To Date', it fails due to
An error has occurred during report processing. (rsProcessingAborted)
Query execution failed for data set 'DimTimesheetTimesheetNumber'. (rsErrorExecutingCommand)
Range operator ( : ) operands have different levels; they must be the same.
BTW, all the default values for these parameters are 'all', since it allows only 'all' to select when I set up the parameters, and I tried to change the default value, but it caused errors about the parameter dependency.
Any idea and suggestion will be appreciated!
Jone
View 1 Replies
View Related
Jun 25, 2007
Hi All,
I'm using report with a date parameter (user enters a date) and all transactions before that date are displayed. I don't know how to set parameter date format on the displayed report to dd/mm/yyyy.
If it's not a parameter I usually use sql " convert(varchar(10),datefield,103)" but don't know how to use this with parameter.
Thanks
Sonny
View 3 Replies
View Related
Sep 8, 2007
My value is approx 50 characters wide, the parameter drop down is only displaying about 10 characters, although I have plenty of room on the screen.
Also, in a multi-parameter environment, are there any controls on where the parameters are being displayed?
thanks
View 2 Replies
View Related
Sep 29, 2006
Hello, I cannot find out to create enum data type in SQL Server 2005 Express. Can I easily create the enum type just like the MySQL does.(please the MySQL example below)
CREATE TABLE myTable
(
myid INT UNSIGNED NOT NULL,
myclass ENUM('FIRST','SECOND','THIRD') DEFAULT 'FIRST'
PRIMARY KEY(myid)
);
View 1 Replies
View Related
Apr 7, 2008
I have an optional param passed to my sproc @Pid if that is populated i want to have it part of where clause, if it is null then not in where
I know this is wrong, and very new to sqlsrver:
WHERE (Pos = 'T') AND (ofDate= @OfDate)
IF not @PID is null
AND (PID = @PID )
GROUP BY
bla bla bla
Thanks
View 12 Replies
View Related
May 2, 2008
Hi All,
I'm having trouoble with changing my report name when I swtich to different parameter values.
I use the following expression.
IIf(Parameters!GroupVar1.Label = "CBank", "CBank", IIf(Parameters!GroupVar1.Value ="DTC","DTC","Total"))
This works fine when I clear Mutli-Value box in paramter properties. but when I use multi-value, this does not work.
Is there any solution for this?
Thanks
View 1 Replies
View Related
Jan 11, 2006
Hi
I have Try to Create Stored Procedure in C# with the following structure
[Microsoft.SqlServer.Server.SqlProcedure]
public static void sp_AddImage(Guid ImageID, string ImageFileName, byte[] Image)
{
}
But when I try to deploy that SP to SQL Server Express , The SP Parameters become in the following Stature
@ImageID uniqueidentifier
@ImageFileName nvarchar(4000)
@Image varbinary(8000)
But I don€™t want that Data types .. I want it to be in the following format
@ImageID uniqueidentifier
@ImageFileName nText
@Image Image
How Can I Control the data type for each parameter ??
Or
How Can I Change the data type of the parameter for the Deployed Stored Procedure ??
Or
How Can I defined the new Data type ??
Or
What's the solution to this problem ??
Note : I get Error when I try to use Alert Statement to change the parameter Data type for the SP
ALTER PROCEDURE [dbo].[sp_AddImage]
@ImageID [uniqueidentifier],
@ImageFileName nText,
@Image Image
WITH EXECUTE AS CALLER
AS
EXTERNAL NAME [DatabaseAndImages].[StoredProcedures].[sp_AddImage]
GO
And thanks with my best regarding
Fraas
View 7 Replies
View Related
Dec 18, 2007
I have a report parameter named "Schools" which display a list of schools. For example, Alo elementary school, Balo middle school and Calo high school.
When "Alo elementary" is selected the report only display students from that school along with other assessments data fields. same goes for other schools too. But I want to display different data fields for "Calo high school" when it is selected. It is not currently possilbe becasue I am using the same template for all types of schools. There some fields only should be displayed for "Calo high school" but not for any other type of schools.
I can accomplish this by creating two separate report, one for "Calo high school" and the other for other schools. But I want to accomplish this just by creating one report. So when "Alo elementary school" is selected it displays report with certain fields and when "Calo high school" is selected then it displays same fields as "Alo elementary school" but as well as some other fields too in the report. Is this possible? Need help.
View 4 Replies
View Related
Apr 22, 2015
In an existing SSRS 2012 report, I have a requirement for a user to be able to select by multiple school(s) and/or multiple grade(s). This is fine except certain schools like elementary have grade levels of KG to 06, Middle school has grades of 06 to 09 and high school has grades of 10 to 12. Thus for example, if a user has initially selected grades 11 and 12 and then they select an elementary school that has grades KG through 06, the 'grade level' selection would need to change.In other words, I am thinking of initially having the available and default values for the parameter called 'Grade' set to KG through 12. However if a school is selected that only has specific grade levels like elementary school, how can I override the original grade level and only allow the user to select grades that the particular school contains?
View 3 Replies
View Related
Jun 24, 2015
I want to Change parameter position in SSRS report.I need Start Date and End Date Parameter at same column so client can easily select Start Date and End Date.I have tried a lot but not succeed.
How Can I change the position of Start Date and End Date.I can't change order of other three parameter Select Institutions, Select Author and Course Pack Names parameter because they are internally related to each other(forward dependencies are there).
View 2 Replies
View Related
Aug 26, 2015
I have a requirement to show Day of week in parameter drop down list in different order, actual order is Monday to Sunday (Monday,Tuesday,Wednesday,Thursday,Friday,Saturday,Sunday) in DayOfWeek dimension in cube.
But my requirement is to show Friday to Thursday(Friday,Saturday,Sunday,Monday,Tuesday,Wednesday,Thursday) in DayOf Week parameter drop down list and report table. How I can get this requirement done.
View 2 Replies
View Related
Jan 29, 2008
Presently using CONVERT(VARCHAR(11), [ExpiryDate], 100) to get close to the correct format.Only stumbled across this by accident so am assuming there might be better hidden 'treasures' .Formatting dates seems to be my biggest time-consuming activity and I just don't seem to get better at it!
View 4 Replies
View Related
Apr 16, 2015
I am working on reports in SSRS 2008 (not R2)... There are some reports with parameters that are hidden when the report is accessed through normal URL using ReportViewer.asx..The thing is that these hidden parameters need to be visible when the report is accessed using SSRS Report Manager.
View 3 Replies
View Related
May 12, 2015
Trying to determine what the minimum permissions i can grant to a user so they can see the change tracking data
View 1 Replies
View Related
Nov 18, 2015
We ran into weird/interesting issue with below details.
Version:Â Microsoft SQL Server 2012 (SP1) - 11.0.3000.0 (X64)Â Standard Edition (64-bit) on Windows NT 6.2 <X64> (Build 9200):
We are using SQLCMD to run DDL script on our product database in below order. That script has below content.
step # 1 - database collation change (case -sensitive) statement as very first statement of the script
step # 2 - Actual DDL SQL statements
step # 3 - database collation change back to original (case insensitive)
When we execute all above 3 steps in single script using SQLCMD on our test_server#1 , it is successful but when same is being implemented on test_ server#2 , it is failing.We ensured that there is no other user accessing the db and setting on both the server are all default/basic. Separating out all 3 steps in 3 different script working fine. This is only problem when we combine them into single script and fire it using SQLCMD. If it is something related to session/transaction then we should hit same issue on our test_server#1 server as well but that is not the case.test_server#1 and test_server#2 has exact same database/data, just two different physical machine & SQL Server instance.
View 7 Replies
View Related
Feb 19, 2007
Hello,
since a couple of days I'm fighting with RS 2005 and the Stored Procedure.
I have to display the result of a parameterized query and I created a SP that based in the parameter does something:
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE PROCEDURE [schema].[spCreateReportTest]
@Name nvarchar(20)= ''
AS
BEGIN
declare @slqSelectQuery nvarchar(MAX);
SET NOCOUNT ON
set @slqSelectQuery = N'SELECT field1,field2,field3 from table'
if (@Name <> '')
begin
set @slqSelectQuery = @slqSelectQuery + ' where field2=''' + @Name + ''''
end
EXEC sp_executesql @slqSelectQuery
end
Inside my business Intelligence Project I created:
-the shared data source with the connection String
- a data set :
CommandType = Stored Procedure
Query String = schema.spCreateReportTest
When I run the Query by mean of the "!" icon, the parameter is Prompted and based on the value I provide the proper result set is displayed.
Now I move to "Layout" and my undertanding is that I have to create a report Paramater which values is passed to the SP's parameter...
So inside"Layout" tab, I added the parameter: Name
allow blank value is checked and is non-queried
the problem is that when I move to Preview -> I set the value into the parameter field automatically created but when I click on "View Report" nothing has been generated!!
What is wrong? What I forgot??
Thankx for any help!
Marina B.
View 3 Replies
View Related
Aug 21, 2015
I am working on existing ssrs report. When I see the preview I could see the extra parameter than the actual parameter.Â
How do I know , when this parameter is coming in the preview ?
View 5 Replies
View Related
Jul 29, 2015
I have two report , first is main report which is matrix and have one parameter User_ids which is multi value selection and my second report is basic chart of user_wise performance.
Now, my main report (matrix ) works fine for Multiple selection of users and i have putted one textbox on main report chart which has action properties set for chart report, when user click on chart button it must goes to chart with user selected in main report. Now , i have used expression for parameter to send it like ..
=join(parameter!user_id!value,",") which pass selected value to chartÂ
And when I am selecting single user it passing that value to chart parameter list but , when it is more than one user it errors with conversion failed when converting the nvarchar value '121,128' to data type int. But my chart also works when passing 121,128 in user parameter in preview of report .
View 2 Replies
View Related
Jan 30, 2007
Hi,
I need "conditional" cascading parameters: In Report Manager when one changes parameter 1, parameter 2 get changed based on parameter 1. Optionally, one can also enter values to parameter 2 directly.
I was able to achieve this in SSRS 2000 (SP2) with the following setups. SSRS 2005 and SP1 no longer works - Parameter 2 always shows its default value regardless whether one select a value in Parameter 1 or not.
Parameter 1
available values: from query
default values: non query (specify a value "<None>")
Parameter 2
available values: Non query (no value specified)
default values: from query (based on Parameter 1)
It seems to me that the default value in SSRS 2000 is considered as cascading parameter. But it is no longer the case in SSRS 2005.
Is this a SSRS 2005 bug? is there any other work arounds or suggestions?
Thanks.
Kong
View 6 Replies
View Related