Hi! I would like to know if is it possible in a Telerik report with a Group, filtering in the details of the group, a Cross-Tab by the group field...
Thanks a lot for your help.

Hello there,

I'm new with Telerik Reporting and I have a Problem, where I didn't find a solution in the documentation.

Assume we have the same scenario as in the Quickstart-Example "How To: Use the Report Wizard to create a Band Report". With one difference: My DataSource has a further Field named "RowColor". I want a Report where each Row has the Color specified in this field.

How can I achieve that?

 

Best Regards

                        Frank Kruse

Hello,

I've created a report that displays entries grouped by different time periods (year, month, week, ...) in multiple levels.
As a caption for these layers, I have each created a date field that will be displayed in a matching format.
For example, MM.yyyy (MMM.) For month, will be formatted as follows: 01.2018 (Jan).
I also use the groups in my table of contents.
For this I have created corresponding levels and deposited in the group editor in each case a TocText as an expression.
That works so far everything, but is sometimes very complicated.
If you want to have a formatting as above that is very expensive.
The expression looks like this:

The simple variant

That's easy.
But if you also want the month in short form, as above, I have the following expression:

That works, but nice is different.
And if you still want to localize it is over.
My question on you is:
Is there a way to apply formatting to TocTexte, such as on a text box?
Or maybe there is another way how to solve something?

Hello,

I'm in charge to evaluate the component Report tool for wpf for an integration in our product.

I'm confident to produce standard reporting elements but in the reports we want to edit, we should be able to reproduce a grid like the ones attached in this post.

Is it easily possible with your component ? I don't want to have to draw a grid line by line as it will be necessary with raw pdf technology.

Regards,

Cédric

 

Hi all,
 
Environment

1)    VS 2017
2)    Telerik_UI_for_ASP.NET_AJAX_2019_1_115_Dev
3)    Telerik_Reporting_R1_2019_SP1_13_0_19_123_DEV

In my solution I am using Telerik HTML5 Report Viewer. Also using VS Installer Setup Wizard (Attached WebSetupWizard.png) for deployment purposes in production server from my solution.

My question is which .dll files/libraries I need to put for deployment (Attached HTML5 Report Viewer and Web Application.png) in deployment Wizard (Project Name: WebSetup) ?

In the past I was using Regular Report Viewer (Attached Obsolute Report Viewer.png) although that Report Viewer is now Obsolete.  But it worked for us. Not was any issue.

Very much appreciate any help to provide me with the required Telerik .Dll Files that I need to put in my Web Setup Project for Deployment. Also some step by step tasks that I need to do to accomplish my desired result. I did not use HTML5 Report at all.

Sincerely

gc_0620

I just encountered an strange issue where for one of the reports I am getting duplicate records in the excel/csv sheet for the exported report. For PDF there are no duplicates which is correct. Duplicate rows are there only for “Export to Excel” and “Export to CSV” options. In ReportViewer of course it is not displaying any duplicate records.
The report contains Header, Footer and Detail sections. In Header & Detail sections we are dynamically generating columns using the sample code given below:
private void MyReport_NeedDataSource(object sender, EventArgs e)
{
             var ds= //Some data source
             ((Telerik.Reporting.Processing.Report)sender).DataSource =ds //Set datasource from above dataset;

             //Create columns from the ds (generated from data source)
            for (int idx = 1; idx < ds.Tables[0].Columns.Count; idx++)
            {
                 column = ds.Tables[0].Columns[idx];   
                 var label = SetupLabel(column.ColumnName, string.Format("# of {0}", caption), width, LABELHEIGHT, locX, yLabel, HorizontalAlign.Right,                                                                          VerticalAlign.Bottom);
                  var textbox = SetupTextBox(column.ColumnName,width,TEXTHEIGHT,locX,yText);
                  if (Items.Find("labelsGroupHeader", true).Any())
                  {
                      var labelsGroupHeader1 = (GroupHeaderSection)(Items.Find("labelsGroupHeader", true)[0]);
                      labelsGroupHeader1.Items.Add(label);
                  }
                  if (Items.Find("detail", true).Any())
                  {
                      var detail1 = (DetailSection)(Items.Find("detail", true)[0]);
                      detail1.Items.Add(textbox);
                  }  
            }           
}

We are using Telerik.Reporting.dll 12.2.18.912.
Any immediate help will be much appreciated.

Thanks.

Hello,

is there a possibility to change the language for the parameter area on the webpage?

By default all settings are in english language.

But I want to set them in german language.

Is there a language file to load im my project or give it an easy way to change the language?

As you can see in the attached file the Datetime component is by default in english,

the names of the month and the names of the days.

 

 

Hello! I need some general guidance. I will try to upload an example with CSV files and example report tomorrow morning to elaborate, but wanted to get this explanation out tonight. Been a hectic weekend.
 
I am generating what's called an ASSESSMENT report. I have a datasource that queries an Oracle DB to get an ID number, called an ASSESSMENT_ID, from a table in our DB. Through several inner joins it gathers information from several DB tables to fill out numerous Telerik Table items. One Table item is supposed to be duplicated for three records, which are based on TASKS_IDs associated with this ASSESSMENT_ID, that this query returns.

One of the tables in our query, though, returns a column called EXPOSUE_CODES which has numerous records per TASK_ID and cannot be inner joined. I have tried setting up a report parameter to make a list of TASK_IDs and tried to pass this list into a second query to grab the EXPOSURE_CODES separately, but it duplicates all EXPOSURE_CODES from all three TASK_ID records in EACH TASK_ID table.

How do I get each TASK_IDs list of EXPOSURE_CODES into their respective table without duplication in other tables?

ASSESSMENT_ID ->

TASK_ID1, TASK_ID2, TASK_ID3 ->

[TASK_ID1:EXPOSURE_CODE1, EXPOSURE_CODE2, EXPOSURE_CODE3],

[TASK_ID2:EXPOSURE_CODE2, EXPOSURE_CODE5, EXPOSURE_CODE6],

[TASK_ID3:<NO EXPOSURE_CODES>]

Hi, I have a simple report where I make a Sum in the footer that summarizes depending of the invoice date. I have only one record with a value of 120.01 but the Sum of that record displays 120.00 in the footer. The format I am using is Numeric with 2 decimals and the field coming from the DB is a decimal, the other formulas are correct. Any idea ?

The attached file shows the generated report.

Thanks a lot !

Hi all,

I am trying to add different subreports (for ex. report1, report2) programmatically, but I couldn't placed each subreport as a new page. I just want to have each subreport in a new page. I tried to set pagebreak to "before", but it didn't work. Do you have an example for that? Thank you