Telerik Forums
Reporting Forum
5 answers
557 views
I have a crosstab with company branch as the row group and invoice month as the column group. Sorting by branch and total works fine, but I can't figure out how to sort by invoice month. I've added a ConditionalSum class as documented here: http://www.telerik.com/blogs/dynamic-sorting-of-reporting-crosstabs-using-a-custom-aggregate-function, but when I set the sort on the crosstab to use the ConditionalSum function it tells me that an aggregate function should not be used in a sort expression. What object do I set the sort on? Is this still the recommended way to accomplish this?
Stef
Telerik team
 answered on 21 Jul 2017
1 answer
460 views
Created a report and believe I have set all the properties correctly to have the report print Landscape on Legal paper.  However upon printing, the defaults are Portrait on Letter paper.  What do I need to go to get the printing properties to read the report correctly.
Yana
Telerik team
 answered on 20 Jul 2017
2 answers
343 views

In my application I have to generate paper setter for online and offline test. I have done that so far quite easily, now my requirement is to create a dynamic template, so that while I print report it should fill all data inside created template.

 

I am also providing what I have achieved still now and what still need to be done more.. Please any one rescue me from here.

 

There is a stand alone report designer available in Telerik, please anyone guide me to use that. I think that might be suited for my need.

 

Or if anyone provide me a demo that will be highly helpful.

Stef
Telerik team
 answered on 20 Jul 2017
3 answers
250 views

Hello,

I have a report that has two parameters.  When accessing the report parameters from the report CS file, the parameters are in the collection, but the values are blank.  Any help would be much appreciated.

 

Thanks,
Virgil

 

ReportViewer.aspx

1.<form id="form1" runat="server">
2.    <div>
3.        <telerik:ReportViewer ID="ReportViewer1" runat="server">
4.        </telerik:ReportViewer>
5.    </div>
6.</form>

 

ReportViewer.aspx.cs

01.protected void Page_Load(object sender, EventArgs e)
02.{
03.    int tableId = int.Parse(Request["tableId"]);
04.    int reportType = int.Parse(Request["reportType"]);
05. 
06.    string typeName = typeof(BG0001).AssemblyQualifiedName;
07. 
08.    var reportSource = new Telerik.ReportViewer.Html5.WebForms.ReportSource();
09.    reportSource.Identifier = typeName;
10.    reportSource.IdentifierType = Telerik.ReportViewer.Html5.WebForms.IdentifierType.TypeReportSource;
11.    reportSource.Parameters.Add("TableId", tableId);
12.    reportSource.Parameters.Add("ReportType", reportType);
13.     
14.    this.ReportViewer1.ReportSource = reportSource;
15.}

The generated markup
<input id="ReportViewer1_hidden" name="ReportViewer1_hidden" type="hidden" value="{"documentMapVisible":true,"parametersAreaVisible":true,"scale":1,"scaleMode":"SPECIFIC","viewMode":"INTERACTIVE","printMode":"AUTO_SELECT","reportSource":{"report":"TestReports.Reports.BG0001, TestReports.Reports, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null","parameters":{"TableId":38,"ReportType":3}},"pageNumber":1}">

 

The code inside the BG0001 report

01.public BG0001()
02.{
03.    //
04.    // Required for telerik Reporting designer support
05.    //
06.    InitializeComponent();
07. 
08.    this.ProcessReportParams();
09. 
10.}
11. 
12.protected void ProcessReportParams()
13.{
14.    this.teamId = int.Parse(this.ReportParameters["TableId"].Value.ToString());
15.    this.reportType = int.Parse(this.ReportParameters["ReportType"].Value.ToString());
16.}

 

Intermediate window test of parameter values

01.?this.ReportParameters["TableId"]
02.{Telerik.Reporting.ReportParameter}
03.    AllowBlank: false
04.    AllowNull: false
05.    AutoRefresh: false
06.    AvailableValues: {(none)}
07.    Mergeable: true
08.    MultiValue: false
09.    Name: "TableId"
10.    Text: ""
11.    Type: Integer
12.    Value: ""
13.    Visible: true

 

 

 

Virgil
Top achievements
Rank 1
 answered on 19 Jul 2017
2 answers
128 views

I am using Nested sub report for this situation.

e.g.
Master Report - MainReport which contains Sub Report - SubReport1 and that Sub Report - SubReport1 also contain Sub Report - SubSubReport11.
SubReport1 has multiple data - e.g. Product 1,Product 2 etc.
SubSubReport11 has multiple data - e.g. Product 1 details, Product 2 details etc.
How can I bind data source for SubSubReport11 to get data for each product?

I have this type of scenario, so I have used Nested sub reports.

A. Main Report

       1. Sub Report 1

              a. Sub Sub Report 1 - It contains multiple data...(e.g. Line 1,Line 2,Line 3 etc.)

       2. Sub Report 2

              a. Sub Sub Report 2 - It contains multiple data...(e.g. Line 1,Line 2,Line 3 etc.)

 

If any other way to get this,please let me know.

Please give me any idea.
Thanks & Regards,
Bhavika

Bhavika
Top achievements
Rank 1
 answered on 19 Jul 2017
0 answers
43 views

hi Team,

 

during run time can we swap rows or realign row order after generating the report.

is It possible to x axis and y axis in chart during run time.

we need to achieve above functionality using telerik reports.

 

 

 

karthick
Top achievements
Rank 1
 asked on 19 Jul 2017
1 answer
284 views
Hi,
I'm trying to put string 
"     ===CARD PAYMENT===\r\n\r\nMERCHANT               0000001\r\nTERMINAL               0000001\r\nTIME         18 Jul 2017 18:31\r\nAID             A0000000031010\r\nAPP LABEL      CREDITO DE VISA\r\nCARD          ************0119\r\nPAN SEQ Number              01\r\nENTRY                 VISA ICC\r\nAUTHORISATION           025976\r\nREFERENCE               004779\r\nPURCHASE               GBP2.95\r\nTOTAL                  GBP2.95\r\n                              \r\n"
as a Value of TextBox on Telerik Report. Each line has 30 characters.
The value is displayed on report like `Telerik report.png` but I'm expecting the layout should be like in Visual Studio view (`Visual Studio view.png`).
Looks like the space character uses less width.

Is here any workaround to display it like on `Visual Studio view.png`?

Thank you,
Yuriy.
Stef
Telerik team
 answered on 19 Jul 2017
1 answer
613 views

Hi!
I am working on Telerik Reporting and I need to hide panels when the list I use by ObjectDataSource is empty. How can I handle it? Those blue are panels, and just below the lists. But they are not together, do I have to connect them by something like subreport? Do I have to write some code?

Thanks a lot!

Stef
Telerik team
 answered on 19 Jul 2017
3 answers
412 views

Hi,

I'm trying to add reports to a report book and display the report book in a MVC project, but I haven't found a way to do it so far.

Here is the code behind sample

        public ActionResult ReportBook()
        {
            ReportBook reportBook = new ReportBook();
            reportBook.Reports.Add(new TelerikReporting.MissionPlanning());

            Report report = new Report();
            report.DataSource = new UriReportSource() { Uri = "TelerikReporting.AgencyList, TelerikReporting" };
            reportBook.Reports.Add(report);

            InstanceReportSource instanceReportSource = new InstanceReportSource();
            instanceReportSource.ReportDocument = reportBook;

            return View("ReportBook", instanceReportSource);
        }

and the view code

@model Telerik.Reporting.InstanceReportSource

@(Html.TelerikReporting().ReportViewer()

        .Id("reportViewer1")
        .ServiceUrl("/api/reports/")
        .TemplateUrl("/Reports/templates/telerikReportViewerTemplate-9.1.15.624.html")
        .ViewMode(ViewMode.Interactive)
        .ScaleMode(ScaleMode.Specific)
        .Scale(1.0)
        .PersistSession(false)
        .ReportSource(Model)
)

This results in an empty report with a "No Report" message. I don't see what I'm doing wrong, it looks like the few samples I've found.
I've managed to display a single report by using a TypeReportSource instead of an InstanceReportSource, but that's not what I need...

​

Stef
Telerik team
 answered on 18 Jul 2017
1 answer
141 views

I am using HTML5 Web Form REST Telerik Reporting Q1 2017. When setup the first report which is using the wizard the report and parameter working properly.

However when I tried to pass the parameter from Querystring (from other web form) the report parameter becomes Null.

Please help me, What is the best workaround or solution for this issue?

=======================================================================

On the Page_Load report viewer I get the value from Querystring :

 protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                RptQuot1 report = new RptQuot1(Request.QueryString["Parameter1"] as string);
         
            }
        }

On the report constructor I added the parameter "Parameter1"

public RptQuot1(string parameter1)
        {                        
            InitializeComponent();
            this.DataSource = null;
            this.ReportParameters["Parameter1"].Value = parameter1;         
        }

Also on that class I added the NeedDataSource event handler :

public void RptQuot1_NeedDataSource(object sender, System.EventArgs e)
        { 

          Telerik.Reporting.Processing.Report report = (Telerik.Reporting.Processing.Report)sender;

          this.sqlDataSource1.Parameters[0].Value = report.Parameters["Parameter1"].Value;

          report.DataSource = this.sqlDataSource1;

        }

Stef
Telerik team
 answered on 17 Jul 2017
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?