Telerik Forums
Reporting Forum
3 answers
1.0K+ views
Hi
    When i have groups in a report,and i want to show sum of one column just like following:
   
    name         subject          score
    kate            English          88
    kate            math              100
    kate            chinese         90
    kate           total               278(sum of score above)

    name         subject          score
    lily              English          80
    lily              math              90
    lily              chinese         100
    lily              total               270(sum of score above)

How can i do?

Thanks.
3ms
Top achievements
Rank 2
 answered on 07 Apr 2009
2 answers
100 views
The report viewer is there, so is the report header, but the data does not show up. It works on my local box. I checked the connection string.

What am I missing
Steve
Telerik team
 answered on 07 Apr 2009
1 answer
121 views
Dear support,

Recently I switched from the 2008Q3 release to the 2009Q1 release and noticed that it is not possible anymore to refresh the report anymore. In the previous release I could refresh the report by setting the ReportViewer.Report property to the new report. The report was refreshed if I did a reassignment upon postback of the page.
However after upgrade to the 2009 release the report is not refreshed anymore, it will stick to the initially loaded report. 

How to get this solved?

Best regards,

Daniel van Oostveen
Steve
Telerik team
 answered on 07 Apr 2009
1 answer
124 views
I'm anxious to ditch Crystal Reports and start working with Telerik in production but i first need to convert all my reports to Telerik. Problem is, i had some wacky reports but i'm sure there is a way to reproduce them. See the pic below before moving on :

http://s734.photobucket.com/albums/ww342/crazycoders/?action=view&current=crystallayout2.jpg

This layout, although it looks like it's displayed horizontally is actually displayed vertically like any other reports, but what we used was to simply detect group changes based on the employee name and service name and in the details section we'd hide the field that gets repeated for nothing.

In Telerik, i though i could achieve this doing the following: (Note that PreviousEmployeeName and PreviousServiceName as simple Strings declared private at the top of the report object)

    Private Sub Details_ItemDataBound(ByVal sender As ObjectByVal e As System.EventArgs) Handles Details.ItemDataBound 
        If PreviousEmployeeName = "" Or PreviousEmployeeName <> EmployeeName.Value Then 
            PreviousEmployeeName = EmployeeName.Value 
            PreviousServiceName = "" 
        Else 
            EmployeeName.Value = "" 
        End If 
    End Sub 
 
    Private Sub ServiceName_ItemDataBound(ByVal sender As ObjectByVal e As System.EventArgs) Handles ServiceName.ItemDataBound 
        If PreviousServiceName = "" Or PreviousServiceName = ServiceName.Value Then 
            PreviousServiceName = ServiceName.Value 
        Else 
            ServiceName.Value = "" 
        End If 
    End Sub 

But this doesn't do what i would have expected it to do... instead it does the following:

http://s734.photobucket.com/albums/ww342/crazycoders/?action=view&current=teleriklayout2.jpg

And you can see in this picture that the employee name seems to repeat twice then stops but the service name never stops repeating. I don't think my logic is all that bad.. can someone help me try to achieve that layout?

Thanks




Ivan
Telerik team
 answered on 06 Apr 2009
3 answers
187 views
I am trying out Telerik Reporting component and currently have a problem that I hope to get some help with.

I have everything setup in my application and the report seems to work on first pass.  After I make changes to my database via the application, e.g. My application assigns an asset to a person, none of my associated reports show the changes in the database.  Other portions of my application do reflect the change indicating that the changes are successful, but my Telerik reports do not see the changes.  The only I can get the reports to reflect the changes is by restarting my application.  This obviously will not be an acceptable behavior.

I was hoping someone can help me with this.

Thanks in advance.  Prompt responses are definitely appreciated.
KNana
Bob
Top achievements
Rank 1
 answered on 04 Apr 2009
5 answers
163 views
Hi,
I've been trying the report tool (v1.1). My data was generated by the radeditor which has embedded html markup in it. When the report is generated it shows the data just fine. When I try to export the data to pdf or tiff, the html markup is shown literally. When I attempt to export to a web archive, the html markup is ok (as expected), except I have <img> tags that are not resolved (I get the red X). I have the HtmlRendering.dll, ImageRendering.dll and WebForms.dll in my bin directory of the app.

I'm I missing something required to have my markup rendered correctly including images?

Thanks,
Bruce
Steve
Telerik team
 answered on 03 Apr 2009
2 answers
266 views
I have an existing web report that I want to convert to use the table control in order to get better column alignments and to fix some exporting issues.  I've looked at the new demos, which all look to use the crosstab control, and not the table.  My current report binds the datasource to the report of the reportviewer in an aspx page by using something like:

_report = ReportViewer1.Report

_report.DataSource = ds.Tables(0).DefaultView

The current report also uses groups to group hierarchial data.  I would like to either convert this report, or create a newer report class for the above mentioned reasons.  So I have some questions about the table control.
1) Initially, it looks like I have to bind a datasource to the table and not to the report anymore.  Is that true and if so, how do I programmatically bind the datasource defined in my aspx page to the table in the report of the reportviewer?

2) Some column headings from the original report span multiple columns of the detail section.  I would assume to get the same effect with the table control I could merge columns.  However, I was unable to figure out how to merge adjacent cells in either the table header or detail.  How is that accomplished?

3) When I added a row grouping to group by a field in my datasource, the designer appeared to bunch the grouping into a single column that spanned a couple of rows.  I just have 2 layers of simple grouping I need to perform for the report, and I would expect for the group row to span the length of the table, but it doesn't.  What is the proper way to add row groupings to the table control?

4)  My current report has aggregate sums and calculations in the group headers of the different groupings.  How do I associate those cells with the same grouping scope?

5)  It appears that the demos use the crosstab and not the table control.  I understand they are similar, but the crosstab has sections that I don't feel I need for this type of report.  Is there an example of a table report that uses groupings that I could download and learn from?

An example layout of the report I am working is similar to this:
Segment 1  total1   total2  total3  total4
  Division 1  total1   total2  total3  total4
      Plant 1  data1  data2  data3  data4
      Plant 2  data1  data2  data3  data4
  Division 2  total1  total2  total3  total4
      Plant 2  data1  data2  data3  data4
      Plant 2  data1  data2  data3  data4
Any answers, help, or examples would be most appreciated.
-kenf-

Steve
Telerik team
 answered on 03 Apr 2009
1 answer
81 views
Hi all

I am facing a rather strange problem while using the Telerik Reporting tool.I have enabled the show zoomselect property to true in my code. When i view the report  in Internet Explorer the zoom dropdown is visible as it should be but when i open the same report in a Firefox browser,Surprisingly the zoom dropdown is missing......

Has any 1 come across a problem like this......Please help/Suggest how to get arround this problem.


Thanks and regards
Rahul GCT
Steve
Telerik team
 answered on 03 Apr 2009
4 answers
189 views
Active Reports had a winform tool that people could use to build reports outside of VS.net.  This would allow people other than developers to create reports.  These reports could be saved in their xml format (.rpx I think), which could be loaded up at runtime, bound, ran, then exported as PDF, etc.  Does Telerik plan to support this type of scenario in the future?  If so, would there be a winform or wpf report designer app for this?  I am not very familiar with Telerik Reporting so far, but did not find anything like this on your site or documentation.
Steve
Telerik team
 answered on 03 Apr 2009
1 answer
64 views
After upgrading from Q3 2008 to Q1 2009, all my existing reports show up as regular .vb files.  I can click on them and view the code-behind but I see no way to get to the designer.  Underneath in VS 2008, I see .designer.vb files that seem to open the designer code with the textboxes and such.

If I create a new report, it shows up correctly.  So I think the system is just identifying these incorrectly.  Any help in changing these so I can design them?
Chameleoki
Top achievements
Rank 2
 answered on 03 Apr 2009
Top users last month
Rob
Top achievements
Rank 3
Iron
Iron
Iron
Atul
Top achievements
Rank 1
Iron
Iron
Iron
Alexander
Top achievements
Rank 1
Veteran
Iron
Serkan
Top achievements
Rank 1
Iron
Shawn
Top achievements
Rank 1
Iron
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?