Telerik Forums
Reporting Forum
3 answers
108 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
247 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
334 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
82 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
87 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
130 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
136 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
2 answers
132 views
I want control the reportviewer's documentmap,and want change the documentmap's background .How can I do?
he seaman
Top achievements
Rank 1
 answered on 09 Nov 2011
1 answer
115 views
I've got a table built using the table wizard that seems to be trying to generate an infinite number of pages.

There's only supposed to be a little over 200 records, but when I hit the preview tab, it works until it hits an out of memory exception. I tried the HTML preview, and it will actually show me the first page of the report, which is all of the right records, but the page count keeps going up, and all of the other pages are exactly the same as the first page. The first time I didn't notice that the page count was going up, and it got up to over 1100 pages.

I've verified that my query is returning the right number of records. It seems to be just this table.

What's going on here?

Thanks
Devin
Top achievements
Rank 1
 answered on 09 Nov 2011
3 answers
224 views
I'm getting the following error trying to install reporting Q1 2011.  Here is the error:

Error-2147467259: failed to create SQL Database: AdventureWorks, error detail: Unknown error.

I do already have the AdventureWorks database.
TonyG
Top achievements
Rank 1
 answered on 08 Nov 2011
Top users last month
Simon
Top achievements
Rank 2
Iron
Iron
Bob
Top achievements
Rank 3
Iron
Iron
Veteran
Marco
Top achievements
Rank 4
Iron
Iron
Iron
Grant
Top achievements
Rank 3
Iron
Iron
Iron
Kao Hung
Top achievements
Rank 1
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?