Telerik Forums
Reporting Forum
1 answer
400 views
I'm using a table with a rotated layout, so the items are listed horizontally.  If the page has room for 5 items, the 6th item is displayed on a new page (for pdf output).  Is there a way to force the table to restart on the same page if possible? 

So instead of having item 6 on the next page, I'd like it to "start over" under the first 5 items.

Instead of this:
Page 1 Boundary                                  Page 1 Contents                              Page 2 Boundary        Page 2 Contents  
           |                       Item 1         Item 2       Item 3       Item 4        Item 5            |                        Item 6          Item X...

I want this:
Page 1 Boundary                                  Page 1 Contents                              Page 2 Boundary
           |                       Item 1         Item 2       Item 3       Item 4        Item 5            |            
           |                       Item 6         Item X...


Is there any way to accomplish this?
IvanY
Telerik team
 answered on 08 Feb 2012
3 answers
396 views
Dear,
I have been evaluting Telerik Reporting for one of my clients who is already using crystal reports. For this I have produced some their reports in Telerik. I am facing  some very serious problems during the reports development. One of these problems is listed below for your consideration.

I have developed a cross tab report with drill down. In which i have two row groups One is Category (parent) group and other is Description (child) group. I initially set Description visibility False and set its visibility to toggle on Category Action. It is working fine for following Layout of Crosstab offered by Telerrik.

  1. No Subtotals and grand totals
  2. Blocked Layout, Subtotals below
  3. Blocked Layout, Subtotals above

But my required Layout for the report is "Stepped Layout, Subtotals above". When I select this Layout for my report and try to drill down the report by clicking plus sign I get the following error.

An error has occured while processing table 'crosstab1'.
Index was outside the bounds of the array.

I am also attaching few iamges to show the fact.
Please also not that this particular error is only with Stepped Layout while with other Layouts it works fine. I wonder why, Please help me soon


Steve
Telerik team
 answered on 08 Feb 2012
3 answers
263 views
Hello Everybody

Previously i had been working with Crystal reports, there for use the cross tab you must to put it in the page header, an advantage of this feature is that, besides use cross tab you can use the detail area to put the detail of the cross tab report. Currenly i migrate all reports to Telerik Reports, and is  a huge difference, but my customers are asking for the detail of the cross tab, but as in Telerik Reporting the cross tab must be in the detail area, i didnt find the way to do it, I try to make it creating a group and putting the Cross tab in the header of the group, and the textboxes in detail area, but now for each group appears the cross tab and after a few minutes say that the memory is out.


Can anybody show me any way to fix this requirement pls, in the attachment you can find how i made in Crystal, the defintion and the result and in Telerik the defintion and the result


Regards

CM






Steve
Telerik team
 answered on 08 Feb 2012
1 answer
228 views
Hi,

A client has problems with his reportviewer, when clicking the print button in the wpf report viewer nothing gets printed. It worked until recently.

I have not changed anything in the project and it prints from my pc.
I would like to know if Telerik depends on other components than .net 4 framework ?. Because something has been changed in the clients computer, for it to stop working.

Best regards

Ole.
Steve
Telerik team
 answered on 07 Feb 2012
1 answer
103 views
Hello,
I have a problem with reporting in Lightswitch. I have created an empty report, a new control in client and WCF service with reporting service. So now I am able to view empty report in Lightswitch application.
The report is in ServerGenerated project.
The problem is that I am not able to view some data in report. I cannot use the direct SQL access. I need to use existing RIA domain service with existing queries.
The solution should be deployed in Azure and in 3 tier scenario.
How to achieve that?
Thank you
Steve
Telerik team
 answered on 07 Feb 2012
3 answers
601 views
Hi All,

I have try to create a bar chart from database,but I have no clue to make dynamic chart legend data from database.

Can anyone give example for me..?


=========  This is my Code ======================
 private void chart1_NeedDataSource(object sender, System.EventArgs e)
        {
            this.chart1.Series.Clear();
            String pPeriodeStart = Convert.ToString(this.ReportParameters["PeriodeStart"].Value);
            String pPeriodeUntil = Convert.ToString(this.ReportParameters["PeriodeUntil"].Value);




            if (pPeriodeStart == "") pPeriodeStart = "null"; else pPeriodeStart = "'" + pPeriodeStart + "'";
            if (pPeriodeUntil == "") pPeriodeUntil = "null"; else pPeriodeUntil = "'" + pPeriodeUntil + "'";


            string sql = @"exec dbo.procedureName @PeriodeStart = " + pPeriodeStart+ ", @PeriodeUntil = " + pPeriodeUntil;
           
            string connectionString =
             "Data Source=xxx-pc\\SQLEXPRESS;Initial Catalog=dbname;Persist Security Info=True;User ID=sa;Password=password";


            SqlDataAdapter adapter = new SqlDataAdapter(sql, connectionString);
            DataSet dataSet = new DataSet();
            adapter.Fill(dataSet);


            ChartSeries series = new Telerik.Reporting.Charting.ChartSeries();
            series.DataYColumn = "AuctionDealValue";


            series.Appearance.LabelAppearance.Visible = true;
            //series.Appearance.ShowLabelConnectors = true;
            series.Appearance.ShowLabels = true;


            series.Appearance.LegendDisplayMode = Telerik.Reporting.Charting.ChartSeriesLegendDisplayMode.ItemLabels;
            
            //this.chart1.DataGroupColumn = "StakeholderId";


            this.chart1.ChartTitle.TextBlock.Text = "Test";


            this.chart1.PlotArea.XAxis.AutoScale = false;
            this.chart1.PlotArea.XAxis.AddRange(1, 10, 1);
            this.chart1.PlotArea.XAxis.DataLabelsColumn = "CommodityName";


            this.chart1.Series.Add(series);
            (sender as Telerik.Reporting.Processing.Chart).DataSource = dataSet.Tables[0].DefaultView;
        }

============= end of code ===============

+++++++++ this is my data from store procedure ++++++++++++++++
AuctionDealValue StakeholderName CommodityName CommodityId  StakeHolderId
36.475000000 fedde1                       Jagung 1 bures1
271.723100000 fedde2 Kayu Jati 2 bures1
47.050000000 fedde3 Kakao 3 bures2
+++++++++ this is my data from store procedure ++++++++++++++++


Regards,


Diki

Elian
Telerik team
 answered on 07 Feb 2012
1 answer
95 views
I am hosting a Silverlight ReportViewer in a XAML file that programmatically sends parameters to the ReportViewer like this:
void TheReportViewer_RenderBegin(object sender, Telerik.ReportViewer.Silverlight.RenderBeginEventArgs args)
{
    args.ParameterValues["SubjectId"] = subjectId;
    runOnce = true;
}

I also have a DrillThrough action setup on the DetailsSecion of my initial report, which I created through the Design view, so that each details ReportItem has an action that operates like this (taken from the Designer.cs):
navigateToReportAction1.Parameters.Add(new Telerik.Reporting.Parameter("SubjectId", "=Fields.SubjectId"));
navigateToReportAction1.ReportDocumentType = "Application.Reports.ReportType.DetailReport, Application.Reports, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null";

The DrillThrough is intended to load a DetailReport, passing the SubjectId of the particular item clicked in as a parameter. The navigateToReportAction behaves as expected, but my DetailReport loads with the following error.
One or more parameters are not set or have invalid values.

I believe the RenderBegin event might be blowing out my parameters, but even if I try some trickery like this:
private bool runOnce = false;
void TheReportViewer_RenderBegin(object sender, Telerik.ReportViewer.Silverlight.RenderBeginEventArgs args)
        {
            if (!runOnce)
            {
                args.ParameterValues["SubjectId"] = subjectId;
                runOnce = true;
            }
        }

my DetailReport still reaches the ItemDataBound event of the DetailSection with ReportParameters["SubjectId"].Value equaling null.

What am I to do? Has anyone run across a scenario where parameters passed from a DrillThrough don't load in the report navigated to?

Many thanks for your time,
-Jonathan
Elian
Telerik team
 answered on 07 Feb 2012
4 answers
163 views
Hi:

I'm trying to make a really simple report to print in a 4-different-parts per page document.

So my report has only a Detail, you can see it in "reportdetail.png".

This detail HAS TO BE 7,6cm because every page will be cutted in 4 different parts and all of them must be written the same way (I mean, every field should be in the same place (the first one at 2cm X 2cm Y etc...).

The result is really confusing because it doesn't leaves those 7,6cm for each detail and you can see the result in reportprint.png

As you can see, every detail is different from each other, this is especially seen in the last part of the report (see at that LARGE margin when it should be almost at the bottom of the report.

Am I doing anything wrong? How should I do this?? Thanks in advance!!

IvanY
Telerik team
 answered on 07 Feb 2012
1 answer
116 views
Hello,

I`m trying to make a X-Axis variable scale chart. I have attached one image with a similar chart style. From this chart I'm only interested on variable scale. (It's the best example I have found).

The image shows how X-Asis values grows exponentially from 0 to 10000.

I don`t know how to make a non lineal X-Asis with Reporting Charts.

How Can I develop a Reporting Chart like this?

Thank you very much.
Evgenia
Telerik team
 answered on 07 Feb 2012
1 answer
88 views
Hi,
I have a report which need me to print out the user and their number. I want to have the following format:

UserName Phone   UserName   Phone
User1        999        User5         999
User2        999        User6         999
User3        999        User7         999
User4        999        User8         999


The above report is all in 1 page. What happen here is that the report record continue to next column3 and column4.
Is it possible?

Thanks
Regards
Steve
Telerik team
 answered on 07 Feb 2012
Top users last month
Miljana
Top achievements
Rank 2
Iron
Iron
Joel
Top achievements
Rank 3
Bronze
Bronze
Bronze
Cynthia
Top achievements
Rank 1
John
Top achievements
Rank 1
Iron
Mozart
Top achievements
Rank 1
Iron
Veteran
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?