Telerik Forums
Reporting Forum
or
Ask question
All Questions
Unanswered
Answered
13,715 questions
3 answers
443 views
deployment to test server difficulty: Object cannot be cast from DBNull to other types
Hello. My Telerik Reporting project is a Windows Service that generates a PDF report. The report has a mix of ObjectDataSources and SqlDataSources (MySql). My reporting service processes the report just fine on my development machine but when I deployed it to a test server I started encountering problems. I've already fixed the missing entry in DbProviderFactories for MySql, which I put into the service's app.config.

Now I'm getting exceptions on all parts of my report that call MySql stored procedures with SqlDataSource, the InvalidCastException.

There's also a series of FileNotFoundExceptions at the beginning of processing, I'm not sure if those are setting the rest of the report up for failure.

I'm also seeing System.Reflection.TargetInvocationException in Telerik.Reporting.dll when processing my graphs.

As I said, this is all working fine on my development machine, but on my test server it's not. Could there be some deployment step that I'm missing?

Output window text follows.

*** Get PDF Rendering Extension STARTED ***
A first chance exception of type 'System.IO.FileNotFoundException' occurred in mscorlib.dll
A first chance exception of type 'Telerik.Reporting.Interfaces.ExtensionManagerException' occurred in Telerik.Reporting.dll
A first chance exception of type 'System.IO.FileNotFoundException' occurred in mscorlib.dll
A first chance exception of type 'Telerik.Reporting.Interfaces.ExtensionManagerException' occurred in Telerik.Reporting.dll
A first chance exception of type 'System.IO.FileNotFoundException' occurred in mscorlib.dll
A first chance exception of type 'Telerik.Reporting.Interfaces.ExtensionManagerException' occurred in Telerik.Reporting.dll
A first chance exception of type 'System.IO.FileNotFoundException' occurred in mscorlib.dll
A first chance exception of type 'Telerik.Reporting.Interfaces.ExtensionManagerException' occurred in Telerik.Reporting.dll
*** Get PDF Rendering Extension DONE in 00:00:00.4249358 ***


*** ReportProcessor.ProcessReport STARTED ***

*** ProcessReport #0 STARTED ***

*** Report Processing STARTED ***
'PeachFarm.Reporting.Service.exe' (Managed (v4.0.30319)): Loaded 'C:\Windows\Microsoft.Net\assembly\GAC_MSIL\System.Configuration.Install\v4.0_4.0.0.0__b03f5f7f11d50a3a\System.Configuration.Install.dll', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.
'PeachFarm.Reporting.Service.exe' (Managed (v4.0.30319)): Loaded 'C:\Windows\Microsoft.Net\assembly\GAC_MSIL\System.Security\v4.0_4.0.0.0__b03f5f7f11d50a3a\System.Security.dll', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.
'PeachFarm.Reporting.Service.exe' (Managed (v4.0.30319)): Loaded 'C:\Windows\Microsoft.Net\assembly\GAC_MSIL\System.Xaml\v4.0_4.0.0.0__b77a5c561934e089\System.Xaml.dll', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.

*** Table::ProcessItem STARTED ***

*** TableBuilder::AddColumns STARTED ***
*** TableBuilder::AddColumns DONE in 00:00:00.0251090 ***


*** TableBuilder::AddRows STARTED ***
*** TableBuilder::AddRows DONE in 00:00:00.0082406 ***


*** TableBuilder::AddBody STARTED ***

*** Table::ProcessItem STARTED ***

*** TableBuilder::AddColumns STARTED ***
*** TableBuilder::AddColumns DONE in 00:00:00.0000996 ***


*** TableBuilder::AddRows STARTED ***
*** TableBuilder::AddRows DONE in 00:00:00.0001124 ***


*** TableBuilder::AddBody STARTED ***
*** TableBuilder::AddBody DONE in 00:00:00.0224333 ***

*** Table::ProcessItem DONE in 00:00:00.0874301 ***

*** TableBuilder::AddBody DONE in 00:00:00.1158163 ***

*** Table::ProcessItem DONE in 00:00:00.2623333 ***


*** Table::ProcessItem STARTED ***
'PeachFarm.Reporting.Service.exe' (Managed (v4.0.30319)): Loaded 'C:\Windows\Microsoft.Net\assembly\GAC_MSIL\System.Numerics\v4.0_4.0.0.0__b77a5c561934e089\System.Numerics.dll', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.
'PeachFarm.Reporting.Service.exe' (Managed (v4.0.30319)): Loaded 'C:\Windows\Microsoft.Net\assembly\GAC_64\System.Data.OracleClient\v4.0_4.0.0.0__b77a5c561934e089\System.Data.OracleClient.dll', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.
'PeachFarm.Reporting.Service.exe' (Managed (v4.0.30319)): Loaded 'C:\pf\MySql.Data.dll'
'PeachFarm.Reporting.Service.exe' (Managed (v4.0.30319)): Loaded 'C:\Windows\Microsoft.Net\assembly\GAC_64\System.Transactions\v4.0_4.0.0.0__b77a5c561934e089\System.Transactions.dll', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.
'PeachFarm.Reporting.Service.exe' (Managed (v4.0.30319)): Loaded 'C:\Windows\Microsoft.Net\assembly\GAC_64\System.EnterpriseServices\v4.0_4.0.0.0__b03f5f7f11d50a3a\System.EnterpriseServices.dll', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.
'PeachFarm.Reporting.Service.exe' (Managed (v4.0.30319)): Loaded 'C:\Windows\Microsoft.Net\assembly\GAC_64\System.EnterpriseServices\v4.0_4.0.0.0__b03f5f7f11d50a3a\System.EnterpriseServices.Wrapper.dll', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.
'PeachFarm.Reporting.Service.exe' (Managed (v4.0.30319)): Loaded 'C:\Windows\Microsoft.Net\assembly\GAC_MSIL\System.Management\v4.0_4.0.0.0__b03f5f7f11d50a3a\System.Management.dll', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.
A first chance exception of type 'System.Reflection.TargetInvocationException' occurred in mscorlib.dll
A first chance exception of type 'System.Reflection.TargetInvocationException' occurred in Telerik.Reporting.dll
*** Table::ProcessItem DONE in 00:00:00.9704175 ***

An exception has occurred while processing '' item:
System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.InvalidCastException: Object cannot be cast from DBNull to other types.
   at System.DBNull.System.IConvertible.ToByte(IFormatProvider provider)
   at MySql.Data.MySqlClient.MySqlCommandBuilder.DeriveParameters(MySqlCommand command)
   --- End of inner exception stack trace ---
   at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)
   at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments)
   at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
   at System.Reflection.MethodBase.Invoke(Object obj, Object[] parameters)
   at Telerik.Reporting.Processing.Data.SqlProviderFactory.DeriveParameters(IDbCommand command) in c:\temp\reporting\@RBuild-19923\Reporting_Build\Source\Code\Telerik.Reporting.Processing.Data\SimpleDataSources\Sql\SqlCommandProvider.cs:line 154
   at Telerik.Reporting.Processing.Data.SqlCommandProvider.ResolveProcedure(IDbCommand command, SqlDataSourceParameterCollection parameters) in c:\temp\reporting\@RBuild-19923\Reporting_Build\Source\Code\Telerik.Reporting.Processing.Data\SimpleDataSources\Sql\SqlCommandProvider.cs:line 287
   at Telerik.Reporting.Processing.Data.SqlCommandProvider.CreateParameters(IDbCommand command, SqlDataSourceParameterCollection parameters) in c:\temp\reporting\@RBuild-19923\Reporting_Build\Source\Code\Telerik.Reporting.Processing.Data\SimpleDataSources\Sql\SqlCommandProvider.cs:line 246
   at Telerik.Reporting.Processing.Data.SqlQueryProvider.CreateCommand(IDbConnection connection, Boolean evaluateParameters) in c:\temp\reporting\@RBuild-19923\Reporting_Build\Source\Code\Telerik.Reporting.Processing.Data\SimpleDataSources\Sql\SqlQueryProvider.cs:line 103
   at Telerik.Reporting.Processing.Data.SqlQueryProvider.CreateCommand(IDbConnection connection) in c:\temp\reporting\@RBuild-19923\Reporting_Build\Source\Code\Telerik.Reporting.Processing.Data\SimpleDataSources\Sql\SqlQueryProvider.cs:line 90
   at Telerik.Reporting.Processing.Data.SqlDataEnumerable.<GetEnumerator>d__0.MoveNext() in c:\temp\reporting\@RBuild-19923\Reporting_Build\Source\Code\Telerik.Reporting.Processing.Data\SimpleDataSources\Sql\SqlDataEnumerable.cs:line 49
   at Telerik.Reporting.Processing.Data.ResultSetAdapter.Fill(ResultSet resultSet, IEnumerable`1 data) in c:\temp\reporting\@RBuild-19923\Reporting_Build\Source\Code\Telerik.Reporting.Processing.Data\ResultSet.cs:line 137
   at Telerik.Reporting.Processing.Data.SimpleDataProvider`1.Execute(MultidimensionalQuery query) in c:\temp\reporting\@RBuild-19923\Reporting_Build\Source\Code\Telerik.Reporting.Processing.Data\SimpleDataSources\SimpleDataProvider.cs:line 84
   at Telerik.Reporting.Processing.DataItem.GetDataCore(IDataSource dataSource, Dictionary`2 aggregatesMap) in c:\temp\reporting\@RBuild-19923\Reporting_Build\Source\Code\Telerik.Reporting.Processing\DataItem.cs:line 397
   at Telerik.Reporting.Processing.DataItem.ResolveData() in c:\temp\reporting\@RBuild-19923\Reporting_Build\Source\Code\Telerik.Reporting.Processing\DataItem.cs:line 262
   at Telerik.Reporting.Processing.DataItem.ProcessItem() in c:\temp\reporting\@RBuild-19923\Reporting_Build\Source\Code\Telerik.Reporting.Processing\DataItem.cs:line 192
   at Telerik.Reporting.Processing.Table.ProcessItem() in c:\temp\reporting\@RBuild-19923\Reporting_Build\Source\Code\Telerik.Reporting.Processing\Table.cs:line 244
   at Telerik.Reporting.Processing.ReportItemBase.ProcessElement() in c:\temp\reporting\@RBuild-19923\Reporting_Build\Source\Code\Telerik.Reporting.Processing\ReportItemBase.cs:line 157
   at Telerik.Reporting.Processing.ProcessingElement.Process(IDataMember dataContext) in c:\temp\reporting\@RBuild-19923\Reporting_Build\Source\Code\Telerik.Reporting.Processing\ProcessingElement.cs:line 241

*** Table::ProcessItem STARTED ***
A first chance exception of type 'System.Reflection.TargetInvocationException' occurred in mscorlib.dll
A first chance exception of type 'System.Reflection.TargetInvocationException' occurred in Telerik.Reporting.dll
*** Table::ProcessItem DONE in 00:00:00.2692167 ***

An exception has occurred while processing '' item:
System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.InvalidCastException: Object cannot be cast from DBNull to other types.
   at System.DBNull.System.IConvertible.ToByte(IFormatProvider provider)
   at MySql.Data.MySqlClient.MySqlCommandBuilder.DeriveParameters(MySqlCommand command)
   --- End of inner exception stack trace ---
   at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)
   at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments)
   at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
   at System.Reflection.MethodBase.Invoke(Object obj, Object[] parameters)
   at Telerik.Reporting.Processing.Data.SqlProviderFactory.DeriveParameters(IDbCommand command) in c:\temp\reporting\@RBuild-19923\Reporting_Build\Source\Code\Telerik.Reporting.Processing.Data\SimpleDataSources\Sql\SqlCommandProvider.cs:line 154
   at Telerik.Reporting.Processing.Data.SqlCommandProvider.ResolveProcedure(IDbCommand command, SqlDataSourceParameterCollection parameters) in c:\temp\reporting\@RBuild-19923\Reporting_Build\Source\Code\Telerik.Reporting.Processing.Data\SimpleDataSources\Sql\SqlCommandProvider.cs:line 287
   at Telerik.Reporting.Processing.Data.SqlCommandProvider.CreateParameters(IDbCommand command, SqlDataSourceParameterCollection parameters) in c:\temp\reporting\@RBuild-19923\Reporting_Build\Source\Code\Telerik.Reporting.Processing.Data\SimpleDataSources\Sql\SqlCommandProvider.cs:line 246
   at Telerik.Reporting.Processing.Data.SqlQueryProvider.CreateCommand(IDbConnection connection, Boolean evaluateParameters) in c:\temp\reporting\@RBuild-19923\Reporting_Build\Source\Code\Telerik.Reporting.Processing.Data\SimpleDataSources\Sql\SqlQueryProvider.cs:line 103
   at Telerik.Reporting.Processing.Data.SqlQueryProvider.CreateCommand(IDbConnection connection) in c:\temp\reporting\@RBuild-19923\Reporting_Build\Source\Code\Telerik.Reporting.Processing.Data\SimpleDataSources\Sql\SqlQueryProvider.cs:line 90
   at Telerik.Reporting.Processing.Data.SqlDataEnumerable.<GetEnumerator>d__0.MoveNext() in c:\temp\reporting\@RBuild-19923\Reporting_Build\Source\Code\Telerik.Reporting.Processing.Data\SimpleDataSources\Sql\SqlDataEnumerable.cs:line 49
   at Telerik.Reporting.Processing.Data.ResultSetAdapter.Fill(ResultSet resultSet, IEnumerable`1 data) in c:\temp\reporting\@RBuild-19923\Reporting_Build\Source\Code\Telerik.Reporting.Processing.Data\ResultSet.cs:line 137
   at Telerik.Reporting.Processing.Data.SimpleDataProvider`1.Execute(MultidimensionalQuery query) in c:\temp\reporting\@RBuild-19923\Reporting_Build\Source\Code\Telerik.Reporting.Processing.Data\SimpleDataSources\SimpleDataProvider.cs:line 84
   at Telerik.Reporting.Processing.DataItem.GetDataCore(IDataSource dataSource, Dictionary`2 aggregatesMap) in c:\temp\reporting\@RBuild-19923\Reporting_Build\Source\Code\Telerik.Reporting.Processing\DataItem.cs:line 397
   at Telerik.Reporting.Processing.DataItem.ResolveData() in c:\temp\reporting\@RBuild-19923\Reporting_Build\Source\Code\Telerik.Reporting.Processing\DataItem.cs:line 262
   at Telerik.Reporting.Processing.DataItem.ProcessItem() in c:\temp\reporting\@RBuild-19923\Reporting_Build\Source\Code\Telerik.Reporting.Processing\DataItem.cs:line 192
   at Telerik.Reporting.Processing.Table.ProcessItem() in c:\temp\reporting\@RBuild-19923\Reporting_Build\Source\Code\Telerik.Reporting.Processing\Table.cs:line 244
   at Telerik.Reporting.Processing.ReportItemBase.ProcessElement() in c:\temp\reporting\@RBuild-19923\Reporting_Build\Source\Code\Telerik.Reporting.Processing\ReportItemBase.cs:line 157
   at Telerik.Reporting.Processing.ProcessingElement.Process(IDataMember dataContext) in c:\temp\reporting\@RBuild-19923\Reporting_Build\Source\Code\Telerik.Reporting.Processing\ProcessingElement.cs:line 241

*** Table::ProcessItem STARTED ***
A first chance exception of type 'System.Reflection.TargetInvocationException' occurred in mscorlib.dll
A first chance exception of type 'System.Reflection.TargetInvocationException' occurred in Telerik.Reporting.dll
*** Table::ProcessItem DONE in 00:00:00.2682179 ***

An exception has occurred while processing '' item:
System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.InvalidCastException: Object cannot be cast from DBNull to other types.
   at System.DBNull.System.IConvertible.ToByte(IFormatProvider provider)
   at MySql.Data.MySqlClient.MySqlCommandBuilder.DeriveParameters(MySqlCommand command)
   --- End of inner exception stack trace ---
   at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)
   at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments)
   at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
   at System.Reflection.MethodBase.Invoke(Object obj, Object[] parameters)
   at Telerik.Reporting.Processing.Data.SqlProviderFactory.DeriveParameters(IDbCommand command) in c:\temp\reporting\@RBuild-19923\Reporting_Build\Source\Code\Telerik.Reporting.Processing.Data\SimpleDataSources\Sql\SqlCommandProvider.cs:line 154
   at Telerik.Reporting.Processing.Data.SqlCommandProvider.ResolveProcedure(IDbCommand command, SqlDataSourceParameterCollection parameters) in c:\temp\reporting\@RBuild-19923\Reporting_Build\Source\Code\Telerik.Reporting.Processing.Data\SimpleDataSources\Sql\SqlCommandProvider.cs:line 287
   at Telerik.Reporting.Processing.Data.SqlCommandProvider.CreateParameters(IDbCommand command, SqlDataSourceParameterCollection parameters) in c:\temp\reporting\@RBuild-19923\Reporting_Build\Source\Code\Telerik.Reporting.Processing.Data\SimpleDataSources\Sql\SqlCommandProvider.cs:line 246
   at Telerik.Reporting.Processing.Data.SqlQueryProvider.CreateCommand(IDbConnection connection, Boolean evaluateParameters) in c:\temp\reporting\@RBuild-19923\Reporting_Build\Source\Code\Telerik.Reporting.Processing.Data\SimpleDataSources\Sql\SqlQueryProvider.cs:line 103
   at Telerik.Reporting.Processing.Data.SqlQueryProvider.CreateCommand(IDbConnection connection) in c:\temp\reporting\@RBuild-19923\Reporting_Build\Source\Code\Telerik.Reporting.Processing.Data\SimpleDataSources\Sql\SqlQueryProvider.cs:line 90
   at Telerik.Reporting.Processing.Data.SqlDataEnumerable.<GetEnumerator>d__0.MoveNext() in c:\temp\reporting\@RBuild-19923\Reporting_Build\Source\Code\Telerik.Reporting.Processing.Data\SimpleDataSources\Sql\SqlDataEnumerable.cs:line 49
   at Telerik.Reporting.Processing.Data.ResultSetAdapter.Fill(ResultSet resultSet, IEnumerable`1 data) in c:\temp\reporting\@RBuild-19923\Reporting_Build\Source\Code\Telerik.Reporting.Processing.Data\ResultSet.cs:line 137
   at Telerik.Reporting.Processing.Data.SimpleDataProvider`1.Execute(MultidimensionalQuery query) in c:\temp\reporting\@RBuild-19923\Reporting_Build\Source\Code\Telerik.Reporting.Processing.Data\SimpleDataSources\SimpleDataProvider.cs:line 84
   at Telerik.Reporting.Processing.DataItem.GetDataCore(IDataSource dataSource, Dictionary`2 aggregatesMap) in c:\temp\reporting\@RBuild-19923\Reporting_Build\Source\Code\Telerik.Reporting.Processing\DataItem.cs:line 397
   at Telerik.Reporting.Processing.DataItem.ResolveData() in c:\temp\reporting\@RBuild-19923\Reporting_Build\Source\Code\Telerik.Reporting.Processing\DataItem.cs:line 262
   at Telerik.Reporting.Processing.DataItem.ProcessItem() in c:\temp\reporting\@RBuild-19923\Reporting_Build\Source\Code\Telerik.Reporting.Processing\DataItem.cs:line 192
   at Telerik.Reporting.Processing.Table.ProcessItem() in c:\temp\reporting\@RBuild-19923\Reporting_Build\Source\Code\Telerik.Reporting.Processing\Table.cs:line 244
   at Telerik.Reporting.Processing.ReportItemBase.ProcessElement() in c:\temp\reporting\@RBuild-19923\Reporting_Build\Source\Code\Telerik.Reporting.Processing\ReportItemBase.cs:line 157
   at Telerik.Reporting.Processing.ProcessingElement.Process(IDataMember dataContext) in c:\temp\reporting\@RBuild-19923\Reporting_Build\Source\Code\Telerik.Reporting.Processing\ProcessingElement.cs:line 241

*** Table::ProcessItem STARTED ***
A first chance exception of type 'System.Reflection.TargetInvocationException' occurred in mscorlib.dll
A first chance exception of type 'System.Reflection.TargetInvocationException' occurred in Telerik.Reporting.dll
*** Table::ProcessItem DONE in 00:00:00.2676148 ***

An exception has occurred while processing '' item:
System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.InvalidCastException: Object cannot be cast from DBNull to other types.
   at System.DBNull.System.IConvertible.ToByte(IFormatProvider provider)
   at MySql.Data.MySqlClient.MySqlCommandBuilder.DeriveParameters(MySqlCommand command)
   --- End of inner exception stack trace ---
   at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)
   at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments)
   at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
   at System.Reflection.MethodBase.Invoke(Object obj, Object[] parameters)
   at Telerik.Reporting.Processing.Data.SqlProviderFactory.DeriveParameters(IDbCommand command) in c:\temp\reporting\@RBuild-19923\Reporting_Build\Source\Code\Telerik.Reporting.Processing.Data\SimpleDataSources\Sql\SqlCommandProvider.cs:line 154
   at Telerik.Reporting.Processing.Data.SqlCommandProvider.ResolveProcedure(IDbCommand command, SqlDataSourceParameterCollection parameters) in c:\temp\reporting\@RBuild-19923\Reporting_Build\Source\Code\Telerik.Reporting.Processing.Data\SimpleDataSources\Sql\SqlCommandProvider.cs:line 287
   at Telerik.Reporting.Processing.Data.SqlCommandProvider.CreateParameters(IDbCommand command, SqlDataSourceParameterCollection parameters) in c:\temp\reporting\@RBuild-19923\Reporting_Build\Source\Code\Telerik.Reporting.Processing.Data\SimpleDataSources\Sql\SqlCommandProvider.cs:line 246
   at Telerik.Reporting.Processing.Data.SqlQueryProvider.CreateCommand(IDbConnection connection, Boolean evaluateParameters) in c:\temp\reporting\@RBuild-19923\Reporting_Build\Source\Code\Telerik.Reporting.Processing.Data\SimpleDataSources\Sql\SqlQueryProvider.cs:line 103
   at Telerik.Reporting.Processing.Data.SqlQueryProvider.CreateCommand(IDbConnection connection) in c:\temp\reporting\@RBuild-19923\Reporting_Build\Source\Code\Telerik.Reporting.Processing.Data\SimpleDataSources\Sql\SqlQueryProvider.cs:line 90
   at Telerik.Reporting.Processing.Data.SqlDataEnumerable.<GetEnumerator>d__0.MoveNext() in c:\temp\reporting\@RBuild-19923\Reporting_Build\Source\Code\Telerik.Reporting.Processing.Data\SimpleDataSources\Sql\SqlDataEnumerable.cs:line 49
   at Telerik.Reporting.Processing.Data.ResultSetAdapter.Fill(ResultSet resultSet, IEnumerable`1 data) in c:\temp\reporting\@RBuild-19923\Reporting_Build\Source\Code\Telerik.Reporting.Processing.Data\ResultSet.cs:line 137
   at Telerik.Reporting.Processing.Data.SimpleDataProvider`1.Execute(MultidimensionalQuery query) in c:\temp\reporting\@RBuild-19923\Reporting_Build\Source\Code\Telerik.Reporting.Processing.Data\SimpleDataSources\SimpleDataProvider.cs:line 84
   at Telerik.Reporting.Processing.DataItem.GetDataCore(IDataSource dataSource, Dictionary`2 aggregatesMap) in c:\temp\reporting\@RBuild-19923\Reporting_Build\Source\Code\Telerik.Reporting.Processing\DataItem.cs:line 397
   at Telerik.Reporting.Processing.DataItem.ResolveData() in c:\temp\reporting\@RBuild-19923\Reporting_Build\Source\Code\Telerik.Reporting.Processing\DataItem.cs:line 262
   at Telerik.Reporting.Processing.DataItem.ProcessItem() in c:\temp\reporting\@RBuild-19923\Reporting_Build\Source\Code\Telerik.Reporting.Processing\DataItem.cs:line 192
   at Telerik.Reporting.Processing.Table.ProcessItem() in c:\temp\reporting\@RBuild-19923\Reporting_Build\Source\Code\Telerik.Reporting.Processing\Table.cs:line 244
   at Telerik.Reporting.Processing.ReportItemBase.ProcessElement() in c:\temp\reporting\@RBuild-19923\Reporting_Build\Source\Code\Telerik.Reporting.Processing\ReportItemBase.cs:line 157
   at Telerik.Reporting.Processing.ProcessingElement.Process(IDataMember dataContext) in c:\temp\reporting\@RBuild-19923\Reporting_Build\Source\Code\Telerik.Reporting.Processing\ProcessingElement.cs:line 241

*** Graph::ProcessItem STARTED ***
A first chance exception of type 'System.Reflection.TargetInvocationException' occurred in mscorlib.dll
A first chance exception of type 'System.Reflection.TargetInvocationException' occurred in Telerik.Reporting.dll
*** Graph::ProcessItem DONE in 00:00:00.2975278 ***

An exception has occurred while processing '' item:
System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.InvalidCastException: Object cannot be cast from DBNull to other types.
   at System.DBNull.System.IConvertible.ToByte(IFormatProvider provider)
   at MySql.Data.MySqlClient.MySqlCommandBuilder.DeriveParameters(MySqlCommand command)
   --- End of inner exception stack trace ---
   at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)
   at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments)
   at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
   at System.Reflection.MethodBase.Invoke(Object obj, Object[] parameters)
   at Telerik.Reporting.Processing.Data.SqlProviderFactory.DeriveParameters(IDbCommand command) in c:\temp\reporting\@RBuild-19923\Reporting_Build\Source\Code\Telerik.Reporting.Processing.Data\SimpleDataSources\Sql\SqlCommandProvider.cs:line 154
   at Telerik.Reporting.Processing.Data.SqlCommandProvider.ResolveProcedure(IDbCommand command, SqlDataSourceParameterCollection parameters) in c:\temp\reporting\@RBuild-19923\Reporting_Build\Source\Code\Telerik.Reporting.Processing.Data\SimpleDataSources\Sql\SqlCommandProvider.cs:line 287
   at Telerik.Reporting.Processing.Data.SqlCommandProvider.CreateParameters(IDbCommand command, SqlDataSourceParameterCollection parameters) in c:\temp\reporting\@RBuild-19923\Reporting_Build\Source\Code\Telerik.Reporting.Processing.Data\SimpleDataSources\Sql\SqlCommandProvider.cs:line 246
   at Telerik.Reporting.Processing.Data.SqlQueryProvider.CreateCommand(IDbConnection connection, Boolean evaluateParameters) in c:\temp\reporting\@RBuild-19923\Reporting_Build\Source\Code\Telerik.Reporting.Processing.Data\SimpleDataSources\Sql\SqlQueryProvider.cs:line 103
   at Telerik.Reporting.Processing.Data.SqlQueryProvider.CreateCommand(IDbConnection connection) in c:\temp\reporting\@RBuild-19923\Reporting_Build\Source\Code\Telerik.Reporting.Processing.Data\SimpleDataSources\Sql\SqlQueryProvider.cs:line 90
   at Telerik.Reporting.Processing.Data.SqlDataEnumerable.<GetEnumerator>d__0.MoveNext() in c:\temp\reporting\@RBuild-19923\Reporting_Build\Source\Code\Telerik.Reporting.Processing.Data\SimpleDataSources\Sql\SqlDataEnumerable.cs:line 49
   at Telerik.Reporting.Processing.Data.ResultSetAdapter.SeedData(IEnumerable`1 rawData) in c:\temp\reporting\@RBuild-19923\Reporting_Build\Source\Code\Telerik.Reporting.Processing.Data\ResultSet.cs:line 177
   at Telerik.Reporting.Processing.Data.ResultSetAdapter.Fill(ResultSet resultSet, IEnumerable`1 data) in c:\temp\reporting\@RBuild-19923\Reporting_Build\Source\Code\Telerik.Reporting.Processing.Data\ResultSet.cs:line 119
   at Telerik.Reporting.Processing.Data.SimpleDataProvider`1.Execute(MultidimensionalQuery query) in c:\temp\reporting\@RBuild-19923\Reporting_Build\Source\Code\Telerik.Reporting.Processing.Data\SimpleDataSources\SimpleDataProvider.cs:line 84
   at Telerik.Reporting.Processing.DataItem.GetDataCore(IDataSource dataSource, Dictionary`2 aggregatesMap) in c:\temp\reporting\@RBuild-19923\Reporting_Build\Source\Code\Telerik.Reporting.Processing\DataItem.cs:line 397
   at Telerik.Reporting.Processing.DataItem.ResolveData() in c:\temp\reporting\@RBuild-19923\Reporting_Build\Source\Code\Telerik.Reporting.Processing\DataItem.cs:line 262
   at Telerik.Reporting.Processing.DataItem.ProcessItem() in c:\temp\reporting\@RBuild-19923\Reporting_Build\Source\Code\Telerik.Reporting.Processing\DataItem.cs:line 192
   at Telerik.Reporting.Processing.ReportItemBase.ProcessElement() in c:\temp\reporting\@RBuild-19923\Reporting_Build\Source\Code\Telerik.Reporting.Processing\ReportItemBase.cs:line 157
   at Telerik.Reporting.Processing.ProcessingElement.Process(IDataMember dataContext) in c:\temp\reporting\@RBuild-19923\Reporting_Build\Source\Code\Telerik.Reporting.Processing\ProcessingElement.cs:line 241

*** Graph::ProcessItem STARTED ***
A first chance exception of type 'System.Reflection.TargetInvocationException' occurred in mscorlib.dll
A first chance exception of type 'System.Reflection.TargetInvocationException' occurred in Telerik.Reporting.dll
*** Graph::ProcessItem DONE in 00:00:00.2697955 ***

An exception has occurred while processing '' item:
System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.InvalidCastException: Object cannot be cast from DBNull to other types.
   at System.DBNull.System.IConvertible.ToByte(IFormatProvider provider)
   at MySql.Data.MySqlClient.MySqlCommandBuilder.DeriveParameters(MySqlCommand command)
   --- End of inner exception stack trace ---
   at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)
   at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments)
   at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
   at System.Reflection.MethodBase.Invoke(Object obj, Object[] parameters)
   at Telerik.Reporting.Processing.Data.SqlProviderFactory.DeriveParameters(IDbCommand command) in c:\temp\reporting\@RBuild-19923\Reporting_Build\Source\Code\Telerik.Reporting.Processing.Data\SimpleDataSources\Sql\SqlCommandProvider.cs:line 154
   at Telerik.Reporting.Processing.Data.SqlCommandProvider.ResolveProcedure(IDbCommand command, SqlDataSourceParameterCollection parameters) in c:\temp\reporting\@RBuild-19923\Reporting_Build\Source\Code\Telerik.Reporting.Processing.Data\SimpleDataSources\Sql\SqlCommandProvider.cs:line 287
   at Telerik.Reporting.Processing.Data.SqlCommandProvider.CreateParameters(IDbCommand command, SqlDataSourceParameterCollection parameters) in c:\temp\reporting\@RBuild-19923\Reporting_Build\Source\Code\Telerik.Reporting.Processing.Data\SimpleDataSources\Sql\SqlCommandProvider.cs:line 246
   at Telerik.Reporting.Processing.Data.SqlQueryProvider.CreateCommand(IDbConnection connection, Boolean evaluateParameters) in c:\temp\reporting\@RBuild-19923\Reporting_Build\Source\Code\Telerik.Reporting.Processing.Data\SimpleDataSources\Sql\SqlQueryProvider.cs:line 103
   at Telerik.Reporting.Processing.Data.SqlQueryProvider.CreateCommand(IDbConnection connection) in c:\temp\reporting\@RBuild-19923\Reporting_Build\Source\Code\Telerik.Reporting.Processing.Data\SimpleDataSources\Sql\SqlQueryProvider.cs:line 90
   at Telerik.Reporting.Processing.Data.SqlDataEnumerable.<GetEnumerator>d__0.MoveNext() in c:\temp\reporting\@RBuild-19923\Reporting_Build\Source\Code\Telerik.Reporting.Processing.Data\SimpleDataSources\Sql\SqlDataEnumerable.cs:line 49
   at Telerik.Reporting.Processing.Data.ResultSetAdapter.SeedData(IEnumerable`1 rawData) in c:\temp\reporting\@RBuild-19923\Reporting_Build\Source\Code\Telerik.Reporting.Processing.Data\ResultSet.cs:line 177
   at Telerik.Reporting.Processing.Data.ResultSetAdapter.Fill(ResultSet resultSet, IEnumerable`1 data) in c:\temp\reporting\@RBuild-19923\Reporting_Build\Source\Code\Telerik.Reporting.Processing.Data\ResultSet.cs:line 119
   at Telerik.Reporting.Processing.Data.SimpleDataProvider`1.Execute(MultidimensionalQuery query) in c:\temp\reporting\@RBuild-19923\Reporting_Build\Source\Code\Telerik.Reporting.Processing.Data\SimpleDataSources\SimpleDataProvider.cs:line 84
   at Telerik.Reporting.Processing.DataItem.GetDataCore(IDataSource dataSource, Dictionary`2 aggregatesMap) in c:\temp\reporting\@RBuild-19923\Reporting_Build\Source\Code\Telerik.Reporting.Processing\DataItem.cs:line 397
   at Telerik.Reporting.Processing.DataItem.ResolveData() in c:\temp\reporting\@RBuild-19923\Reporting_Build\Source\Code\Telerik.Reporting.Processing\DataItem.cs:line 262
   at Telerik.Reporting.Processing.DataItem.ProcessItem() in c:\temp\reporting\@RBuild-19923\Reporting_Build\Source\Code\Telerik.Reporting.Processing\DataItem.cs:line 192
   at Telerik.Reporting.Processing.ReportItemBase.ProcessElement() in c:\temp\reporting\@RBuild-19923\Reporting_Build\Source\Code\Telerik.Reporting.Processing\ReportItemBase.cs:line 157
   at Telerik.Reporting.Processing.ProcessingElement.Process(IDataMember dataContext) in c:\temp\reporting\@RBuild-19923\Reporting_Build\Source\Code\Telerik.Reporting.Processing\ProcessingElement.cs:line 241
*** Report Processing DONE in 00:00:03.4022893 ***

*** ProcessReport #0 DONE in 00:00:03.6040165 ***

*** ReportProcessor.ProcessReport DONE in 00:00:03.6425769 ***


*** RenderReport #0 STARTED ***

*** Measure Report STARTED ***

*** Measure Report STARTED ***

*** Measure Report STARTED ***
*** Measure Report DONE in 00:00:00.1668263 ***

*** Measure Report DONE in 00:00:00.1913456 ***

*** Measure Report DONE in 00:00:00.2123840 ***


*** Arrange Report STARTED ***

*** Arrange Report STARTED ***

*** Arrange Report STARTED ***
*** Arrange Report DONE in 00:00:00.0108444 ***

*** Arrange Report DONE in 00:00:00.0309172 ***

*** Arrange Report DONE in 00:00:00.0532095 ***

*** RenderReport #0 DONE in 00:00:01.3111565 ***

General Discussions
Stef
Telerik team
 answered on 22 Nov 2013
3 answers
180 views
Querying from two tables
Please it it possible to have two sqldatasources in one report.
Thank you
General Discussions
IvanY
Telerik team
 answered on 22 Nov 2013
1 answer
153 views
Validate expressions before runtime and evaluate expressions
Hi Telerik team,

1. I need to validate expressions used in my report before report generation.
ex: = Parameters.Parameter1.Value / LineStyle.Solid, 

This expression gives me an error when generating report. I want to detect this very earlier stage. 

2. Is there any object type which keeps expression values or those expression evaluates in runtime? Can't I reuse expressions?
General Discussions
KS
Top achievements
Rank 1
 answered on 22 Nov 2013
3 answers
170 views
2nd column will not show (even in print preview mode)
Hi there,

I have a page 8.1 inches with margins .2 inches all around. I have also tried with 8 inch page.

Second column will not work. I have tried 8" page, 7" page, no margins, 1" margins, etc. Whatever I do it does not work. I have also tried removing the header and that did nothing. I have attached a pic of what it looks like in PP mode.

Here is my report:

<?xml version="1.0" encoding="utf-8"?>
<Report DataSourceName="sqlDataSource1" Width="8.1in" Name="guestlist" SnapGridSize="0.1in" xmlns="http://schemas.telerik.com/reporting/2012/3.3">
  <Style>
    <BorderWidth Default="0in" />
  </Style>
  <DataSources>
    <SqlDataSource ConnectionString="STRINGNAME" SelectCommand="select * from guestlist order by lastname" Name="sqlDataSource1" />
  </DataSources>
  <Items>
    <DetailSection Height="1.8in" Name="detail">
      <Style>
        <BorderStyle Top="None" Bottom="None" Left="None" Right="None" />
        <BorderColor Top="Black" Bottom="Black" Left="Black" Right="Black" />
        <BorderWidth Top="1pt" Bottom="1pt" Left="1pt" Right="1pt" />
      </Style>
      <Items>
        <TextBox Width="0.9in" Height="0.2in" Left="0.15in" Top="0.07in" Value="Name:" Name="textBox1">
          <Style TextAlign="Right" VerticalAlign="Middle">
            <BorderStyle Top="None" Bottom="None" Left="None" Right="None" />
            <BorderColor Top="Black" Bottom="Black" Left="Black" Right="Black" />
            <BorderWidth Top="1pt" Bottom="1pt" Left="1pt" Right="1pt" />
            <Font Size="9pt" />
          </Style>
        </TextBox>
        <TextBox Width="0.9in" Height="0.2in" Left="0.15in" Top="0.3in" Value="Guest Name:" Name="textBox4">
          <Style TextAlign="Right" VerticalAlign="Middle">
            <BorderStyle Top="None" Bottom="None" Left="None" Right="None" />
            <BorderColor Top="Black" Bottom="Black" Left="Black" Right="Black" />
            <BorderWidth Top="1pt" Bottom="1pt" Left="1pt" Right="1pt" />
            <Font Size="9pt" />
          </Style>
        </TextBox>
        <TextBox Width="0.9in" Height="0.2in" Left="0.15in" Top="0.5625in" Value="Children:" Name="textBox5">
          <Style TextAlign="Right" VerticalAlign="Middle">
            <BorderStyle Top="None" Bottom="None" Left="None" Right="None" />
            <BorderColor Top="Black" Bottom="Black" Left="Black" Right="Black" />
            <BorderWidth Top="1pt" Bottom="1pt" Left="1pt" Right="1pt" />
            <Font Size="9pt" />
          </Style>
        </TextBox>
        <TextBox Width="0.9in" Height="0.2in" Left="0.15in" Top="0.8in" Value="Address:" Name="textBox6">
          <Style TextAlign="Right" VerticalAlign="Middle">
            <BorderStyle Top="None" Bottom="None" Left="None" Right="None" />
            <BorderColor Top="Black" Bottom="Black" Left="Black" Right="Black" />
            <BorderWidth Top="1pt" Bottom="1pt" Left="1pt" Right="1pt" />
            <Font Size="9pt" />
          </Style>
        </TextBox>
        <TextBox Width="0.9in" Height="0.2in" Left="0.15in" Top="1.25in" Value="Phone:" Name="textBox8">
          <Style TextAlign="Right" VerticalAlign="Middle">
            <BorderStyle Top="None" Bottom="None" Left="None" Right="None" />
            <BorderColor Top="Black" Bottom="Black" Left="Black" Right="Black" />
            <BorderWidth Top="1pt" Bottom="1pt" Left="1pt" Right="1pt" />
            <Font Size="9pt" />
          </Style>
        </TextBox>
        <TextBox Width="0.9in" Height="0.2in" Left="0.15in" Top="1.5in" Value="Email:" Name="textBox9">
          <Style TextAlign="Right" VerticalAlign="Middle">
            <BorderStyle Top="None" Bottom="None" Left="None" Right="None" />
            <BorderColor Top="Black" Bottom="Black" Left="Black" Right="Black" />
            <BorderWidth Top="1pt" Bottom="1pt" Left="1pt" Right="1pt" />
            <Font Size="9pt" />
          </Style>
        </TextBox>
        <TextBox Width="2.80000025431315in" Height="0.2in" Left="1.10000014305115in" Top="0.0700000151991844in" Value="=Fields.FirstName + " " + Fields.LastName" Name="textBox10">
          <Style VerticalAlign="Middle">
            <BorderStyle Top="None" Bottom="Solid" Left="None" Right="None" />
            <BorderColor Top="Black" Bottom="Black" Left="Black" Right="Black" />
            <BorderWidth Top="1pt" Bottom="1pt" Left="1pt" Right="1pt" />
            <Font Size="9pt" />
            <Padding Left="0.0299999993294477in" />
          </Style>
        </TextBox>
        <TextBox Width="2.80000025431315in" Height="0.2in" Left="1.10000014305115in" Top="0.3in" Value="=Fields.Guests" Name="textBox11">
          <Style VerticalAlign="Middle">
            <BorderStyle Top="None" Bottom="Solid" Left="None" Right="None" />
            <BorderColor Top="Black" Bottom="Black" Left="Black" Right="Black" />
            <BorderWidth Top="1pt" Bottom="1pt" Left="1pt" Right="1pt" />
            <Font Size="9pt" />
            <Padding Left="0.03in" />
          </Style>
        </TextBox>
        <TextBox Width="2.80000025431315in" Height="0.2in" Left="1.10000014305115in" Top="0.5625in" Value="=Fields.Children" Name="textBox12">
          <Style VerticalAlign="Middle">
            <BorderStyle Top="None" Bottom="Solid" Left="None" Right="None" />
            <BorderColor Top="Black" Bottom="Black" Left="Black" Right="Black" />
            <BorderWidth Top="1pt" Bottom="1pt" Left="1pt" Right="1pt" />
            <Font Size="9pt" />
            <Padding Left="0.03in" />
          </Style>
        </TextBox>
        <TextBox Width="2.80000025431315in" Height="0.2in" Left="1.10000014305115in" Top="0.8in" Value="=Fields.Street" Name="textBox13">
          <Style VerticalAlign="Middle">
            <BorderStyle Top="None" Bottom="Solid" Left="None" Right="None" />
            <BorderColor Top="Black" Bottom="Black" Left="Black" Right="Black" />
            <BorderWidth Top="1pt" Bottom="1pt" Left="1pt" Right="1pt" />
            <Font Size="9pt" />
            <Padding Left="0.03in" />
          </Style>
        </TextBox>
        <TextBox Width="2.80000025431315in" Height="0.2in" Left="1.10000014305115in" Top="1in" Value="=Fields.City + ", " + Fields.State + " " + Fields.Zip " Name="textBox14">
          <Style VerticalAlign="Middle">
            <BorderStyle Top="None" Bottom="Solid" Left="None" Right="None" />
            <BorderColor Top="Black" Bottom="Black" Left="Black" Right="Black" />
            <BorderWidth Top="1pt" Bottom="1pt" Left="1pt" Right="1pt" />
            <Font Size="9pt" />
            <Padding Left="0.03in" />
          </Style>
        </TextBox>
        <TextBox Width="2.80000025431315in" Height="0.2in" Left="1.10000014305115in" Top="1.25in" Value="=Fields.Phone" Name="textBox15">
          <Style VerticalAlign="Middle">
            <BorderStyle Top="None" Bottom="Solid" Left="None" Right="None" />
            <BorderColor Top="Black" Bottom="Black" Left="Black" Right="Black" />
            <BorderWidth Top="1pt" Bottom="1pt" Left="1pt" Right="1pt" />
            <Font Size="9pt" />
            <Padding Left="0.03in" />
          </Style>
        </TextBox>
        <TextBox Width="2.80000025431315in" Height="0.2in" Left="1.10000014305115in" Top="1.5in" Value="= Fields.Email" Name="textBox16">
          <Style VerticalAlign="Middle">
            <BorderStyle Top="None" Bottom="Solid" Left="None" Right="None" />
            <BorderColor Top="Black" Bottom="Black" Left="Black" Right="Black" />
            <BorderWidth Top="1pt" Bottom="1pt" Left="1pt" Right="1pt" />
            <Font Size="9pt" />
            <Padding Left="0.03in" />
          </Style>
        </TextBox>
      </Items>
    </DetailSection>
    <PageHeaderSection Height="1in" Name="pageHeaderSection1">
      <Style BackgroundColor="238, 236, 225">
        <BorderStyle Top="Solid" Bottom="Solid" Left="Solid" Right="Solid" />
        <BorderColor Top="74, 69, 42" Bottom="74, 69, 42" Left="74, 69, 42" Right="74, 69, 42" />
        <BorderWidth Top="1pt" Bottom="1pt" Left="1pt" Right="1pt" />
        <Font Name="Edwardian Script ITC" />
      </Style>
      <Items>
        <PictureBox Value="Value" Width="7.7000002861023in" Height="0.799960613250732in" Left="0.199999968210856in" Top="0.0999999865889549in" Sizing="ScaleProportional" MimeType="image/png" Name="pictureBox1" />
      </Items>
    </PageHeaderSection>
  </Items>
  <PageSettings>
    <PageSettings PaperKind="Letter" Landscape="False" ColumnCount="2" ColumnSpacing="0in">
      <Margins>
        <MarginsU Left="0.2in" Right="0.2in" Top="0.2in" Bottom="0.2in" />
      </Margins>
      <BorderWidth Default="0in" />
    </PageSettings>
  </PageSettings>
</Report>
Report Designer (standalone)
Stef
Telerik team
 answered on 22 Nov 2013
3 answers
459 views
Horizontal Data
I am converting my reports over from Crystal Reports and have run into a little snag.  I list sometimes 800 weights to an order.  To list them vertically would be a show stopper.  In Crystal I went to the section expert and told it my layout was Horizontal (across then down).  Is there a way to do this in Telerik.  This is very important to us and if it cannot be done I will have to stay with Crystal which I do no want to do

Thank You
John Russo
Meat Processing Software
www.scaleprogrammers.com
General Discussions
Stef
Telerik team
 answered on 21 Nov 2013
1 answer
745 views
How create table with dynamic columns
Hi all,

I want design a report with a table,  but the number of columns is dynamic. How I can do it?  I receive data from a Stored Procedure.
If you can, please send an example.

Best Regarsd,
Marcelo Videira
Report Designer (standalone)
Stef
Telerik team
 answered on 20 Nov 2013
3 answers
178 views
Where to change the deafault message "missing parameters"
Hi,
where/how can I change the default message that appears when parameters have not yet been selected by the user?
See attached picture.
General Discussions
IvanY
Telerik team
 answered on 20 Nov 2013
1 answer
227 views
HTML5 ReportViewer and Objectdatasource
Is there an example of how to use the Html5 reportviewer with a objectdatasource

public class DashboardController : Controller
{
     public ActionResult Index()
    {
        var model = data.GetReportData()
 
        return View(model);
    }
}
@(Html.TelerikReporting().ReportViewer()
        .Id("reportViewer1")
        .ServiceUrl("/api/reports/")
        .TemplateUrl("/ReportViewer/templates/telerikReportViewerTemplate.htmll")
        .ReportSource(new TypeReportSource{TypeName="MyReportLibrary, Dashboard"})
        .ViewMode(ViewModes.INTERACTIVE)
        .ScaleMode(ScaleModes.SPECIFIC)
        .Scale(1.0)
        .PersistSession(true)
)

How do I attached the model to the reportsource?
General Discussions
IvanY
Telerik team
 answered on 20 Nov 2013
1 answer
1.0K+ views
Binding telerik report with dataset
PLEASE REFER TO MY STACK OVERFLOW QUESTION FOR DETAILED EXPLANATION.

http://stackoverflow.com/questions/20039340/binding-data-to-a-telerik-report

I'm using ASP.NET MVC with telerik reporting. I'm trying to bind data to a dataset, which is assigned to a telerik report.

I have tried with below code but data is not showing up.

private void Report1_ItemDataBound(object sender, EventArgs e)
        {
            SqlDataAdapter adapter = new SqlDataAdapter();
            rep = new reportRepository();
            List<ReportViewModel> model = rep.GetData();

            // Creating and configuring the ObjectDataSource component:
            var objectDataSource = new Telerik.Reporting.ObjectDataSource();
            objectDataSource.DataSource = dsConvertion.ToDataSet(model); // GetData returns a DataSet with three tables
            objectDataSource.DataMember = "tblFirst"; /// Indicating the exact table to bind to. If the DataMember is not specified the first data table will be used.

            // Creating a new report
            Telerik.Reporting.Report report = new Telerik.Reporting.Report();

            // Assigning the ObjectDataSource component to the DataSource property of the report.
            report.DataSource = objectDataSource;

            // Use the InstanceReportSource to pass the report to the viewer for displaying
            Telerik.Reporting.InstanceReportSource reportSource = new Telerik.Reporting.InstanceReportSource();
            reportSource.ReportDocument = report;

        }

General Discussions
Peter
Telerik team
 answered on 20 Nov 2013
3 answers
223 views
Graph of simple data

I am new to Telerik reporting and am trying to include a simple graph from data that has two columns (X, Y), for instance



1 345



2 10



...



12 3273 



The Graph wizard seems to assume a more complicated data structure and requires a category.



For the simple X Y graph I need there are no grouping or categories.



How do I graph this simple data.







The graph produced by the wizard also has "ALL" under the X axis for which I can not find the property displaying this text.



General Discussions
Petio Petkov
Telerik team
 answered on 20 Nov 2013
Narrow your results
Done
Selected tags
Tags
General Discussions
Report Designer (standalone)
Report Designer - Web
.NET Core
Report Parameters
Report Viewer - HTML5
.NET Framework
Report Viewer - ASP.NET
Rendering
Report Viewer - Blazor
DataSource SQL
Report Viewer - Angular
DataSources
Table
Rest Service
Report Viewer - WPF
Expressions
Report Viewer - MVC
Binding
Programming
Report Viewer - WinForms
Styling
.NET 5
Grouping
Conditional Formatting
DataSource Object
Graph
Report Viewer - HTML5 WebForms
Report Book
Filtering
SubReport
Upgrade
CrossTab
DataSource JSON
DataSource WebService
PictureBox
Installation
HTMLTextBox
Licensing
Report Wizard
Serialization
Actions
Sorting
Security
Converters
Interactivity
Accessibility
Events
Performance
TOC
Localization
Map
DataSource CSV
Report Viewer - Silverlight
CrossSection
AI Coding Assistant
+? more
Top users last month
Simon
Top achievements
Rank 2
Iron
Iron
Bob
Top achievements
Rank 3
Iron
Iron
Veteran
Marco
Top achievements
Rank 4
Iron
Iron
Iron
Grant
Top achievements
Rank 3
Iron
Iron
Iron
Kao Hung
Top achievements
Rank 1
Iron
Want to show your ninja superpower to fellow developers?
Learn how
629 630
631
632 633
Top users last month
Simon
Top achievements
Rank 2
Iron
Iron
Bob
Top achievements
Rank 3
Iron
Iron
Veteran
Marco
Top achievements
Rank 4
Iron
Iron
Iron
Grant
Top achievements
Rank 3
Iron
Iron
Iron
Kao Hung
Top achievements
Rank 1
Iron
Want to show your ninja superpower to fellow developers?
Learn how
Want to show your ninja superpower to fellow developers?
Learn how