Questions on Reporting Forum

1 answer

317 views

What gives?

General Discussions

answered on 01 Nov 2010

0 answers

591 views

Warning: Report is too wide to fit on a single page

Nevermind. Math helps.

General Discussions

asked on 30 Oct 2010

1 answer

165 views

Document Map not grouping

I have a report with the following grouping sections: ( groupHeaderSection1 > groupHeaderSection2 > labelsGroupHeader )
The values ot groupHeaderSection1.DocumentMapText and groupHeaderSection1.DocumentMapText have been set to different field values and display in the UI. However they are at the same level under the report entery. The expected result would be that the values would be nested in groups.
imo - The documentation on the DocumentMapText is very limited on this and could be expanded to include more detail.

General Discussions

answered on 29 Oct 2010

1 answer

143 views

Website publishing error

I am using the telerik report control. On my local machine it runs fine, but when I publish to the website using VS2008 i get this error when I am trying to run it.

Server Error in '/' Application.

--------------------------------------------------------------------------------

Configuration Error

Description: An error occurred during the processing of a configuration file required to 

service this request. Please review the specific error details below and modify your configuration 

file appropriately.

Parser Error Message: Could not load file or assembly 'Telerik.ReportViewer.WebForms, Version=4.1.10.921, 

Culture=neutral, PublicKeyToken=a9d7983dfcc261be' or one of its dependencies. 

The system cannot find the file specified. (C:\Inetpub\CEMM\web.config line 45) (C:\Inetpub\CEMM\web.config line 114)

Source Error:

Line 112: <httpModules>

Line 113: <add name="ScriptModule" type=

"System.Web.Handlers.ScriptModule, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"

/>

Line 114: <add name="RadUploadModule" type="Telerik.Web.UI.RadUploadHttpModule" />

Line 115: <add name="RadCompression" type="Telerik.Web.UI.RadCompression" />

Line 116: </httpModules>

Source File: C:\Inetpub\CEMM\web.config Line: 114

--------------------------------------------------------------------------------

Version Information: Microsoft .NET Framework Version:2.0.50727.3615; ASP.NET Version:2.0.50727.3618

Line 114: <add name="RadUploadModule" type="Telerik.Web.UI.RadUploadHttpModule" />

Is there a dll file I can physically move to fix this problem and if so what is it called?

General Discussions

answered on 29 Oct 2010

1 answer

142 views

Paging in HTML

So everything I've read says that the HTML reports will be paged based on the 'PageSettings' fields. Can you elaborate on this? When I place my report in a ReportViewer on a web page, I always get 2 pages: 1 with all of the records, the other is blank with only a footer.

It seems to me like there are two issues, but I cannot find any further documentation on the PageSettings for HTML output paging, and I also cannot figure out why that second page is printing. I've checked that the margins + padding + table width do not add up to more than the report width. Anything else to check for?

Your help is appreciated.

~Scott McNeany

General Discussions

answered on 29 Oct 2010

1 answer

396 views

Telerik and MySQL

I have a MySQL data source that I want to use with Telerik. Using the Data Source configuration wizard, I was able to point to my database, and access the stored procedures. One thing I am not able to do though, is to get telerik to pick up my parameters in my query (whether it is in a stored procedure or if I enter the query in the wizard. I tried a sql server data source, and it seems to pick up @ parameters just fine. Is this a limitation of Telerik, or is there something special you have to do in this scenario?

Thanks,
Sasan

General Discussions

answered on 29 Oct 2010

2 answers

80 views

Report Constructor runs 3 times and values set in between are lost

I'm trying to set available columns as a list and allow callers to make them visible at run-time. Maybe I'm trying to do too much with the available tools, but my approach is much preferred over traditional report parameters for the following reasons:

1. I can define columns programmatically and make them available as a list to the callers without the caller having to know the column names at compile-time.
2. Callers can choose which columns to make visible, change the size, etc at run-time.

So basically I have a List<ReportColumn> collection and a List<SortableColumn> collection. I populate these collections in the report constructor.

I then bind a checkbox list in the caller to allow the user to specify which columns to show. I also bind a drop-down to allow the user to pick which column to sort on.

I then have methods ShowHideColumn(string key, bool visible) and SetSortColumn(string key, SortDirection direction) available for the caller to chose which columns to show and sort by.

My problem is that setting these properties on the list are simply wiped away the next time the constructor is run. Is there a way to preserve these values. Web caching perhaps? I'd rather not use caching if there is a better way to preserve them, but i will do what i have to to preserve the binding functionality.

Thanks,

Scott

protected void btnRunReport_Click(object sender, EventArgs e)

{

CompensationStatement report = new CompensationStatement();

report.ReportParameters["ProducerNumber"].Value = ddlProducerNumber.SelectedValue;

report.ReportParameters["Month"].Value = DateTime.Parse(ddlMonth.SelectedValue);

//Indicate which columns to show.

foreach (ListItem li in cblstAvailableColumns.Items)

{

bool columnExists = report.ShowHideColumn(li.Value, li.Selected);

if (!columnExists)

{

Elmah.ErrorSignal.FromCurrentContext()

.Raise(new Exception(string.Format(

"An attempt was made to execute report 'Compensation Report' with invalid parameter '{0}'. This indicates a bug.", li.Value)));

}

report.SetSortColumn(

ddlSortColumn.SelectedValue,

(Telerik.Reporting.Data.SortDirection)Enum.Parse

(typeof(Telerik.Reporting.Data.SortDirection), ddlSortDirection.SelectedValue, true));

this.ReportViewer1.Report = report;

}

General Discussions

answered on 29 Oct 2010

6 answers

1.0K+ views

Setting PictureBox in OnItemDataBinding

Hi,
I try to show pictures in the Report Details Section and simply don't bring it to work. I filled a DataSet with some images and gave it as DataSource to the Report.

During the ItemDataBinding event I wand to set the Value Property of my PictureBox:

private void Detail_ItemDataBound(object sender, System.EventArgs e)
{
    DataSet ds = (DataSet)DataSource;
    System.Drawing.Bitmap image =
        (System.Drawing.Bitmap) ds.Tables["Maps"].Rows[RowIndex]["MapImage"];
    PictureMap.Value = image;
    RowIndex++;
}

As result I get this error:

[ArgumentNullException: Der Wert darf nicht NULL sein.
Parametername: encoder]
 System.Drawing.Image.Save(Stream stream, ImageCodecInfo encoder, EncoderParameters encoderParams) +386727
 System.Drawing.Image.Save(Stream stream, ImageFormat format) +36
 Telerik.Reporting.HtmlRendering.ImageRenderer.SaveImageInStream(HtmlRenderingContext context, Image img, String uniqueImageID, String mimeType) +80
 Telerik.Reporting.HtmlRendering.ImageRenderer.Render(ReportItemBase item, HtmlRenderingContext context) +85
 Telerik.Reporting.HtmlRendering.HtmlItemRender.Telerik.Reporting.HtmlRendering.IReportItemRender.Render(ReportItemBase item, RenderingContext context) +67
 Telerik.Reporting.HtmlRendering.RenderingContext.Render(ReportItemBase item) +47
 Telerik.Reporting.HtmlRendering.Matrix.Render(HtmlRenderingContext context) +1159
 Telerik.Reporting.HtmlRendering.ReportSectionBaseRenderer.Render(ReportItemBase item, HtmlRenderingContext context) +75
 Telerik.Reporting.HtmlRendering.HtmlItemRender.Telerik.Reporting.HtmlRendering.IReportItemRender.Render(ReportItemBase item, RenderingContext context) +67
 Telerik.Reporting.HtmlRendering.RenderingContext.Render(ReportItemBase item) +47
 Telerik.Reporting.HtmlRendering.HtmlPage.RenderBodyInternal(HtmlWriter bodyWriter) +598
 Telerik.Reporting.HtmlRendering.HtmlPage.Render(HtmlTextWriter writer, HtmlRenderingContext renderingContext) +152
 Telerik.Reporting.HtmlRendering.HtmlReport.Render(HtmlTextWriter writer) +353
 Telerik.Reporting.HtmlRendering.HtmlRenderingExtension.Telerik.Reporting.Processing.IRenderingExtension.Render(Report report, Hashtable renderingContext, Hashtable deviceInfo, CreateStream createStreamCallback, EvaluateHeaderFooterExpressions evalHeaderFooterCallback) +260
 Telerik.Reporting.Processing.ReportProcessor.Render(String format, Report reportDefinition, Hashtable deviceInfo, CreateStream createStramCallback) +136
 Telerik.ReportViewer.WebForms.ServerReport.Render(HttpResponse response, String format, Int32 pageNumber, Boolean refresh) +784
 Telerik.ReportViewer.WebForms.ReportPageOperation.PerformOperation(NameValueCollection urlQuery, HttpResponse response) +72
 Telerik.ReportViewer.WebForms.HttpHandler.System.Web.IHttpHandler.ProcessRequest(HttpContext context) +118
 System.Web.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +303
 System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +64

Any ideas?

Greetings,
Alexander Brütt

General Discussions

answered on 29 Oct 2010

2 answers

122 views

Custom Reporting

Hello Sir

I have implement reporting in my applicaiton and it's work fine.

I have requirement of End-User Reporting.

Means Different user can create their own report as per their requirement.
Is this possible to create in your Tool ?

Please give me proper solution for that.

Thanking you.

Kishor Dalwadi

General Discussions

answered on 29 Oct 2010

2 answers

205 views

Crosstab Column Header Row

Hi,

Is it possible to remove the column header row from a cross tab.

I have a main report and a sub report, The subreport just has a cross tab on it
In the main report detail section i include the subreport and currently get:

Sub Report

[Col1]    -    [Col2]    -    [Col3]    -    [Total]

  0       -    1000      -     0        -    1000

In the Main Report I Get

{GroupHead}      [Itemcode]    -    [Count1]    -    [Count2]

                                                                     [Col1]    -    [Col2]    -    [Col3]    -    [Total]

{DetailSection}  ItemCode      -    400         -    250     -

0 - 1000 - 0 - 1000

What i want to do is get the header columns from the Sub report onto the main report Group header Line

General Discussions

answered on 29 Oct 2010