Hi,

    I am pretty new to Telerik Reporting and I am using C# WPF.  I have set a datatable to the DataSource of Report. The datatable is generated correctly with all rows from specified DB. But it is not displayed in ReportViewer.  Below is my code snippet. Please advise.

            Telerik.Reporting.Report myReport = new Telerik.Reporting.Report();
            string selectCommand = @"SELECT * FROM Angle";
            string connectionString = @"Data Source=IndianSections.db3";

            using (var connection = new SQLiteConnection(connectionString))
            {
                using(var command = new SQLiteCommand(connection))
                {
                    connection.Open();
                    command.CommandText = selectCommand;
                    using (var reader = command.ExecuteReader())
                    {                        
                        SQLiteDataAdapter dataAdapter = new SQLiteDataAdapter(selectCommand, connectionString);
                        DataTable dataTable = new DataTable();
                        dataTable.Load(reader);
                        //dataAdapter.Fill(dataTable);
                        
                        var objectDataSource = new Telerik.Reporting.ObjectDataSource();
                        objectDataSource.DataSource = dataTable;

                        myReport.DataSource = objectDataSource;
                        
                        var reportSource = new Telerik.Reporting.InstanceReportSource();
                        reportSource.ReportDocument = myReport;

                        this.reportViewer.ReportSource = (reportSource as ReportSource);
                        this.reportViewer.RefreshReport();
                    }    
                   // connection.Close();
                }
            }

Hello All, 

  I have my table of data, but above my table, I want to add two rows that will contain the report title, as well as the date rendered information. This information extends beyond what would fit into just one cell, so I'd like to merge the adjacent cells so everything is visible. I don't want to use a header for this information.

Thanks for your help.

Travis

Hi,

I have been trying to reduce the checkbox width (Please refer to the attached image) by setting the size property.

this.checkBox1.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(2D), Telerik.Reporting.Drawing.Unit.Inch(0.079999998211860657D));

The height attribute works but when I try to change the width, the text part of the checkbox is getting cut off. It's very frustrating as I have spent a lot of time on it without getting the desired result.

Can you please assist me this issue.

Thanks,

Ashith.

Hi. I try to use this example for create dynamically generated report. I'm want grouping output as described here.Only one change in code from documentation it change

to

As I understood this allow me output row with col1=1 in separate group with footer and header,  col1=2 in separate group with footer and header, and two col1=4 with separate group. But it not work as expected. I see one header, one footer and all data between this header and footer.
What I do wrong?
Thank you in advance.

And I want to get the selected value in the ItemDataBinding event, but it is always null or it keeps the value if I set it 
manually.
this.ReportParameters["GroupBy"].Value.ToString()

If I add a textbox in the editor with its value set to :Parameters.GroupBy.Value then the selected field is bound correctly. 

Thanks for you help.

I have a report where someone could pass in a parameter to show "Detail" for the record.  The "detail" is tied to a second  within the Telerik Report.  I am unsure of how to get it to fire and show as it should.  I have added the primary  and displays the records in the group header.  

Attached is an image of what my report looks like SQLDatasource1 is the primary  and uses parameters passed in to display.  If input parameter DetailFlag = true then I want to show the Detail Record which is tied to SQLDataSource2.  

Tried the following in the code-behind but not displaying.

One of the reports on my company's product, which uses Telerik Reporting R3 2016, is intermittently generating an error about resolving the dsGiftCard object data source that it uses. Sometimes, the report viewer says that it is unable to create a report instance, while other times it says that it is unable to get the parameters. The error only occurs on our deployments and not on our local builds. Our local builds load the report much faster. Usually the report loads fine, but this error generates on such a random basis my team is having trouble tracking it and finding out the cause. We're hoping someone here at Telerik can help us resolve this issue.

exceptionMessage: "An error has occurred while resolving 'dsGiftCard' data source: An error occurred while invoking data retrieval method."
exceptionType: "Telerik.Reporting.Processing.Data.ObjectDataSourceException"
message: "An error has occurred."
stackTrace: " at Telerik.Reporting.Processing.Data.ObjectDataSourceInstanceResolver.TryResolveAsMethodInvocationOnTarget(Type type, Func`1 resolveTarget, String dataMember, ObjectDataSourceParameterCollection parameters, Object& result) ↵ at Telerik.Reporting.Processing.Data.ObjectDataSourceInstanceResolver.TryResolveAsMethodInvocation(Object dataSource, String dataMember, ObjectDataSourceParameterCollection parameters, Object& instance) ↵ at Telerik.Reporting.Processing.Data.ObjectDataSourceInstanceResolver.ResolveDataSource(Object dataSource, String dataMember, Boolean evaluateParametersValues) ↵ at Telerik.Reporting.Processing.Data.ObjectDataProviderBase`1.ResolveDataSource() ↵ at Telerik.Reporting.Processing.Data.ObjectDataEnumerable.ResolveEnumerable() ↵ at Telerik.Reporting.Processing.Data.ObjectDataEnumerableBase.GetEnumerator() ↵ at Telerik.Reporting.Processing.Data.SeedDataAdapter.GroupData(IEnumerable`1 rawData) ↵ at Telerik.Reporting.Processing.Data.SeedDataAdapter.Execute(IEnumerable`1 data) ↵ at Telerik.Reporting.Processing.Data.ResultSetAdapter.Execute(IEnumerable`1 data) ↵ at Telerik.Reporting.Processing.Data.MultidimentionalDataProvider.Execute(MultidimensionalQuery query) ↵ at Telerik.Reporting.Processing.ReportParametersManager`1.CalculateParameterProperties(P parameter, IReportParameter parameterDef, IDictionary`2 parameterValues) ↵ at Telerik.Reporting.Processing.ReportParametersManager`1.Calculate(P parameter, IDictionary`2 parameterValues) ↵ at Telerik.Reporting.Processing.ReportParametersManager`1.CalculateChildren(P parameter, IDictionary`2 parameterValues) ↵ at Telerik.Reporting.Processing.ReportParametersManager`1.CalculateParameters(IDictionary`2 parameterValues) ↵ at Telerik.Reporting.Processing.DocumentParametersManager`1.CalculateParameters(IDictionary`2 values, Boolean ensureCalculated) ↵ at Telerik.Reporting.Processing.DocumentParametersManager`1.GetMergedParameters(IDictionary`2 values) ↵ at Telerik.Reporting.Services.WebApi.ReportsControllerBase.GetParameters(String clientID, ClientReportSource reportSource) ↵ at lambda_method(Closure , Object , Object[] ) ↵ at System.Web.Http.Controllers.ReflectedHttpActionDescriptor.ActionExecutor.<>c__DisplayClass10.<GetExecutor>b__9(Object instance, Object[] methodParameters) ↵ at System.Web.Http.Controllers.ReflectedHttpActionDescriptor.ExecuteAsync(HttpControllerContext controllerContext, IDictionary`2 arguments, CancellationToken cancellationToken) ↵--- End of stack trace from previous location where exception was thrown --- ↵ at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task) ↵ at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) ↵ at System.Web.Http.Controllers.ApiControllerActionInvoker.<InvokeActionAsyncCore>d__0.MoveNext() ↵--- End of stack trace from previous location where exception was thrown --- ↵ at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task) ↵ at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) ↵ at System.Web.Http.Controllers.ActionFilterResult.<ExecuteAsync>d__2.MoveNext() ↵--- End of stack trace from previous location where exception was thrown --- ↵ at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task) ↵ at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) ↵ at System.Web.Http.Controllers.ExceptionFilterResult.<ExecuteAsync>d__0.MoveNext()"

Here is the C# method that the data source gets its data from:

Hi,

One of our customer has an issue to selected item from report parameters dropdown.

When dropdown is opened first time, all items shows correctly. After item selection, the first item disappear!?

This happens only IE 11 (version 11.2244.14393.0), no problems with Firefox or Chrome

What could cause this behavior?

BR,

Auvo