Questions on Reporting Forum

2 answers

111 views

CrossTab need Datasource not fired in Azure

OK, this is an odd one but I have a CrossTab report that when run locally on my dev machine under IIS runs perfectly fine.

However when run in Azure the needDataSource event for the CrossTab isn't raise. I have attached a remote debugger, I can see the report initialize, and the Reports NeedDataSource event is raised however CrossTab1_NeedDataSource is never executed.

No errors are thrown, no error statements in the console during debugging.

Is there another way to force the NeedDataSource even to fire? Or a way to bind the cross tab(s) from the reports datasource.

using System.Linq;

using Bentley.SelectServer.Database;

using System;

namespace Bentley.SelectServer.Reporting

{

/// /*------------------------------------------------------------------------------------------------------*/

/// <summary>

/// Summary description for MonthlyPeakUsage.

/// </summary>

/// <author>marcus.kellermann</author>                                                  <date>7/23/2013</date>

/// /*------------------------------------------------------------------------------------------------------*/

//public partial class MonthlyPeakUsage : Telerik.Reporting.Report, iBaseReport

public partial class MonthlyPeakUsage : BaseReport, iBaseReport

{

public MonthlyPeakUsage()

{

InitializeComponent();

this.DocumentName = GetReportName();

this.crosstab1.NeedDataSource +=crosstab1_NeedDataSource;

}

///*--------------------------------------------------------------------------------------**/

/// <summary>

/// Report Name used for Display in the report and parameters name

/// </summary>

/// <returns></returns>

/// <author>Marcus.Kellermann</author> <date>07/2011</date>

/*==============+===============+===============+===============+===============+==========*/

public string GetReportName()

{

return ReportingStrings.MonthlyPeakUsageReport;

}

///*--------------------------------------------------------------------------------------**/

/// <summary>

/// Creates the Report Configuration Object used to configure the reporting GUI

/// </summary>

/// <returns>Report Configuration</returns>

/// <author>Marcus.Kellermann</author> <date>07/2011</date>

/*==============+===============+===============+===============+===============+==========*/

public ReportConfiguration GetReportConfiguration()

{

return new ReportConfiguration

{

ShowGeneralParametersTab=true,

ShowMachineParametersTab=false,

ShowUserParametersTab=false,

ShowVirtualSites = false,

ReportName = ReportingStrings.MonthlyPeakUsageReport,

ShowIncludeDetails = false,

ShowCAGOption = false

};

}

/// /*------------------------------------------------------------------------------------------------------*/

/// <summary>

/// Handles the NeedDataSource event of the crosstab1 control.

/// </summary>

/// <param name="sender">The source of the event.</param>

/// <param name="e">The <see cref="EventArgs"/> instance containing the event data.</param>

/// <author>marcus.kellermann</author>                                                  <date>7/23/2013</date>

/// /*------------------------------------------------------------------------------------------------------*/

private void crosstab1_NeedDataSource(object sender, EventArgs e)

{

Telerik.Reporting.Processing.Table table = (Telerik.Reporting.Processing.Table)sender;

Telerik.Reporting.Processing.Report rpt = table.Report;

DateTime startDate = (DateTime)rpt.Parameters[ReportParameterNames.StartDate].Value;

DateTime endDate = (DateTime)rpt.Parameters[ReportParameterNames.EndDate].Value;

String userID = (String)rpt.Parameters[ReportParameterNames.UserID].Value;

string reportID = (String)rpt.Parameters[ReportParameterNames.ReportID].Value;

Boolean includeWeekends = (bool)rpt.Parameters[ReportParameterNames.IncludeWeekends].Value;

//Jiao: Add UltimateID to ReportParameter

long ultimateID = long.Parse ((string)rpt.Parameters[ReportParameterNames.UltimateID].Value);

var reportDataSet = Reports.MonthlyPeakUsage(startDate, endDate, userID, new Guid(reportID), includeWeekends, ultimateID);

ReportUtils.CheckReportSize(reportDataSet.MonthlyPeakUsage.Count());

table.DataSource = reportDataSet.MonthlyPeakUsage;

}

private void MonthlyPeakUsage_NeedDataSource(object sender, EventArgs e)

{

RPTLogger.Log.trace("In Report Need DataSource");

}

General Discussions

answered on 08 Nov 2013

1 answer

212 views

The source of the report definition has not been specified

I have viewed the forum for previous messages relating to this error, but my issue is not resolved.
When I click my "Search" button, I am supposed to display data in a Telerik Reportview control. However, I get the message "The source of the report definition has not been specified."

In my Telerik.Reporting.Report page, I have a Telerik.Reporting.SQLDataSource control that has a valid connection string value, along with a valid parameters value and a SelectCommand value to a stored procedure.

In the Telerik.Reporting.Report page, the properties window displays a valid value for the DataSource along with ReportParameters.

So I am providing an accurate report source. I can see the data perfectly fine in Preview and HTML mode in the reportviewer design time. The issue is when I run my asp.net application, I cannot see the data displayed on the aspx page.

What else could be causing the data to not display?

General Discussions

answered on 08 Nov 2013

1 answer

313 views

Call SubReport Multiple Times From Master

Hi Guys

Today i came across one situation
1) can we call subreport in a for loop meaning one report for multiple output,
I saw one link(below) where i am in same situation and same requirement

http://www.telerik.com/community/forums/reporting/telerik-reporting/multiple-output-from-single-subreport.aspx

Let me know whether we can do as i need to let my client know
If my requirement not possible ,what are other ideas to achieve

Senthil

General Discussions

answered on 08 Nov 2013

11 answers

307 views

Refresh a Silverlight Report

Good Evenign

i am not using MVVM parttern, i looked for examples here on our site and could not find just a simple way to refresh a Reportviewer in Silverlight. The Scenirio is simple. i have a listbox outside the Report, and when the SelectedChanged even is fire, i want to refresh the report, So i tried to call the Asnyc of the "reportViewer1_RenderBegin" Event , but nothing is happenig. my renderbegin is initializing the report parameters. So i want to refresh a report.

THanks

General Discussions

answered on 08 Nov 2013

1 answer

135 views

Reporting Upgrade Wizard Missing

Hi,

Using Visual Studio 2008 with Reporting.

I just updated from Q1 2013 to Q3 and I don't know how to upgrade my references. I have seen a few pages that mention using the Reporting Upgrade wizard on the Telerik menu, but I do not have that.

Am I missing something? (See attachment images)

Thanks!

General Discussions

answered on 07 Nov 2013

1 answer

68 views

Report Height With Multiple Pages

I am having an issue when I have multiple page reports. The first 2 pages show at the correct height but when I hit the third page the height is about 150px with a scrollbar. I only see the issue in IE10. Also if I go into compatibility mode I see no pages.

https://www.fashioncabinet.com/dealer/printinvoice.aspx?inv=AC1649&Row=26246

There is a link to the report

General Discussions

answered on 07 Nov 2013

1 answer

85 views

Reports Stopped Working When dev project was moved to new pc

Hello All. I have a problem I am not sure how to fix. I developed a bunch of reports using Q3 2011 and my boss took it upon himself to move my development projects to a new pc and reformatted the old one. The problem I face now is that none of my reports will open and I can not find the original install for Q3 2011 to reinstall in hopes of fixing the issue.

I get several errors telling me that a slew of parameters with name 'xxx' already exist, where 'xxx' is the name of one of my parameters. How can I fix this issue??

General Discussions

answered on 07 Nov 2013

3 answers

166 views

Export pdf render problem

Hello,

We have a problem with a report when exporting to PDF. For some reason a chart is split over 2 pages when exporting. The problem only occurs at the production server. If we export the report locally there aren't any problems.

I attached some screenshots with the problem.

Specifications
Iss (v7.5.6) is on both systems the same.
We used a copy of the productiondatabase so that can't be the problem.
Windows 7 (local) vs Windows Server 2008 (production)

Sodi We

General Discussions

answered on 07 Nov 2013

2 answers

327 views

Report works locally but not on hosting server

I am going mad with this:
I have made a report in a class library and then referenced the DLL in my website project.
Added the viewer and the code in the page behind:

protected void Page_Load(object sender, EventArgs e)

{

ReportViewer1.Report = new MyClassRep1.IndustryRep();

}

Locally on my machine is working fine. No problems of any type. Beautiful.
Then I change the string in the web.config from the local database :

<add name="stad_conn" connectionString="Data Source=WIN-72PL3253COR\SQLEXPRESS;Initial Catalog=DataIntelli1;Integrated Security=True;"/>

to the production database:

<add name="stad_conn" connectionString="Data Source=foooo.db.1and1.com;

Initial Catalog=fooo;

uid=fooo;

pwd=myPassword" providerName="System.Data.SqlClient" />

And when I finally try to run the report on the production server I get the following message (also in the attached pic):

"""An error has occurred while processing Report 'IndustryRep': Request for the permission of type 'System.Security.Permissions.FileIOPermission, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed."""

What is very strange is that I have other additional 4 reports on the same website out of the same class library that works without problems.
What could be wrong on this particular report?
Some help will be appreciated.
Thanks,
Felice

General Discussions

answered on 07 Nov 2013

4 answers

204 views

Filter at runtime

Hi,
I know this question has been asked in the past but may be that with time and new added features there is something new on this subject.
I have a simple report with Customers by countries and I would like to give the user the possibility to choose a specific country to be rendered as report.

Is there a way to add a filter with preselected values on the report that can be used at runtime by the user?
Something like a drop down list.

Thanks,
Felice

General Discussions

answered on 06 Nov 2013