hi.. i'm facing a new problem in ssrs reports ... i have hosted an asp.net application which is running fine in XP.. but when i open the application in UBANTU OS application is working fine but reports in kannada are not displaying it is displaying some russian character .. same problem when i export to PDF it is displaying some russian character.. In windows XP prof3 Kannada reprots are working fine.. but in ubantu OS it is not displaying the fonts.. what to do... ? help me....

hi.. the below is my SP.. i want to pass the parameter @name to the open query but it is showing the error incorrect syntax near '+' ALTER PROCEDURE [dbo].[cub] @name nvarchar(50) AS BEGIN SET NOCOUNT ON; select * from OPENQUERY(XHMNDGHFYUHFGHJFFRJF,'select {[Employee].[Dept].[Dept]*[Employee].[Empno].[Empno]} on 1, [Measures].[Salary] on 0 from [Employee] where [Employee].[Empname].&'+ @name +' ') END if i pass the value directly.. like this.. where [Employee].[Empname].&vasu ') it will execute fine.. but through the parameter name it will show error.. help me..

Thanks for reply.. i have an old backup consider for ex on 01-02-2011 after the backup i have added some entries into the table.. now my database is crashed if i restore the old backup only the old data will be restored .. but how to retrive the new data that i have entered after the old backup.. help me...

Hi.. i am using sql server 2008.. if suddenly database crashes then how to recover it? what about data?

hi.. check the following code.. <script type="text/javascript"> var indMoney = function (v) { v = (Math.round((v - 0) * 100)) / 100; v = (v == Math.floor(v)) ? v + ".00" : ((v * 10 == Math.floor(v * 10)) ? v + "0" : v); v = String(v); var ps = v.split('.'), whole = ps[0], sub = ps[1] ? '.' + ps[1] : '.00', r = /(\d+)(\d{3})/; while (r.test(whole)) { whole = whole.replace(r, '$1' + ',' + '$2'); } v = whole + sub; return v; } </script> The result of the above function is displaying like this 123,123,123.00 but i want in this format 12,31,23,123.00 i.e indian currency format..

thanks for replying.. sorry for one more stupid Question There are two teams hosting team and development team developers build the software and related document before release they have the code and document. now what is the process to that builded project to the hosters i.e hosting department.. means... what are the steps that we should keep in mind before we give the project to the hosters.....??

hi... i have released one application.. now i have to maintain the document for the released application.. which is the best method to write the information such as in word,or pdf or excel or is there any way to keep the document..? so that every one should know that the new release application is released .. and they should be updated i've hosted the previous application and now i have release the modules in that application .. now i have inform all the user that we have released new modules with etc etc features .. which is the best way to inform the user about newly released application..?

hi.. this is my SP USE [TASKDB] GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO ALTER PROCEDURE [dbo].[GetCmtRpt] -- Add the parameters for the stored procedure here @logid int AS BEGIN SET NOCOUNT ON; -- Insert statements for procedure here SELECT Date ,From_Name ,To_Name ,Todays_Task ,Tommorrows_Task ,Status,Comments,Date as months from TaskSheet inner join login on TaskSheet .loginID = login.loginID where login.loginID = @logid order by Date desc END i want to display the months field as jan feb mar based on date how to do...?

hi.. The following is my Sp SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO ALTER PROCEDURE [dbo].[GettomoTaskSheet] -- Add the parameters for the stored procedure here @fname nvarchar(50) AS BEGIN SET NOCOUNT ON; SELECT date,To_Name ,Todays_Task,Status ,Tommorrows_Task,REPLACE(Comments, 'vinni','<font color="red">raki</font>') as comment from TaskSheet where From_Name = @fname; END The above SP is used for displaying the data in SSRS reports .. but when i run the SP in comment field where vinni occurs i want raki in red color but it is displaying <font color="red">raki</font> this value. i want to display the word raki in red color in ssrs2008 reports please help me..

hi.. i've created an report in which i want to change the color of the particular word i've four words which i want to change the color john,steve,mike,and danial.. for these name where ever they appear in the row the color should change is it possible.. ??

hi.. i'm using ssrs 2008 enterprice edition.. i want to send a report as email.. to my gmail address.. i want to schedule a report so that it can deliver daily to my gmail address.. how to send the report to my gmail address.. i dont know anything about smtp server activation and services and also in configuration of reporting services.. i dont know how to configure email settings.. please help me.. can anyone provide a step by step datails for the above requirment..

hi.. i'm trying to retrieve the data from database using ssis package.. database name is employee which contains 48 tables and it is around 20GB of memory.. it is a production database.. now what i want is to retrieve the data for each four hours.. i.e i want to execute the package for every 4 hrs.. now what i did is i have taken a database transfer task and from the source i.e production database i want to transfer to my database which works fine.. but what is the problem here is for every 4 hrs whole DB is replaced in my system i've given overwrite TRUE.. Here user enter the data into database for every 4 hour is minimum 10 MB of data.. instead for replacing the whole database for every 4 hrs is there any solution that what user enter data into database only that much amount of data should be append into my system.. is it possible please help me..

hi... to all i've two system one's domain name is sam and my domain name is ram.. i've deployed my reports in ram system i'e in my system URL (http://ram/reports) it prompt for user name and password.. and i'll give windows crediantial which works fine.. now when i enter the same URL in sam's system it will again prompt for user name and password if i give my windows crediantial then it work.. but if i give his crediantial the following error is displayed " (The permissions granted to user 'domain\user' are insufficient for performing this operation. (rsAccessDenied)"... now how to create his user name that is sam and password ..? when i try to create a new role assignment by giving [domainname\sam] then [rsunknown] error is displayed.. and i have tried to create a new user account in my system only.. and when i create a new role it has created without any error.. but when i run the URL (http://ram/reports) prompts for uname and pwd if i enter sam and pwd again the same error is displayed... please help me..

hi.. everybody i got the solution here.. http://community.discountasp.net/showthread.php?t=4402 but now again i'm in a problem how to assign security role for different system in a network for a folder or it can be report.. i want to assign diferent permission for different users..

hi.. everybody.. i'm using ssrs2008 without IIS ... i've created my reports and deployed in my system.. i.e http://localhost:8080/rpt which are working fine.. (" i.e in XP prof SP3") now i've developed an application in different system which windows server2008 in that i'm using reportviewer now.. what i want is when i run the project in windows server the reports display from my system.. i.e my url http://myip:8080/rpt error msg("enable to connect remotely") please help me... i've tried by giving my http://myip:8080/rpt in another system .. but it will ask username and password i've tried giving my system and password .. and also the system name and passward where i'm trying to execute.. the error is displayed ("An application error occurred on the server. The current custom error settings for this application prevent the details of the application error from being viewed remotely (for security reasons). It could, however, be viewed by browsers running on the local server machine.") wat to do...

modified on Saturday, December 4, 2010 8:25 AM

hi... everybody sorry for my stupid question.. i've three options for creating the reports 1)crystal reports for asp.net application using crystal report viewer or silverlite application using silverlite report viewer.. 2)ssrs reports for asp.net application using microsoft report viewer or silverlite application using silverlite report viewer.. 3)report sharp shooter for asp.net application using report manager preview or silverlite application using report manager.. i'm really confused which one to choose.. the main requirment for me is the report should be fast accessible in server as our application is big.. the report should be fast viewed and take the print at the client side... and also load should be less at serverside.. please can anybody help me which one to prefer...

thanku.. for reply i have just change the language setting..

hi... to all.. i've written the code in expression field... =format(sum(fields!salary.value),"##\,##\,##\,##\,##\,##\,##0.00") the code is for printing the number in this format(12,23,23,34,123.00) now i got an problem i.e if i give 5 digit the it will print ,,,,,12,123.00 the remaining commas are printed.. i dont want to print the extra commas.. how the word length is there that much it should take..i.e( for 5 digit 12,123.00 and for 9 digit 12,23,23,123.00)... i've tried by removing some of the #'s but it is for fixed number.. please help me...

thanks .. i got in 2008 enterprise edition....

hi.... in which version of sql server i can get the below two option... 1) performance tools 2)database tuning advisor.. please send me the download site...