Telerik Forums
Reporting Forum
2 answers
588 views
Hello,

when i'm in a asp.net website i can loop through all the controls with

(foreach Control c in this.Controls)

Is this is also possible in telerik report to loop through all the controls?

kind regards,

Jonam
Steve
Telerik team
 answered on 11 Nov 2011
1 answer
134 views
I've used the conditional expression in the past (=RowNumber()%2) to highlight every other row in a table with no problems. With grouping, especially when some rows are filtered the highlighting is weird at best. Multiple consecutive rows that are the same color etc...

How can I get around this issue?
Stuart Hemming
Top achievements
Rank 2
 answered on 10 Nov 2011
2 answers
108 views
I'm creating a report to use as a service order print out for my companies software. For some of the reports the customers need to have custom fields and such designed by them. We built a custom designer, and using those fields, rebuilding custom portion into the report. I was printing out a page to use as a reference as I fix some alignment issues, and I notice none of the custom fields are printing. I currently have them set up as a sub report on a master report and seemed to work with the report viewer, but nothing else.

The first attachment  Page4ReportViewer.png is what the viewer is showing currently in my application.
The second attachment Page4WhenSavedAsPDF.png is what the pdf version and printed version will resemble.
Jacob
Top achievements
Rank 1
 answered on 10 Nov 2011
3 answers
79 views
Hello everybody,

I have a single report who displaying tables from different SqlDataSource and everything works fine.

I want to add a bar chart displaying data from an other SqlDataSource ( stored procedure ) in the same scope.

Here is my stored procedure return :

ID        Name

1        Hello
2        Hello
3        Bye
4        Hello
5        Bye    
6        Hi

I want my chart to display data like this :
- One bar by name (distinct)
- The value is the count of the repetition

Example :
bar "Hello" => value = 3
bar "Bye" => value = 2
bar "Hi" => value = 1

I am trying to solve my problem since few days, without the expected result

PS : i cannot modify the stored procedure

Thanks a lot, Kevin.
Elian
Telerik team
 answered on 10 Nov 2011
1 answer
205 views
I created a project using telerik reporting (trial version). I created a Class Library - the application name is QuotationReportClassLibrary - It has one report - Specific Quote.

I am able to preview it.

I use IronSpeed for my asp.net web application.

I copied QuotationReportClassLibrary.dll to the \bin directory of my IronSpeed project.

I also added the following lines to the IronSpeed web.config file -
<add assembly="Telerik.ReportViewer.WebForms, Version=5.1.11.928, Culture=neutral, PublicKeyToken=A9D7983DFCC261BE"/>
        <add assembly="Telerik.Reporting, Version=5.1.11.928, Culture=neutral, PublicKeyToken=A9D7983DFCC261BE"/>
        <add assembly="System.Design, Version=2.0.0.0, Culture=neutral, PublicKeyToken=B03F5F7F11D50A3A"/>

I created an empty page in IronSpeed - and added the following -

<telerik:reportviewer id="ReportViewer1" report="QuotationReportClassLibrary.SpecificQuote, QuotationReportClassLibrary, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null" runat="server" style="border:1px solid #ccc;" width="800px" height="1000px"/>

Also the following registration code -

<%@ Register assembly="Telerik.ReportViewer.WebForms, Version=5.1.11.928, Culture=neutral, PublicKeyToken=a9d7983dfcc261be" namespace="Telerik.ReportViewer.WebForms" tagprefix="telerik" %>

I am able to run the report successfully.

However I want to specify the report in code behind - like 

Dim fs As New QuotationReportClassLibrary.SpecificQuote()

But I get a compile time error - the QuotationReportClassLibrary is not found.

What must I do to rectify my error?


Massimiliano Bassili
Top achievements
Rank 1
 answered on 10 Nov 2011
5 answers
282 views
Please help me with buttlet spacing in my report on the HtmlTextBox i add my connction from sqldatabase. At the bottom of the report the report don't show right
Attach capture1 is the code copy out of sql database and paste in your Edit Expression
Attach capture2 is the review when i get the data from sqldatabase

please help to get this right

IvanDT
Telerik team
 answered on 10 Nov 2011
1 answer
57 views
Hi,
    I have, on my webpage, a telerik report and a ajax pane that the user can select certain paramteres to update the data in the report. If I remove the ajax UpdatePanel on the pane, when the btton is pressed the data on the report is updated. However, if I leave the ajax UpdatePanel on the pane and the user clicks the button, the code behind function is catched and the code executed but the report is not updated. It's as if the ajax panel is not allowing the report to referesh. Any ideas?
Elian
Telerik team
 answered on 09 Nov 2011
1 answer
61 views
Hi, 
   We know that Telerik Report reside on the server which means that the data should be available on the server. In my project, the client generate the data ( the type is ObservableCollection<T>), it needs to display by the format of report.  So  my problem that can the client create a self-host reporting service, it needn't transmit the big data to the server.
     thanks a lot 
     jeremy
Elian
Telerik team
 answered on 09 Nov 2011
1 answer
89 views
Hello
This is my code to input data into a table on the report.
The table is linked to a objectdatasource with the same columns
When i bind to the report none of my data comes through

private void monthlyservicesales_NeedDataSource(object sender, EventArgs e)
       {
           var report = (Telerik.Reporting.Processing.Report)sender;
 
           using (var mySql = new MySQL(App.ConnString))
           {
               var data =
                   mySql.QueryDataset(
                       @"SELECT servicetable.Name,count(*) as Total,0 as BWTotal
                                 FROM    axxess.axstable axstable
                                      JOIN
                                         axxess.servicetypetable servicetypetable
                                      ON (axstable.ServiceTypeId = servicetypetable.ServiceTypeId)
                                      join axxess.servicetable ON servicetypetable.ServiceId = axxess.servicetable.ServiceId
                                WHERE     (date_format(axstable.DateCreated,'%Y%M') =  date_format(?0,'%Y%M'))
                                        and axxess.servicetable.Name not like '%*%'
                                    Group by servicetypetable.ServiceId
                                    order by count(*) desc",
                       report.Parameters["datetime"].Value);
 
               var objectDataSource = new Telerik.Reporting.ObjectDataSource();
               objectDataSource.DataSource = data.Tables[0]; // GetData returns a DataSet with three tables
               
               report.DataSource = objectDataSource;
           }
       }
Steve
Telerik team
 answered on 09 Nov 2011
2 answers
103 views
Anyone knows how to print next student on next paper in case one student take up 1,2 or 3 pages.
Customer will use a duplex printer.

Greatefull for help.

Steve
Telerik team
 answered on 09 Nov 2011
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?