Telerik Forums
Reporting Forum
2 answers
104 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
342 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
149 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
164 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
714 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
0 answers
141 views
Hello,

will inheritance work / full supported in the new Report Designer?

Thank you,
Manuel
Manuel
Top achievements
Rank 1
 asked on 06 Mar 2012
3 answers
96 views
Hello,

I´m designing various letters in different reports and each must contain the same Header (e.g. a merchant logo or address).
Since it´s not possible to put a subreport in the "PageHeaderSection" i´m wondering how to solve this.


Edit: I´ve read the other posts about inheriting from a BaseReport. But the samples don´t work since they´re from an older version. Can someone provide a new sample please.
Steve
Telerik team
 answered on 06 Mar 2012
2 answers
233 views
Hello,

I want to set page header height by binding on my report.
I tryed to use a help function as below:

 

 

        Public Shared Function GetHeaderPageHeight(pageNumber As Integer) As Telerik.Reporting.Drawing.Unit
            If pageNumber = 1 Then
                Return New Unit(10, Telerik.Reporting.Drawing.UnitType.Cm)
            Else
                Return New Unit(20, Telerik.Reporting.Drawing.UnitType.Cm)
            End If
        End Function

 
On binding dialog I set the property Height as my help function, but isn't work.
Please, tell me what I do wrong.

Thanks a lot, excuse my bad english.



Elian
Telerik team
 answered on 06 Mar 2012
0 answers
146 views
Hai !

   I am creating new Report dynamically in ClassLibrary.I have Serialized the Report in XML format .I have no Idea  for how to display the report after deserialization in reportVIewer?


Serialization code:
 
 private void button1_Click(object sender, EventArgs e)
        {
            ForSerialization report = new ForSerialization();
            using (System.Xml.XmlWriter xmlWriter = System.Xml.XmlWriter.Create("c:/tmp/SerializedReport.xml"))
            {
                System.Xml.Serialization.XmlSerializer xmlSerializer = new System.Xml.Serialization.XmlSerializer(typeof(Telerik.Reporting.Report));
 
                xmlSerializer.Serialize(xmlWriter, report);
            }
        }
 
 
 
 
 
 
 
deserialization:
 
  private void button2_Click(object sender, EventArgs e)
        {
 
            using (System.Xml.XmlReader xmlReader = System.Xml.XmlReader.Create("c:/tmp/SerializedReport.xml"))
            {
                System.Xml.Serialization.XmlSerializer xmlSerializer = new System.Xml.Serialization.XmlSerializer(typeof(Telerik.Reporting.Report));
 
                Telerik.Reporting.Report report = (Telerik.Reporting.Report)xmlSerializer.Deserialize(xmlReader);
                 
              
            }
gowthami
Top achievements
Rank 1
 asked on 06 Mar 2012
3 answers
84 views
One of our users is reporting that when they select the export option (pdf, excel etc) the link for "Export" does not enable.  No one else has this problem.  Has anyone seen this, and do you have any idea how to resolve it?  Paging works fine for example.
Steve
Telerik team
 answered on 06 Mar 2012
Top users last month
Jay
Top achievements
Rank 3
Iron
Iron
Iron
Benjamin
Top achievements
Rank 3
Bronze
Iron
Veteran
Radek
Top achievements
Rank 2
Iron
Iron
Iron
Bohdan
Top achievements
Rank 2
Iron
Iron
Richard
Top achievements
Rank 4
Bronze
Bronze
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?