Telerik Forums
Reporting Forum
3 answers
238 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
670 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
241 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.1K+ 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
230 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
493 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
21 answers
283 views
just out of curiosity do you gusy have any plans to implement a runtime designer so my users can create ad hoc reports or is that out side the scope of what Telerik Reporting is supposed to do?

We are currently trying to decide between this and Crystal as our report engine, but the main advantage Crystal has currently is they do have a report designer I can give my end users so I don't end up having to write all the reports.

Thanks!
Tim
Top achievements
Rank 1
 answered on 15 Mar 2012
4 answers
630 views
Hi,
We wanted to find out if it is possible to allow users to dynamically group data in a Telerik Reporting Report (the users are used to the group by features from the Telerik RadGrid/RadGridView).  The users want to be able to select 1 or more columns in the report to group the data by, is this possible?  Some times they will just let the report generate without adding grouping.
Mike
Top achievements
Rank 1
 answered on 15 Mar 2012
5 answers
177 views
I have a chart that works fine. The problem is the chart may have 7 items on the X axis or 700. If there are 7 it looks great, if there are 700 it is unreadable.

How can I print the 700 so it is readable.

The two solutions I have been looking into (I am open to other solutions) are:

1) Determine the number of elements in the result set and change the height of the report to be a multiple of the data set.
2) Duplicate the chart as many times as needed based on the results limiting each chart to 20 records.

Option 2 is probably the preferred option. I have not been able to work my way through how to do either of these.

Is there a way to do what I need to do? I don't want to filter the data, I need to show it all.
Ryan
Top achievements
Rank 1
 answered on 15 Mar 2012
3 answers
140 views
Hello,

I need to vary the color of the Bars in bar chart in silverlight telerik report.

I have attached the screen shot which provide more idea what i need.

Thanks,
Hiren
Hadib Ahmabi
Top achievements
Rank 1
 answered on 15 Mar 2012
Top users last month
Rob
Top achievements
Rank 3
Bronze
Bronze
Iron
Sergii
Top achievements
Rank 1
Iron
Iron
Dedalus
Top achievements
Rank 1
Iron
Iron
Lan
Top achievements
Rank 1
Iron
Doug
Top achievements
Rank 1
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?