Telerik Forums
Reporting Forum
1 answer
486 views
 dear team,
i'm trying to filter table pragmatically,
i use the below code and it is working only for equal to, how can i do the same for start with and contains operators because the below code not working for them.
do i miss something 
switch (Operator) {
                    case ("Contains"):
                        objFilter.Operator = Telerik.Reporting.FilterOperator.Like;
                        objFilter.Value = string.Format("%{0}%", FieldValue);
                        break;
                    case ("StartWith"):
                        objFilter.Operator = Telerik.Reporting.FilterOperator.Like;
                        objFilter.Value = string.Format("{0}%", FieldValue);
                        break;
                    case ("EqualTo"):
                        objFilter.Operator = Telerik.Reporting.FilterOperator.Equal;
                        objFilter.Value = string.Format("{0}", FieldValue);
                        break;
                    default:
                        objFilter.Operator = Telerik.Reporting.FilterOperator.Equal;
                        objFilter.Value = string.Format("{0}", FieldValue);
                        break;
                }
Elian
Telerik team
 answered on 31 Jul 2013
1 answer
113 views

Hi, I am new to Telerik Reporting. I used the Graph Wizard to create a clustered column graph and the labels are not aligning with the column clusters. When using a Stacked Column graph the labels would align with the columns and I did not have this problem. 


Images is attached. I have obfuscated the label names for privacy purposes 

Stef
Telerik team
 answered on 31 Jul 2013
1 answer
186 views
Hi All - 
I have a simple pie chart on a report that uses same datasource as the report. I can easily change the report datasource at runtime and all is well, but for some reason the chart throws the following (see attached). It works fine in preview in design mode, and all other reports I have bound with this method at runtime work perfectl. It is just adding the graph object I get this error. I have tried adding as subreport and just adding graph to report same issue -- it is loaded in the report footer. Here is the code I use to databind the report:

(NOTE: I am using a custom class and methods for getting data tables etc.. instantiated previously as db.)

                  Dim tbl As DataTable
                    tbl = db.GetDataTable("SELECT * FROM rpt_WholeProgram_Summary WHERE ProgramID = " & nProgramID)

                    Dim report1 As New BMETReports.WholeProgramSummary
                    report1.DataSource = tbl
       
                    '--------------- set Parameters -----------
                    'Get the Owner Name
                    Dim sOwnerName As String = db.GetSingleValue("SELECT IsNull(OwnerName,'owner name here') FROM Programs WHERE ProgramID = " & nProgramID)
                    report1.ReportParameters.Item("OwnerName").Value = sOwnerName
                     
                    Dim sSubtitle As String = txtSubTitle.Text
                    Dim sProgramName As String = txtProgramName.Text
                    Dim sDraft As String = " "
                    If chkMarkDraft.Checked Then
                        sDraft = "DRAFT"
                    End If
   
                    report1.ReportParameters.Item("ProgramName").Value = sProgramName
                    report1.ReportParameters.Item("SubTitle").Value = sSubtitle
                    report1.ReportParameters.Item("Draft").Value = sDraft
                    
                    '----------------------------------------------------
                        
                        
                    Dim instanceReportSource As New Telerik.Reporting.InstanceReportSource()
                    instanceReportSource.ReportDocument = report1
                    ReportViewer1.ReportSource = instanceReportSource


Steve
Top achievements
Rank 1
 answered on 30 Jul 2013
10 answers
1.4K+ views
I cannot figure out how to make the header rows of the new Telerik.Reporting.Table control repeat when the table has more rows than fit on one page?

I see my header on the page where the table first appears, but on subsequent pages only the data rows appear, not the header.

This is a very basic feature for tabular reporting.  Where are the properties to make this happen?

Hadib Ahmabi
Top achievements
Rank 1
 answered on 30 Jul 2013
5 answers
223 views
Hi Pals,

           I am getting problem with Telerik Sub report  problem in ASP.NET.
My Requirement is I need to pass the data to Main Report and Sub report From ASP.NET Webpage Code Be-hind Page.
right now I am passing the data to Main report from the code... need to pass data to sub report from the code itself.
Please help in this issue.

Thanks in advance.


Stef
Telerik team
 answered on 30 Jul 2013
1 answer
142 views
I have used information from a related question to develop a report that lists serial numbers in a multiple column format, as shown in the attached picture.  (I must use the crosstab instead of a multicolumn report because this will be a subreport.)

In the example in the attached output picture you can see that I want 4 columns of data, but I only have 10 items, so there are two empty slots.  If the 4th and 8th items shifted up a row, the order would be correct.  I have tried adding sorting to the groups, but it doesn't seem to help.

I have attached a picture of my report design, and my datasource is a simple query:
select serial_number, ROW_NUMBER() OVER(ORDER BY serial_number) as RowNum
from myTable
order by RowNum

What am I doing wrong?  How can I control the sorted order of the output?  I prefer to sort by row (e.g. row1: a b c d, row2: e f g h)

I am using Telerik Reporting Q3 2012.
Hadib Ahmabi
Top achievements
Rank 1
 answered on 30 Jul 2013
1 answer
83 views
We're doing some testing on Telerik Reporting Q2 2013 for compatibility with our current reports. First we're using a small function for getting the report on the enter button within textboxes.

function SubmitIt(sender, args) {<br>
  var c = args.get_keyCode();<br>
   if (c == 13) {<br>
  $get('<%=btnGetReport.ClientID %>').click();
  }
 }



What we're seeing in the code behind is that whatever radtextbox your cursor is in and is being edited is not being sent to the code behind one the first enter click. However on the second it is. Thus it always stays a enter stroke behind, unless you leave the radtextbox by physically click the get report button.

Hast anyone else seen this issue?
Hadib Ahmabi
Top achievements
Rank 1
 answered on 30 Jul 2013
2 answers
76 views
Hi Team,

    When we try to fetch records over 75000 and try to export into pdf(all is in programmatically no reportviewer used) then resportservice send us a exception saying this "Cannot set new clip region in an inner graphic state level."  .We don't understand why it is giving such error.Is it for out of memory problem? Please Tell us a solution.Client needs it desparately.

Thanks
S
Tejaswee
Top achievements
Rank 1
 answered on 30 Jul 2013
4 answers
105 views
I'm having a problem with my report and so far i have not been able to debug it at all. I've set debug points on my data source but it just does not hit any of them. The report seems to have broken after i enabled SQL session state. I have a webviewer set to display the report and it is returning this instead. 

HTTP/1.1 200 OK
Cache-Control: private
Content-Length: 1692
Content-Type: text/html; charset=utf-8
Server: Microsoft-IIS/7.5
X-AspNet-Version: 4.0.30319
X-Powered-By: ASP.NET
Date: Mon, 22 Jul 2013 23:23:11 GMT

<html>
<head>
<link rel="stylesheet" type="text/css" href="/mysite/Telerik.ReportViewer.axd?name=Resources.ParametersArea.css&amp;optype=Resource&amp;version=6.0.12.215" />
</head><body style="margin:0;padding:0;background-color:white;">
<form name="mainForm" method="post" action="Telerik.ReportViewer.axd?instanceID=3f7311afc6d84ca6ae6a67c924abbd0b&amp;optype=Parameters&amp;bgColor=white" id="mainForm" onclick="FormClick();" style="width:100%;border-width:0px;padding:0px;margin:0px;">
<div>
<input type="hidden" name="__VIEWSTATE" id="__VIEWSTATE" value="/wEPDwUBMA9kFgJmDxYEHgdvbmNsaWNrBQxGb3JtQ2xpY2soKTseBXN0eWxlBTN3aWR0aDoxMDAlO2JvcmRlci13aWR0aDowcHg7cGFkZGluZzowcHg7bWFyZ2luOjBweDsWAmYPZBYCZg9kFgRmD2QWAmYPDxYEHgVXaWR0aBsAAAAAAABZQAcAAAAeBF8hU0ICgAJkZAIBD2QWAmYPDxYEHwIbAAAAAAAAWUAHAAAAHwMCgAJkZGRlmxY10PAf8eqiqtIji5qJxpZjvg==" />
</div>


<script src="/mysite/Telerik.ReportViewer.axd?name=Resources.Parameters.js&amp;optype=Resource&amp;version=6.0.12.215" type="text/javascript"></script><div id="ParametersDiv"><table id="parametersTable" cellspacing="0" cellpadding="0" border="0" style="width:100%;border-collapse:collapse;">
<tr style="height:2px;">
<td style="width:100%;"></td>
</tr><tr id="parametersRow">
<td id="editorsCell" style="width:100%;"><table id="editorsTable" cellspacing="0" cellpadding="0" border="0" style="width:100%;border-collapse:collapse;">

</table></td>
</tr>
</table></div></form>
</body>
</html><script type="text/javascript">
var ParametersPage = new ParametersPage(null, 'init', false, false, false, '', '<br />Object reference not set to an instance of an object.');
</script>

Elian
Telerik team
 answered on 30 Jul 2013
1 answer
89 views
Hello I'm looking for a way to group my data, and would like to know if it is possible to do.

It is possible for one record to exist multiple groups, and I would like to display this somehow.

Ex: Records:

AccountId - DimensionId - DimValue

Account1 - Dimension1 - 000
Account1 - Dimension2 - 213
Account1 - Dimension3 - 390

Account2 - Dimension1 - 000
Account2 - Dimension2 - 240
Account2 - Dimension3 - 300

Account3 - Dimension1 - 000
Account3 - Dimension2 - 240
Account3 - Dimension3 - 290

Account4 - Dimension1 - 000
Account4 - Dimension2 - 240
Account4 - Dimension3 - 610

Account5 - Dimension1 - 000
Account5 - Dimension2 - 240
Account5 - Dimension3 - 610

I want my report to display something like this:

000
213
390
Account1
390
213

240
300
Account2
300

590
Account3
590

610
Account4
Account5
610
240
000

Is this possible
Elian
Telerik team
 answered on 29 Jul 2013
Top users last month
Rob
Top achievements
Rank 3
Iron
Iron
Iron
Atul
Top achievements
Rank 1
Iron
Iron
Iron
Alexander
Top achievements
Rank 1
Veteran
Iron
Serkan
Top achievements
Rank 1
Iron
Shawn
Top achievements
Rank 1
Iron
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?