I have been trying to create a financial aging report.  To do that, I have used a db2 sql with "days(date(@ARDATE as date)) - days(date(of char string for ar dates) as invoicedays".  The ARDATE is a datetime report parameter.

This statement works fine in the Execute Query option as well as the Report Designer Preview.  Unfortunately, when the report is published to our database, the invoicedays values show as zero. 

If I replace days(date(@ARDATE as date))  with days(current date), the calculation of days shows the correct values when published.

Note: The @ARDATE works with <=, >= or between in db2 sql so I think the format of data from the datepicker is '2016-03-10:hh:mm:ss'. 

Note: I can also change the parameter type to string and use csv data source as '2015-12-31, 2016-01-31,2016-02-29, etc to get the report to work.

How do I get the report to accept the @ARDATE from within the sql statement?

Hi,

I currently use images generated via a DevExpress chart component for my reports.  The reason for this is that historically I have not been happy with the look of the charts that have been generated.  I have completed a Material Design reworking of my site and now want to get the charts to have a material design look and feel. The good thing here is that the material design is considerably more simple in appearance than the old look of charts that I had.  Side benefit is that I will then only rely on Telerik controls and can ditch some more dlls!

So I want to use the Graph component that is built into the reporting.  I have the following initial questions:

1) Is there any connection between the Graph, Kendo UI charts and ASP.NET charts?  I'm interested as the examples shown on Kendo/ASP.Net have more detail so if they are related I'd know that functionality in one might be in the other.

2) Styles.  I'm now using style sheets for reports and it would be nice to use them on the graphs.  So for example I am using Calibri as my principle font on reporting and would like any titles, legends, data labels etc to use that.  Is this possible?

3) Is it possible to have better legend placement for the pie chart - the existing one doesn't seem great when dealing with small data slices.  I suppose that is the perpetual issue with pie charts though.  

4) Could I request that some better demos/samples be made available.  The docs are fairly basic with not much in the way of data relating to advanced customization of the charts.

Regards

Jon

in the official demo Dashboard.trdx report file, it defines two datasources:

1. yearDataSource

2. mainDataSource

 

I am trying to render the report as pdf with the ability to update the data source from the code (runtime), like this:

 

static void SaveReport(Telerik.Reporting.Report report, string fileName)
        {
            ReportProcessor reportProcessor = new ReportProcessor();

            Telerik.Reporting.InstanceReportSource instanceReportSource = new Telerik.Reporting.InstanceReportSource();
            instanceReportSource.ReportDocument = report;
            
            RenderingResult result = reportProcessor.RenderReport("PDF", instanceReportSource, null);

            using (FileStream fs = new FileStream(fileName, FileMode.Create))
            {
                fs.Write(result.DocumentBytes, 0, result.DocumentBytes.Length);
            }
        }

 

 

it only allows me to set the report.DataSource, not sure how to update all the data sources (yearDataSource & mainDataSource).

 

Can I just pass a dataset with 2 tables (named "yearDataSource" & "mainDataSource")?

 

Hi Team,

I am new in Telerik and i dont know , how to create a report in which we can use variable and fuction .I want to create a daily ,weekly and montly collection report .Suppose i have a date , country and amount fields.

Now i want to create a report in which i have to show daily ,Weekly and Montly collecion against country wise.    

 

Plaese suggest me.

Thanks,

Narender

Hi

I have seem this thread from early 2009:

http://www.telerik.com/community/forums/reporting/telerik-reporting/print-parameters-on-report.aspx 

It indicates that it is not possible to trap the parameters and show them in a report at runtime. To relate this to my situation, I have a report which is being used as the basis of billing for services. Billing is conducted for different date ranges so I have start and end date parameters in my report. Finance have asked me to include these dates in the report so clients can see the billing period. Unless I have misinterpreted the response in the attached thread and if nothing has changed in the interim, am I right in saying there is no way I can capture these two parameters and include them in my report?

thx

Michael

Hello everyone

I'm trying to add some fold marks on my Telerik report. The goal is to add such a fold mark each third of the whole A4 page. First I tried to add some textboxes with some value like "_" or "|". But logically this does not work.

I couldn't find any helpful thread/link in the forums or even in google. I'm talking about something similar to the attachment.

 To achieve this I'm using C# and a Telerik ReportViewer. Is this even possible?

Suggestions appreciated :)

Regards,
Danilo

I have previously used Telerik's Charts back in 2013 and now I need to start using it again with the new version.  I am trying to follow this example (http://docs.telerik.com/reporting/graphhowtocreateprogrammaticallygraph), but I can't seem to make basic changes to the graphs via code in this new version of the charts.  

Previously I was able to change the title of the chart by this syntax.

Chart1.ChartTitle.TextBlock.Text = "My Test Title"

 

How do I do this under the new graph?  

 

 

Hi telerik support , I have a problem a i Want to change the width between categorys in the x axis , how can i get it ,

 

            categoryscale.SpacingSlotCount =  (I need dinamyc);            
            graphAxisCategoryScale.Scale = categoryscale;

the porpouse it´s change the distance between points in the x axis 

 

Hell me please =(

 

Hi how ca i make the graph logarithmic  , i attacment the example , help me please i don know how to change the  vertical gridline, can you help me ?

Hi All,

I have created a report in Report Designer (Standalone) whose neme is test.trdx.Which is working fine.

Now i have installed report server to publish test.trdx report in report server.

So i have uploaded test.trdx report file in report server.But when i click on test.trdx in report server then it shows error.

 

"Unable to get report parameters.
An error has occurred.
Unable to establish a connection to the database. Please, verify that your connection string is valid. In case you use a named connection string from the application configuration file, make sure the name is correct and the connection string settings are present in the configuration file of your application".

 

Thanks,

 

Narender