How can one use Access to add or modify fields in SQL server?It depends on the versions of SQL Server and Access being used, so for example Access 2000 can not modify SQL Server 2000 or SQL Server 2005 properties but Access XP/2003 should be able to.
Basically the version of access must have shipped after the version of SQL for this to work, but even then its not always the case.
HELP
Server Error in '/CommerceVBSDK' Application.
SQL Server does not exist or access denied.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Data.SqlClient.SqlException: SQL Server does not exist or access denied.
Source Error:
Line 28: Dim products As ASPNET.StarterKit.Commerce.ProductsDB = New ASPNET.StarterKit.Commerce.ProductsDB()
Line 29:
Line 30: MyList.DataSource = products.GetProductCategories()
Line 31: MyList.DataBind()
Line 32:
Source File: C:\Program Files\ASP.NET Starter Kits\ASP.NET Commerce (VBSDK)\CommerceVBSDK\_Menu.ascx Line: 30
Stack Trace:
[SqlException: SQL Server does not exist or access denied.]
System.Data.SqlClient.ConnectionPool.GetConnection(Boolean& isInTransaction) +474
System.Data.SqlClient.SqlConnectionPoolManager.GetPooledConnection(SqlConnectionString options, Boolean& isInTransaction) +372
System.Data.SqlClient.SqlConnection.Open() +384
ASPNET.StarterKit.Commerce.ProductsDB.GetProductCategories()
ASP._Menu_ascx.Page_Load(Object sender, EventArgs e) in C:\Program Files\ASP.NET Starter Kits\ASP.NET Commerce (VBSDK)\CommerceVBSDK\_Menu.ascx:30
System.Web.UI.Control.OnLoad(EventArgs e) +67
System.Web.UI.Control.LoadRecursive() +35
System.Web.UI.Control.LoadRecursive() +98
System.Web.UI.Control.LoadRecursive() +98
System.Web.UI.Page.ProcessRequestMain() +731Try creating a blank Database with OSQL and give ASP.NET account DBO permissions in the Database before installing the Commerce Starter kit. Hope this thelps.
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnmsde2kwrk/html/msde2000webapp.asp
Kind regards,
Gift Peddie
Should be simple. I'm writing a report to find employees by last name.
I want the user to key in at least a few characters of the last name and the report will search for all last names that are like that.
I know in TSQL it would go:
Last_name like 'Jones%'
But how do I set up a parameter in Reporting Services
I've tried:
last_name like =@.name%
Any ideas?
Thanks,
Jim
Any ideas? Can the Keyword "Like" be used to find similar occurences of a user entered parameter...|||Within the dataset query you can declare a variable that references the parameter with the text then append the necessary % to the end. So the reference would look something like...DECLARE @.some_variable NVARCHAR(40)
SET @.some_variable = @.parameter_field_text + '%'
You can then use this...
SELECT *
FROM some_view
WHERE NameField LIKE @.some_variable|||
You would probably need to use dynamic sql and expression.
="Select * from table1 where last_name like '" + @.name + "%'"
Or use a stored procedure and perform the like statement within it.
cheers,
Andrew
hi,
I am using a function in sql server 2005 like this:
...... myfunction(... @.FlagOn int)
.......
begin
return
(
if(@.FlagOn = 1)
select * from.......
else
select * form....
)
end
But it keeps complaining there is some syntax error around if. What is it?
Thanks.
No. Table valued function won’t allow this. Because it might cause more than one schema definition for the table valued function, which is not possible in the database.
If it is a filter then you can attach the additional condition on the where clause. If the flag is used to fetch different columns or different table create new function for each flag.
If the final schema is same (same number of columns and identical datatype for both the flags), use table valued function (not inline table valued function).
Code Snippet
Create function getvalues(@.flag as int)
Returns @.result table (id int, name varchar(100))
As
Begin
If @.flag=1
Insert into @.result
Select Top 10 id, name from sysobjects
Else
Insert into @.result
Select Top 10 id,name from syscolumns
return;
End
Go
Select * from getvalues(1)
go
Select * from getvalues(0)
|||Thanks lot, it works great.
Another thing is, can I create index on table @.result?
Coz I am thinking something like this:
select * from getvalues(1) as s where s.ID > 100
If it has index on ID, it might be faster.
|||Maximum you can add Primary Key/Unique key on the table variable. If your values are unique then you can go for it.
@.result table (id int primary key, name varchar(100))
Thank you.|||
Quote:
Originally Posted by iburyak
No, you can not use IF condition in a view.
There are so many other ways to do it.
Thank you.
Create view View_Tables
AS
select name from sysobjects where type like 'u'
and more....|||Hi iburyak,
I've used the case statement and it is working as expected here.
Thanks for the excellent explanation.|||
Quote:
Originally Posted by leniel
Hi iburyak,
I've used the case statement and it is working as expected here.
Thanks for the excellent explanation.
Specifically, I would like to have the link point to an .jpg file stored in a folder on the computer.
Thanks!The "hyperlink" field type is not supported, by you can store text in a SQL CE database, both the Hyperlink description and the file path (in 2 nvarchar fields)
Thanks
Tudor
hi,
In SQL Server, does it have this:
if...
else if ...
else if....
else....
It seems I have to do it like this:
if..
else...
begin
if ....
else
begin
if......
end
end
i think you can do it this one works well
USE pubsIF (SELECT AVG(price) FROM titles WHERE type = 'mod_cook') < $15
BEGIN
PRINT 'The following titles are excellent mod_cook books:'
PRINT ' '
SELECT SUBSTRING(title, 1, 35) AS Title
FROM titles
WHERE type = 'mod_cook'
END
ELSE
IF (SELECT AVG(price) FROM titles WHERE type = 'mod_cook') > $15
BEGIN
PRINT 'The following titles are expensive mod_cook books:'
PRINT ' '
SELECT SUBSTRING(title, 1, 35) AS Title
FROM titles
WHERE type = 'mod_cook'
ENDELSE
IF (SELECT AVG(price) FROM titles WHERE type = 'mod_cook') > $50
BEGIN
PRINT 'The following titles are more expensive mod_cook books:'
PRINT ' '
SELECT SUBSTRING(title, 1, 35) AS Title
FROM titles
WHERE type = 'mod_cook'
ENDHello all,
I am relatively new to SQL and Database. Your help is greatly appreciated! Thanks in advance!
Recently, I joined a company that uses MS SQL Server. Our team, which is located in Toronto, has been maintaining and updating a database. The following is some information on the connection string that we are currently using.
Dim con As ADODB.Connection
Set con = New ADODB.Connection
con.Open "Provider=SQLOLEDB.1;Integrated Security=SSPI;Initial Catalog = CBA; Data Source=PROD.CORP.COMPANY.COM"
Just last week, I was informed that people in the New York Office requires access to the database. What they want to do, essentially, is to have the ability to use the same spreadsheet that retrieves data from our database. My concern is that the computers in the New York Office might not be under the same server. The "static" Data Source stated in the connection string might not work. I was advise to switch over to ODBC connection so that I can specify a System DSN name to point to a specific server. This will allow me to change the "path" that the DSN is pointed to, without going through the code and change every Data Source name, is this true?
I've been reading up on ODBC and OLE DB. The impression I got is that OLE DB is superior to ODBC. It just doesn't make sense for me to "downgrade", is it? Please advise on what I should do so that people in both the Toronto and the NY office will have access to the database. In addition, is there a way for me to simulate a "remote access" scenario so taht I can be sure the new connection is working as it should be?
Thank you so much for your help! I really appreciate your time and effort in helping me to solve this issue.
Best regards,
William
For DSNs in specific, you can use the OLE DB provider for ODBC and use IPersistFile::Load to load the dsn. Details available at
http://msdn.microsoft.com/library/en-us/oledb/htm/odbcproviderinitialization_properties_and_kag_files.asp?frame=true
For the SQLOLEDB provider, you can use the UDL files instead of DSN files to allow managing connections to data sources.
Details at http://msdn.microsoft.com/library/en-us/oledb/htm/datalinkapioverview.asp?frame=true
Suroor
I hope to pass a dimension such as int A[5] to a stored procedure
A[0]=10
A[1]=20
...
Can I do that in sql server 2005? if so , please give me a sample, thanks!
I dont think you can do that in SQL yet. You could pass a delimited string and parse it over in your stored proc.
Hi
I've a doubt. I don't know whether it is possible or not.
I've a very less knowledge in DTS packages.
When I execute a package in C#. it is displaying predefined GUI for showing process.
Can I've my own UI when executing DTS.
Thanks in advance.
Could you clarify what you mean by "When I execute a package in C#" and whether the question is about DTS 2000 or SSIS. This forum is about SSIS, BTW.|||
Thanks for the reply Michael
I'm using SSIS
I'm putting the C# code here
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
}
Package package;
ConnectionManager ConMgr;
Package p;
private void Form1_Load(object sender, EventArgs e)
{
string pkg ="Package.dtsx";
Microsoft.SqlServer.Dts.Runtime.Application app = new Microsoft.SqlServer.Dts.Runtime.Application();
p = app.LoadPackage(pkg, null);
}
private void button1_Click(object sender, EventArgs e)
{
if(p!=null)
p.Execute();
}
}
When I click on Button ie) p.Execute(); is invoked I need my own UI to see the processing . Is it possible.
Thank u
|||Of course - you need to implement event sink interface (IDTSEvents) and/or logging sink interface (IDTSLogging), and call package.Execute(...) version that takes these interfaces (pass null for all other arguments). You'll get the information about the package progress and can show the UI similar (or completely different if you choose) to the one DtExecUI shows (DtExecUI uses the same interfaces).|||
Thanks michael
It is useful
and can I know abt DtExecUI for what it is useful for?.]
|||Well, it executes the packages :)
Some people use command line and some people like to use GUI to execute packages. We provide DTEXEC and DTEXECUI for each group appropriately.|||
Thank u Michael .
Thanks for ur support to know these.
And finally one , can u provide some resource to learn , how to create custom UI. and executing package.etc
|||
Hi
I've one more doubt.
Executing package is a single threaded or multi threaded?
Can I catch the names of the currently transfering table when Executing package?
Thanks in advance.
|||Execution is multithreaded, you'll need to gather information you need from the event and pass it to the UI thread, and probably call package.Execute() on a different thread too to avoid locking up the UI.
There are many events and log information, see Books Online for details. Creative use of this information joined with the package information (e.g. transform properties) may give you most of the information you need.
I don't have any sample, sorry.|||
Thanks alot Michael.
We have decided to use business objects in our new application, which seems to be working well, since they can be used as a binding source for grids, etc.
I am trying to evaluate whether SSIS is a practical solution for our ETL requirements. The problem is, I can't find any examples or references, or even the slightest hint that anyone is using them with business objects. Any attempts to search yield a ton of results which are based on a commercial product called "Business Objects" rather than the design pattern.
It is currently a requirement of our development team that all data access must be done via business objects, rather than communicating directly with the database.
Can anyone provide some more information (besides just suggesting I write a custom connection manager)? Is there anyone who has actually made SSIS work with business objects?
Thanks, Richard
What is a "business object"?|||I don't know what kind of information you're looking for. Yes, it can be done. Yes, you'll have to write custom components to talk to the business objects instead of the database. I've done it for Reporting Services as a custom data extension (source) and it wasn't a bunch of fun. SSIS I think would be even less. Biggest downside I can think of off-hand is that you won't be able to bulk load into the database (think row-by-row), which is going to be really painful in an ETL scenario. I've never heard of an ETL process that wasn't allowed to access the database directly.We are a 3PL, so in our case, ETL is more along the lines of importing batches of orders and exporting batches of shipping confirmations from and to a variety of data formats. Row-by-row is not an issue.
It would be nice to find a working example of how to do this prior to investing a bunch of time into SSIS.
|||This sounds more like BizTalk than SSIS. It isn't your business objects that I'd be concerned about in SSIS, it's the "variety of data formats". SSIS wants to move 10,000+ rows per second between well-defined sources and destinations and do a bunch of transformations along the way. BizTalk wants to route transactions between different systems and talk different formats to each one.BizTalk has a price tag. We already have SSIS. Everything I've read to date on it indicates that it is something we should be able to use to meet our needs. I am not questioning whether SSIS is the best choice. I would like to know if anyone has used it successfully with business objects, and if so, can they provide some examples, or other helpful information.
Thanks, Richard.
|||What will your business objects be constructed as? COM objects, web services, .NET assemblies? That has an impact on how easy they are to interface with.|||
SSIS Evaluator wrote:
BizTalk has a price tag. We already have SSIS. Everything I've read to date on it indicates that it is something we should be able to use to meet our needs. I am not questioning whether SSIS is the best choice. I would like to know if anyone has used it successfully with business objects, and if so, can they provide some examples, or other helpful information.
Thanks, Richard.
Can I reiterate Phil's question (above)? What exactly are these "business objects"?
-Jamie
|||It's a generic term for objects that represent business entities and the rules associated with those entities. So you might have a Customer business object, with all the attributes that a customer has, and methods to represent any operations that can be performed on the customer. Usually, these provide a layer of abstraction between the database and the user interface. Business objects know where their data is stored for persistence, and user interfaces request information from the business objects rather than accessing the database directly. Changes in the data from the UI are also handled through the business object. Data validation, enforcement of business rules, etc, are all handled in the business object.
In the OP's case, evidently they have made an architectural decision that all data access has to go through these business objects. As has been stated, it is possible to do this with SSIS. The degree of complexity depends in large part on how the business objects are implemented. If this is being looked at a method to handle importing or exporting data from business objects to an external database, it might work OK, assuming performance is not the major concern. If it is for business object to business object communication, I really think the OP would be better off investigating other tools.
i have an instrument dimension. the instrument dimension has a conversion ratio attribute (i.e. each instrument has a conversion ratio). the conversion ratio attribute is not interesting for analysis in itself, but is often used in calculations.
I want to say somehting like this:
for all instruments, show me sum of [measures].[Price] * ~ CONVERSION RATIO OF THAT INSTRUMENT ~
this actually works ok at the detail level. however, when I start rolling up instruments into say, sectors, then i get a type mismatch error saying that teh "All" member cannot be converted to type double.
In general, is it valid to use a non-measure group dimension attribute to perform a calculation? If not, should any attribute that might participate in a calculation be created as a measure (even though it has no real analysis value by itself). Or should I do the
"Fact * Looked Up Attribute"-type calculation in the DSV and create a new Fact called something like [Price X Conv Ratio]?
The first of these queries generates the error you mention above. I believe the second handles the logic in the manner you are wanting. I haven't had a lot of time to look at this, so I would highly recommend you independtly verify the results of this logic (or the version you implement) to make sure the values are correct. Also, I used a SUM function to aggregate the values in the calculated member. There are a number of functions available to you. In this situation, AVG may be more appropriate.
Thanks,
Bryan
Code Snippet
withmember Measures.[x] as
[Measures].[Reseller Sales Amount]/[Product].[List Price].CurrentMember
select
{[x],[Reseller Sales Amount]} on 0
from [Adventure Works]
;
withmember Measures.[x] as
SUM(
[Product].[List Price].[List Price].Members,
([Product].[List Price].CurrentMember, [Measures].[Reseller Sales Amount])/
[Product].[List Price].CurrentMember.MemberValue
), format="#,#"
select
{[x],[Reseller Sales Amount]} on 0
from [Adventure Works]
;
I would really appreciate any kind of sugestionAMO (Microsoft.AnalysisServices.dll) is built and works with .net framework 2.0, so you will not be able to use it with Visual Studio 2003 (that uses .net framework 1.1).
SQL Setup 2005 install .net framework 2.0, so you can build AMO applications from command line with csc.exe. Or use Visual Studio 2005 Beta 2 (http://lab.msdn.microsoft.com/vs2005/).
Adrian.
Can the ALTER USER statement be used (without a hack like using EXEC) in a stored procedure? I know that the sp_password system stored procedure can not be. Additionally, it is being deprecated anyway. I guess what is boggling me about my attempts so far relate to the errors I am getting due to the user being specified not being in quotes in the syntax. All of the searching I have done so far have come up lame so far; the only examples I have found about it were in scripts that create other scripts for transferring users and other administrative tasks that would be run from the query window, but not from an application. To be complete as possible, here is an example of a script the returns errors:
ALTER PROC [dbo].[lbxChangePassword]
(
@.loginid nvarchar(180),
@.oldpassword nvarchar(40),
@.newpassword nvarchar(40)
) AS BEGIN
IF @.oldpassword = (SELECT password FROM contacts WHERE loginid = @.loginid)
BEGIN
BEGIN TRANSACTION
UPDATE contacts
SET password = @.newpassword
WHERE loginid = @.loginid
ALTER LOGIN @.loginid WITH PASSWORD=@.newpassword OLD_PASSWORD=@.oldpassword
END
ELSE
BEGIN
RAISERROR(N'The password you entered does not match your current password.', 16, 1)
RETURN
END
IF @.@.ERROR <> 0
BEGIN
RAISERROR(N'There was an error creating your new password.', 16, 1)
RETURN
END
COMMIT TRANSACTION
END
************
This returns:
Msg 102, Level 15, State 1, Procedure lbxChangePassword, Line 15
Incorrect syntax near '@.loginid'.
Msg 319, Level 15, State 1, Procedure lbxChangePassword, Line 15
Incorrect syntax near the keyword 'with'. If this statement is a common table expression or an xmlnamespaces clause, the previous statement must be terminated with a semicolon.
************
If ALTER LOGIN isn't how to change the password, then please tell me what the correct practice of changing a password is. I want to use the CURRENT_USER keyword in my queries and want I can't finish setting that up until I have this resolved because users will need to change their own passwords through the application I am developing.
I guess you have to put that in dynamic sql to execute:
DECLARE @.SQLStrng NVARCHAR(500)
SET @.SQLString = 'ALTER LOGIN ' + @.loginid + ' WITH PASSWORD= '' + @.newpassword + '' OLD_PASSWORD= '' + @.oldpassword + '''
EXEC(SQLString )
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
Yes, the DDL does not accept variables. If you build the string dynamically, use quotename() around the variable names to get them quoted properly:
DECLARE @.SQLStrng NVARCHAR(500)
SET @.SQLString = 'ALTER LOGIN ' + quotename(@.loginid) + ' WITH PASSWORD= ' + quotename(@.newpassword, '''') + ' OLD_PASSWORD= ' + quotename(@.oldpassword, '''')
EXEC(SQLString )
Thanks
Laurentiu
I'll try this, but I was hoping that there would be a way to do this without using a "hack".
Am I not approaching this the right way? The user will be logging into a PHP application and I need for them to be able to change their password. Would you recommend a stored procedure to accomplish this like the ones we've been writing about, or is there a best practice for this. I mean, otherwise how can one administer database users from a web app and still use SQL Server's security model? I don't understand Microsoft's reasoning in this architecture.
|||Writing a stored procedure to accomplish this is OK. If you don't like to build the dynamic SQL and execute it with EXEC, you might prefer using sp_executesql instead: http://msdn2.microsoft.com/en-US/library/ms175170(SQL.90).aspx.
Thanks
Laurentiu
Well, I read a post by a SQL Server MVP that said that another way to do this is to specify the old/new password in a connection string to the SQL Server Native Client. e.g.:
"Provider=SQLNCLI;Data Source=MyServer;User ID=MyLogin;Old Password=oldpassword;Password=password"
But I don't think PHP is friendly to connection strings though; I tried fiddling with ODBC connections in PHP with no luck. Has anyone heard anything about this?
|||Try posting on SQL Server Data Access for more details on the connection string idea. I think this connection string is probably meant to be used when a login password is expired; it is not the regular way of changing a login password. If you're looking at all possible ways of changing a login password, you should also check the SQL Server SMO/DMO forum - you could write a CLR procedure to perform this action (see .NET Framework inside SQL Server for questions on using CLR inside SQL Server).
Thanks
Laurentiu
I'm just a curious person :-) Thanks. Good Ideas.
-Ryan
Hi~
I know some function can be used in debug mode,like MsgBox()...,in ASP.NET 2.0.
But I don't know that Can ADOMD or AMO be used in ASP.NET 2.0.
Could someone tell me?
thanks~
Server: SQL Server 2005
OS: Windows 2003
Yes you can use both ADOMD and AMO from ASP.NET. The main "trick" is to get the code executing as a user that has the approriate rights to access the required SSAS objects. Setting up your application pool up to run under a domain account that is in appropriate SSAS roles is one way of getting this to work.Gary
Hi Garry,
This link says it is possible to use Access as a Server which works well with the size limit of 1GB but then it obviously requires expert coding to make it function as a server.
Thanks
Subhash Subramanyam
Create a variable and then for its properties, set EvaluateAsExpression to True and then build your expression accordingly in the Expression box.
Then in your OLE DB source/destination, you can use that variable as the table. Just know that you'll want to probably set DelayValidation to True on your connection managers when you do this.
There are plenty of examples in this forum if you search for them on how to build expressions, if you need.|||I found the option for this under Data Access Mode but we need to do the same thing for the database name which will be in a similar format e.g. databasename_mmddyy and the source db name will change every month.|||Same thing. You can use expressions on your connection managers to dynamically create the current connection string.|||The same principals can be applied to a connection manager (i.e. database name of database server). You can use an expression to build the connection string from a variable in the properties window of the connection manager.|||Any examples of this?|||
Any examples of this?
In the ConnectionString expression box for a connection manager. Also it can't hurt to set DelayValidation to True.
"Data Source=" + @.[User::YourDatabaseNameVariable] +";Initial Catalog=Report;Provider=SQLNCLI.1;Integrated Security=SSPI;Auto Translate=False;"|||What goes in the database name field? I am assuming that it gets overridden by the expression.|||
What goes in the database name field? I am assuming that it gets overridden by the expression.
The ConnectionString will override any other parameters.|||
Any examples of this?
http://search.live.com/results.aspx?FORM=QBJK&q1=macro%3Ajamiet.ssis&q=expressions
-JT
|||This seems to be changing both of my OLE DB Connections. Is there a way one can be static and the other updated by the variable? It also appears that Data Source controls the server and Catalog is the database name.|||
This seems to be changing both of my OLE DB Connections. Is there a way one can be static and the other updated by the variable?
That's impossible (unless one of us has misunderstood). An expression on the ConnectionString property of a connection manager only changes that connection manager.
It also appears that Data Source controls the server and Catalog is the database name.
Correct.
-Jamie
|||
agentf1 wrote:
This seems to be changing both of my OLE DB Connections. Is there a way one can be static and the other updated by the variable?
That's impossible (unless one of us has misunderstood). An expression on the ConnectionString property of a connection manager only changes that connection manager.
agentf1 wrote:
It also appears that Data Source controls the server and Catalog is the database name.
Correct.
-Jamie
My bad, I had the expression on both connections. I am OK, thanks for all the help, worked beautifully.
Is it possible to use a user defined function in an IF statement? The UDF returns a scalar value. Like:
IF dbo.DoSomething (@.x)
The only way I can see to call a UDF is with
SELECT @.y = dbo.DoSomething (@.x)
Thank you!
YES but you have to compare its result with something or your function should return bit or integer value IF dbo.DoSomething (@.x)=1
Hello,
I have created a web page with a FormView that allows me to add and edit data in my database. I configured the SqlDataSource control and it populated the SELECT, INSERT, UPDATE and DELETE statements. I've created a stored procedure to do the INSERT and return to new identity value. My question is this: Can I configure the control to use this stored procedure? If so, how? Or do I have to write some code for one of the event handlers (inserting, updating?)
Any help would be appreciated.
-brian
Yes you can. Not seeing your code makes it difficult to diagnose, but it sounds like you have the SqlDataSource partially set up. Make sure you also have the insertcommand attribute set to your new stored procedure and the insertcommandtype set to "StoredProcedure". The InsertParameters should also be set to include any input parameters that are not explicitly bound within the FormView.InsertItemTemplate.
From here, you need to make sure the FormView is in insert mode, your InsertItemTemplate is properly set up, and you have an insert button with the CommandName attribute properly set to "Insert".
Once you click that button, the FormView.ItemInserting event will fire, then the SqlDataSource.Inserting event will fire.
Assuming you have all of your stored procedure input parameters properly set up within your ASPX page, your stored procedure should run, and you can pick up your return parameter from the SqlDataSource.Inserted event.
Hope this helps.
Is it possible to use a stored procedure to fill the default value of a column when i'm building the db?
i mean if i can use a stored procedure for the "colum property": "default value or bnding"
if yes how can i do it?
No, you won't be able to specify a stored procedure in your table definition as a default value for a column. Your best bet for this is to set up a trigger (either AFTER or INSTEAD OF) to enforce the default value.
|||You can, however, use a scalar user-defined function as the default value. So if you can convert the sproc to a UDF or call it from one, you're good to go.
Don
Hi,
I have a data table called STOCKPE which holds stock valuation information at the close of business each day. I wish to use reporting services to extract the data in this table on a daily basis and keep a daily history on the report server. I know I can do this - this isn't my problem.
When I have the history of this table on the report server, can the data that the reports on the report server hold be used as a datasource for another report?
I'm no expert in reporting services, so if this is possible, or if there's a better way of doing it, please use small words and short sentences. No offence intended to all the very well educated SQLRS wizards out there, it's just that I'm not one of them and your answer will be lost on me if you use a lot of abreviations and acronyms.
Thanks,
Chris
Hi,
I guess you are takling about Snaphots in SQL Server RS. Snapshots are dedicted to one Report (actually its a snapshot of the report). AFAIK there is no way to base reports on other reports snapshot data.
HTH, Jens K. Suessmeyer.
http://www.sqlserver2005.de
Hi Jens,
I had a feeling this was the case but y'never know so I thought I'd ask all the same.
Thanks for your response, much appreciated.
Chris
I am familiar with the navigation hyperlink action of "Jump to URL" but I cant get it to use the data returned in the report as part of the URL address. When I enter the Url into the expression editor: ="http://internal.company.address/sys1/sys2/caseEdit.pl?case="&"Fields!CaseID.Value" it opens an explorer window but it echos the address and tries to use the text 'Fields!CaseID.Value' instead of the data returned in that field.
Can this be done?
="http://internal.company.address/sys1/sys2/caseEdit.pl?case=" & Fields!CaseID.Value
|||Thanks, this answers my question. Seems so simply once I see the answer.