.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Post New Web Links

problem with culture info in Report.rdlc

Posted By:      Posted Date: October 31, 2010    Points: 0   Category :ASP.Net
 

Hai

          Me with C#.net and using report viewer control I am populating reports in my Report.rdlc I have a table in which two field are money values I want to format these fields so that if there is a value like 2300 it should show as 2,300.00 but when in format property I typed c then it shows as $2,300.00 How can I remove $ symobol from the field

I had changed the current culture info and tested  its working fine for a new new value but still in the report $ is showing

 private static void Pr_NewMethod()
        {
            int[] ARR ={ 3, 2, 2 };
            System.Globalization.CultureInfo cultureInfo = new System.Globalization.CultureInfo("en-US");
            System.Globalization.NumberFormatInfo NumberInfo = new System.Globalization.NumberFormatInfo();
            NumberInfo.CurrencySymbol = "";
            NumberInfo.CurrencyDecimalDigits = 3;
            NumberInfo.CurrencyDecimalSepar


View Complete Post


More Related Resource Links

Problem with changing language using culture info

  

I'm using the following msdn article to use different languages in my web application:

http://msdn.microsoft.com/en-us/library/fw69ke6f(v=VS.80).aspx

I'm following the instructions step by step in VS 2010, and it creates the resource files exactly how it's supposed to. 

However, when I run the program it just doesn't apply it. I don't see the different values from the resource file. 

If I leave my resource file name as sample.aspx.resx, it works. But when I change it to sample.aspx.en-us.resx, it doesn't work. I'm supplying culture from the aspx page's Culter and UICulture properties. I'm being very careful in choosing the correct file name, as that could be the issue,  but it just doesn't work. I also tried changing the culture in the backend code this way:

.RDLC report layout...huge problem!!

  
 Hi!I'm designing a layout for a report in VS2008 using SSRS/RDLC format. And every time I setup a part of that report i test it on my workstation to see if everything is ok. But, today, i finished the first page of that report and uploaded it to my hosting server (were it's going to be used), and when i press the button to convert the report to .pdf and download it the layout is completely ruined :-/When i do the same thing in my workstation every thing 'comes out' beautifully, but up on the server it doesn't :(Why is that happening? Can anyone help me?

Crystal Report vs 2003 convert to vs 2008 parameter problem

  

Hi friend,

I have a project develop with Visual Studio 2003, when i convert the project to Visual Studio 2005 is work well. But when i convert to Visual Studio 2008, the crystal report when have pass parameter will prompt the parameter field to re-type then show the report.

But in this converted project i create a new report and pass the parameter is ok. That means i wan re-do all report @.@??
 

Does someone can help me solve this problem??

Thank you


page postback problem with crystal report

  

Hi , i am creating crystal report with asp.net it is working showing data but  data is of two page its is take round trip action but report is not show 
until again i click on show button in this it is not propersly showing that data is how.

<br />
    <asp:Button ID="btnShow" runat="server" OnClick="btnShow_Click" Text="Show Report" />
    &nbsp;
<CR:CrystalReportViewer ID="CrystalReportViewer1" runat="server" AutoDataBind="true" DisplayGroupTree="False" EnableDatabaseLogonPrompt="False" /> CrystalReportViewer1.ReportSource = null; SqlCommand cmd = new SqlCommand(strcmd, c.con); SqlDataAdapter da = new SqlDataAdapter(cmd); DataSet ds = new DataSet(); da.Fill(ds); ReportDocument doc = new ReportDocument(); doc.Load(AppDomain.CurrentDomain.BaseDirectory + "\\rptQuotation.rpt"); doc.SetDataSource(ds.Tables[0]); // login info SqlConnectionStringBuilder csb = new SqlConnectionStringBuilder(ConfigurationManager.ConnectionStrings["conStr"].ConnectionString); TableLogOnInfos crtableLogoninfos = new TableLogOnInfos(); TableLogOnInfo crtableLogoninfo = new Tabl

RDLC Report Hide Export Option

  
The article RDLC Report Hide Export Option was added by mandandeo on Sunday, August 15, 2010.

protected void ReportViewer1_PreRender(object sender, EventArgs e) {DisableFormat(ReportViewer1, "Pdf"); }protected void DisableFormat(ReportViewer viewer, string formatName) {const System.Reflection.BindingFlags Flags =System.Reflection.BindingFlags

Unwanted page breaks in rdlc report

  

Hi 


I hav a report that has a table group =Fields!Location.Value


and in the cells I do this

=Avg(IIF(Fields!Contaminant.Value = "Element1", cDbl(Fields!Value.Value), cDbl(0)))


what I am getting is 1 row for each location then there is a pagebreak! what i want is the next location right below the  first I looked through for all the page breaks with no luck. Any ideas?


Report printing problem(ssrs 2005)

  
HI   i have a SSRS 2005 report with width as 32 inches i have a requirement to print the report in a3 landscape  but when i print the report it comes in 3 page width   is there any way to auto scale the report into a3 size without affecting the view in the report viewer   Thanks varun kumar

Problem using an action to link to a report in another site

  
Hi ! I'm using SSRS 2008 with WSS 3.0 (integrated mode) and I want, from a report in a site A, to link to a report in a site B. I'm using the full path to the report and when I paste it in a browser, it correctly shows the report. When I click on the link of the action in the report from site A, a report (having the same name) from site A is displayed instead... Any help would be appreciated Thanks Paul

Report viewer problem in Publish Website

  
hi all,          I have done website designing and i published that website in vs2005 after that i transfer to iis webroot. when i open the report viewer page i got the below error,An error occurred during local report processing.    The definition of the report 'Main Report' is invalid.      The report definition is not valid. Details: Data at the root level is invalid. Line 1, position 1.the same reportviewer page opened when i was upload to webroot without publishing website..i added all report dll file, but i got the above error (published website)Thank You,Arunabathan.G  

A connection could not be made to the report server - Problem deploying an SSRS report from Business

  
I’m having trouble with what seems to be a common issue for people, regarding deployment of an SSRS report from Business Intelligence Development Studio. Unfortunately none of the solution I have seen posted here (and elsewhere) have been able to help me so far.   Two of my collegaues can both deploy with no problem, and I am using exactly the same Target destinations as them (TargetDataSourceFolder, TargetReportFolder, TargetServerURL).   I have posted the error message below, which from my basic understaning would indicate, I think, a security issue (perhaps something local to my PC, or user account)   Has anyone experienced this particular issue who might be able to help?   Best wishes, Jamie TITLE: Microsoft Report Designer ------------------------------ A connection could not be made to the report server http://turpin-net.turpin-bg.local/Reportserver. ------------------------------ ADDITIONAL INFORMATION: Client found response content type of 'text/html; charset=utf-8', but expected 'text/xml'. The request failed with the error message: -- <HTML dir="ltr"> <HEAD><meta name="GENERATOR" content="Microsoft SharePoint" /><meta name="progid" content="SharePoint.WebPartPage.Document" /><meta HTTP-EQUIV="Content-Type" content="text/html; c

Struggling to assign the parameter value for the RDLC report, VS2010

  
 Struggling to assign the parameter value for the report, I saw so many helps in this forum. seems i have the same error comes again after i click the button. pls help what i miss in the below?   Following is my .XSD (DataSet) SELECT     [Order Details].OrderID, [Order Details].ProductID, Products.ProductName, [Order Details].UnitPrice, [Order Details].Quantity, [Order Details].Discount,                       CONVERT(money, ([Order Details].UnitPrice * [Order Details].Quantity) * (1 - [Order Details].Discount) / 100) * 100 AS ExtendedPriceFROM         Products INNER JOIN                      [Order Details] ON Products.ProductID = [Order Details].ProductID <div> <asp:Label ID="lblMessage" runat="server" Text="Label"></asp:Label> <asp:DropDownList ID="DropDownList1" runat="server" DataSourceID="SqlDataSource1" DataTextField="OrderID" DataValueField="OrderID"> </asp:DropDownList> <asp:Button ID="Button1" runat="s

RDLC Report Viewer

  
I want to Export Rdlc Report into PDF format, programmatically. How can i do that, Please help me Thanks in advance Bheemidi.  

Having problem accessing multi-choice parameter in SQL Query in Report.

  
Hi, I have a report with a multi-choice input parameter. My report contains a dataset that uses CHARINDEX on this multichoice parameter. The dataset query is in text, not in stored procedure. When I run the report I get "the charindex requires 2-3 arguments the reason being that the SQL is run as follows (You can see the multi-choice list screws up the string: exec sp_executesql N'Select test.Region [Region], test.Location [Location], nvarchar3 [Year], nvarchar4 [StatisticType], nvarchar5 [StatisticType2], ntext2 [Detail], float1 [Amount]   from [WSS_Content].[dbo].[AllUserData] UD   inner join [WSS_Content].[dbo].[AllLists] AL on AL.tp_ID = UD.tp_ListId and AL.tp_Title=''Statistics''   left outer join   (       Select UD.tp_id [ID],nvarchar1 [Region],     nvarchar3 [Location]   from [WSS_Content].[dbo].[AllUserData] UD   inner join [WSS_Content].[dbo].[AllLists] AL on AL.tp_ID = UD.tp_ListID and AL.tp_Title=''Regions''   where UD.tp_ListId = AL.tp_ID   and UD.tp_ListId = AL.tp_ID   and UD.tp_DeleteTransactionId = 0x0   and tp_IsCurrentVersion = 1   ) test on test.id = UD.int1   where UD.tp_ListId = AL.tp_ID   and UD.tp_ListId = AL.tp_ID   and UD.tp_DeleteTransactionId = 0x0   and tp_IsCurrentVersion = 1  &n

drilldown report problem

  
Hi, We are using SSRS 2005 and Sql Server 2005. I have a requirement to do drilldown report with +/-. I need to do group by CID. This is how my data looks CID    TID  fund position amount 1        11    xx    high      700 1        12    yy    Low      500 2        13    zz    Med       600           14    zz    high      800 So, TID is unique and I have to group by CID. Some rows will not have CID. What I have to do is, When I group by CID and enable +/-, all my empty CID rows are coming under + sign with out CID. My requirements are: If CID is there and there are more that 1 row for that CID, enable +/-. IF CID exists and only 1 row for that CID, do not give +/- If there is no CID, show all those transactions as independent individual transactions with out +/- sign. When I group by CID, I need to show total amount also in group header.  I appreciate your response, if some one can help me in figuring out this. Thanks, Spunny  

Problem with Report parameter inside SSRS Report Viewer webpart with deployment from one server to a

  
Hi all,I've got this problem.me and my team have developed a lot of reports by using a SSRS configured in Sharepoint Integration Mode.For accessing these report we are using the Sql Server 2008 Report Viewer Webpart.One of its parameter is the Report ur that is an absolute url so the problem is when I move our solution from server1 to server2 I have to re-editing all pages where I've added the Report Viewer webpart for updating the report url with the new servername otherwise it's impossible to view the report.Is there any official or unofficial way to solve this problem ?many thanks

Data Driven Subscription problem - sub runs slowly, has 40 errors out of 300, but report server trac

  
I have two report servers and a single separate SQL Server 2008 server hosting the data source database and the report server catalogues. There is a data driven subscription that runs off a sproc that returns 300 rows with email addresses for this report to be emailed to. The report itself contains around 30 subreports each with its own sproc to retrieve data. As the report is executing there are long pauses between the times when emails are actually sent out, and the subscription status will finally end with something like "Done: 300 processed of 300 total; 40 errors." I am not sure how to go about troubleshooting this problem. Details: I kicked it off at (say) 2:00 PM. Within 3 minutes in the report server execution log I saw 300 entries. There were exactly 300 people who should receive reports, so the master report should have executed 300 times and sent out 300 emails. So this looked good in the execution log. But when I checked report manager's status page for the subscription it was listed as processing 50 out of 300... Then all activity stopped, about 15 minutes some more reports started emailing out, and now I see there are around 590 rows in the execution log and maybe 97 emails sent out... Then finally I get a grand total of 846 rows in the execution log and a grand total of 260 of 300 emails sent out with 40 errors so 260+40=300 exactly. The time betw

Multiple Rdlc report in one reportviewer.

  
Hi, I have multiple reports that take the same parameters. Need to create a master report with all the reports merged together. I dont want to copy paste the rdlc files into one large file. found a control by Telerik called ReportBook but it costs money!! http://www.telerik.com/help/reporting/designing-reports-general-explanation.html anyone knows something similar? or am i missing something very obvious? using visual studio 2005... Cheers will subreports solve my problem? not sure how these work. so say i have a report that lists employers and i create a subreport that lists all employees for a particular empoyer. is it then possible on one rdlc to have the list of employers and a bunch of subreports for each employer's employees?
Categories: 
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend