I was working on a report that had a sub report that displayed in multiple columns. From what I understand Telerik Reports do not currently support multiple columns in sub reports so I came up with this hack.

1)      Create master report

2)      Create a sub report for as many columns you need

3)      For the sub reports you will need to return a rownumber value. From that you can use the modulus function to filter what is displayed. For example:

 Report1 filter would be

Me.Filters.AddRange(New Telerik.Reporting.Data.Filter() {New Telerik.Reporting.Data.Filter("= Fields.RowNumber Mod 2", Telerik.Reporting.Data.FilterOperator.Equal, "0")})

        Report2 filter would be

Me.Filters.AddRange(New Telerik.Reporting.Data.Filter() {New Telerik.Reporting.Data.Filter("= Fields.RowNumber Mod 2", Telerik.Reporting.Data.FilterOperator.NotEqual, "0")})

This splits the sub report columns to odds and even based on row count.

I wanted to make the solution a little more robust and move some processing to the server so I ended up using the stored procedure below. You pass in the total number of columns and which column the call is being made from. For example for a two columns-

subreport1 would pass @NumberofColumns=2, @ColumnNumber=1, @MultiColumn=True
subreport2 would pass @NumberofColumns=2, @ColumnNumber=2, @MultiColumn=True

I hope this helps and if anyone has ideas on improving this please post them.

CREATE PROCEDURE [dbo].[NET_sp_PullBuildingSubDept2]

(

      @BuildingIdnt int=0,

      @NumberofColumns int=0,

      @ColumnNumber int=0,

      @MultiColumn bit =0

)

AS

BEGIN

      SET NOCOUNT ON;

If (@MultiColumn =0)

BEGIN

      SELECT    REPLACE(REPLACE(EntityName,'(COM)',''),'(RES)','') as EName, EntityName as EntityName, DepartmentType, PoliticalSubdivision, ApprovalDate, BuildingIdnt,Row_Number() OVER (ORDER BY EntityName) as RowNumber

      from dbo.NET_vw_Building

      where PrimaryBuildingIDnt=@BuildingIdnt

      order by entityname

END

ELSE

BEGIN

      If (@ColumnNumber =@NumberofColumns)

      BEGIN

            Set @ColumnNumber =0

      END

      ;With MyCTE as

      (

      SELECT    REPLACE(REPLACE(EntityName,'(COM)',''),'(RES)','') as EName, EntityName as EntityName, DepartmentType

      , PoliticalSubdivision, ApprovalDate, BuildingIdnt

      ,Row_Number() OVER (ORDER BY EntityName) as RowNumber

      from dbo.NET_vw_Building

      where PrimaryBuildingIDnt=@BuildingIdnt

      )

      SELECT EName, EntityName, PoliticalSubdivision, ApprovalDate, BuildingIdnt, RowNumber

      FROM MyCTE

      WHERE RowNumber %  @NumberofColumns = @ColumnNumber

      order by entityname

END

END

GO

Hi there. 
I try to access the ReportProcessor and receive the following three Exceptions:



To translate this it means the , Telerik.ReportConverter.ActiveReports, Crystalereports and XtraReports could not be found. The telerik reporting dll 5.1.11.928  is added as a reference. I also tried another (newer) version of reports. The code area looks like this:

private RenderingResult RenderClearingArchivedReport(int clearingId, string culLang)

       {

           RenderingResult result = null;

 

           rptClearingArchived reportClearingArchived = new rptClearingArchived(culLang, this.DocumentTitle);

           reportClearingArchived.ReportParameters["clearingId"].Value = clearingId;

           result = new ReportProcessor().RenderReport("pdf", reportClearingArchived, null);

 

           return result;

       }

the line "result=" is throwing the exception.

The code was working on my collegues machine (who is on holidays currently) so there MIGHT be a configuration issue he did not check in.

Probably something really stupid.

I currently have a standard report that is working well and looks something like the following:

-----------------------------
Product: Foo
-----------------------------
Date      Itmes Sold    Total
Feb 01    5             14.95
Feb 03    2             5.98
Feb 04    10            29.90
-----------------------------
Total     17            50.83 [1]
-----------------------------

-----------------------------
Product: Bar
-----------------------------
Date      Itmes Sold    Total
Feb 01    7             34.94
Feb 03    1             4.99
-----------------------------
Total     8             39.92 [1]
-----------------------------

//...
more products
//....

-----------------------------
Report
Totals    26            90.75
-----------------------------

I've been asked to include a summary at the bottom of the report.  The summary will list the totals for each product (the information marked [1] above) similar to the following:


-----------------------------
Summary
-----------------------------
Foos      17            50.83
Bars       8            39.92
-----------------------------
Total     26            90.75
-----------------------------


As there is only one item detail per report, can this be done?  How would I create the summary?  Do I need to create a sub report?

Any help would be appreciated.

I have just installed the 2012 Q1 release.
If I create a new project and add a Telerik report,
the Telerik.Reporting and Telerik.Reporting.Design dlls
are added to the project's references.
The designer throws an error that the Telerik.Reporting.Report class is not found.
The Telerik,Reporting assembly is not visible in the object browser.
Afte closing VS and reloading the project, the Telerik.Reporting dll is visible
in the object browser until I either build the project or open the report designer wizard.

I'm using VS2010 SP1 on windows 7 professional 64bit.
Has anyone else run into this issue?
Corrective action?
Thanks,
Mark

I have a query that is returning TotalSubmissions, AcceptedSubmissions, RejectedSubmissions and PendingSubmissions.  These are drawn as four bars on a bar chart.  I want to add two ChartMarkedZones to the chart, one at 10% of the TotalSubmissions and one at 60% of TotalSubmissions.  How do I go about this?

Thomas

I have a crosstab with the following Row Groups:
Year ->
     Month ->
             Sales Unit ->
                       Sub Sales Unit 1 ->
                                  ... Sub Sales Unit N ->
                                                           Product ->
                                                                             Detail.

Groups are linked to each other by parent-child relationship.
In an application this tree structure is dynamic, the level of the Sub Sales Units equals 1...N (for example Nmax=5). User can select Sales Units that are shown on the report.
How to prepare a report with this structure. Is it possible to hide unused levels and show Product and Details?
Detail group in the crosstab is linked with the last child group. How can I show Product and Details if there are less levels than Nmax?
Attached image shows a report with one Sub Sales Unit. I'd like to avoid designing a separate reports for each level.

Thanks,
Sebastian

Hi,

After click the print button,no dialog display anymore and directly print to a pdf file. I checked the demo(http://demos.telerik.com/reporting/product-sales/demo.aspx)     it's the same.But the previous version is normal.

thanks

Kevin

I am calling ReportBook from ReportViewer(in silverlight). In silverlight I am passing parameter to reportbook as follows.
In ReportBook I am adding reports as follows.

Report1 needs parameter FormNumber. Report2 needs parameter FormID.
1. How to transfer these parameter to appropriate reports from reportbook?
2. Is there any way to add reports to reportbook from client(Silverlight) with appropriate parameters?

Hi,

I need to put a subreport in a groupfooter, and I can't seem to make it work.
So, I have a Master Report, called List, this object has several properties that have to be set on the Master report.
In the detailsection I've put an SubReport, this Detail Report contains all lines from the List.
Until here, everything works great.
In the detailreport I've added several groups, because the lines have to be grouped.

Example:

Driver A (Driver-Group)
    Customer X (Customer Group)
         Address XYZ (Address Group)
              - Line1
              - Line 2
              - Line 3
          Address XYZ Footer: SubReport with all carriers on line 1,2,3
        Address ABC
              - Line 4
              - Line 5
         Adress ABC Footer: Subreport with all carriers on line 4,5
    Customer Y
    ...
Driver B
...

So I've managed to display all lines corretly,
I've also managed to get all group-data (Driver A, Customer X, Address XYZ)
By storing it in private variable in the detail_ItemDataBound,
when I debug I see that the correct data is being fetched.



or by using the data I find for each Address-group:


which is sufficient to me to get data for the subreport in the footer.


Only the last line of code (subTLCarriers1.DataSource = amountOfCarriers;) sets the datasource on the control on the Detail Report, not the instance of the subreport in de groupFooter, as result, I get the same subreport for ALL the groups in my Detail Report instead of a different subreport for each address-group of lines.

Could you help me find a way to set the DataSource of each instance of the subreport in the Group-Footer,
so that each Address-Group get it's own subreport in it's footer?

Any help is very much welcome since I've been struggling with this for a few days now.

How to show ellipsis to indicate text overflow in the textblock control in telerik reporting