Hello,

I am creating a report that pulls data from an SqlDataSource object. In the report's C# code-behind, I need to access the same data that the report uses to generate a string for an informational QR code on the report. Right now, I am pulling the data a second time from the same table through a data source for the project (DataSet object).

I'm wondering if there is a more efficient way to do this, as in a way to read the same data that the report has already selected. I've explored the SqlDataSource object's properties, but I'm pretty new to this and nothing seems to work there. Another solution could be to use an expression to pass all the values in a field from the report designer to a method in the code-behind, but I can't figure out how to do that either.

I'm not sure if this makes a difference, but in the report, the SqlDataSource is only used by a table and by the report parameters.

Let me know if more information is needed, and thanks in advance!

I am getting an "Exception was unhandled" error along with the following information: Unsupported ReportSource. Cannot create resolver.

I am running in a WinForm system.

I have tried to run my report 2 different ways and both give me the same error message.

Instance #1

  public partial class frmReviewPlans : Form {     public frmReviewPlans() 

  {      

      InitializeComponent();       

     var typeReportSource = new Telerik.Reporting.TypeReportSource();      

     typeReportSource.TypeName = "PlanTracking.Reports.Reports.LCPC.ReviewPlans";       

     rvReviewPlans.ReportSource = typeReportSource;       

     rvReviewPlans.ViewMode = Telerik.ReportViewer.WinForms.ViewMode.PrintPreview;       

     rvReviewPlans.RefreshReport();    

 }

Instance #2

    private void btnPrintReport_Click(object sender, EventArgs e) 

  {       

      var typeReportSource = new Telerik.Reporting.TypeReportSource();       

      typeReportSource.TypeName = "PlanTracking.Reports.Reports.LCPC.ReviewPlans";       

      rvReviewPlans.ReportSource = typeReportSource;       

      rvReviewPlans.ViewMode = Telerik.ReportViewer.WinForms.ViewMode.PrintPreview;       

      rvReviewPlans.RefreshReport();

  }

both of these instances are erring rvReviewPlans.ReportSource = typeReportSource.  

Can anybody shed any light on what I am doing wrong or what the error message is telling me?

Any information would be greatly appreciated as I and a co-worker are at a loss as to what it could be.

Marshall Long

Hi,

Could you please help in solving this issue.I have 4 parameters:

-StartDate is a custom datetime picker param

-EndDate is a custom datetime picker param

-Campus is a builtin param bound to an sql datasource with both value and display text.

-Vehicle Numbers is is a builtin param bound to an sql datasource with both value and display text and mutilvalue enabled.This param is cascading from Campus param,so when picking a campus the vehicle numbers gets filtered

The problem I am facing is that when I pick a campus, the vehicle numbers are filtered but the start and end date values are lost.I feel the whole parameter area in being refreshed so the values entered are not restored.

Environment:

-ASP.NET MVC 5

.-NET 4.5

-Latest Reporting package

Thanks in advance

Madani

Hello, 

       I am using Telerik Reporting R3 2016 and displaying report result as PDF Document. I am using Roboto Fonts, i have installed these fonts in my development machine which is working fine. PDF Content embed as Roboto. But in Production server contents are gets displaying in Microsoft Sans Serif Font.

        I have Installed Roboto(TrueType) font in production server and restarted production machine. But still it is not working. I have checked in Windows\Fonts Folder, my fonts are there. Am i need to change any other configuration to get Roboto font in PDF?

I want a table column right from a column of which I set the visibility to false with a visibility binding expression to take the free space availalble.

How can I achieve this?

Using 10.2.16.1025, VS Professional 2015, Win 10, SQL Server 2016.  I have built several SQL stored procedures to fetch data, integrated them into Entity framework and have successfully used them for both main report datasources and as lists of values for report parameters, accessing them as Entity DataSources.

However, one stored procedure does not work right.  After adding it to a new Entity datasource for a report parameter, the column names in its output dataset are not displaying, just an unusable thing named 'item'.

When the wizard gets to Select a Context Member, I pick this:

Method: RptUtlTimeZone(Nullable<Int32> systemTimeZoneId, Nullable<Boolean> returnResultSet, String& zoneMsName) : List<RptUtlTimeZoneReturnModel>
Type: Myriad.Pc.Data.SqlServer.PointCentricContext
Assembly: Myriad.Pc.Data.SqlServer, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null

Looks similar to all the other stored procedures that work correctly.  Note that it does have the output data set definition List<RptUtlTimeZoneReturnModel>

The Wizard completes, I go to Data Explorer and all I see is "item".

Here is part of the file from Visual Studio which describes the output data set - RptUtlTimeZoneReturnModel.cs

    public partial class RptUtlTimeZoneReturnModel
    {
        public System.Int32? SystemTimeZoneId { get; set; }
        public System.String ZoneMSName { get; set; }
    }

and this looks fine.

But why does Data Explorer not display the proper columns in the output data set?  Thanks.

Hello
Our application provides a Telerik report which can be exported to Word. Some of our customers are complaining that they are not able to insert a manual page break in the exported file by using CTRL+Enter.

Because the report extends over several pages, the whole page is packed in an outer table. CTRL+Enter inserts a page break in front of the table instead at the current cursor position.

Do you have any suggestions to solve this issue?

Regards, Markus

I have a binding expression for the Height property of a Picturebox. The height depends on a boolean value.

=IIF(Fields.LiftVanesUsed,"0,9cm","1,2cm")

The height of the picturebox becomes around 10 times larger than the height that is provided in the expression.

How to return the height from an expression?

Has anyone found a limitation for character length on the query write for Telerik Report Designer?  I have a lengthy oracle query that is over 30,000 characters and performs about 56 counting operations based on case statements to create a report.  The query works in sql Developer, but I am not able to paste the entire query into the query editor.