Telerik Forums
Reporting Forum
1 answer
834 views
Hi,

I moved to a new machine, and all is well except for reporting. I have removed and re-added the DLLs and References to no avail. 
The installer for reporting ran fine. I am running Visual Studio 2008, .net Framework 3.5, and the web.config entries for reporting are 

 <system.webServer>

....

 <handlers>

 ....

      <add name="Telerik.ReportViewer.axd_*" path="Telerik.ReportViewer.axd" verb="*" type="Telerik.ReportViewer.WebForms.HttpHandler, Telerik.ReportViewer.WebForms, Culture=neutral, PublicKeyToken=a9d7983dfcc261be" preCondition="integratedMode,runtimeVersionv2.0" />

    </handlers>


This project worked on another machine fine, so I am guessing there is some subtle missing piece here. all other telerik products such as RadChart, grid, etc. work fine. Thanks.
Steve
Telerik team
 answered on 05 Mar 2012
4 answers
212 views
Dear All
I create Telerik application and when I publish it to the server I found this problem : 
 the web ReportViewer looks messed up no images no toolbar 
I try to make all the checks in the documentaion but it not work and it works in my pc but for server its not work 
Server is :
OS : windows server 2008 , IIS7
I attached the photo for error and that is the web.config settings :

 

<httpHandlers>
   <remove path="*.asmx" verb="*" />
   <add path="*.asmx" verb="*" type="System.Web.Script.Services.ScriptHandlerFactory, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" validate="false" />
   <add path="*_AppService.axd" verb="*" type="System.Web.Script.Services.ScriptHandlerFactory, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" validate="false" />
   <add path="ScriptResource.axd" verb="GET,HEAD" type="System.Web.Handlers.ScriptResourceHandler, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" validate="false" />
   <add path="ChartImage.axd" verb="*" type="Telerik.Web.UI.ChartHttpHandler" validate="false" />
   <add path="Telerik.Web.UI.SpellCheckHandler.axd" verb="*" type="Telerik.Web.UI.SpellCheckHandler" validate="false" />
   <add path="Telerik.Web.UI.DialogHandler.aspx" verb="*" type="Telerik.Web.UI.DialogHandler" validate="false" />
   <add path="Telerik.RadUploadProgressHandler.ashx" verb="*" type="Telerik.Web.UI.RadUploadProgressHandler" validate="false" />
   <add path="Telerik.Web.UI.WebResource.axd" verb="*" type="Telerik.Web.UI.WebResource" validate="false" />
   <add path="Telerik.ReportViewer.axd" verb="*" type="Telerik.ReportViewer.WebForms.HttpHandler, Telerik.ReportViewer.WebForms, Version=5.3.11.1222, Culture=neutral, PublicKeyToken=a9d7983dfcc261be" validate="true" preCondition="integratedMode,runtimeVersionv2.0"/>
  
  
  
  </httpHandlers>
        <httpModules>
            <add name="ScriptModule" type="System.Web.Handlers.ScriptModule, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" />
      <!--<add name="RadUploadModule" type="Telerik.Web.UI.RadUploadHttpModule"/>
      <add name="RadCompression" type="Telerik.Web.UI.RadCompression"/>-->
        </httpModules>
and that is the header for page  (Note I am useing masterpage) :
<%@ Register assembly="Telerik.ReportViewer.WebForms, Version=5.3.11.1222, Culture=neutral, PublicKeyToken=a9d7983dfcc261be" namespace="Telerik.ReportViewer.WebForms" tagprefix="telerik" %>
  
  
   
<asp:Content ID="Content1" ContentPlaceHolderID="head" runat="server">
Mohamed
Top achievements
Rank 2
 answered on 05 Mar 2012
1 answer
1.6K+ views
Hi,

I need to put soem text eg : 'xxx' + =fields.value into a single textbox. can you please let me know how?
Ibraim
Top achievements
Rank 1
 answered on 03 Mar 2012
1 answer
54 views
This following line doesn't work because this.subReport1.Items has nothing in there.

Telerik.Reporting.

 

SubReport grandChildSubReport = this.subReport1.Items.Find("subReport2", true)[0] as Telerik.Reporting.SubReport;

Please help

Thanks

 

SHANE
Top achievements
Rank 1
 answered on 02 Mar 2012
6 answers
288 views
I've installed Telerik reporting just now.(actually I've installed it 3 times now, because it doesn't work.)  I can't drag the report viewer control to a .aspx page.  Why is that?  The machine next to me works fine, and the developer told me he had a very hard time getting the report configuration to actually work.  Why?  He doesn't remember what he did, but it took him a long time to actually get telerik reporting configured in VS2010.  What are the Exact steps to follow to get telerik reporting actually working?  I've followed all the documentation, which doesn't work as I just mentioned.  So, what needs to be done exactly?  Any, why isn't this posted along with the documentation? 
Jorge Sanchez
Top achievements
Rank 2
 answered on 02 Mar 2012
3 answers
735 views
New to these specific reporting controls, and that "ah ah" moment just hasn't arrived. Creating the class for a report, generating the datasource, setting up the parameters makes sense but getting it to work with parameters in designer is eluding me. I want to pass in a "begin" and "end" date for the data I pull, so I've set up the parameters in the datasource as @dtstrDate and @dtendDate, with DbType as Date and the Value as "=Parameters.startDate.Value" and "= Parameters.endDate.Value" respectively.

The query:

SELECT        w.Firstname, w.Lastname, wf.Login, wf.Logout, DATEDIFF(hour, wf.Login, wf.Logout) AS Hours
FROM            Workers AS w INNER JOIN
                       Workflow AS wf ON wf.LoggedInWorkerid = w.ID
WHERE        (wf.Login >= @dtstrtDate) AND (wf.Logout <= @dtendDate)


I've tested it in SQL Server with

DECLARE @dtstrtDate AS DateTime
SET @dtstrtDate = '02/13/2012'
DECLARE @dtendDate AS DateTime
SET @dtendDate = '02/17/2012'
 
SELECT w.Firstname, w.Lastname, SUM(DATEDIFF(hour, wf.Login, wf.Logout)) AS Hours
FROM Workers AS w JOIN Workflow AS wf ON wf.LoggedInWorkerid = w.ID
WHERE wf.Login >= @dtstrtDate AND wf.Logout <= @dtendDate
GROUP BY w.Lastname, w.FirstName


... and it works just fine.

In the Configure DataSource Parameters
Name                   DbType                     Value
@dtstrtDate         Date                          =Parameters.startDate.Value
@dtendDate        Date                          =Parameters.endDate.Value

Design Time Parameters
Name                 Value
@dtstrtDate       =02/13/2012 (and I've tried putting these values in single quotes as well)
@dtendDate      =02/17/2012

I've tried setting the DbType to string, as well on the designer, setting the startDate and endDate members in the ReportParameter collection to DateTime and String, and even using the CDate function to wrap the Parameters.startDate.Value i.e = CDate(Parameters.startDate.Value)...When I try to execute the query in the designer I get "Conversion failed when converting date/and or time from character string." What am I doing incorrectly?


Elian
Telerik team
 answered on 02 Mar 2012
1 answer
184 views
I have been reading threads about setting a subreport's datasource.   I am confused about where to set it programmatically.  Some threads show it being set after the Master report InitialComponent() event.  Some threads show it via the subrpt_NeedDataSource or Subrpt_ItemDatabaBinding within the parent report class file.  Others show it being set in the Subreport's class file in its NeedDataSource or Item Databinding event.

Could someone please tell me where to set the subreport datasource?

Elian
Telerik team
 answered on 02 Mar 2012
1 answer
302 views
hi

been wondering if i can use a dictionary of the format dictionary<string,list<sqlToLinqClass>> as the datasource id so how can i retrive the values from the list.. or there is a better method..

Regards
Saneesh
Elian
Telerik team
 answered on 02 Mar 2012
7 answers
555 views
Dear All ,
Hi
I want to Show More Then One Records Details In Single Report Viewer?
Like this way

Record 1                                                                                Record 2
ASHOK ENTERPRISE   ASHOK ENTERPRISE  
  DATE : 12/1/2011   DATE : 12/1/2011
ANAN BUILDERS   ANAN BUILDERS  
       
PAYMENT IS DUE AS PER UNDERMENTIONED PAYMENT IS DUE AS PER UNDERMENTIONED
BILLS, SO PLEASE MAKE THE PAYMENT SOON. BILLS, SO PLEASE MAKE THE PAYMENT SOON.
       
BILL NO. DATE AMOUNT Rs. BILL NO. DATE AMOUNT Rs.
       
150 6/30/2011 5000 150 6/30/2011 5000
175 7/31/2011 5500 175 7/31/2011 5500
200 8/31/2011 5500 200 8/31/2011 5500
225 9/30/2011 5000 225 9/30/2011 5000
250 10/31/2011 5500 250 10/31/2011 5500
300 11/30/2011 5000 300 11/30/2011 5000
       
  TOTAL RS. 31500   TOTAL RS. 31500

Thanks in advanse..
Elian
Telerik team
 answered on 02 Mar 2012
2 answers
144 views
hi i create dynamic report from the follwing code
all fine the pbm is when i export the report got problem
when i export report to xls the header is totally black
if i export the reportt to csv the alignment and header is repeated
if i export to pdf the header background color missing

If HttpContext.Current.Session("DynamicReportDatas") IsNot Nothing Then
 
           Dim datas As DataTable = HttpContext.Current.Session("DynamicReportDatas")
           Me.Table1.DataSource = datas
 
           Dim textboxGroup As Telerik.Reporting.HtmlTextBox
           Dim textBoxTable As Telerik.Reporting.HtmlTextBox
           Table1.ColumnGroups.Clear()
           Table1.Body.Columns.Clear()
           Table1.Body.Rows.Clear()
           Dim ColCount As Integer = datas.Columns.Count
           For i As Integer = 0 To ColCount - 1
 
 
               Dim tableGroupColumn As New Telerik.Reporting.TableGroup()
               Table1.ColumnGroups.Add(tableGroupColumn)
               'table1.Body.Columns.Add(new Telerik.Reporting.TableBodyColumn(Unit.Inch(1)));
 
               textboxGroup = New Telerik.Reporting.HtmlTextBox()
               'textboxGroup.Style.BorderColor.[Default] = Color.Black
               'textboxGroup.Style.BorderStyle.[Default] = BorderType.Solid
               textboxGroup.Value = datas.Columns(i).ColumnName
               textboxGroup.Size = New SizeU(Unit.Inch(1.4), Unit.Inch(0.2))
               textboxGroup.Style.BackgroundColor = Color.FromName("#79A7E3")
               textboxGroup.Style.Font.Bold = True
               textboxGroup.Style.Font.Size = New Unit(10)
               textboxGroup.Style.VerticalAlign = VerticalAlign.Middle
               textboxGroup.Style.TextAlign = HorizontalAlign.Left
               tableGroupColumn.ReportItem = textboxGroup
 
               textBoxTable = New Telerik.Reporting.HtmlTextBox()
               'textBoxTable.Style.BorderColor.Default = Color.Black;
               'textBoxTable.Style.BorderStyle.Default = BorderType.Solid;
               textBoxTable.Value = "=Fields.[" + datas.Columns(i).ColumnName & "]"
               textBoxTable.Size = New SizeU(Unit.Inch(1.4), Unit.Inch(0.3))
               textBoxTable.Style.VerticalAlign = VerticalAlign.Middle
               textBoxTable.Style.TextAlign = HorizontalAlign.Left
 
              
 
               Table1.Body.SetCellContent(0, i, textBoxTable)
               
 
               Table1.Items.AddRange(New ReportItemBase() {textBoxTable, textboxGroup})
           Next
 
 
       End If


is there any way to create dynamic reports
cs the column name and table name is dynamic and the column count is dynamic


IvanY
Telerik team
 answered on 02 Mar 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?