Telerik Forums
Reporting Forum
or
Ask question
All Questions
Unanswered
Answered
13,640 questions
3 answers
147 views
Email Report from MVC application
We have created a set of reports in VS that run just fine.  There is a listing of Orders with a button that launches each report based upon the row selected in the listing.  Now they would like me to add another button to simply email out the report for the selected row.  So what I have done is:
  1. Taken existing VS report and imported them into the StandAlone Designer.
  2. Saved the .tdrx files to the app_Data folder.
  3. Used the XML Deserializer to get the report.
  4. Render the report as a PDF. (See issue below)
  5. Attached the PDF to an email and send.

The basics work, however I am having trouble fully rendering the report due to the data connection. 

Issue:
I can't seem to figure out if the connection string from the original VS report; the string needs to be modified in the .tdrx or (as in my code below) programically added just before rendering????

If needed at run time, I have 2 SQL data sources in the original report, how do I do multiples in my code?

public void MailReportWparam(string Neededreport,
            string param,
            string paramValue,
            string reportNames,
            string from,
            string to,
            string subject,
            string body)
        {
            ReportProcessor reportProcessor = new ReportProcessor();
 
            System.Xml.XmlReaderSettings settings = new System.Xml.XmlReaderSettings();
            settings.IgnoreWhitespace = true;
 
            using (System.Xml.XmlReader xmlReader = System.Xml.XmlReader.Create("C:\\Development\\PFSc2\\PFSc2\\PFSc2\\App_Data\\" + Neededreport + ".trdx", settings))
            {
                //Generate Report from XML Template
                Telerik.Reporting.XmlSerialization.ReportXmlSerializer xmlSerializer =
                    new Telerik.Reporting.XmlSerialization.ReportXmlSerializer();
 
                Telerik.Reporting.Report report = (Telerik.Reporting.Report)
                    xmlSerializer.Deserialize(xmlReader);
                    report.Name = reportNames;
                //Set Database connection
                //Edit for Production
                    Telerik.Reporting.SqlDataSource dataSource = new Telerik.Reporting.SqlDataSource();
                    dataSource.ConnectionString = "Data Source=ITDESKTOP\\PFS;Initial Catalog=PFS;Persist Security Info=True;User ID=########;Password=##########";
                    dataSource.SelectCommand = "SELECT        KF_Procurement.ID, KF_Procurement.Vendor_ID, KF_Procurement.Receiving_Date, KF_Procurement.Create_Date, KF_Procurement.BOL_ID, KF_Procurement.BOL_Date, KF_Procurement.PO_ID, KF_Procurement.PO_Date, KF_Procurement.Rec_Del_Method_ID, KF_Procurement.Temperature,KF_Procurement.Confirm_Date, KF_Procurement.Sent_Date, KF_Procurement.POType_ID, KF_Procurement.Revision_Date, KF_Procurement.warehouse_ID, KF_Procurement.VendorAddressID, KF_Procurement.Trucking_PackType_ID, KF_Address.TypeID, KF_Address.IsActive AS Expr2, KF_Address.Street1, KF_Address.Street2, KF_Address.City, KF_Address.StateID, KF_Address.State, KF_Address.CountryID, KF_Address.Country, KF_Address.Postal, KF_Address.Start_Date AS Expr3, KF_Address.End_Date AS Expr4, KF_Address.ID AS AddrID, KF_Address.Ven_ID AS AddrVenID, KF_Address.Store_ID, KF_Address.Cust_ID, KF_Address.Ware_ID, KF_Address.Person_ID, KF_Address.Owner_ID AS Expr5, KF_Address.IsPrimary, KF_Address.Owner_Type, KF_BOLs.ID AS BOLID, KF_BOLs.Date, KF_BOLs.Number, KF_BOLs.POType_ID AS BOLPOtypeID, KF_BOLs.POType, KF_BOLs.Status_ID, KF_BOLs.OwnerType_ID, KF_BOLs.Owner_ID AS BOLOwnID, KF_BOLs.DeliveryDate, KF_BOLs.Comment, KF_BOLs.Issued, KF_BOLs.Date_Issued, KF_BOLs.InsertDt, KF_BOLs.InsertBy,  KF_BOLs.UpdateDt, KF_BOLs.UpdateBy, KF_BOLs.Old_Sys_Num, KF_Person.FName, KF_Person.LName, KF_Person.FullName, KF_Person.OwnerID,  KF_Person.IsActive AS PerIsActive, KF_Person.Start_Date AS PerStartDt, KF_Person.End_Date AS PerEndDt, KF_Person.Vendor_ID AS PerVenId,  KF_Person.Cust_ID AS PerCustID, KF_Person.Store_ID AS PerStoreID, KF_Person.ID AS PersonID, KF_Person.WrHse_ID, KF_Person.IsPrimary AS PerIsPrimary,  KF_Person.UserID, KF_Phone_Email.Owner_ID AS PhEmOwnId, KF_Phone_Email.Phone_Number AS PhEmPhNum, KF_Phone_Email.EmailAddress AS PhEmEmail,  KF_Phone_Email.IsActive AS PhEmIsActive, KF_Phone_Email.Start_Date AS PhEmStartDt, KF_Phone_Email.End_Date AS PhEmEndDt, KF_Phone_Email.Type_ID,  KF_Phone_Email.ID AS PhEmID, KF_Phone_Email.Cust_ID AS PhEmCustID, KF_Phone_Email.Ven_ID AS PhEmVenID, KF_Phone_Email.Person_ID AS PhEmPerId,  KF_Phone_Email.Ware_ID AS PhEmWarID, KF_Phone_Email.Store_ID AS PhEmStoreID, KF_Phone_Email.IsPrimary AS PhEmIsPrimary, KF_Vendor.ID AS VenID,  KF_Vendor.Name FROM            KF_Procurement LEFT OUTER JOIN KF_Vendor ON KF_Procurement.Vendor_ID = KF_Vendor.ID LEFT OUTER JOIN KF_Person ON KF_Vendor.ID = KF_Person.Vendor_ID LEFT OUTER JOIN KF_Phone_Email ON KF_Vendor.ID = KF_Phone_Email.Ven_ID AND KF_Person.ID = KF_Phone_Email.Person_ID LEFT OUTER JOIN KF_BOLs ON KF_Procurement.BOL_ID = KF_BOLs.ID FULL OUTER JOIN KF_Address ON KF_Vendor.ID = KF_Address.Ven_ID AND KF_Procurement.VendorAddressID = KF_Address.ID AND KF_Person.ID = KF_Address.Person_ID WHERE        (KF_Procurement.ID = @ProcID) AND (KF_Person.IsPrimary = 1)";
                    dataSource.Name = "ProcDataSource";
 
                    report.DataSource = dataSource;
                //Feed report paramaters
                    report.ReportParameters[param].Value = paramValue;
                //Create PDF of report
                    RenderingResult result = reportProcessor.RenderReport("PDF", report, null);
                    MemoryStream ms = new MemoryStream(result.DocumentBytes);
                    ms.Position = 0;
 
                //Create Email Message with Attachments
                    MailMessage msg = new MailMessage(from, to, subject, body);
                    Attachment attachment = new Attachment(ms, report.Name + ".pdf");
                    msg.Attachments.Add(attachment);
                    SmtpClient client = new SmtpClient();
                    client.Send(msg);
           }
}


General Discussions
Peter
Telerik team
 answered on 25 Nov 2013
1 answer
130 views
Long text fields problem
There is a problem in our report pages. long text fields looks bad.
Not: All fields multiline have to be.

Page view screenshot: http://prntscr.com/25ozvf

Designer and "Açıklama" textbox properties: http://prntscr.com/25p0ls
Designer and Other textbox screenshot: http://prntscr.com/25p193

Thanks
Report Designer (standalone)
Stef
Telerik team
 answered on 22 Nov 2013
1 answer
121 views
Prevent WPF Reportviewer from Rerendering when Hidden
Hi Telerik Team,

i have a WPF application with several Reportviewers,
each in a RadTabItem (inside an RadTabControl).

The Report in the active (visible) RadTabItem is rendered properly. However, when the user selects another RadTabItem
(so the ReportViewer is hidden) the ReportViewer loses its rendering. When the RadTabItem with the reportviewer inside is selected again,
(so the ReportViewer becomes visible again) the Report is rendered newly from the scratch.

This is very annoying because a) rendering takes some time and b) i render a reportbook, so the second time the ReportViewer renders the report, the position of the selected report is lost.

Is there any possibilty to prevent the ReportViewer from losing the rendering when hidden? Some kind of caching..

Best regards.
General Discussions
Stef
Telerik team
 answered on 22 Nov 2013
3 answers
352 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
105 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
117 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
129 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
395 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
675 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
125 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
Narrow your results
Done
Selected tags
Tags
General Discussions
Report Designer (standalone)
Report Designer - Web
Report Parameters
.NET Core
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
Binding
Report Viewer - MVC
Report Viewer - WinForms
Programming
Styling
.NET 5
Conditional Formatting
Grouping
DataSource Object
Graph
Report Viewer - HTML5 WebForms
Report Book
Filtering
Upgrade
DataSource JSON
DataSource WebService
CrossTab
SubReport
Installation
PictureBox
HTMLTextBox
Report Wizard
Serialization
Actions
Sorting
Converters
Licensing
Security
Events
Interactivity
Accessibility
Performance
TOC
Map
DataSource CSV
Localization
Report Viewer - Silverlight
CrossSection
+? more
Top users last month
Jay
Top achievements
Rank 3
Iron
Iron
Iron
Benjamin
Top achievements
Rank 3
Bronze
Iron
Veteran
Radek
Top achievements
Rank 2
Iron
Iron
Iron
Bohdan
Top achievements
Rank 2
Iron
Iron
Richard
Top achievements
Rank 4
Bronze
Bronze
Iron
Want to show your ninja superpower to fellow developers?
Learn how
621 622
623
624 625
Top users last month
Jay
Top achievements
Rank 3
Iron
Iron
Iron
Benjamin
Top achievements
Rank 3
Bronze
Iron
Veteran
Radek
Top achievements
Rank 2
Iron
Iron
Iron
Bohdan
Top achievements
Rank 2
Iron
Iron
Richard
Top achievements
Rank 4
Bronze
Bronze
Iron
Want to show your ninja superpower to fellow developers?
Learn how
Want to show your ninja superpower to fellow developers?
Learn how