I have a web page where my users are selecting a bunch of filters to generate a report. The page then pulls the initial data from the database, applies some adjustments to the records, and then puts the data in a temporary table for that user. I want to create a report template (or a report saved on the report server) for this report. I want to use the same report for each user but be able to change the datasource for the report on the fly for the current user's temp table in my webpage before displaying the report. Is this possible?
Hi, I want to modify the layout and stuff of the main reporting page...but I'm not sure how to open it ... is there a project for it that gets installed on the server?
I've seen some video demos on the microsoft site and they had some pretty nice front ends set up. I'd like to put some actual metrics on that front page and set up some links and different layouts.
Can someone please at least point me in the right direction to do this? I'm hoping it doesn't require setting up an entirely new site from scratch.
Hello SQL Server Experts, Data Analysts, and Report Writers et al:
re: Reporting Options with SQL Server
I wanted to propose an offshoot to the pryor thread:
Would anyone take a stab at comparing Access Reports, Crystal Reports, Cognos or other options to all the Reporting Services and its components offered as part ofSQL Server, especially as to extracting data from SQL Server into a report format?
I guess this is a far as capabilites, ease of use, limitations, and especially formatting or presentation of the end report product?
Thank you to all, and I hope this is a beneficial discussion to others.
I have an already published application running several MS SQL Server 2000 Reporting Services report. I need a way to find from either the reporting services log or the application server (IIS) logs or windows log to know the frequency of each report being used.
Based on this info, the business needs to know which reports are being used and to what extend? How can I acheive this?
I have already got the IIS logs and it did not give the required info. I have looked into the Reporting Services logs but it does not provide the info either.
I have an already published application running several MS SQL Server 2000 Reporting Services report. I need a way to find from either the reporting services log or the application server (IIS) logs or windows log to know the frequency of each report being used.
Based on this info, the business needs to know which reports are being used and to what extend? How can I acheive this?
I have already got the IIS logs and it did not give the required info. I have looked into the Reporting Services logs but it does not provide the info either.
My issue is with converting multi-value parameters:
In Crystal Reports, you can set a parameter to accept multiple vales (Discrete, Range or Discrete and Range).
As an example:
I have a database table with a column called ID. I can create a parameter called param_id and set the options of the parameter to "Allow multiple range values".
With this setup, I can limit the result set of the report by comparing the param_id parameter to the ID column in the database. Because param_id is a multi-value range parameter, I can pass it the following data: 1 - 50 60 - 80 150 - 127
This will only return results within those ranges.
Does anyone know if SSRS provides this kind of functionality?
Is there a way to copy reports from other users "My reports" folder? I am logging onto the management studio reporting services using an administrative account and I am able to view the reports from all users' "My Reports" folder. But I am not able to export them as an rdl file. I am able to export reports from other common folders, but not from the "My Reports" folder.
The reason I need to do this is some of the users have created some reports in one environment and the reports are available in their respective "My Reports" folder. I need to move these reports to their corresponding "My Reports" folder in another environment.
1. I downloaded ChartFXRSTrial and created one chart, and able to deploy it in ReportServer, but the problem is the reports are not showing there, i checked the configuration of .dll files in the help provided by chartFX, but couldn't get anything, so could help me on this.
2. How to give Tooltip for the X- axis or Y- axis values in the ReportServer , i tried using chartproperties of .rdl file, but didnt understand it. can help me on this, and one more i tried with Dundas too, If im giving tooltip as #valy then, it is showing samething in reportserver instead the values of 'Y-axis'.
I'm trying to make a searching tool in my web site that will search in one table in databaseWhat i want to do is to search by three columns and shows the result if the string found in one of this three columns, so here what i tried to and its not working okay, coz sometimes it works and other not while entering correct stringstring Search = Request.QueryString["s"].ToString(); string Sql = "SELECT * FROM Topics WHERE TopicName LIKE '% " + Search + " %' OR";Sql += " TopicIntro LIKE '% " + Search + " %' OR TopicBody LIKE '% " + Search + " %'";I also wanna know how to remove quotations and other stuff that shows error message if entered in the TextBoxThank you alot
HelloI am getting this err msg when trying to logon to my website on the web - on my machine there is no prob, An error occurred while established a connection to the server.When connection to Sql.S 2005, this failure may be caused by the fact thatunder the default settings sql.s doesn't allow remote connection.(provider :Sql.S Network interface, error:26- Error Location Server/Interface Specified)(the files path is like in the web host s)
Hi everyone. This is my first post here. I did a quick search and didn't find what I as looking for, so I'm hoping you all can help me.
I'm working on a project that will allow my company to upload images to a database and have the website pull the images from the DB. We are planning to incorporate some type of cacheing, however I'm skeptical as to if it is really necessary. I imagine that I'm certianly not the first to do this and I'm wondering if someone can let me know if I truly should expect a performance hit, or if I shouldn't really worry about it b/c this is a very common mantra.
Thanks all. I've been pretty vague and haven't explained all of the details. I can write more, but I'm just looking for generalizations right now.
I am new to .NET and the Visual Web Developer Express and what not...I have created a website on my machine which works wonderfully...however, and I'm sure this is somewhere but I can't find it, I cannot get it to work on my host server...the Default page comes up, but when I try to sign in it says: "An attempt to attach an auto-named database for file c:hostingwebhost4lifememberharrison0801App_Dataaspnetdb.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share." The host support tells me to change the db name from aspnetdb to something else...I do this and when I run the site again or try to log in, I get the exact same error message...then they go on to tell me that I have to remove the LocalSqlServer in the web.config file which now looks like this: <connectionStrings> <remove name="LocalSqlServer"/> <add name="LocalSqlServer" connectionString="Data Source=.SQLEXPRESS;Integrated Security=True;AttachDbFilename=|DataDirectory|aspnetdb.mdf;User instance=true;" providerName="System.Data.SqlClient" /> <add name="Example" connectionString="Data Source=.SQLEXPRESS;Integrated Security=True;AttachDbFilename=|DataDirectory|example.mdf;User instance=true;Initial Catalog=example;" providerName="System.Data.SqlClient" /> </connectionStrings> Of course this isn't working either...otherwise I would off playing on my server, and not posting here. Also, when I set up all the roles, users, and what not on my machine...does this carry over to the host machine? Desperately needing massive help here.... Not a DBA and no expert in .NET Thank you very much in advance, Darren
Hi I want to have a report on a website page that will respond to user input.
Basically a page that will displays requests when the user inputs a user_id; the user will then need to be able to drill down and select a specific request to display and print that request.
It's been a long time since I last experimented with SQL Server (2001) so I am not sure of new product features or developer techniques.
A client of mine is wanting to deploy an E-Commerce website and one if the core requirement is that the site must integrate with his internal MS SQL Database i.e. Orders placed online must be seamlessly entered into his internal Sales database. Ideally this would not require any re-keying or daily batch imports.
Many web hosts offer SQL hosting so how (if it is possible) could I link the hosted database to the internal database?
Ok, I have this up and running thanks to the help of lots of users in this forum (Thank You again)
I deployed some reports, and everything looks fine, however to add another twist to this, I would like the website to look prettier, by adding something like a welcome page,and some folders and such.
Does anyone have any ideas on how to do that ??? DO you have any material or a website, where I can get some info ??
I wanted to make a login for custom content on my asp website. I installed 2005 sql, gave it a named instance(sql34). I set the connections to local and remote for tcp only in the "surface area config", and made the tcp enabled in "sql manager". All of the sql services are started. So i open up the "server management studio" and it prompts me for a connection. I sellect "database engine" because thats what i installed. I typed the server's name in the "server name" and select sql server authentication for the "authentication", and use my username and password for the login. Then I get a message cannot connect: the default settings sql server does not allow remote connections(provider:named pipes provider,error:40-could not open a connections to sql server)(microsoft sql server, error:2) What is the deal with this?
Another problem was i saw the sql express does not integrate with the real sql 2005. So how do i make mywebsite's web.config(express edition) to integrate for my real sql 2005 server? An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified
I'm a newbie with SQL Server Reporting Services. I've played around with creating reports and I'm now ready to move on with calling reports from my C# .Net website. Does anyone know of a good tutorial to get me started? I'm specifically interested in building the SQL string on the fly using responses from the my website user and then using that string to populate the report. Thanks!
Hi, Im currently running a website in conjuction with MSSQL Express. However at the moment the website/database seems to 'sleep' when no-one is using it, then there are huge dealays accessing the data while the database/website kicks in again. I tried to google this but truthfully i don't know what i am looking for. Does anyone have any ideas? Or whether this problem is Database or website driven? I thought there might be a control in the web.config but i haven't found a solution as yet! Thanks Daniel
Hi, I'm new in asp.net and I have few questions. My hoster have the SQL server and the webserver on different machine. I need to use a login to restrict acces to some webpages and I see that asp.net is storing that data in App_data/ASPNETDB.MDF which have the connection string set to local server. Can asp store that data on a remote database?
Since from using my local host to view my website, I am assuming I already have SQL Server installed on my computer? Is it possible to have users access my website files directly onto there own computer, say if they type my ip address or domain name into their address bar? What I am actually wanting to do is to host my website from my home computer... Any ideas, or good slash easy to understand articles on how to do this?
Hi! Not sure if this is the right place to post. I need to copy a website that I created on a CD. It is using SQL Server as the database and VB, ASP as front end. However, the problem is that I need to copy it in such a way so that it can be viewed from the CD itseld without needing MSDE or SQL Server. Need help. Thanks.
Hi! Maybe I ask simple question. But for me it’s not so. The matter’s I plan organize search at my website. It has catalog of firm’s and good’s in SQL Server. I plan to build dictionary table with two fields’ search_item and link. But problem is that I should put all search variant’s in field search_item(name of firm, name of boss, name of good etc.) Maybe there’s another concept to build search? Thank’s for any answer.
Hello everyone..... First of all i have to say that a network engineer not a programmer. So here is my question..... A contractor built a web application in visual studio 2005 and sql server 2005 expess. It is on a windows xp pro developement box.... and the site runs in VS2005 but when it is put into IIS i get SQL errors and nothing runs. Can anyone help me sort out this issue because it has been dumped in my lap and i'm clueless....... when you goto the site you are supposed to be able to loging to a server page ( not windows Authentication) however, when you enter a name and password to log in it returns a sql error. i'm really getting tired of this issue so any help would be appreciated. I have included the SQLexpress error below.... thanks in advance!
Server Error in '/' Application.
Failed to generate a user instance of SQL Server due to a failure in starting the process for the user instance. The connection will be closed. 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: Failed to generate a user instance of SQL Server due to a failure in starting the process for the user instance. The connection will be closed.Source Error:
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below. Stack Trace:
My ASP.NET application runs fine within the VS2005 IDE; but, when I deploy to my local machine to try to run it under IIS and calling it up in a browser, I'm getting the following exception: Exception Details: System.Data.SqlClient.SqlException: Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection. Source Error: An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below. Stack Trace: [SqlException (0x80131904): Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.] System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +734979 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +188 System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +1838 System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK) +33 System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) +628 System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) +170 System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection) +359 System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options) +28 System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject) +424 System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject) +66 System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) +496 System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) +82 System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +105 System.Data.SqlClient.SqlConnection.Open() +111 System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +121 System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +137 System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable) +83 System.Web.UI.WebControls.SqlDataSourceView.ExecuteSelect(DataSourceSelectArguments arguments) +1770 System.Web.UI.WebControls.ListControl.OnDataBinding(EventArgs e) +92 System.Web.UI.WebControls.ListControl.PerformSelect() +31 System.Web.UI.WebControls.BaseDataBoundControl.DataBind() +70 System.Web.UI.WebControls.BaseDataBoundControl.EnsureDataBound() +82 System.Web.UI.WebControls.ListControl.OnPreRender(EventArgs e) +26 System.Web.UI.Control.PreRenderRecursiveInternal() +77 System.Web.UI.Control.PreRenderRecursiveInternal() +161 System.Web.UI.Control.PreRenderRecursiveInternal() +161 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1360 I'm a novice at this and really need some help. What stupid newbie mistake am I making here? Thanks in advance for any guidance/assistance rendered.
