Telerik Forums
Reporting Forum
1 answer
162 views
Hi ,
    At this moment ; I use the telerik reporting's version is 5.0.11.510 , and the report's data bind the ObjectDataSource in the Report_ItemDataBinding event.

   The telerik reporting report display well by using silverlight reportviewer ; But , When I have selected the 'pdf' or 'tiff' file format to export the report , the reportviewer will throw the exception.
  
   The other file format excluded the 'pdf' or 'tiff' have exported successfully.

   Please see the attachment included the exported exception.

   How to solve this issue ?
  
   Thanks.
Peter
Telerik team
 answered on 20 Mar 2012
6 answers
932 views
I'm trying to conditionally format the text of all fields showing on my report, if the value is a specific string value. Example, if the field has a value of "No" then i would leave it alone, if it was "Yes" it would have a text font color of red. I don't want to declare this for each field, I want to write one logical statement that can check the field value and if it meets a certain criteria, then it would format the style on the textbox that contains that field reference.


Is there a way to do this through design time dialogues or programatically?
Peter
Telerik team
 answered on 19 Mar 2012
1 answer
282 views
I'm developing a report that includes an HtmlTextbox.  However, while the formatted Html looks fine in the RadRichTextbox where it is being edited, it ends up with each span having its last several characters cut off.  This is an example of Html that produces the issue:
<p style="margin: 0px 0px 0px 0px;text-align: left;text-indent: 0pt;padding: 0px 0px 0px 0px;"><span style="font-family: 'Segoe UI';font-style: Normal;font-weight: normal;font-size: 12px;color: #E57572;">%%CALLDATE%% - %%CALLTIME%%12345123451234512345</span><span style="font-family: 'Segoe UI';font-style: Normal;font-weight: normal;font-size: 12px;color: #000000;"><br /></span><span style="font-family: 'Segoe UI';font-style: Normal;font-weight: normal;font-size: 12px;color: #000000;"> this is a testdsafsdf</span></p><p style="margin: 0px 0px 0px 0px;text-align: left;text-indent: 0pt;padding: 0px 0px 0px 0px;"><span style="font-family: 'Segoe UI';font-style: Normal;font-weight: normal;font-size: 12px;color: #000000;">sent on </span><span style="font-family: 'Segoe UI';font-style: Normal;font-weight: bold;font-size: 12px;color: #000000;">%%LETTERDATE%%</span></p><p style="margin: 0px 0px 0px 0px;text-align: left;text-indent: 0pt;padding: 0px 0px 0px 0px;"><span style="font-family: 'Segoe UI';font-style: Normal;font-weight: bold;font-size: 12px;color: #000000;"> </span></p><p style="margin: 0px 0px 0px 0px;text-align: left;text-indent: 0pt;padding: 0px 0px 0px 0px;"><span style="font-family: 'Segoe UI';font-style: Normal;font-weight: normal;font-size: 12px;color: #E57572;">12345123451234512345</span><span style="font-family: 'Segoe UI';font-style: Normal;font-weight: normal;font-size: 12px;color: #000000;"><br /></span><span style="font-family: 'Segoe UI';font-style: Normal;font-weight: normal;font-size: 12px;color: #E57572;">12345123451234512345</span><span style="font-family: 'Segoe UI';font-style: Normal;font-weight: normal;font-size: 12px;color: #000000;"><br /></span><span style="font-family: 'Segoe UI';font-style: Normal;font-weight: normal;font-size: 12px;color: #E57572;">12345123451234512345123451234512345123451234512345123451234512345123451234512345</span><span style="font-family: 'Segoe UI';font-style: Normal;font-weight: normal;font-size: 12px;color: #000000;"><br /><br /><br /></span><span style="font-family: 'Segoe UI';font-style: Normal;font-weight: bold;font-size: 12px;color: #000000;" /></p>

in the HtmlTextbox, this has every single span cut off at the right.  The same happens to the printout if I print directly from the ReportViewer control.  However, if I export the Html to PDF, the mysterious padding goes away!  It would be greatly appreciated if you could shed some light on this mystery.
IvanY
Telerik team
 answered on 19 Mar 2012
3 answers
674 views
I'm attempting to use the RunningValue function that accepts a System.String for the "scope" parameter.  The documentation says it can refer to a group but when I assign it the name of a group I get the following exception:

"Invalid Scope: 'DivisionId'"

... where "DivisionId" is the name of the group and also the name of the field the group is grouped by.

Help!

Thanks - wg
IvanY
Telerik team
 answered on 19 Mar 2012
3 answers
282 views
Can telerik reporting be used to make reports from a Microsoft Access database?  We are unable to move to SQL server at this time...
Steve
Telerik team
 answered on 16 Mar 2012
1 answer
818 views
I have developed several reports that use the Arial Unicode MS font because of the possibility that the report contains Japanese characters.  The Style for the titles has the Bold property set to true and it displays fine when it is viewed in the Telerik Report Viewer.  For some reason when the report is exported to a PDF none of the text displays in bold, or at least it is not noticeable.  If the same report is exported to other formats it displays as I would expect it to.  What I don't understand is why this is a  problem with the PDF file type.
Elian
Telerik team
 answered on 16 Mar 2012
3 answers
289 views
I'm using MVC 3, and I use Telerik Report to call a method witch the parameter is the user id, and it should not be changed, so the user wouldn't see other user data.

public List<ViewBoleto> ListBoleto(long userid)

what I did was, in the report.cs, I let the parameter as:
 new Telerik.Reporting.ObjectDataSourceParameter("userid", typeof(long), "=Parameters.userid.Value")});

so I set the value in ViewReport.aspx, and I set as Visible = false, so nobody could edit it.

rpt.ReportParameters["userid"].Value = ViewData["UserId"];
rpt.ReportParameters["userid"].Visible = false;

It works wonders, but there is a bug, when I click in Refresh, the "Navigate Back" button turns green, and if I click on it, the Parameters will turn to Visible = true, and the user can change the values!!!

Is there a better way to I call the method ListBoleto, and pass the parameter, and block the user from changing it?
Arthur
Top achievements
Rank 1
 answered on 16 Mar 2012
13 answers
2.3K+ views
Hi Telerik team,

I'm currently facing to a problem that really limits my field of action,let me explain it with a simple example (though the designer, not through the code) :
I have two reports :
- Masterreport
- DetailReport

Into Master report detailsection, I add a subreport control. I set its reportsource to DetailReport, its backcolor to blue and its dock property to Top.
Into Detail report, I remove header and footer sections, and I set its detailsection.backcolor to red.
Finally, I set their width to a thin one like 10cm.

When previewing the report, I see that my subreport doesn't filled its parent control width. With use of backgroundcolors, I saw that it's really MasterReport's SubReport control that wasn't horizontally filled, not it's reportsource. I really would like to make it fill !

When searching a solution into this forum, I saw that you tell to set Location of subreport or something like that but I don't understand what to do exactly.

Thanks for all,
Regards

Steeve
Steve
Telerik team
 answered on 16 Mar 2012
0 answers
264 views
* RESOLVED - Looks like this was a PEBKAC error.  I recreated the report this morning and it works great.  Thanks!

It doesn't look like my report parameters are being passed through to the stored procedure in the data source.  I'm on the trial version of Q1 2012.

Using the wizard, I created a simple report in an ASP.NET Web application that pulls data from a stored procedure with a single parameter.  In the properties of the SQLDataSource I selected, "<New Report Parameter>" and created a report parameter assigned to the stored procedure parameter.  At run time I display the report using the following code,

Dim _Report As New TSVStandardReports.Rpt_TelerikCustomersWithTwentyAccounts
DirectCast(_Report.DataSource, Telerik.Reporting.SqlDataSource).ConnectionString = sConnectionString
_Report.ReportParameters("BranchID").Value = "42"
ReportViewer1.Report = _Report


Seems pretty straight forward, but at run time the value "42" is not passed to my stored procedure.  What am I missing?
David
Top achievements
Rank 1
 asked on 15 Mar 2012
1 answer
548 views
Hello.  I set up a few Telerik reports a couple of years ago, and now I'm trying to remind myself how they work.  :-)

I am creating a new report that has a dynamic datasource here:
public Report1()
    {
        /// <summary>
        /// Required for telerik Reporting designer support
        /// </summary>
        InitializeComponent();
 
        //
        // TODO: Add any constructor code after InitializeComponent call
        //
 
 
        this.NeedDataSource += new System.EventHandler(this.Report1_NeedDataSource);
    }
 
    private void Report1_NeedDataSource(object sender, EventArgs e)
    {
        Telerik.Reporting.Processing.Report report = (Telerik.Reporting.Processing.Report)sender;
 
        int advertiserID = int.Parse(report.Parameters["advertiserID"].Value.ToString());
        DateTime dtStartDate = DateTime.Parse(report.Parameters["startDate"].Value.ToString());
        DateTime dtEndDate = DateTime.Parse(report.Parameters["endDate"].Value.ToString());
 
        report.DataSource = (GetBannersByMonthByAdvertiser(advertiserID, dtStartDate, dtEndDate)).Tables[0];
    }


The report works fine when I build the project and view it through the report viewer, however, I cannot get the data to run in the Preview version of the report, and the designer does not recognize that any fields are available for the report.

I tried using a SqlDataSource stored procedure, but I have been unable to successfully pass in the date parameters when trying to run the stored procedure. 

So, my question is:  how to I get the report to recognize that data fields are available for creating the report when I have a dynamic data source?  Thanks!!
Elian
Telerik team
 answered on 15 Mar 2012
Top users last month
Tien
Top achievements
Rank 1
Iron
Krasimir
Top achievements
Rank 3
Bronze
Iron
Iron
Cedar
Top achievements
Rank 1
Iron
Emil
Top achievements
Rank 1
Iron
Kyle Watson
Top achievements
Rank 1
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?