Telerik Forums
Reporting Forum
1 answer
120 views
Hi,
I am having an issue exporting to CSV. I have a Report where Reports Items have Sub-Reports.  when i exported to CSV i got dulicate values.same data can be see over and over,some of the data do not match with the original.
Other exportings are working fine....


Is there any suggestions or work-arounds to get for a solution Please give a reply..

Regards
Manu vijayan
Stef
Telerik team
 answered on 16 May 2014
1 answer
133 views
I have a Telerik Report to produce monthly invoices. When I run the invoices into a Telerik Report Viewer, it works great.

If I use the same Report with RenderReport to run the invoices into a PDF document to
be emailed, the PDF consists of the report's header logo, and the footer
datetime and page number. The center section (retrieved from the
database) is blank. I'm not sure what I'm doing wrong. I've verified
that the parameters passed are correct and the same as the ones passed
into the Report Viewer. Any help would be appreciated.


private string SendOutInvoiceEmails(DateTime dtStartDate, Int16 intFinalInvoice, Int16 intFacility)
{
var typeReportSource = new Telerik.Reporting.TypeReportSource();
typeReportSource.TypeName = "TelerikReports.InvoiceMaster, TelerikReports";
typeReportSource.Parameters.Add("RID", rdr["Resid"]);
typeReportSource.Parameters.Add("RDM", dtStartDate.Month);
typeReportSource.Parameters.Add("RDY", dtStartDate.Year);

MailReport(typeReportSource, "admin@rexxrally.com", recRes.email_address, "Monthly Invoice For " + dtStartDate.ToString("MMM") + ", " + dtStartDate.ToString("yyyy"), "Here is your monthly invoice.", rdr["resid"].ToString());
}


void MailReport(Telerik.Reporting.ReportSource rptSource,
string from,
string to,
string subject,
string body,
string ResID)
{
ReportProcessor reportProcessor = new ReportProcessor();
RenderingResult result = reportProcessor.RenderReport("PDF", rptSource, null);
MemoryStream ms = new MemoryStream(result.DocumentBytes);
ms.Position = 0;
Attachment attachment = new Attachment(ms, "Invoice" + ResID + ".pdf");

MailMessage msg = new MailMessage(from, to, subject, body);
msg.Attachments.Add(attachment);

SmtpClient smptClient = new SmtpClient();
smptClient.Credentials = CredentialCache.DefaultNetworkCredentials;

smptClient.Send(msg);
}
Dave
Top achievements
Rank 1
 answered on 15 May 2014
9 answers
139 views
Is it possible to off-load the Report Processing to a client-side Silverlight application, instead of processing the Report Definition and Data on the server side to produce the Report Instance?

-Paul
Mike
Top achievements
Rank 1
 answered on 15 May 2014
5 answers
313 views

Hello again,

could it be that the TElerik Reporting Html 5 Service is not compatible to the current Microsoft.WebAPI (5.0)?
- I created an empty Asp.net Application (WebForms) in VS2013,
- added the Telerik.Reporting dlls via filesystem
- and the Microsoft.WebAPI via nuget.
- configure the reporting routes in the global.asax /APP_START:
ReportsControllerConfiguration.RegisterRoutes(System.Web.Http.GlobalConfiguration.Configuration);
- Start the WebApp

The application throws an exception:

Die Datei oder Assembly "System.Web.Http, Version=4.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" oder eine Abhängigkeit davon wurde nicht gefunden. Die gefundene Manifestdefinition der Assembly stimmt nicht mit dem Assemblyverweis überein. (Ausnahme von HRESULT: 0x80131040)

The same problem arises when using the default visual studio webforms template which includes/defaults to the current Microsoft.AspNet.WebAPI (5.0)

I tried to download the latest internal build but the link (
http://www.telerik.com/downloads/nightbuildfiles/dkkm/Telerik_Reporting_Q3_2013_7.2.13.1105_DEV.msi)

only points to a moved resource which redirects to the  accounts/download.aspx

To reproduce the problem just follow the steps above in a VS2013 instance

THank you for your assistance.
Regards,
Kris


Yegor
Top achievements
Rank 1
 answered on 15 May 2014
2 answers
62 views
Hi,
I am considering buying your reporting package, to html5 project in durandal.
I wanted to ask a few questions: 
1. I installed the trial version and tried to add your report to my project, and in the add report wizard in choosing data source I do not accept the types to choose from, its just empty window . What could be the problem? 

2. Can I link the data source for dynamic connection string / comes in the configuration? 

3. I tried to print a report of your sample project in html5 demo but instead printing is performed , pdf file Download.
What could be the reason for this? Have defined a default printer on the computer - control panel, but it did not help. 

4.Whether you can edit the  sql query- select sentence at runtime (by user search/filter/order.. on Client)?

I would be happy if you answer me as soon as possible,

It is urgent to me to decide whether your financial tool answer my needs,

Thank you!
Nasko
Telerik team
 answered on 14 May 2014
2 answers
304 views
Hi,

I'm with this problem in a report that I am unable to solve the problem 

I have these command gives the error and where this is 



protected void Form1_LoadCompleted_1()
{
try
            {
                System.Xml.XmlReaderSettings settings = new System.Xml.XmlReaderSettings();
                settings.IgnoreWhitespace = true;
                System.Xml.XmlReader xmlReader = System.Xml.XmlReader.Create(this.MapPath("Rel_proposta_teste.trdx"), settings);


                Telerik.Reporting.XmlSerialization.ReportXmlSerializer xmlSerializer = new Telerik.Reporting.XmlSerialization.ReportXmlSerializer();
                Telerik.Reporting.Report report = (Telerik.Reporting.Report)xmlSerializer.Deserialize(xmlReader);
                Rel.SetReportConnectionString(report, Convert.ToString(((Databases)Application["Databases"]).DataBaseList["Bdescala"].StringConnection)); <<<here problem>>>
                report.ReportParameters["Param_idproposta"].Value = Param_idproposta_inicio;


                // Atenção = altere o parâmetro “pld_entidade” para o parâmetro que vc criou no Reporting Telerik. 

                this.ReportViewer1.ReportSource = new Telerik.Reporting.InstanceReportSource
               {
                   ReportDocument = report,
               };

            }
            catch (Exception ex)
            {
                labError.Text = ex.Message.ToString();
            }
}


public partial class Rel : System.Web.UI.Page
{

public static void SetReportConnectionString(Telerik.Reporting.Report reportDocument, String connectionString)
        {
            Telerik.Reporting.SqlDataSource sds = (Telerik.Reporting.SqlDataSource)reportDocument.DataSource;
            if (sds != null)
                sds.ConnectionString = connectionString;
            SetReportConnectionString(reportDocument.Items, connectionString);
        }
        public static void SetReportConnectionString(Telerik.Reporting.ReportItemBase.ItemCollection items, String connectionString)
        {
            foreach (Telerik.Reporting.ReportItemBase ib in items)
            {
                if (ib.Items != null)
                {
                    SetReportConnectionString(ib.Items, connectionString);
                }
                Type type = ib.GetType();
                System.Reflection.PropertyInfo dataSourceProperty = type.GetProperty("DataSource");
                if (dataSourceProperty == null)
                    continue;
                var dataSource = dataSourceProperty.GetValue(ib, null) as Telerik.Reporting.SqlDataSource;
                dataSource.ConnectionString = connectionString;
            }
        }

}

The report is attached

thank you

NIgri
KS
Top achievements
Rank 1
 answered on 14 May 2014
1 answer
144 views
Hi, I'm still new to this, and my question seems to be really easy but i couldn't find the answer for it. Basically, i want to display the value of the column on the top of the column just like the picture below. Is there an easy way to do this? 
Ivan Hristov
Telerik team
 answered on 14 May 2014
4 answers
587 views
Hi,

Does anyone have a sample Project of how to create a Report Programatically (VB preferably).  I need to create reports completely from a set of parameters defined by the user.

I have tried working through the documentation section, but the parts there are too brief to let me work out the complete sequence of what I need to do, and if anyone has a sample of how this could be done to create Header, Group Header, Detail, Group Footer and Footer sections that would be great.

David Penny
Nasko
Telerik team
 answered on 13 May 2014
1 answer
68 views
I am new to Teleric and like the product but the documentation and samples need alot of work.

I have created a trdx file and have it using drillthrough. I want to use the Viewer on a form in my application  but do not see how or an example of doing this.

Can someone please point me to a solid example?

Cheers,
Brent McCaw
Nasko
Telerik team
 answered on 13 May 2014
1 answer
109 views
Hi. I've been trying to localize the (WPF) report viewer strings, and while most of it is done, I still have a problem with a few items.
Namely, I can't get the localization to work with one particular tooltip - the one that shows when the user hovers the mouse over the red validation error indicator (see attachment). I'm using resource files to do this, and, to my understanding, the localized string should be placed under the InvalidValueForParameter key, but this doesn't work for some reason. We're using Telerik Reporting Q1 2013.
Also, I noticed that your documentation for ITextResources <a href="http://www.telerik.com/help/reporting/allmembers_t_telerik_reportviewer_wpf_itextresources.html">here</a> does not specify the PageSetupToolTip property, nor the StopToolTip property - is this an accidental omission, or are there differences between the versions?

P.S. I also noticed that ITextResources interface doesn't contain an InvalidValueForParameter property in TR Q1 2013. Does this mean that this particular tooltip cannot be localized in this version?
Stef
Telerik team
 answered on 13 May 2014
Top users last month
Rob
Top achievements
Rank 3
Iron
Iron
Iron
Atul
Top achievements
Rank 1
Iron
Iron
Iron
Alexander
Top achievements
Rank 1
Veteran
Iron
Serkan
Top achievements
Rank 1
Iron
Shawn
Top achievements
Rank 1
Iron
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?