Telerik Forums
Reporting Forum
1 answer
689 views

Hi,

I spent hours trying to filter Table data in GroupFooterSection. We need to filter it by group scope, how can we do this? Filter like Fields.code = Exec('group',Fields.code) didn't work. Many thanks in advance.

 

Todor
Telerik team
 answered on 08 Jun 2020
4 answers
267 views
hi,
I created a telerik report with table in which a row is having very large text.When the report is exported to pdf the first page of report is blank and table is shown from the second page.although i kept together as false still i am unable to fix this issue.

here is the code i am using to set datasource to table

   private static Random random = new Random((int)DateTime.Now.Ticks);
        private string RandomString(int size)
        {
            StringBuilder builder = new StringBuilder();
            char ch;
            for (int i = 0; i < size; i++)
            {
                ch = Convert.ToChar(Convert.ToInt32(Math.Floor(26 * random.NextDouble() + 65)));
                builder.Append(ch);
            }

            return builder.ToString();
        }
     
         DataTable GetTable()
        {
          
            DataTable table = new DataTable();
            table.Columns.Add("Dosage", typeof(int));
            table.Columns.Add("Drug", typeof(string));
            table.Columns.Add("Patient", typeof(string));
            table.Columns.Add("Date", typeof(DateTime));
            table.Columns.Add("Desc", typeof(string));
            string test =  RandomString(10000);
            table.Rows.Add(25, "Indocin", "David", DateTime.Now, test);

            return table;
        }

         private void Report1_NeedDataSource(object sender, EventArgs e)
         {
             this.table1.DataSource = GetTable();
         }
Channah Miriam
Top achievements
Rank 1
 answered on 07 Jun 2020
3 answers
124 views

Hi,

So I'm trying to stop our reports from auto-loading and the only viable way seems to be stopping the date parameter from auto loading the current date.

I've tried setting the default value to NULL or random strings in both the report designer and XML (see attachments) to try and cause an error to stop the reports auto loading but it still sets the date to today regardless of what I set the initial value to.

Is there a way to achieve what I'm looking for?

Richard
Top achievements
Rank 1
 answered on 05 Jun 2020
3 answers
179 views

We're getting this message in our standard error output:

EagleServer.exe Information: 0 : Unit.DotsPerInch = 96

EagleServer.exe is our application.

 

This happens on the bold line below:

  using (XmlReader xmlReader = XmlReader.Create(new StringReader(entity.ReportDefinitionXml)))
                {
                    ReportXmlSerializer xmlSerializer = new ReportXmlSerializer();
                    report = (Telerik.Reporting.Report)xmlSerializer.Deserialize(xmlReader);
                }

 

The message in the standard error output causes our application to think that something failed. Is there any way we can prevent this from happening?

Ivan Hristov
Telerik team
 answered on 04 Jun 2020
2 answers
788 views

Hi!

I have a chart in my report where I print inspections that are divided between finished and unfinished. I get this data from a database field and at the end of my report I created another field called total that sums up all of these numbers. 
What I need to do next is to get the percentage of how many of these inspections are finished and unfinished, and for that I need to get the sum of each one of the fields and divide by the sum of all finished and unfinished inspections, what should be something like this:

= (((Sum(Fields.FinishedInsp))/((Sum(Fields.FinishedInsp))+(Sum(Fields.UnfinishedInsp))))-1)*100

But I noticed that Telerik always return 0 for a division between two Sum() functions instead of the actual value, any idea why am I getting 0 and how to fix the problem?


Noah
Top achievements
Rank 2
 answered on 04 Jun 2020
0 answers
105 views

HI,

 

I would like to allow my customers the ability to add and hide columns from reports made up of crosstab tables.

I have not been able to achieve this.

 

IS this possible on telerik report designer?

 

THANKS

Balen
Top achievements
Rank 1
 asked on 04 Jun 2020
0 answers
231 views

Hello, I am using an older version of the Telerik Reporting tool (R1 2017 SP2)  and in earlier versions than that I was able to get the values for parameters that were passed.

Code that passes and generates the report:

var typeReportSource = new Telerik.Reporting.TypeReportSource();
typeReportSource.TypeName = string.Format("ReportLogic.{0}, ReportLogic, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null", ReportName);
foreach (var Parameter in Parameters)
{
    typeReportSource.Parameters.Add(Parameter.Name, Parameter.Value);
}
 
var result = reportProcessor.RenderReport("PDF", typeReportSource, null);

 

Report code:

void QuoteRequest_ItemDataBinding(object sender, EventArgs e)
{
     var id = Convert.ToInt32(this.ReportParameters[0].Value);
 
      // Transfer the value of the processing instance of ReportParameter
      // to the parameter value of the sqlDataSource component
      using (var db = new PetaPoco.Database())
      {
                var pcqp = new Repository(db).GetAllDynamicFields(id);
      }
}

Before this was able to pull a value,

In the earlier versions this was able to pull a value from this.ReportParameters[0].Value. But when I updated to this version it would just pass back a null value. Is there a reason why this could have happened? 

Mark
Top achievements
Rank 2
 asked on 03 Jun 2020
4 answers
303 views

Hello Telerik,
We are not able to filter the Grouped data in Excel after exporting from Telerik Reports.
Grouping of data is done through CrossTab in Telerik reports.
A sample excel file is shared for your reference.
As you can see in the excel, i have grouoed the data based on COL1, COL2, COL3.
Now when i filter COL3 and select value as BAA, then it shows only row 1 data instead of showing rows 1,2,3 and 4
similarly when i filter COl2 and select XYZ, then it shows only row 10 data instead of showing rows 10,11,12,13,14,15,16,17,18
What am i missing here. Or is it the limitation in Excel exported from Telerik Reports

 

Sijeesh
Top achievements
Rank 1
Veteran
 answered on 03 Jun 2020
1 answer
322 views

Hi,

We have updated our Reporting dlls to R2 2020.
We use WebView inside UWP app to show HTML5 Report Viewer and Web Report designer. Currently, the report viewer is working fine but we have a problem with a web designer. We tested with a separate web page outside of UWP WebView using the Chrome browser and it is working fine. We also noticed, that the same thing which is working in a Chrome browser is not working on Microsoft Edge, it seems it is the same issue. Also everything is working fine in a new Chromium-based Microsoft Edge, it is working fine.
in summary:
- working fine for Chrome, Microsoft Edge (Chromium-based)
- not working on UWP WebView control, Microsoft Edge.
Definition of not working: the control is loading fine, but when I open the report it is not showing report. We debugged client-server communication and it is sending appropriate information from the server. The same server is used for all testings (UWP, Chrome, Edge).
Is it something missing with a new release, or is it know the issue, or did someone reported this already?


Thank you,

Neli
Telerik team
 answered on 02 Jun 2020
3 answers
618 views
I have 2 bool report parameters. If the user changes the one to true, i want the other one to automatically change to false and vice versa. Say the first boolean is report parameter 1 on the list and the other one is report parameter 2. By using the expressions, I have managed to change parameter 2 to the correct value when changing parameter 1's value, but I can't get it to work the other way around. Expression on par 1: =(Parameters.parameter2.Value=False) Expression on par 2: =(Parameters.parameter1.Value=False) If I remove the expression on parameter 2, it works up.
Todor
Telerik team
 answered on 01 Jun 2020
Top users last month
Tien
Top achievements
Rank 1
Iron
Krasimir
Top achievements
Rank 3
Bronze
Iron
Iron
Cedar
Top achievements
Rank 1
Iron
Emil
Top achievements
Rank 1
Iron
Kyle Watson
Top achievements
Rank 1
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?