Telerik Forums
Reporting Forum
1 answer
222 views
Hi,
I am working with the integrated tool in visual studio. The attached picture shows a report where I have set the margins left and right= to 1 cm.
My understanding is that, in order to get it printed correctly, no controls or images should stay out of those margins.
The problem is that I clearly see the red line indicating the margins on the right and therefore I can manage to position the elements of the report on its left but the margin on the left side of the report (red line) is not showing correctly as it is on the edge of the report and not 1 cm inside as it should be.
Is this a bug or there is something I am missing?

Moreover, knowing that I will set the side margins at 10mm from left and right, should a give the report the total dimensions of the paper size less the margins ( A4= 210 mm, margins 10+10, report width= 210-10-10=190 mm)?
Or there is another way to handle this ? 

Peter
Telerik team
 answered on 11 Nov 2013
5 answers
301 views
Greetings

This concept should be straightforward; however, I have not been able to see it in the documentation.

How do I add Report-Book navigation based on the reports dynamically added to the Report Book. I want a navigation similar to the demo page - http://demos.telerik.com/reporting/report-book/demo.aspx

I do not need document-map, rather just links that will enable me to navigate from report to report, once the report book has been dynamically created.

Please advise
Thanks
Nasko
Telerik team
 answered on 11 Nov 2013
1 answer
84 views
Hello,

Still testing Telerik reporting. I tried to use an ObjectDataSource to reuse the repository layer of my application.

So I added a reference to my project from the Report project. Everything was fine until I had to signed the Repository assembly in my solution.

I tried to signed as well the TelerikReports assembly but it's still not working.

I double check if there was an x64 or x86 issue but all assemblies in my solution are built against AnyCPU.

Is there any known restriction by using signed assemblies in the designer?

EDIT1: Forgot to mention that I also installed the DLL in the GAC.

Pierrick
Peter
Telerik team
 answered on 11 Nov 2013
7 answers
536 views
I need to exec a stored procedure. Some of the parameters are strings (but can also be null) and need to have this format: < 'IntVal1,IntVal2,IntVal3' >.
IntVals are basically city IDs.
I managed to format them with Join function:  Join(",",Parameters.Cities.Value).
The problem I'm facing is when the parameter City is null (I sometimes need it to be null). The Join function outputs an error in that case. To avoid calling the Join function when the param City is null I tried the following:
@queryParamCity   =   IIf  (Parameters.Cities.Value,  Join(",",Parameters.Cities.Value),  null)
or
@queryParamCity   =   IIf  (Parameters.Cities.Value IS NOT null,  Join(",",Parameters.Cities.Value),  null)
or 
@queryParamCity   =   IIf(Parameters.Cities.Value is null,null,Join(",",Parameters.Cities.Value))
.....but the Join function is still being called even if the City parameter is null, so it generates an error and the execution is stopped.

So, no matter what is the value of the expression, the other two member of the IIf function are called.
Gaurav
Top achievements
Rank 1
 answered on 11 Nov 2013
2 answers
106 views
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");
    }
Stef
Telerik team
 answered on 08 Nov 2013
1 answer
195 views
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?
Stef
Telerik team
 answered on 08 Nov 2013
1 answer
302 views
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
Nasko
Telerik team
 answered on 08 Nov 2013
11 answers
301 views
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
Vitrum
Top achievements
Rank 1
 answered on 08 Nov 2013
1 answer
134 views
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!

David
Top achievements
Rank 1
 answered on 07 Nov 2013
1 answer
61 views

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

Stef
Telerik team
 answered on 07 Nov 2013
Top users last month
Jay
Top achievements
Rank 3
Iron
Iron
Iron
Benjamin
Top achievements
Rank 3
Bronze
Iron
Veteran
Radek
Top achievements
Rank 2
Iron
Iron
Iron
Bohdan
Top achievements
Rank 2
Iron
Iron
Richard
Top achievements
Rank 4
Bronze
Bronze
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?