Telerik Forums
Reporting Forum
1 answer
423 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
336 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
136 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
140 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
145 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
818 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
1 answer
89 views
 

We are displaying table1 for patient 1 and table2 for patient2.Here invisible table1 for patient2 and

table2 for patient1.But Next consecutive patients(means patient3,patient4,patient5,..) table1 and table2 are not displaying which are same conditions of patient1 and patient2 in the report.

How to make those tables visible to other patients also.

May I know Why this is happening altough we are making visible to "true".

Thanks

Steve
Telerik team
 answered on 25 Apr 2012
2 answers
141 views
HI,
I have create a web class library that contient a telerik reporting,and in the same solution a have create a website project and a user control to display a telerik reporting, and for that i have put a report viewer in the user control,i have add the class library reference to the web site project
and put too :  

Protected Sub Page_Load(ByVal sender As Object, ByVal e As EventArgs) Handles Me.Load


        If Not IsPostBack Then
            Dim report As New HotelClassLibraryVb.HotelDashboard2
            'report1.DataSource = MyDataSource; 
            ReportViewer1.Report = report


        End If
    End Sub

In the user control to show the telerik reporting
But it doesn't work !!?I realy wish to know why 
Thankx
Berrabah
Top achievements
Rank 1
 answered on 25 Apr 2012
0 answers
74 views
I know i'm well beyond the intended use of Telerik Reporting, but i keep thinking there should be some creative and interesting way to do this.

What i want to do is use Telerik Reporting to generate some printed handouts.  There are about a dozen different ones, with the same template but different text/images.  The trick i'm running into is, any one handout may have X images, where X is between 0 and 5.  Additionally, i want text to either flow around them, or at least be broken by them (text above and below).  It would look like this


Blah blah blah blah blah 
blah blah blah blah blah 
          <IMAGE1>
blah blah blah blah blah
blah blah <IMAGE2
blah blah   IMAGE2>
blah blah blah blah blah

(example attached)

In a perfect world, the HTML textbox would accept all HTML, and i could use <img src...> and floats to solve this, but i understand the HTML text box is limited in function.  Does anyone have a brilliant notion on how to do this? or should i just save each side of my handout as an image and forget about my pipe dream here?
IIJ Tech Support
Top achievements
Rank 1
 asked on 24 Apr 2012
3 answers
90 views
Hi. 
I have a little problem, but can't handle it.
I have designed simple crosstable with drilldown.
In Designer's preview mode all works good. But when report is showed by silverlight application, drilldown toggle button (with +/-) is not visible. Beside this it works good when i click on its place (place, where it should be).


Can somebody help me? I appreciate any advices or critics.
Steve
Telerik team
 answered on 24 Apr 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?