Telerik Forums
Reporting Forum
2 answers
412 views
Hey there...I have a report that I'm working on and I have a field called AssetOwner and AssetValue....this owner has a possibility of having 3 different values (Self, Spouse, Joint)

I can bind a table and display the raw values without any problems, but at the bottom of the table I want to sum up the AssetValues based on the Asset Owners...like this.


Asset Owner               Asset Type               AssetValue
--------------------------------------------------------------------
Self                            Car                                  $5000
Self                            Boat                                $1000
Spouse                      Jewelry                            $1000
-------------------------------------------------------------------
Self Asset Total:                                                $6000
Spouse Asset Total:                                          $1000
Joint Asset Total:                                                     $0   


I was trying to just do a sum(AssetValue) but I can't find out how to filter that sum for a particular AssetType.


Any help would be really appreciated.



Thanks in advance.


John Scott.
Mayank Tyagi
Top achievements
Rank 1
 answered on 26 Jul 2011
1 answer
109 views
Hello. I have added a Chart to my report that will be a Point chart. The axes both start at 0 and go to 6. For some reason, the 0 on the x-axis is indented about 1/3 inch from the origin. (and points with 0 for X are indented 1/3 inch) What property/setting can I change to make 0 be at the origin like it is with the Y origin?

Thanks,
Justin
Justin Lee
Top achievements
Rank 1
 answered on 26 Jul 2011
1 answer
359 views
Hello,

We have created one report in telerik reporting and provided facility to export report in PDF and Excel format.
Used Code :
byte[] buffer = Telerik.Reporting.Processing.ReportProcessor.Render(chkPDF.Checked ? "PDF" : "XLS", form, null, out mimType, out extension, out encoding);

PDF file and Excel file display data. But Excel file giving an error
File Error. Some number formats may have been lost

See screen shot of error.
Peter
Telerik team
 answered on 26 Jul 2011
7 answers
144 views
********** Sorry, subject was supposed to say "Trouble ..." **********

Good afternoon,

I'm having difficulty with my VB.net 3.5 WPF application where printing with your WPF Report Viewer is no longer working since I've upgraded from version 5_0_11_316 to version 5_0_11_510.

Printing does work fine when printing from the deveoplmet computer that has Visual Studios 2010 and the latest installation (5_0_11_510) of your reporting system installed on it.

I build the application and publish it with no problems or errors flagged. There are also no runtime errors that occur. When I run the published application on a machine other than the developent computer, I load up the report view, the report loads fine, I then hit the print button and the print dialog opens. It can see all of the printers available to it, so I select print. Sadly, nothing happens from that point on other than the print dialog window closes.

Do you think I'm missing some kind of prerequisite or library reference with my application?

It's funny how the exact same program works when installed on the development machine (and when ran in debug mode in VS2010), but not on any other PC. I've tried this on several machines in my companies network, with different types of available printers (network, local etc), and I have the same results each time. I would just like to state that printing worked fine on all machines when I was using Telerik Reporting version 5_0_11_316.

The current telerik references that I have in my project are as follows:
  • Telerik.Reporting (v 5.0.11.510)
  • Telerik.Reporting.OpenXmlRendering (v 5.0.11.510)
  • Telerik.ReportViewer.WPF (v 5.0.11.510)
  • Telerik.Windows.Controls (v 2011.1.419.35)
  • Telerik.Windows.Controls.Date (v 2011.1.419.35)
  • Telerik.Windows.Controls.Input (v 2011.1.419.35)
  • Telerik.Window.Controls.Navigation (v 2011.1.419.35)

Any suggestions that you may have is greatly appreciated. I need to try and get this fixed ASAP.
Thank you very much for your time.

Rob

Rayne
Top achievements
Rank 1
 answered on 26 Jul 2011
3 answers
862 views
Hi,
 I am trying to exec function to refer another datascope. I have a list 'list1' which is bound to sqlDataSource1 and another list in this list 'list2' which is bound to sqlDataSource2, I am trying to refer to a field in datascope of list1 using exec but it is complaining invalid scope list1.
the exec function is used to display the value in the textbox:
=CDbl(Exec("list1", Sum(Fields.Id)))

I am also wondering if i can just refer to Fields.Id, which is what I actually need but for now i am just trying to get the exec function work with typical aggregate function.

Please help, Thank you
IvanDT
Telerik team
 answered on 26 Jul 2011
2 answers
488 views
Hello.
I have a table in a report that is bound to a list of objects.  I would like to add a filter to only display rows where a certain property is not null.  The property is a nullable decimal (C#: Decimal?)

How would I set this filter up?  (is it possible?)

I tried:
    Expression:    =Fields.Property
    Operator:        <>
    Value:            =Null
And
    Expression:    =CStr(=Fields.Property)
    Operator:        <>
    Value:            <left the value blank>

but neither worked.

Thanks,
Justin
Justin Lee
Top achievements
Rank 1
 answered on 26 Jul 2011
11 answers
251 views
LightSwitch is going to be a great development tool for LoB apps based on Silverlight 4 technology. It saves a lot of time by automating many steps. However, any LoB apps ends up requiring lots of reports, printings and etc. But the unfortunate part is, LS V1 (due to time constraints and others), will not have reporting and I see more and more developers voicing their frustration and disappointment over this issue. I think Telerik has a great Reporting service and with the new SL viewer, it can perhaps solve this problem and offer a solution.

My question, is the team looking at having a custom solution for LightSwitch? If yes, please let us know, so we can spread the word and bring you business.

Thanks!
..Ben
Vassil Petev
Telerik team
 answered on 26 Jul 2011
4 answers
154 views
Hi there.

I have a need to capture the filtering criteria that a user selects and save it as an item in their "My Reports" section. I think how this would work is you would create a canned report that a user can run and select the criteria that makes sense for them, then executes the report. When the report gets created, the user would be able to save the criteria so they can run the report quickly the next time.

Also, is there anyway to have the user select which columns of data they want to see as well?

Just seeing if it can be done with Telerik.

Thanks, Mike
Paul
Top achievements
Rank 1
 answered on 26 Jul 2011
2 answers
177 views
Hi,

I have created a test bar graph inside Telerik Reporting and I can't figure out why the texts are blurry when PDF & printing.  I did a search but can't find the answer to my issue.  I have check my Adobe's display resolution and it is set to Use System Setting.  What am I doing wrong?   If you need more information, let me know.


I am using Telerik Reporting Q2 2011.

Thanks!
Hin
hin
Top achievements
Rank 1
 answered on 25 Jul 2011
1 answer
79 views
Hi, i am trying develop some reports in silverlight 4 desktop application with Telerik Reporting Q1 2011 version 5.0.11.510.
My problem is that i don't know how to bind my report to the ReportViewer.
The xaml code is this:

<StackPanel VerticalAlignment="Stretch" HorizontalAlignment="Stretch">        
        <telerik:ReportViewer Name="reportViewer" Report="Reporting.Report, Reporting"  Height="700" Width="800" HorizontalAlignment="Center" VerticalAlignment="Center"/>
</StackPanel>

where Reporting.Report is a simple report with only a textbox.
If i run this code no report will be displayed, i like to understand where is the mistake. Can anyone help me?

Thanks,
Gio
Peter
Telerik team
 answered on 25 Jul 2011
Top users last month
Rob
Top achievements
Rank 3
Bronze
Bronze
Iron
Sergii
Top achievements
Rank 1
Iron
Iron
Dedalus
Top achievements
Rank 1
Iron
Iron
Lan
Top achievements
Rank 1
Iron
Doug
Top achievements
Rank 1
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?