Telerik Forums
Reporting Forum
1 answer
202 views
I have a telerik report designed as follows. - Windows Forms

The detail section has a number of sub reports (4 in this case)  which are bound by lists. 
Some sub reports are visible or not visible depending on data. The detail section is being rendered in one page and in case, there is less data in sub reports
there is a lot of space left beneath it . The section goes into new page again for next data.

I am not able to change the keep together property of detail section. It is kept to true and says that I have to enable docking to make it false.
I have changed the sub report detail section's  keep together to false but it doesnt work. 

Any help appreciated. Thanks

HN

Stef
Telerik team
 answered on 13 Aug 2014
2 answers
135 views
Hi! 
I would like to know if we can create custom reports with Telerik reporting. For example the user will choose the columns on the fly, the group by and the sort and when he is done, a Telerik report will comes up. Is it possible without creating a template for each report?
Stef
Telerik team
 answered on 12 Aug 2014
11 answers
1.2K+ views
Hello I have a problem when I deploy my website but when I run in localhost it's didn't have a problem.

Error is show in picture "capture002.png"

I use MySql as database.

My code on "web.config" is

<?xml version="1.0"?>
<configuration>
    <connectionStrings>
        <add name="timesheet" connectionString="server=localhost;User Id=xx;password=xxxxxxxxxx;Persist Security Info=True;database=testDB" providerName="MySql.Data.MySqlClient"/>
    </connectionStrings>
    <appSettings>
        <add key="Telerik.ScriptManager.TelerikCdn" value="Disabled"/>
        <add key="Telerik.StyleSheetManager.TelerikCdn" value="Disabled"/>
    </appSettings>
    <system.web>
    <customErrors mode="Off"/>
    <compilation debug="true" strict="false" explicit="true" targetFramework="4.0">
            <assemblies>
                <add assembly="Microsoft.ReportViewer.WebForms, Version=10.0.0.0, Culture=neutral, PublicKeyToken=B03F5F7F11D50A3A"/>
                <add assembly="Microsoft.ReportViewer.Common, Version=10.0.0.0, Culture=neutral, PublicKeyToken=B03F5F7F11D50A3A"/>
                <add assembly="Microsoft.Build.Framework, Version=4.0.0.0, Culture=neutral, PublicKeyToken=B03F5F7F11D50A3A"/>
                <add assembly="System.Management, Version=4.0.0.0, Culture=neutral, PublicKeyToken=B03F5F7F11D50A3A"/>
                <add assembly="Telerik.ReportViewer.WebForms, Version=4.2.10.1110, Culture=neutral, PublicKeyToken=A9D7983DFCC261BE"/>
                <add assembly="Telerik.Reporting, Version=4.2.10.1110, Culture=neutral, PublicKeyToken=A9D7983DFCC261BE"/>
                <add assembly="System.Design, Version=4.0.0.0, Culture=neutral, PublicKeyToken=B03F5F7F11D50A3A"/>
            </assemblies>
            <buildProviders>
                <add extension=".rdlc" type="Microsoft.Reporting.RdlBuildProvider, Microsoft.ReportViewer.WebForms, Version=10.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"/>
            </buildProviders>
        </compilation>
        <pages>
            <controls>
                <add tagPrefix="telerik" namespace="Telerik.Web.UI" assembly="Telerik.Web.UI"/>
            </controls>
        </pages>
        <httpHandlers>
            <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="Reserved.ReportViewerWebControl.axd" verb="*" type="Microsoft.Reporting.WebForms.HttpHandler, Microsoft.ReportViewer.WebForms, Version=10.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" validate="false"/>
            <add path="Telerik.ReportViewer.axd" verb="*" type="Telerik.ReportViewer.WebForms.HttpHandler, Telerik.ReportViewer.WebForms, Version=4.2.10.1110, Culture=neutral, PublicKeyToken=a9d7983dfcc261be" validate="true"/>
        </httpHandlers>
        <httpModules>
            <add name="RadUploadModule" type="Telerik.Web.UI.RadUploadHttpModule"/>
            <add name="RadCompression" type="Telerik.Web.UI.RadCompression"/>
        </httpModules>
    </system.web>
    <system.webServer>
        <validation validateIntegratedModeConfiguration="false"/>
        <modules runAllManagedModulesForAllRequests="true">
            <remove name="RadUploadModule"/>
            <add name="RadUploadModule" type="Telerik.Web.UI.RadUploadHttpModule" preCondition="integratedMode"/>
            <remove name="RadCompression"/>
            <add name="RadCompression" type="Telerik.Web.UI.RadCompression" preCondition="integratedMode"/>
        </modules>
        <handlers>
            <remove name="ChartImage_axd"/>
            <add name="ChartImage_axd" path="ChartImage.axd" type="Telerik.Web.UI.ChartHttpHandler" verb="*" preCondition="integratedMode"/>
            <remove name="Telerik_Web_UI_SpellCheckHandler_axd"/>
            <add name="Telerik_Web_UI_SpellCheckHandler_axd" path="Telerik.Web.UI.SpellCheckHandler.axd" type="Telerik.Web.UI.SpellCheckHandler" verb="*" preCondition="integratedMode"/>
            <remove name="Telerik_Web_UI_DialogHandler_aspx"/>
            <add name="Telerik_Web_UI_DialogHandler_aspx" path="Telerik.Web.UI.DialogHandler.aspx" type="Telerik.Web.UI.DialogHandler" verb="*" preCondition="integratedMode"/>
            <remove name="Telerik_RadUploadProgressHandler_ashx"/>
            <add name="Telerik_RadUploadProgressHandler_ashx" path="Telerik.RadUploadProgressHandler.ashx" type="Telerik.Web.UI.RadUploadProgressHandler" verb="*" preCondition="integratedMode"/>
            <remove name="Telerik_Web_UI_WebResource_axd"/>
            <add name="Telerik_Web_UI_WebResource_axd" path="Telerik.Web.UI.WebResource.axd" type="Telerik.Web.UI.WebResource" verb="*" preCondition="integratedMode"/>
            <add name="ReportViewerWebControlHandler" preCondition="integratedMode" verb="*" path="Reserved.ReportViewerWebControl.axd" type="Microsoft.Reporting.WebForms.HttpHandler, Microsoft.ReportViewer.WebForms, Version=10.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"/>
            <add name="Telerik.ReportViewer.axd_*" path="Telerik.ReportViewer.axd" verb="*" type="Telerik.ReportViewer.WebForms.HttpHandler, Telerik.ReportViewer.WebForms, Version=4.2.10.1110, Culture=neutral, PublicKeyToken=a9d7983dfcc261be" preCondition="integratedMode"/>
        </handlers>
    </system.webServer>
</configuration>


If you want any information to analyse this problem please tell me.

Thank you for help,
Jo
Stef
Telerik team
 answered on 11 Aug 2014
6 answers
829 views
Hi,
      I want to create textboxes dynamically at runtime.In my application the number of columns returned from database is not fixed. So I have to create that number of textboxes as the number of column returned.
      For that I have used the following code:

        Dim cntColumns As Integer
        cntColumns = ds.Tables(0).Columns.Count()-1
        Dim xaxis, yaxis As Integer
        Dim headcolumnname As String
        Dim i As Integer
        Dim headcolumnlist As Telerik.Reporting.ReportItemBase() = New          Telerik.Reporting.ReportItemBase(cntColumns) {}
        For i = 0 To cntColumns
            headcolumnname = ds.Tables(0).Columns(i).ColumnName
            headcolumnlist(i) = CreatetxtHead(headcolumnname, i)
            Dim textBox As Telerik.Reporting.TextBox =               DirectCast(headcolumnlist(i), TextBox)
            textBox.Location = New Telerik.Reporting.Drawing.PointU(New               Telerik.Reporting.Drawing.Unit(xaxis,               Telerik.Reporting.Drawing.UnitType.Inch), New               Telerik.Reporting.Drawing.Unit(yaxis,               Telerik.Reporting.Drawing.UnitType.Inch))
       textBox.Size = New SizeU(New Unit(2,     Telerik.Reporting.Drawing.UnitType.Cm), New     Telerik.Reporting.Drawing.Unit(2,     Telerik.Reporting.Drawing.UnitType.Cm))
          i += 1
          xaxis += 1
        Next
        Me.ReportHeaderSection1.Items.AddRange(headcolumnlist)
        Me.Items.Add(DirectCast(ReportHeaderSection1, ReportItemBase))


Private Function CreatetxtHead(ByVal FieldName As String, ByVal i As Integer) As Telerik.Reporting.TextBox
        Dim txtHead As New Telerik.Reporting.TextBox()
        txtHead.Value = "=[" + FieldName + "]"
        Return txtHead
    End Function

When I execute this code I am getting error 'value must be of type Telerik.Reporting.ReportItemBase' at the Me.ReportHeaderSection1.Items.AddRange(headcolumnlist) location.
         This code sample I have taken from forum. Can you please help me what error I am making?

Thanks,
Rahul
Stef
Telerik team
 answered on 11 Aug 2014
4 answers
530 views

Hello, I am new to Telerik. I want to have a button in my ASP.NET MVC web application that when clicked:

  1. executes a .trdx standalone Telerik file
  2. exports the output to a Word file

I don't know how to get started with this, what tutorial might help explain this? What sort of methods might be available? Here is my pseudo-code of what I would like to do:

string filePath = Server.MapPath("~/reportFolder/reportFile.trdx");
// I made this stuff up:
Telerik.StandaloneReport myReport = new Telerik.StandaloneReport(filePath);
myReport.executeAndPromptTheUserToSaveAs();

I have the .trdx file linked to my database, and so it is already correctly processing the report I want. Keep in mind that I don't want to embed the report in the web application in any way, I just want to "Save as..." the output of the .trdx report file when clicking a button in the application.

Ian
Top achievements
Rank 1
 answered on 08 Aug 2014
3 answers
126 views
Hello Telerik Reporting Team,

I would like to ask you to help me formatting PDF export.

Simply what I want to achieve is to let a report start to be printed only in odd numbered page.

For example,
let's say our system is trying to generate employee report in a department.
This department has 5 employees, so the report template needs to be iterated 5 times.

And each report has different length of page, let's say 1, 2, 3, 4, 5 pages for each employee.

When I export this reports, I would like to see 

PDF page1. Report for Employee1
PDF page2. Empty page
PDF page3. Report for Employee2
PDF page4. Report for Employee2
PDF page5. Report for Employee3

PDF page6. Report for Employee3
PDF page7. Report for Employee3
PDF page8. Empty page
PDF page9. Report for Employee4
PDF page10. Report for Employee4
PDF page11. Report for Employee4
PDF page12. Report for Employee4
PDF page13-17. Report for Employee5

Please advise me if any approach to handle this issue.

Thank you
Sean

Stef
Telerik team
 answered on 08 Aug 2014
2 answers
286 views
Hello guys,

I would like to create a quite simple report with a map and in these map to show several points at coordinates supplied from database. Unfortunately, I am not able to realize this task following the documentation. It just render the map extent, but without markers. I am sure that I am doing something wrong, but I found the documentation a bit confusing, for example the map extent seems to be in WGS84 coordinates, but the Projection property seems to to only the Mercator and from this comes a question in what kind of coordinates should be supplied to Latitude/Longitude properties of Series (property of Map). 

Thanks for any example or other help.

Best regards,

    Robert
Robert
Top achievements
Rank 1
 answered on 08 Aug 2014
1 answer
79 views
The code below is used to export reports programatically based on the sample in the link http://www.telerik.com/help/reporting/exporting-report-programmatically-in-silverlight.html

void serviceClient_RenderCompleted(object sender, RenderEventArgs e)
{
var result = e.RenderingResult;
if (this.file != null)
{
this.file.Write(result.DocumentBytes, 0, result.DocumentBytes.Length);
this.file.Close();
this.file.Dispose();
this.file = null;
}
}

It stopped working after a data center move, it was working before in production too. After the datacenter move the report is rendered to the UI and the report is also exported but with no data.Could you please tell me what could be the reasons.

Thanks



Stef
Telerik team
 answered on 08 Aug 2014
3 answers
139 views
Is there a way to write a custom rendering extension for Telerik Reporting?
Stef
Telerik team
 answered on 08 Aug 2014
1 answer
121 views
hi
i have a column which indicate as my date time data.
and i have two report parameter which work as start date and
End date.i want set my start date as minimum date in which stored in datetime column
and if no data stored be today date time
Thanks for wonderful suppor
Hinata
Top achievements
Rank 1
 answered on 07 Aug 2014
Top users last month
Will
Top achievements
Rank 2
Iron
Motti
Top achievements
Rank 1
Iron
Hester
Top achievements
Rank 1
Iron
Bob
Top achievements
Rank 3
Iron
Iron
Veteran
Thomas
Top achievements
Rank 2
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?