Questions on Reporting Forum

2 answers

86 views

I am using Linq to SQL to populate generic non LINQ classes to display report data. I created a method to return a List<T> of the class to the Report Datasource in the report constructor. I also have a subreport in the details section of my report where I want to populate with data related to each line item of the main report. The problem is the NeedDataSource is only called once and results in the first line item contains nothing in the subreport and every line item after that has data from the first line item.

My question is, how do I get a subreport in the details section to contain data related to its containing line item?

General Discussions

answered on 23 Jun 2009

1 answer

201 views

Extract MS Word OLE object from SQL Server BLOB

Hi,

I would like to migrate some complex reports from Crystal to telerik. But one feature gives me a headache.
We have created hundreds of text modules containing preformatted text with MS Word and stored them in a BLOB column as OLE Object. Crystal ist able to extract those OLE objects and renders them to display them in the report.
Can this also be done with telerik?

Best Regards,
Stefan

General Discussions

answered on 23 Jun 2009

5 answers

175 views

Passing Parameters - breaks on the server

After struggling with passing in parameters for several days, I finally got it to work perfectly when on my local machine. However, when I deploy it to the server, it doesn't seem to passing the parameter correctly. No data appears in the report. This is how I'm passing in the parameter from my aspx page. (SummaryReport is the name of my Report.) Is there a reason that this would work locally, but not on the server? Help, I'm so frustrated!

Dim RID As Integer

RID = Request.QueryString("RID")

Dim Report As Telerik.Reporting.Report

Report =

New SummaryReport

Report.ReportParameters(0).Value = RID

Me.ReportViewer1.Report = Report

General Discussions

answered on 23 Jun 2009

1 answer

67 views

from filtered grid to report

hi

I am trying to create the following web app scenario, my user on a web page plays around with a linq based grid , filtering, ordering etc, then they choose to run a report based on the records they have in the grid.

Any good example(s) of sending in the resultant linq data set to a telerik report to produce this

thanks
kevin

General Discussions

answered on 23 Jun 2009

1 answer

75 views

Visual Studio 2008 Report Editor strange behavior with the keyboard

Hello again Telerik friends,

I have a strange situation going on when creating reports with the Editor for VS2008... But first thing first, my system config:

Telerik Reporting 2008 Q2

Windows XP - English

Keyboard config - Portuguese.

Now, when I open an editor tab in the VS2008, my keyboard goes mad, and starts to write non accentuated char, by example, when I try to write an á the output in the screen is ´´a ... but more strange than that is that all the applications I try to write that char, the output will be always the wrong one. When I close that tab, the output becomes to be the expected... odd no? Any thoughts about that?

Note, that I don't have any viruses, or any kind of malicious soft in my machine, thats for sure. This only happens when I open the Editor tab in VS2008 IDE.

Can you help me?

Thanks in advance.

Regards,

Sandro Martins

General Discussions

answered on 22 Jun 2009

3 answers

512 views

Works in VS and not in IIS 7

I have a reportviewer that displays some reports on an .aspx page. When I serve these pages with Visual Studio everything runs as it should. Report displays on the page fine.
However, when I go to serve the pages with IIS 7, I get the following error : "Cannot create an object of type 'Telerik.Reporting.IReportDocument' from its string representation 'ReportingLib.Sales, ReportingLib, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null' for the 'Report' property". "ReportingLib" is the class library where my reports exist. Following info seems to be relevant here.
1)I have all of the telerik trial version dlls installed in the gac on the machine as well as in the web applications bin directory. 2) On the page with the report viewer I have the below code. Also below is my web.config. Note I have placed httphandler sections with relevant info in both the <system.web> and <system.webserver> sections of the web.config(as given in a previous post on the forum). I have tinkered with my web.config settings quite a bit believing this maybe where the issue is. If I eliminate the <validation validateIntegratedModeConfiguration="false"> for the <system.webServer> node IIS7 comes back with an error

HTTP Error 500.23 - Internal Server Error

An ASP.NET setting has been detected that does not apply in Integrated managed pipeline mode.

Can anyone tell me is there something i need to tell iis7 in my web.config or is there a better way to troubleshoot this?

Jason

<?
 
xml version="1.0"?>
 
<!--
 
Note: As an alternative to hand editing this file you can use the 
web admin tool to configure settings for your application. Use
the Website->Asp.Net Configuration option in Visual Studio.
A full list of settings and comments can be found in 
machine.config.comments usually located in 
\Windows\Microsoft.Net\Framework\v2.x\Config 
-->
<
 
configuration xmlns="http://schemas.microsoft.com/.NetConfiguration/v2.0">
 
<
 
appSettings/>
 
<
 
connectionStrings>
 
<
 
remove name="LocalSqlServer"/>
 
<
 
add name="connSomsys" connectionString="Data Source=CMDIVST004\JASON08;Initial Catalog=QuoteDB;Persist Security Info=True;User ID=ggggg;Password=ggggg" providerName="System.Data.SqlClient"/>
 
</
 
connectionStrings>
 
<!--
 
 <compilation debug="false" />
 
<customErrors mode="RemoteOnly" defaultRedirect="GenericErrorPage.htm">
<error statusCode="403" redirect="NoAccess.htm" />
<error statusCode="404" redirect="FileNotFound.htm" />
</customErrors>
 
-->
 
<
 
system.web>
 
<
 
httpHandlers>
 
<
 
add path="Reserved.ReportViewerWebControl.axd" verb="*" type="Microsoft.Reporting.WebForms.HttpHandler, Microsoft.ReportViewer.WebForms, Version=9.0.0.0, Culture=neutral, PublicKeyToken=B03F5F7F11D50A3A" validate="false"/>
 
<
 
add path="Telerik.ReportViewer.axd" verb="*" type="Telerik.ReportViewer.WebForms.HttpHandler, Telerik.ReportViewer.WebForms, Version=3.0.9.430, Culture=neutral, PublicKeyToken=a9d7983dfcc261be" validate="true"/>
 
</
 
httpHandlers>
 
<
 
httpRuntime maxRequestLength="512000"/>
 
<
 
compilation defaultLanguage="c#">
 
<
 
assemblies>
 
<
 
add assembly="MonoSoftware.Web.TextBox, Version=1.0.0.0, Culture=neutral, PublicKeyToken=FAF3283597AC56FF"/>
 
<
 
add assembly="System.Design, Version=2.0.0.0, Culture=neutral, PublicKeyToken=B03F5F7F11D50A3A"/>
 
<
 
add assembly="System.Windows.Forms, Version=2.0.0.0, Culture=neutral, PublicKeyToken=B77A5C561934E089"/>
 
<
 
add assembly="Xheo.Licensing, Version=2.1.5000.0, Culture=neutral, PublicKeyToken=798276055709C98A"/>
 
<
 
add assembly="MonoSoftware.Web.DynamicPopUp, Version=1.5.0.0, Culture=neutral, PublicKeyToken=FAF3283597AC56FF"/>
 
<
 
add assembly="MonoSoftware.Web.Helper, Version=1.0.3300.0, Culture=neutral, PublicKeyToken=FAF3283597AC56FF"/>
 
<
 
add assembly="System, Version=1.0.3300.0, Culture=neutral, PublicKeyToken=B77A5C561934E089"/>
 
<
 
add assembly="System.Web, Version=1.0.3300.0, Culture=neutral, PublicKeyToken=B03F5F7F11D50A3A"/>
 
<
 
add assembly="MonoSoftware.Web.Calculator, Version=1.0.0.0, Culture=neutral, PublicKeyToken=FAF3283597AC56FF"/>
 
<
 
add assembly="Office, Version=11.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c"/>
 
<
 
add assembly="Microsoft.ReportViewer.WebForms, Version=9.0.0.0, Culture=neutral, PublicKeyToken=B03F5F7F11D50A3A"/>
 
<
 
add assembly="Microsoft.ReportViewer.Common, Version=9.0.0.0, Culture=neutral, PublicKeyToken=B03F5F7F11D50A3A"/>
 
<
 
add assembly="Telerik.ReportViewer.WebForms, Version=3.0.9.430, Culture=neutral, PublicKeyToken=A9D7983DFCC261BE"/>
 
<
 
add assembly="Telerik.Reporting.Processing, Version=3.0.9.430, Culture=neutral, PublicKeyToken=A9D7983DFCC261BE"/>
 
<
 
add assembly="Telerik.Reporting, Version=3.0.9.430, Culture=neutral, PublicKeyToken=A9D7983DFCC261BE"/>
 
<
 
add assembly="Telerik.Reporting.Interfaces, Version=3.0.9.430, Culture=neutral, PublicKeyToken=A9D7983DFCC261BE"/>
 
<
 
add assembly="Telerik.Reporting.HtmlEngine, Version=1.0.0.0, Culture=neutral, PublicKeyToken=a9d7983dfcc261be"/>
 
<
 
add assembly="Telerik.Reporting.Design, Version=3.0.9.430, Culture=neutral, PublicKeyToken=A9D7983DFCC261BE"/>
 
<
 
add assembly="Telerik.ReportViewer.Design, Version=3.0.9.430, Culture=neutral, PublicKeyToken=A9D7983DFCC261BE"/>
 
<
 
add assembly="Telerik.ReportViewer.WinForms, Version=3.0.9.430, Culture=neutral, PublicKeyToken=A9D7983DFCC261BE"/>
 
<
 
add assembly="ReportingLib, Version=1.0.0.0, Culture=neutral"/>
 
</
 
assemblies>
 
<
 
buildProviders>
 
<
 
add extension=".rdlc" type="Microsoft.Reporting.RdlBuildProvider, Microsoft.ReportViewer.Common, Version=9.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"/>
 
</
 
buildProviders>
 
</
 
compilation>
 
<
 
sessionState timeout="45"/>
 
<
 
authentication mode="Forms">
 
<
 
forms timeout="300"/>
 
</
 
authentication>
 
<
 
authorization>
 
<
 
deny users="?"/>
 
</
 
authorization>
 
</
 
system.web>
 
<!--
 
 allow users to access these directories/pages/files without logging in-->
 
<
 
location path="loginhelp.aspx">
 
<
 
system.web>
 
<
 
authorization>
 
<
 
allow users="?"/>
 
</
 
authorization>
 
<
 
compilation debug="true"/>
 
</
 
system.web>
 
</
 
location>
 
<
 
system.webServer>
 
<
 
validation validateIntegratedModeConfiguration="false"/>
 
<
 
defaultDocument>
 
<
 
files>
 
<
 
clear/>
 
<
 
add value="default_loc.aspx"/>
 
<
 
add value="default.aspx"/>
 
</
 
files>
 
</
 
defaultDocument>
 
<
 
handlers>
 
<
 
add name="Telerik.ReportViewer.axd_*" path="Telerik.ReportViewer.axd" verb="*" type="Telerik.ReportViewer.WebForms.HttpHandler, Telerik.ReportViewer.WebForms, Version=3.0.9.430, Culture=neutral, PublicKeyToken=a9d7983dfcc261be" preCondition="integratedMode,runtimeVersionv2.0"/>
 
</
 
handlers>
 
</
 
system.webServer>
 
</
 
configuration>

------------------------------------------------------------------------------------------------------------------------
 
            <%@ Page Language="C#" AutoEventWireup="true" CodeFile="chart.aspx.cs" Inherits="reporting_chart" %> 
        
            <%@ Register Assembly="Telerik.ReportViewer.WebForms, Version=3.0.9.430, Culture=neutral, PublicKeyToken=a9d7983dfcc261be" 
        
                Namespace="Telerik.ReportViewer.WebForms" TagPrefix="telerik" %> 
        
            <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> 
        
            <html xmlns="http://www.w3.org/1999/xhtml">  
        
            <head runat="server">  
        
                <title></title>  
        
            </head> 
        
            <body> 
        
                <form id="form1" runat="server">  
        
                <div> 
        
                    <h3>Header</h3> 
        
                <telerik:ReportViewer ID="ReportViewer1" runat="server" Height="482px"   
        
                        Report="ReportingLib.Summary, ReportingLib, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null"   
        
                        Width="686px">  
        
                    </telerik:ReportViewer> 
        
                </div> 
        
                </form> 
        
            </body> 
        
            </html> 
        
             --------------------------------------------------------------------------------------------------------------------

General Discussions

answered on 22 Jun 2009

1 answer

92 views

"An error occurred while processing report": A column named resource_name is already belongs to this datatable.

Hi,

I am able to display report on the report viewer but when i am trying to print or exporting to either pdf or excel or any...... I am getting the following error:

"An error occurred while processing report": A column named resource_name is already belongs to this datatable.

Dynamically i created a datatable and attached to this report.

Thanks.

Regards

Syed Arshad

General Discussions

answered on 22 Jun 2009

5 answers

488 views

Passing parameter to sub report to sort

I have to pass two parameters to subreport one is username and the other is sortby(column name will be entered by user). I am able to filter the data based on the selected username but I am not able to sort based on the parameter entered by the user(only the default value given in the report parameter for sort is getting sorted). I guess the sort parameter is not getting passed to the sub report.
Also my doubt is when I select any username will the sort option be applied to the entire report data or only the selected username report data?

Any help will be appreciated.
Thanks

General Discussions

answered on 22 Jun 2009

1 answer

68 views

Report Page

hi

i created one report in my web application.

I have to show 12 fields in report so when i was show that filed the report is expanded.I cant show all the value sin report viewr
if i generate as pdf some fiedls missing

string

mimeType = string.Empty;

string ext = string.Empty;

Encoding encoding = Encoding.Default;

byte[] reportBytes = Telerik.Reporting.Processing.ReportProcessor.Render(

"PDF"

, reportToExport

,

null

,

out mimeType

,

out ext

,

out encoding);

string fileName = reportName + ".pdf";

Response.Clear();

Response.ContentType = mimeType;

Response.Cache.SetCacheability(

HttpCacheability.Private);

Response.Expires = -1;

Response.Buffer =

false;

Response.AddHeader(

"Content-Disposition",

string.Format("{0};FileName=\"{1}\"",

"attachment",

fileName));

Response.OutputStream.Write(reportBytes, 0, reportBytes.Length);

Response.End();

PDF is generated but Recodr is not coming fully
how to solv this prob

Regards

Abdul Ajees

General Discussions

answered on 22 Jun 2009

4 answers

82 views

Giving a report wizard to the client

Hi, I'm new to telerik reporting and I admit that I have never tried this before.
I'm looking for an answer if my scenario is possible with telerik reporting:

I want to have an engine for displaying report that I will include in my web app for the client (one institution) with a couple of predefined reports. However, the requirement is that those reports will need to be flexible and the client should be able to modify them and create others. So, it seems like I would like to have a component that would be able to run a wizard on the installed app and let the business admin generate report templates that he will place on the site, so that the users can take advantage of them. Everything without visual studio. Is this scenario possible? - I doubt, but it doesn't hurt to ask. If no? is there any other way to include new reports on the site by my client themselves without the need of recompiling ?

thanks

General Discussions

answered on 22 Jun 2009