Telerik Forums
Reporting Forum
1 answer
211 views
Hi,
        I'm Samy Currently Working on Telerik Reporting. I'm serializing the Report to a XML and saving to the Database. and deserializing the XML and Show the Report.

        Now I need is In Detailed Section I'm having two Sub Reports and a text box. I have to assign the Footer of the Sub report value to the Textbox in the Main report. how to do this? Please Provide with Sample Code.


      also Can you please guide me How to add water marking in telerik 2011 Q2.

                    Thanks in advance.


Regards,
K.K.Samy
Chavdar
Telerik team
 answered on 30 Apr 2012
8 answers
372 views
I am trying to make a user-friendly message that says "No Results" if the datasource comes back empty. The only problem is that the NeedDatasource event handler even when it is in the ASPX code behind does not allow for any changes to the web page once it fires. The page rendering must happen before that event. Does any one have any suggestions how to implement this "No Results" feature. I don't know why Telerik Reports wouldn't have an EmptyTemplate sort of thing.
Pavan
Top achievements
Rank 1
 answered on 29 Apr 2012
2 answers
59 views
I couldn't check that switching of parameter will create 1016 requests. Now of it it was convinced. I asked myself a question: why loading of lists occurs so long. Why the sqlDataSourceAddresses requests data so many time?
For my case only once suffices, because parameters:
@adrType, @proTypeOwner, @proConId, @proDepId, @proDate, @userId
 don't change.

Thanks.
ADM-IT Denis Pujdak
Top achievements
Rank 1
 answered on 27 Apr 2012
1 answer
103 views
We are showing pdf by pushing pdfbytes array. 
We can able to view Bookmarks section by clicking on Bookmars icon manually as shown in below figure.
But My requirement is to display Bookmarks section in PDF by default. Please Help how to display that section dynamically.

We have used the below code:

<iframe id="ifPDF" src='@Url.Action("GetHtmlReport", "StandardReports")'  class="resultPDF">

 public ActionResult GetHtmlReport()
        {
            byte[] result = null;
            string mimeType = "application/pdf";
            result = popstreatmernt;
            return File(result, mimeType);
        }

 private void GetReportInfo(StandardReportsListViewModel stdReportsFilters)
        {
            try
            {
                RequistionParameters ReqParams = new RequistionParameters();
                RequisitionCheckListbase ReqchkParams = new RequisitionCheckListbase();              
                RequistionChecklistReport reportRequistionChecklist = new RequistionChecklistReport();
                reportRequistionChecklist.ReportInput = ReqchkParams;
                byte[] pdfbytesReport = GetPdfBytes(reportRequistionChecklist);
                popstreatmernt = pdfbytesReport;

            }
            catch { }
        }

public byte[] GetPdfBytes(Report rpt)
        {
            Telerik.Reporting.Processing.ReportProcessor reportProcessor = new                              Telerik.Reporting.Processing.ReportProcessor();
            //set any deviceInfo settings if necessary
            System.Collections.Hashtable deviceInfo = new System.Collections.Hashtable();
            Telerik.Reporting.Processing.RenderingResult result1 = reportProcessor.RenderReport("PDF", rpt, deviceInfo);
            byte[] result = result1.DocumentBytes;
            return result;
        }

Steve
Telerik team
 answered on 27 Apr 2012
1 answer
416 views
Hi,

is there a way to have a fixed number of row in a table even if the datasource have only one rows?

I have an invoice report and the details must have a fixed number of row (10 in this case). If the datasource returns only 2 rows, the other 8 will be blank. In SQL Server reporting service, I achieve it by this query:
DECLARE @Empty TABLE(ROW_NUM INT);
DECLARE @iCount INT
SET @iCount = 1
 
WHILE @iCount<=10
    BEGIN
        INSERT INTO @Empty VALUES(@iCount)
        SET @iCount = @iCount + 1
    END
 
SELECT DETTAGLI.*
    FROM @Empty RF
    LEFT OUTER JOIN (
                    SELECT
                                    ROW_NUMBER() OVER (ORDER BY SEQ) AS RIGA,
                                    FD.SEQ,
                                    UM.CODICE AS UM,
                                    FD.PREZZO,
                                    FD.QUANTITA,
                                    FD.IMPORTO,
                                    FD.DESCRIZIONE,
                                    I.DESCRIZIONE AS DESC_IVA,
                                    I.ALIQUOTA,
                                    I.CODICE AS CODICE_IVA
                                FROM vend.T_FATTURE_DETTAGLIO FD
                                INNER JOIN cont.T_ALIQUOTE_IVA I ON I.ID_ALIQUOTA = FD.ALIQUOTA_IVA_ID
                                INNER JOIN magaz.T_ARTICOLI ART ON ART.ID_ARTICOLO = FD.ARTICOLO_ID
                                LEFT OUTER JOIN anag.T_UM UM ON UM.ID_UM = ART.UM_ID
                                WHERE FATTURA_ID = @prmIDFattura
                    ) DETTAGLI ON DETTAGLI.RIGA = RF.ROW_NUM

But in Telerik Reporting it is not possibel to declare variables into Query. It is an alternate way?

Thanks
Steve
Telerik team
 answered on 27 Apr 2012
1 answer
325 views
Hi All,

In telerik report viewer is it possible to hide/remove entire column according to the flag value.

Eg.
EmpNo   Name   Sal   Desig
111         aaa      100  abc
112         bbb      200  abb
113         ccc       300  baa

My requirement is, if I remove column Sal the Desig column should shift to the left side. In code behind I made the header textbox and field textbox as visible false from code behind. From doing this, only header is removing and shifting to the left side but the field value is not shifting it is taking space.
Is I need to use filters, report parameters for this. Thanks in advance.

Thanks,
Akki
Steve
Telerik team
 answered on 27 Apr 2012
1 answer
131 views
Is there a way of preventing the very last row of some data appearing on a new page on its own? I’m thinking of something like a property specifying “don’t allow fewer than x rows to appear on a page on their own”. So for example, if I have a dataset containing 25 rows and each page of my report can accommodate 24 rows, ordinarily I would get the heading labels and the last row on a new page on their own. What I would I like is to be able to set a property to say 3, resulting in page one containing 22 rows and page two containing 3 rows.
Steve
Telerik team
 answered on 27 Apr 2012
1 answer
133 views
Hi, 

I have dragged a chart object onto my design view. I have also set up a datasource that returns relatively simple data, e.g. A DVD title, and Quantity Sold. 

I have set this data source in the 'Data Source' property of the chart. I have also inserted the following code in the .cs file, e.g.

private void chart1_NeedDataSource(object sender, EventArgs e)
 {
Telerik.Reporting.Processing.Chart procChart = (Telerik.Reporting.Processing.Chart)sender;
procChart.DataSource = ChartExample1;
 }

From looking at the following post, this appears to be all I should need to do in order to populate the chart, however it doesn't appear to be the case. 

Can someone help?

Thanks.
Steve
Telerik team
 answered on 26 Apr 2012
1 answer
136 views
Hi,

I am trying to generate a pdf from a report that meets the accessibility standards.
For this, I have to add headings so that the pdf is well indexed and can jump from one location to another.

The only thing that I found regarding this is the DocumentMapText field that I set on the Groups.
This creates a nice Bookmarks section for the document but doesn't mark the titles as headings.

Can you point me in the right direction on how could I mark the titles/subtitles on my report as headings?

Thank you.
Steve
Telerik team
 answered on 26 Apr 2012
14 answers
801 views
We incorporated Telerik report into our web-based cube browsing product earlier this year and it was very successful.

However the Excel export has not been popular.  The purpose of an export to Excel is to get the data into Excel and manipulate it further from there.  Unfortunately there is so much formatting in the Telerik Excel export that the result looks identical to the original report but is of no practical use.  In particular because of the blank rows and columns that are added to force formatting into the spreadsheet.

It would be preferable if the Excel export added lighter formatting.  It should never add blank rows and columns between the data.

We would also like to see drill-down capability in the Excel output using the Excel Grouping function.  We have done this using Reporting Services and an Analysis Services cube source and it has been very popular with users.
Steve
Telerik team
 answered on 25 Apr 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?