Telerik Forums
Reporting Forum
9 answers
5.9K+ views
Hi everyone,
Can anyone tell me how to change the numeric format??

In my case, I want to change the -ve sign into ( ), and have the digit grouping when the number reach thousands.(If anyone familiar, it's like the Excel format, changing the negative format)
I can change the -ve sign into ( ) using the IIf() function. E.g: = IIf(Fields.creditAmount>0, Fields.creditAmount, "(" + (Fields.debitAmount) + ")") . So the result which I get satisfy me. If the number is larger than 0 (which is not a negative number) , it display 1123.45. 
If  the result is smaller than 0 (which is a negative number), it display (1123.45). So far the result, fullfill my first requirement.

However, by doing the above stated (using the IIF( ) function), I could not manage to get the digit grouping. How can I do that? I try using the {0:N2},  but the result won't display according to the format digit.

Can anyOne help me? I appreciate any opinion. Thank you very much.
Patrick
Top achievements
Rank 1
 answered on 06 Jul 2010
0 answers
85 views
I have white space on the right of my graph as seen in the image attached to this post.  Anyone know how to get rid of this?

EDIT: I fixed this
ryan
Top achievements
Rank 1
 asked on 06 Jul 2010
2 answers
81 views
I found in the system requirement section in this Web that the requirement of using Telerick components in Windows applications does not apply to Windows 98.

Question:
1. Application writen by Telerick components cannot work under Windows 98 Second Edition, even dotNet 2.0 is installed?

Urgent. Pls. help.
Benson.
Derek
Top achievements
Rank 1
 answered on 06 Jul 2010
1 answer
117 views
Does a report viewer require a report get its data from a telerik SqlDataSource (as opposed to the microsoft version)?  I am currently using an asp SqlDataSource to provide information to my report.  The report works fine when rendered manually using ReportProcessor.RenderReport() but doesn't render correctly when put into a report viewer.  When put into a report viewer, i get this error:

An error has occured while processing Report '':
The expression contains object 'Test_Type' that is not defined in the current context.


Peter
Telerik team
 answered on 06 Jul 2010
0 answers
81 views
.xaml
<Window x:Class="Reports.Window1"
    xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"
    xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml"
    xmlns:telerik="clr-namespace:Telerik.ReportViewer.Wpf;assembly=Telerik.ReportViewer.Wpf"
    Title="Window1" Height="558" Width="532" xmlns:my="clr-namespace:Telerik.ReportViewer.Wpf;assembly=Telerik.ReportViewer.Wpf" Loaded="Window_Loaded">
    <Grid>
        <telerik:ReportViewer Margin="-2,0,0,0" Name="reportViewer1"   />
    </Grid>
</Window>

how  preview  Report.cs in a <telerik:ReportViewer>
Shanka
Top achievements
Rank 1
 asked on 05 Jul 2010
0 answers
61 views
hello,
press the print button in shower ,it has not pop the print page,why?
Anyone know how to solve this problem?thanks!

dida
hui
Top achievements
Rank 1
 asked on 05 Jul 2010
1 answer
251 views
Hello,

I want to create a report viewer parameter combo box but can't seem to figure out a certain part of doing it.  When I'm creating the report parameter, how do I choose the values for the combo box?  I.e. I need a combo box where the user can choose between two values which are "Summary" and "Detailed".  I tried putting those values into an array and assigning it to the AvailableValues.DataSource but that didn't work because it then asks me to fill DisplayMember and ValueMember (which is a problem because an Array doesn't have column names, which is what DisplayMember and ValueMember want).  I also can't find a single example of how to do this.  Anyone know how to do this?

Ryan
Steve
Telerik team
 answered on 05 Jul 2010
0 answers
89 views
how can we give multiple filters  using below coding iam already given data filteroperator in 

now how can i give another data.filteroperator for that same form

 Telerik.Reporting.Data.Filter f12 = new Telerik.Reporting.Data.Filter();
            f12.Expression = "=Fields.courseid";
            f12.Operator = Telerik.Reporting.Data.FilterOperator.In;
            f12.Value = "=Parameters.Courses";
            rp2.UI.AvailableValues.Filters.Add(f12);
pich cock
Top achievements
Rank 1
 asked on 03 Jul 2010
2 answers
236 views
I also am having a problem with the ReportViewer not working after having moved my project into VS2010 and .NET 4.0.  The ReportViewer shows no data for my drop down controls and no chart.  I have added the <handler> to web.config that I found in another post:
<system.webServer> 
    <handlers> 
      <add name="Telerik.ReportViewer.axd_*" path="Telerik.ReportViewer.axd" verb="*" type="Telerik.ReportViewer.WebForms.HttpHandler, Telerik.ReportViewer.WebForms, Version=4.0.10.317, Culture=neutral, PublicKeyToken=a9d7983dfcc261be" preCondition="integratedMode,runtimeVersionv4.0" /> 
    </handlers> 
    <validation validateIntegratedModeConfiguration="false" /> 
</system.webServer> 

I am currently running Telerik Reporting Q3 2008 SP2 (v2.9.9.202).  Would updating to a newer version help?
Thanks.  Dan
Dan
Top achievements
Rank 2
 answered on 02 Jul 2010
1 answer
155 views
How can we use stored procedure returns mutiple result set in telerik reproting? First result set returns company name and address that goes in report header section, second result set returns detailed rows for report. Any examples would be much appreciated. 

hanks for your time.

Steve
Telerik team
 answered on 02 Jul 2010
Top users last month
Will
Top achievements
Rank 2
Iron
Motti
Top achievements
Rank 1
Iron
Hester
Top achievements
Rank 1
Iron
Bob
Top achievements
Rank 3
Iron
Iron
Veteran
Thomas
Top achievements
Rank 2
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?