How to use report in angular 1.x with sql server . provide some sample code .

Hello. I have a project that uses Telerik controls. In my case, I'm dealing with Telerik Reporting.

When I try to preview the report in Visual Studio (I'm using VS 2017), an error about lc.exe is preventing the preview. IIn the past, 've usually deleted license.licx files from the entire solution and things worked.... except for today.

After deleting those licx files, they get re-added ( obviously ) and I'm still unable to preview my report.

What are other ways around this? Deleting the licx files isn't working any more it seems.

Hi All,

          This might just be my lack of M$ Word skills, but how do you add / edit text outside of the nested tables that are generated from an exported report, Html Viewer - export to word, as l can not seem to figure it out.

If l use export to RTF and then open /edit with word it all works fine and l can move my cursor outside of the tables and add text etc. At first l thought maybe it was my report but trying one of the online Telerik Demo reports exported to Word, gives me the same amount of frustrations.

Typing inside the tables is fine, but l would like to add stuff after the tables, my version of word is the desktop office 2013.

Thanks in advance

Paul.

Hello everyone,

I am using both

•  Telerik.ReportViewer.WebForms 11.0.17.222 and 
•  Microsoft.ReportViewer.WebForms 12.0.0.0 in the same solution.
   
   I have just upgraded from Microsoft.ReportViewer.WebForms 10.0.0.0 and whenever I build my solution I get the following messages:
   
  C:\Program Files (x86)\MSBuild\14.0\bin\Microsoft.Common.CurrentVersion.targets(1820,5): warning MSB3268: The primary reference "Telerik.Reporting.Services.HttpClient, Version=11.0.17.222, Culture=neutral, PublicKeyToken=a9d7983dfcc261be, processorArchitecture=MSIL" could not be resolved because it has an indirect dependency on the framework assembly "System.Net.Http, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" which could not be resolved in the currently targeted framework. ".NETFramework,Version=v4.0". To resolve this problem, either remove the reference "Telerik.Reporting.Services.HttpClient, Version=11.0.17.222, Culture=neutral, PublicKeyToken=a9d7983dfcc261be, processorArchitecture=MSIL" or retarget your application to a framework version which contains "System.Net.Http, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a".

3>  No way to resolve conflict between "Microsoft.ReportViewer.ProcessingObjectModel, Version=12.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91" and "Microsoft.ReportViewer.ProcessingObjectModel, Version=10.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a". Choosing "Microsoft.ReportViewer.ProcessingObjectModel, Version=12.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91" arbitrarily.
3>  No way to resolve conflict between "Microsoft.ReportViewer.DataVisualization, Version=12.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91" and "Microsoft.ReportViewer.DataVisualization, Version=10.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a". Choosing "Microsoft.ReportViewer.DataVisualization, Version=12.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91" arbitrarily.

Reports seem to be working as expected, but I am particularly worried about two last messages because I have replaced all references I have found to the 10.0.0.0 version, but I wonder if  there is any hidden dependency to a specific Microsoft.ReportViewer version.

Any hint would be appreciated.

Thank you in advance.

I had set the parameter type as DateTime and put the Data source.

But in the HTML5 report viewer its showing the List view. 

But i wish to Display the Field as DateTime picker and set the max/min from the datasource. 

Any one had idea on how to achieve that ? Thanks in advanced 

using above code to host report in .cshtml 

I need to access client side api in javascript. 

var viewer = <%=ReportViewer1.ClientID%> // Not able to access reportViewer object in .cshtml

  <script type="text/javascript">
        function PrintRepo() {
           PrintDocument(); //if I get the access of reportViewer, then I can use PrintDocument() function
        }
    </script>

Any help is appreciated. Thanks 

I have multiple reports created in Report Designer with the same error condition.  Each has one or more report parameters that have an entity datasource (sql server stored procedure) and set to multivalue=true and set to null=yes and have no initial value set.  These are passed as arguments to the stored procedure for the main datasource.  Having no selections is a valid condition.

When run through our web application, when the report initially displays each of those multi-select parameters it displays the "Please input a valid value" error message.  Usually when this happens, the report engine pauses, additionally displays the "Please input valid data for all parameters" message as well, then waits for more user input.

However this is not happening:  the "Please input..." message is not being displayed, and the report jumps right in and does an initial rendering to the web page.  This indicates it thinks it does not have any invalid parameters.  Yet, the Preview button is not clickable indicating it thinks there are invalid parameters.  Very confusing.

The work-arounds include:

1) Select one item in the parameter list, then un-select it.  Now the Preview button works.

2) In report designer, force an initial selection of one item in the report parameter.

3) In report designer, change the report parameter to be single value instead of multi value.

4) In report designer, run the report in preview mode - it runs fine with no error messages.

None of these are good solutions of course.  So I need to know how to suppress the seemingly erroneous parameter errors.

Telerik 11.0.17.118  Windows 10 VS 2015 SQL Server 2016.  This happens when running locally through VS as well as when deployed to a separate server.

Thanks.

I need to create a graph with a huge information everyday (data created every 5 seconds). The problem is, there is too many record rendered on the graph and it's hard to see (as image attached below). Is there any possible way to group the x-axis (datetime) to show as interval for every hour and every record still plot on the graph.

Thank you.

I have a main report having subreport whose reportsource has to be set dynamically based on the field value (Response type) of the sqldatasource of mainreport ,
I tried to get the value of Responsetype from the dataobject in detail_itemdatabinding event and stored in a variable .
I subreport_itendataBinding event tried to set Telerik.Reporting.SubReport.reportsource to new object of TypeReportSource class, then invalidcastexception is ocurring
Unable to cast object of type 'Telerik.Reporting.Processing.SubReport' to type 'Telerik.Reporting.SubReport
'Telerik.Reporting.Processing.SubReport does not have REportsource property so i used Telerik.Reporting.SubReport, but exception is happening

Kindly assist on this issue

 public partial class InterviewReport : Telerik.Reporting.Report
    {
        protected string reportSourceValue = "";
        public InterviewReport()
        {
            //
            // Required for telerik Reporting designer support
            //
            InitializeComponent();

            //
            // TODO: Add any constructor code after InitializeComponent call
            //
        }

        private void detail_ItemDataBinding(object sender, System.EventArgs e)
        {
            Telerik.Reporting.Processing.DetailSection item =
                (Telerik.Reporting.Processing.DetailSection)sender;
         
            object o = item.DataObject["ResponseType"];
            if (o is string)
            {
                if (string.Equals(o, "Text Response"))
                {
                    this.reportSourceValue = "ReportLibrary.Reports.Response, ReportLibrary, Version=1.0.0.0, Culture=neutral, " +
     "PublicKeyToken=null";
                }
                else if (string.Equals(o, "Check Box"))
                {
                    this.reportSourceValue = "ReportLibrary.Reports.ReportCheckBox, ReportLibrary, Version=1.0.0.0, Culture=neutral, " +
      "PublicKeyToken=null";
                }
            }
        }

        private void subReport1_ItemDataBound(object sender, System.EventArgs e)
        {
            // Telerik.Reporting.Processing.ReportItemBase item =
            // (Telerik.Reporting.Processing.ReportItemBase)sender;
            Telerik.Reporting.SubReport sub = (Telerik.Reporting.SubReport)sender;

            Telerik.Reporting.TypeReportSource typeReportSource2 = new Telerik.Reporting.TypeReportSource();
            typeReportSource2.Parameters.Add(new Telerik.Reporting.Parameter("LocalEngID", "= Parameters.LocalEngID.Value"));
            typeReportSource2.Parameters.Add(new Telerik.Reporting.Parameter("InterviewQuestionsID", "=Fields.InterviewQuestionsID"));
            typeReportSource2.TypeName = reportSourceValue;
            sub.ReportSource = typeReportSource2;
        }

    }

Regards,

Mary Jain