Telerik Forums
Reporting Forum
8 answers
137 views
Hi,

I´ve updated the telerik DLLs for Silverlight RadControls and Reporting.
Opening a Report results now in a XamlPaseException telling me that the Type "TextBoxEx" is missing.
So whats wrong here?
Steve
Telerik team
 answered on 09 Mar 2012
6 answers
301 views
I have a parameter with Multivalues. I would like the parameter do default to Select all and have therefore implemented a AllValue function (as shown in another post in this forum) to set the Value property. This works very well as log as the value only has unique values. Example:

SELECT

 

fullname FROM employee


value=AllValues(fields.fullname)

This works wothout problem.But if I get the value from a table that contains the same value more than once I got problem. Example:

SELECT

 

activity.startdate,employee.fullname FROM activity INNER JOIN employee ON activity.employeesignature=employee.signature
value=AllValues(fields.fullname)

The result of this is that the parameter is shown with the unique values and all values is selected. But, if i deselect all, only some items is deselected. And if I click on the others they could not be deselected at all.
The problem occurs to be that the second example could result in several rows with the same value in employee.fullname. OPnly the rows that have only one row with the same value is handled correctly.

So, how can I solve this problem?

R
Torbjörn 

Steve
Telerik team
 answered on 09 Mar 2012
1 answer
64 views
I am creating a set of reports, each with 1-2 charts.  How do I set the title at run time using the reportviewer?

Sample of my aspx code:

 Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
        If Not IsPostBack Then
            Dim report As New MyReports.RevByOffice
            ReportViewer1.Report = report
        End If
End Sub

I am using Reporting Q3 2011.  Once I have all the reports designed, then I will put all the reports into a ReportBook.
Steve
Telerik team
 answered on 09 Mar 2012
2 answers
112 views
I have created a reportbook which shows sales information at the highest level of a client. If a client-structure contains several departments, a sales report for each department is created, and will be added to the reportbook.

The structure of a client is stored outside telerik, in an AD-database. The parameters are passed to the report in the code-behind (department is item in a list of departments items):

foreach (var item in items)
{
    RptAnalyseOmzetTotaal rptAnalyseOmzetTotaal = new RptAnalyseOmzetTotaal();
    rptAnalyseOmzetTotaal.ReportParameters["customer"].Value = item.TrimStart('0');
    rptAnalyseOmzetTotaal.ReportParameters["year"].Value = year;
    rptAnalyseOmzetTotaal.ReportParameters["periodFrom"].Value = periodFrom;
    rptAnalyseOmzetTotaal.ReportParameters["periodTo"].Value = periodTo;
    reportBook.Reports.Add(rptAnalyseOmzetTotaal);
}

The problem is if a department doesn't have sales for the asked period, an empty report is added to the reportbook.
I need to do a check if a department contains data. Does the report-class rptAnalyseOmzetTotaal have a method to check if it contains data for the given parameters?

I'm using Reporting Q1 2012 in a Umbraco Portal.
Peter
Top achievements
Rank 1
 answered on 09 Mar 2012
1 answer
197 views
I can't find this anywhere.  Your help is appreciated.

I want to change the font and color of the series item label in my chart.  The properties all seem to be exposed as I have changed every font in the chart so far except this label.

I have tried it several different ways in the code behind as well with no luck.

I can go in and set it via properties, series collection, items but that does not display in the report (just the VS preview).  I am databinding in the code behind in new:    Chart1.DataSource = _ds.Tables(0) 

Suggestions greatly appreciated.

Private Sub Chart1_ItemDataBound(ByVal sender As Object, ByVal e As System.EventArgs) Handles Chart1.ItemDataBound
    Chart1.Series(1).Appearance.TextAppearance.TextProperties.Color = Color.Red
 
    Dim myseries As ChartSeries
    Dim myitem As ChartSeriesItem
 
    For Each myseries In Chart1.Series
        myseries.Appearance.TextAppearance.TextProperties.Color = Color.Red
 
        For Each myitem In myseries.Items
            myitem.Label.TextBlock.Appearance.TextProperties.Color = Color.Red
            myitem.Label.TextBlock.Text = "xxxx"
        Next
    Next
 
 
End Sub
Steve
Telerik team
 answered on 09 Mar 2012
2 answers
106 views
Hey All

Today is my first day trying this reporting product and as usual , I have spent allot of time scratching my head. I'm used to that and it's part of taking on new projects and learning. ( and being self employed and having to take on new things all the time!!)
I have been looking at Demo's, reading forums and watching videos most of the day! ( along with trying things)

I normally just bash my way through things till I get it working, but since we have this great resource I thought I would try for some advice please. It should save me going down a path that wont work!. 

The requirement is a report on employers performance. The user will select the month  and the team.

The report layout is multiple page, with a page for each team member.

Report Header: Report for Team Member X

Dates           performance data 1,performance data 2 ,performance data 3  ,total for PD , total@work
01/01/2012      A                                B                                   C                          A+B+C+D          E
01/02/2012      A                                C                                   C                          A+B+C+D          E
  etc ...

Report Footer:
                     Total A                        Total B                        Total C         Total (A+B+C+D)  ,Total E    

               % totals A / E                 % totals B / E            % totals C / E           % totals ALL / E 

I have tried the only 2 report wizards ( table and crosstab) and neither can do the grouping by page, so I asume I need to use the footer for the percentage calculations..

My assumption is that I need to create a parameterised report for the above that is passed the month and the team member ID. Then use a Report Book and dynamically add the report for each team member , passing the month and member ID 

Is that the right approach or is there some way to group into pages that I cannot see?

I'm using 2012 Q1 release

Cheer guys!
Rob
Top achievements
Rank 2
Iron
Veteran
Iron
 answered on 08 Mar 2012
2 answers
351 views
Hello,

I want to design a master-detail report with the main select from the query below as the master and the subselect as the detail. I set up the report data source to use the subselect query and I have to do the outer grouping on the report level. However, I can't figure out how to achieve this behavior in Telerik Reporting, since it doesn't allow aggregate functions in the group by clause and I need to group by SUM(Amount). Is it possible to use alias, as I do in the T-SQL query?

SELECT sub1.ID, SUM(sub1.Value) AS Value, sub1.Amount
FROM
    (SELECT ForeignID AS ID, Value, SUM(Amount) AS Amount
    FROM Tbl
    GROUP BY ForeignID, Value) sub1
GROUP BY sub1.ID, sub1.Amount
Yavor
Top achievements
Rank 1
 answered on 08 Mar 2012
1 answer
158 views
Hi,
  We are using Telerik reports with telerk web report viewer in MVC 3 Razor application. We get "Report is unavailable or session has expired error message" message at random times. I saw this KB Article and it does not provide too much detail.

Since I am using reporting in MVC 3 app, does it makes any difference on how the session time out is affected? Does Telerik report still uses my application's session and its timeout values?

To me, it feels like it is not using the default session timeout from the application. During events of time out it would be ideal to redirect user to login page as well. 

Please provide more clarification.

Regards,


Steve
Telerik team
 answered on 08 Mar 2012
3 answers
170 views
I have to export a radgridview (winforms) with an image column.
I have stored in sql database the image and I defined the column like this:
gv.MasterTemplate.Columns["image"].Width = 120;
gv.MasterTemplate.Columns["image"].DataType = typeof(Image);
gv.MasterTemplate.Columns["image"].ImageLayout = ImageLayout.Zoom;

I can see the images without problem in the radgridview, but if I try to export grid with telerik reporting (Q3 2011), I cannot see image (in the column cells it write "System.Drawing.Bitmap")
this is the code that I use when I create the table to export from the masterview:
System.IO.MemoryStream stmBLOBData = new System.IO.MemoryStream((byte[])gridViewTemplate.Rows[row].Cells[cell].Value);
Image image = Image.FromStream(stmBLOBData);
tableRow[cell] = image;

thanks all,
Marco







Ivan Petrov
Telerik team
 answered on 08 Mar 2012
16 answers
724 views
Hello community,

is it possible to use Telerik Reporting with Microsoft's Entity Framework? I tried it, but the report couldn't retrieve data from the database.
If it is possible could somebody give me directions how to do it or where to investigate further?

Thanks in advance and kind regards,

Gerald
Chris
Top achievements
Rank 1
 answered on 07 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?