Telerik Forums
Reporting Forum
2 answers
421 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
231 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
235 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
845 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
171 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
139 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
281 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
189 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
130 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
1 answer
87 views
I have a nested List(three layers in total) where the detail list or the deepest layer just display all the rows in one page. How can I control the row size in each Page?

Please help

Thanks
Steve
Telerik team
 answered on 06 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?