Telerik Forums
Reporting Forum
6 answers
671 views

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>]

Neli
Telerik team
 answered on 08 Feb 2019
1 answer
304 views

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 !

Neli
Telerik team
 answered on 08 Feb 2019
9 answers
2.2K+ views
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
gajjala
Top achievements
Rank 1
 answered on 08 Feb 2019
1 answer
192 views
Hi all, I have a requirement to make a Single Sign-On between the <a href="https://mindmajix.com/sharepoint-training">SharePoint Online</a> and SharePoint on-Premise. I have read some articles on google which shows the process of synching the On-Premise users to the SharePoint online and then use that user to login in to the SharePOint Online site.

But My Scenario is reverse, I want to sync the SharePoint online user into the SharePoint On-Premise. So that the user which is created in SharePoint Online sync in the Sharepoint On-premise and , that user can use the SharePoint On Premise Site.

Is it possible with the same process of Synch for the SharePoint Online and SharePoint On Premise? is it work reverse way too? or I need to do some other thing for that ?

Please advise?
Eric R | Senior Technical Support Engineer
Telerik team
 answered on 07 Feb 2019
8 answers
2.2K+ views
I have a report with the following ReportItem's in it:

PageHeaderSection
DetailSection
    Panel
        TextBox - The title of the section
        Table - The section data
    Panel
        TextBox - The title of the section
        Table - The section data
    Panel
        TextBox - The title of the section
        Table - The section data
    Panel
        TextBox - The title of the section
        Table - The section data
PageFooterSection

I want each TextBox and Table to show together on one page. If the table data spans exactly one page, the TextBox shows on one page and the Table shows on another. How can I keep both of them together?
Mike
Top achievements
Rank 1
 answered on 07 Feb 2019
3 answers
326 views

Hello!

I have one problem with creating custom formatting for axis label of the bar chart.

I have time in Seconds (int) as Data Source for X Axis but I need to display this in format HH:MM  (and HH can be more than 24).

 

My project with build-in csv data: https://dropmefiles.com/pWr9e

I will appreciate any help! Thanks! 

 

Silviya
Telerik team
 answered on 06 Feb 2019
1 answer
198 views

Hello there!

I would like to know if it's possible to reuse all of our Q1 2016 TypeReport (.cs and .designer.cs) in a pure .net core 2.1 app? Do I to rewrite them in the TRDP format?

I read in the implemented features and limitations that : 

  • [...] type reports are not supported. In such scenario the reports can be converted to .trdx/.trdp definitions through the Standalone Report Designer’s Import Wizard or these classes can be used as a runtime-created report instances.
  • The supported report definition types are TRDX, TRDP and report classes, created in Visual studio without the VS designer-specific code.

Does that mean I can copy my report cs/designer files into a new .net core project and call them through code?
I did migrate with the upgrade wizard my .net 4.6 project but I did not manage the import the report files with the stand alone report designer. I always get an error message.

Thanks!

Silviya
Telerik team
 answered on 06 Feb 2019
6 answers
711 views

I am completely new to the report designer.  I have a couple of questions.  Here is one and I will post the other separately.

If I have a date parameter, is there a way to have it offer the user comparison operators (Is On, Between, On or After, On or Before)?  Would this list be another parameter in the query?  If so, is there a way to just provide a set list of strings that are not stored in the database?

 

Thanks,

 

Jennifer

Jennifer
Top achievements
Rank 1
 answered on 05 Feb 2019
3 answers
693 views

Hello I have a following problem - in my web app I am using an html 5 report viewer with telerik reporting and from time to time I am encountering a following problem - picturebox control is not being loaded with image data. Attached is a screenshot with a problem.

I am loading image data as base:

     [code]var bytes = Convert.FromBase64String(base64String);
            using (var ms = new MemoryStream(bytes))
            {
                pbLogo.Value = Image.FromStream(ms);
            }[/code]

 

I tried to search for similara problems, but none of the resolutions worked out.


Silviya
Telerik team
 answered on 05 Feb 2019
1 answer
163 views

Hi..

I'm using the <telerik:ReportViewer ID="ReportViewer1" 

On one of my users the PRINT Icon does not PRINT, it prompts for Save As.

Same thing happens in IE and Chrome.  Any ideas?

 

thx

 

 

 

 

Silviya
Telerik team
 answered on 05 Feb 2019
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?