Telerik Forums
Reporting Forum
5 answers
113 views
Hi

after reading some threads , i know that we can't use the raddatafilter for the reporting or we don't have any similar components like that in the reporting.

However, how can i get that similar function of the raddatafilter for my reporting

For example, if my radgridview has 3 columns (last name, first name, age)

then i want to be able to filter by Last Name or First name or age ( a drop down box for them will be the best solution). I don't want to have seperated box for each of them (in my real case, i will have a lot of field for the table)

then another drop down to let the user choose the "operator"
and another field to let the user type the value

a function which is similar to the raddatafilter

In summary, i want to achieve something which can let me filter all of the possible Field names in my table without having separated component for each fields. And then let the user print it (having preview option )

I hope my explanation is clear enough

thank you 
Peter
Telerik team
 answered on 05 Sep 2011
1 answer
544 views
Hi there,
the goal that I need to reach is to hide a specific group total row in a crosstab report, based on the value of a field.
With reference to the attached picture, I want that row number 3 (the first group total row) is not visible.
Just to be more clear, it is like if in the "Product Sales per Period" sample report I want to hide the "totals" row when the main category is "Accessories".
I've tried in code behind with this, but only the color style works:
Private Sub Crosstab1_ItemDataBound(ByVal sender As Object, ByVal e As System.EventArgs) Handles Crosstab1.ItemDataBound
  Dim table As Telerik.Reporting.Processing.Table = DirectCast(sender, Telerik.Reporting.Processing.Table)
  For Each row As Telerik.Reporting.Processing.TableRow In table.Rows
    If row.Index = 3 Then
      For colIndex As Integer = 0 To table.Columns.Count - 1
        Dim cell As Telerik.Reporting.Processing.ITableCell = row.GetCell(colIndex)
        If cell.RowIndex = row.Index AndAlso cell.ColumnIndex = colIndex Then
          Dim item As Telerik.Reporting.Processing.ReportItem = cell.Item
          If TypeOf (item) Is Processing.TextBox Then
            Dim txt As Processing.TextBox = DirectCast(item, Processing.TextBox)
            item.Visible = False  'does not work
            txt.Visible = False 'does not work
            txt.Height = New Telerik.Reporting.Drawing.Unit(0)  'does not work
            txt.Style.Color = Color.Red 'it works !
          End If
        Else
          ' Do nothing. This is part of a merged table cell
        End If
      Next
    End If
  Next
End Sub

I've tried to use a Filtering expression for the crosstab, but if apply an expression on the main category field, obviously the WHOLE group gets hidden/displayed, not just the totals row of that group. (NOTE: using the operator Not Like generates an error when previewing, while the same filter with Like operator works. Is it correct ? - see attachment 2)

Please explain me how can I have control over the row of a crosstab, maybe with an example.
I'm using Reporting Q2_2011_v5_1_11_713
TIA
Ubaldo
Hrisi
Telerik team
 answered on 05 Sep 2011
0 answers
120 views
Solved. Thanks!!
Juan
Top achievements
Rank 1
 asked on 03 Sep 2011
1 answer
104 views
Hi,

We have a report that prints fine on the client's WinXp machine.  They received new Win7 machines today and the reports are now printing at a shrunken, almost microscopic size when printed from the ReportViewer.  The report looks fine in the ReportViewer but when  printed it prints at a shrunken size.  We tried this on 2 different computers to 2 different printers with the same result.  I tried saving the report as pdf from the ReportViewer, opened it in Adobe, and it printed fine.  What is strange is that we have this same report at other locations that are using Win7 without a problem.  The report page settings is Portrait;Letter.

Also, the same application has a few ActiveReports in it (we are slowly converting them to Telerik) and they print fine.

Do you have any suggestions or recommendations?

Thank you.
David A.
Top achievements
Rank 1
 answered on 02 Sep 2011
3 answers
97 views
Is there a way to set the tab sequence of the report parameters in the silverlight viewer?  I have a report that has 5 parameters, and it's taking three - four tab strokes to get from one field to the next.
Hrisi
Telerik team
 answered on 02 Sep 2011
1 answer
89 views
Hi,

I am confused about the report viewer's toolbar. My report has 50 pages in it. I want to jump directly to 25th page. How can i do it?

One is I type in the number and press tab, it takes me to the required page. It's happening on lost focus of the textbox to my knowledge.
But i want this functionality when i press enter, instead of tab. 

Is there any way to proceed to the page by pressing enter??

thank you
Peter
Telerik team
 answered on 02 Sep 2011
1 answer
299 views
Hi,

I am using SqlDataSource and data loaded from stored procedure. While designing the report, I am getting this error once the wizard try to populate the result fields. pls check the attachement.

Let me know if you want more details.

Thanks,
Suresh.
Peter
Telerik team
 answered on 02 Sep 2011
4 answers
510 views
Is it possible to use multiple datasources on the one report, and use them at the same time,  like Datasource1.field1,  Datasource1.field2, datasource2.field1, etc.?  I've already searched the forums and google, and the posts are all from 2008, so maybe it has been improved since then?



Chris @ Intrinsic
Top achievements
Rank 1
 answered on 01 Sep 2011
2 answers
125 views
I have the following set up in my report:

A Table with a Header row and 1 data row. Inside the data row is another table, which is displaying most of my data.

I'm having issues with this data row because if the inner table is too big to fit on the page, it moves the entire table to the next page, leaving only the header row on the first page and a ton of blank space. From there, it will then cut itself correctly if it's still too big for one page. Is there a way to force the paging logic to look inside a table row to page, before it just puts it on another?

I've tried setting KeepTogether = true on the outer table and KeepTogether = false on the inner one, but it still doesn't work.  Any help would be really appreciated because I may have to consider other reporting alternatives if I can't get this format working.

Thanks!
Peter
Telerik team
 answered on 01 Sep 2011
1 answer
346 views
I have a multi-value report parameter generated from a SQL query.  The values are retrieved from the database table and listed in a drop-down list.  I have a textbox on the report that should display the selected value(s); however, its' not working.  How do I display the selected value(s) inside that textbox?  The textbox is displaying system.object[].

Thanks,
Rob
Peter
Telerik team
 answered on 31 Aug 2011
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?