Ref : http://social.msdn.microsoft.com/Forums/en/transactsql/thread/8fb014a7-4505-48c2-9f8c-d35fcd73b208 SSRS — SQL Reporting Services — Need to show Rupees symbol in report. –declare @currency nvarchar(20)set @currency=nchar(convert(int, 0x20B9))select nchar(unicode(@Currency)) AS RupeeSymbol
I am using Visual Studio 2005 and os is windows 2007. I had an issue that when I add Report Viewer control , i faced below error. 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 [...]
Get primary key from table name DECLARE @tableName varchar(50) select @tableName = ‘@tablename’ — exclude schema SELECT [name] as primarykeyname FROM syscolumns WHERE [id] IN ( SELECT [id] FROM sysobjects WHERE [name] = (@tableName)) AND colid IN (SELECT SIK.colid FROM sysindexkeys SIK JOIN sysobjects SO ON SIK.[id] = SO.[id] WHERE SIK.indid = 1 AND SO.[name] [...]
–get column info like column name and column type SELECT Table_Schema, Table_Name, Column_Name, Data_Type FROM information_schema.columns WHERE table_name in ( select name from hha..sysobjects where xtype = ‘V’ and name like ‘@objectname’ ) – get table name from field name SELECT Table_Schema, Table_Name, Column_Name, Data_Type FROM information_schema.columns WHERE table_name in ( select name from hha..sysobjects [...]
ALTER SCHEMA destinationschema TRANSFER sourceschema.objectname from http://sql-articles.com/scripts/change-transfer-schema-for-all-objects/
find, usage of reports from report server. –Server:Report server –Database: ReportServer select c.* from ExecutionLog e inner join Catalog c ON c.ItemID = e.ReportID
I found one good link to recover multiple RDL file from server. Reporting Services Scripter is a .NET Windows Forms application that enables scripting and transfer of all Microsoft SQL Server Reporting Services catalog items to aid in transferring them from one server to another. It can also be used to easily move items on [...]
I have read very good article By Milan Negovan here at http://aspnetresources.com/articles/ViewState.aspx Its worth to read. Thanks Milan Negovan . ASP.NET view state is a great feature and an essential tool for web development of today. It maintains the state of a page as it travels back and forth. There is no more need to [...]
if you want to load chart in your asp.net web application , you can try Microsoft Office Web Components. http://msdn.microsoft.com/en-us/library/aa198515%28office.10%29.aspx If you want simple web chart and totally based on dotnet library then use this demo project. Its also simple and nice. http://www.codeproject.com/KB/custom-controls/webchart.aspx Main thing is that both are free , so enjoy web charts.
I had many user controls with datagrid in one page, which worked in my local work station but it suddenly raise below error on production server after deployment. Validation of viewstate MAC failed. If this application is hosted by a Web Farm or cluster, ensure that <machineKey> configuration specifies the same validationKey and validation algorithm. [...]
