Telerik Forums
Reporting Forum
1 answer
260 views

I have a line chart report with only one series and has 4 Legends(Legend A, Legend B, Legend C & Legend D) in it. And I have assigned 4 different color patterns to the chart.

The order is Green, Red, Blue, Yellow.

 

Now, when the Report loads the data for all the Legends, the Colors are mapped correctly. For Example, Legend A = Green, Legend B = Red, Legend C = Blue & Legend D = Yellow in the same order.

There is a scenario where in the report has the data only for 2 legends( Legend B and Legend D). In this case, the report automatically chooses Legend B to be Green and Legend D to be Red.

Is there a way to set or map individual colors to the legends? Like Legend A should always be Green, Legend B as Red, Legend C as Blue & Legend D as Yellow.

I know if we use 4 series in the chart then this is possible, but i do not want to use multiple series.

Todor
Telerik team
 answered on 12 Jun 2020
2 answers
2.8K+ views

Good Day,

I would like to as if it is possible to create a table in the report with a dynamic result table from MSSQL Stored Procedure ?

 

Thank you,

Sherwin

Channah Miriam
Top achievements
Rank 1
 answered on 10 Jun 2020
1 answer
68 views

We use Telerick reporting version 13.0.19.222.

On an aspx page, we have a ReportViewer to display reports, we have the option on the page to switch between Interactive and PrintPreview mode.

When the report runs for parameters that generates a long report (100+ pages), the PrintPreview mode works fine, but the Interactive view basically crashes IE, Or at least, the report never displays and the aspx page gets in a state that makes it un-usable - we then have to reload the page if we need to run the report.

 

 

I could not see any errors coming from IE or the Telerick components, in the debug tools of IE or anywhere else.

 

 

When we try the exact same thing with any other browser (Chrome, Edge, etc...) the report loads fine in Interactive mode or Print Preview mode.

 

 

Is there anyway to fix this issue that you are aware of? Or is there known limitations with IE and the Intercative mode for the ReportViewer ?

Any help will be appreciated.

Thanks.

 

 

 

 

Todor
Telerik team
 answered on 09 Jun 2020
1 answer
626 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
213 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
89 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
127 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
700 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
85 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
176 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
Top users last month
Edmond
Top achievements
Rank 1
Iron
fabrizio
Top achievements
Rank 2
Iron
Veteran
RobMarz
Top achievements
Rank 2
Iron
Fakhrul
Top achievements
Rank 1
Iron
Tejas
Top achievements
Rank 2
Iron
Iron
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?