Questions on Reporting Forum

1 answer

445 views

Telerik Reporting, EntityDatasource, Runtime setting of DbContext

hi,

we're struggled quite a lot with building telerik reports using the new Q1 2015 report builder and are hopefully at the final hurdle.

We've built a report using an entitydatasource pointed at a function written in the DbContext project, GetOrderById(int id). This produces an invoice output which now works in the designer.

When we run it in our application using the webforms report viewer (for compatability purposes) it keeps trying to create a local database instead of reading the sql server connection of the context we've passed in to it.

Here is the runtime code that i've bound to the page_load event of a page (for getting it working purposes)

Dim source = New Telerik.Reporting.UriReportSource()

source.Uri = "web/apps/shared/InvoiceReport2.trdx"

Dim report = New Telerik.Reporting.Report

Dim ds As New EntityDataSource()

Dim context = New

DataContext(connectionString) // passed in as a text string and is 100% valid

ds.Context = context

ds.ContextMember = "GetOrderForReports"

ds.Parameters.Add("OrderId", GetType(Integer), 89720)

report.DataSource = ds

ReportViewer1.ReportSource = source

ReportViewer1.RefreshReport()

the error we get is as below. any help would be great, cheers.

An error has occurred while processing Report 'invoicereport2': An error occurred while invoking data retrieval method. ------------- InnerException ------------- Exception has been thrown by the target of an invocation. ------------- InnerException ------------- Directory lookup for the file "D:\xxxxxx\WebSites\xxxxx\App_Data\xxxxx.mdf" failed with the operating system error 2(The system cannot find the file specified.). CREATE DATABASE failed. Some file names listed could not be created. Check related errors.

General Discussions

answered on 08 Apr 2015

3 answers

105 views

Toolbox items locked

Hi,

I was trying out with Reporting and added report viewer to the project. But i'm not able to add any other items as all the items are seems to be locked. Check out the screen shots attached to get better idea on what i'm talking about.

If we enable show all. All the items are seen but locked. Only report viewer is enabled.

If you guys have an answer please reply to this thread.

Thanks in advance.

Swaroop

General Discussions

answered on 07 Apr 2015

3 answers

569 views

Reporting for printing Labels

Hello,
I am using Telerik Reporting for web to create shipping labels and it looks great to print out one label at a time but if I want to print in a different position based on a parameter. I am using Avery label (template number is 5264) and it has 6 (2x3) labels on a sheet. Currently the label is a static design

How can I do it?

For example,
----------
| A | B |
| C | D |
| E | F |
---------

Thanks

General Discussions

answered on 06 Apr 2015

1 answer

149 views

Incorrect value in expression

Hello,

I am using a formula that should be pretty straightforward in a cross tab field.

= IIf((Exec("rowGroup1", Sum(Fields.Field1)) - RunningValue("rowGroup1", Sum(Fields.Field1))) = 0, 0, (Exec("rowGroup1", Sum(Fields.Field2)) - RunningValue("rowGroup1", Sum(Fields.Field2))) / (Exec("rowGroup1", Sum(Fields.Field1)) - RunningValue("rowGroup1", Sum(Fields.Field1))))

The idea is that we are taking the sum of all values and dividing it but the running total. In most scenarios, this is running correctly and the last value is 0 because the running total is equal to the sum of all values. However, in a couple of instances, a negative number is produced and I can't figure out what's going on. I have checked the values of the sum of all vs the running total and it appears that it should calculate to 0. I'm coming close to a deadline and hoping the community may be able to help.

Thanks

General Discussions

answered on 03 Apr 2015

3 answers

882 views

Unable to establish a connection to the database using Report Designer

Dear Telerik Team,

I have a problem.

"An error has occurred while processing Report 'theReport':
Unable to establish a connection to the database. Please, verify that
your connection string is valid. In case you use a named connection
string from the application configuration file, make sure the name is
correct and the connection string settings are present in the
configuration file of your application."

I'm
1. Using Telerik Report Q2 2014
2. Designing report using Report Designer (.TRDX)
3. implementing report using ASP.NET v.4 (VB)
4. confuse, it works when i click preview from report designer, but it wont work (saying the above error message) when running it using ASP.NET

the code behind:
Dim uriReportSource As New UriReportSource()
uriReportSource.Uri = Server.MapPath("~/Report/") & "theReport.trdx"
uriReportSource.Parameters.Add(New Telerik.Reporting.Parameter("ID", Request("ID")))
ReportViewer1.ReportSource = uriReportSource

The ConnectionString:
1. in Report Designer/TRDX file, "MyCS"
2. in Web.Config, "MyCS"
3. the same connection string value and the same named connectionString.

Can you help me with this? how can i run my report using asp.net.

Thank you

General Discussions

answered on 03 Apr 2015

2 answers

95 views

Telerik report designer

How can I display headers in crosstab?

General Discussions

answered on 03 Apr 2015

1 answer

141 views

Change the postion of the grouping label in category group

Hi,

I have a stacked bar chart and a line chart, both are grouped by a property but i want the grouping label to be displayed lower than the label and also delimiting every group by a line. I have added 2 images which will explain what i want better (the file names are suggestive).

Report Designer (standalone)

answered on 02 Apr 2015

1 answer

290 views

Hide grouping column of a crosstab

Hi All

I am using a crosstab for generating a report. Now there is a new requirement, based on the users input there are some columns to be hide. I did follow some approaches and end up with the same problem.

1. Use bindings for the column and set visible false. Resulting column not visible but still white space is still there. (this happens only for grouped columns)
2. Set width to be 0 for the column index. Columns are hidden but space for the header still there and last column header of the grouping is missing

Is there a way to hide any column including header of the crosstab according to the index of the column from left.

following is the code i used for set width of columns

int count = 0;

var rowGroups = this.crosstab1.RowGroups;

while (rowGroups != null)

{

foreach (var group in rowGroups)

{

if (hideColumnIndexes.Contains(count))

{

group.ReportItem.Width = new Telerik.Reporting.Drawing.Unit(0.000000,

Telerik.Reporting.Drawing.UnitType.Inch);

}

if (rowGroups.Any())

{

rowGroups = rowGroups[0].ChildGroups;

}

else

{

rowGroups = null;

}

count++;

}

General Discussions

answered on 02 Apr 2015

1 answer

318 views

Dynamically change connection string of a parameter

I'm using the Standalone report viewer as I'm not a developer, though I can muddle through some stuff. I am writing a report where 95% of the data is in a customer database.

There is a database that contains the database name of the available customer databases. At run time, the user would select the customer to run the report for, and the report would retrieve the database name from this master database.

I then have two other parameters that the user would need to select based on values in the customer database for the selected customer. I want to generate a list of available values, but to do so, I need to use the first parameter to retrieve the database name, then change the connection string of the second parameter. Once the user selects these values, I can then pass them to the subreports that make up the reports and use them to update the connection strings.

I have written a custom library using the examples found here so I can change the connection string and it works for the sub reports.

However, I'm trying to figure out a way to do the same for the parameters. I tried putting my custom function call into the ConnectionString parameter in place of the defined connection that is selected in the Report Viewer but that didnt seem to work, or I didn't do it correctly.

Is there a way to do what I need to here?

General Discussions

answered on 02 Apr 2015

4 answers

653 views

Best way to replace a Telerik Reporting ObjectDataSource programmatically in a SubReport?

We have some very complex reports that must be fed by a data controller class library. The Telerik ObjectDataSource the is used to represent controller methods as data sources in the designer assume that the data access methods are static. Unfortunately, our controllers do not have parameter-less constructors. It has become more challenging to cope with this limitation ever since the SubReport ReportSource could be something other than a Telerik Report. I have struggled to find the best way to replace Telerik SubReport ObjectDataSources programmically in your TR Q1 2013 SP1 release. I am hoping that someone who has a strong opinion will evaluate our approach because Google hasn't revealed a clear answer to us.

Facts and Assumptions About Telerik Reporting

Let's make sure that I have my facts straight:

The recommended way to represent a controller method as a data source in the Telerik Reports designer is the ObjectDataSource.
The Telerik ObjectDataSource assumes that the controller method it calls is static.
The recommended way to override a data source programmatically is to bind to the SubReport's NeedDataSource event.
A Report will only fire its NeedDataSource event if the Report's DataSource property is set to null.
A Telerik SubReport acts like a placeholder control. It could represent a Telerik Report or a blob of text. This flexibility makes it impossible to directly access the DataSource of a Report that is instantiated by a SubReport at compile time. Instead, you must programmatically instantiate the Report, change its properties and then replace the SubReport.ReportSource with the new Report instance.

All true? If not, please explain.

Hypothetical Report

Now suppose we have a nested stack of Telerik Reports where Report1 includes SubReport2 to instantiate Report2 that in turn includes SubReport3 to instantiate Report3. Report1 is instantiated by an ASP.NET page and bound to the Telerik ReportViewer. Here's what we would do to replace the ObjectDataSource at run-time:

When we instantiate Report1, we use a custom constructor that receives a LINQ to SQL data context as an argument. Given a data context, we instantiate our controllers inside Report1.cs. In the Report1 ItemDataBinding event handler, we replace SubReport2.ReportSource like so:
public Report1(LINQToSQLDataContext dataContext)

{

    //

    // Required for telerik Reporting designer support

    //

    InitializeComponent();

    // custom constructor actions

    this.DataContext = context;



    // for debugging

    detail.ItemDataBound += new EventHandler(detail_ItemDataBound);

    this.detail.ItemDataBinding += new EventHandler(detail_ItemDataBinding);

    // force NeedDataSource to fire

    this.DataSource = null;

    this.NeedDataSource += new EventHandler(Report1_NeedDataSource);

    this.Error += new ErrorEventHandler(Report1_Error);



    // replace the subReport in order to pass it the MyContactMethodController to replace its static DataSource

    Report2 emailReport = new Report2SubReport(this.MyContactMethodController);

    this.Report2SubReport.ReportSource = new InstanceReportSource() { ReportDocument = emailReport };

    this.Report2SubReport.ReportSource.Parameters.Add(new Telerik.Reporting.Parameter("parameter1", "=Fields.ID"));

    this.Report2SubReport.ReportSource.Parameters.Add(new Telerik.Reporting.Parameter("effectiveDate", "=Parameters.effectiveDate.Value"));

}



#region Event Handlers



void Report1_NeedDataSource(object sender, EventArgs e)

{

    Telerik.Reporting.Processing.Report report = (Telerik.Reporting.Processing.Report)sender;

    var id = report.Parameters["ID"].Value;

    _ID = Convert.ToInt32(ufdID);

    var effectiveDT = report.Parameters["effectiveDate"].Value;

    _effectiveDate = Convert.ToDateTime(effectiveDT);

    this.DataSource = this.MyDataController.GetHighLevelInfo(_ID, _effectiveDate);

}



// for debugging

void Report1_ItemDataBinding(object sender, EventArgs e)

{

    int? id = (((Telerik.Reporting.Processing.ReportItemBase)(sender))).DataObject.RawData as int?;

}



// for debugging

void detail_ItemDataBinding(object sender, EventArgs e)

{

    Telerik.Reporting.Processing.ReportSection reportSection = sender as Telerik.Reporting.Processing.ReportSection;

    HighLevelInfo data = reportSection.DataObject.RawData as HighLevelInfo;

    _ID = data.ID;

}



// for debugging

void detail_ItemDataBound(object sender, EventArgs e)

{

    Telerik.Reporting.Processing.ReportSection reportSection = sender as Telerik.Reporting.Processing.ReportSection;

    var data = reportSection.DataObject.RawData;

}



void Report1_Error(object sender, ErrorEventArgs eventArgs)

{

    throw new Exception(string.Format("{0} Telerik Report Exception: {1}", this.Name, eventArgs.Exception.ToString()), eventArgs.Exception);

}

#endregion Event Handlers

2. In Report2:

public Report2(DataController dc)

{

//

// Required for telerik Reporting designer support

//

InitializeComponent();

//

// TODO: Add any constructor code after InitializeComponent call

//

// save controller for the NeedDataSource event handler

this.MyDataController = dc;

// force NeedDataSource to fire

this.DataSource = null;

this.NeedDataSource += new EventHandler(Report2_NeedDataSource);

this.Error += new ErrorEventHandler(Report2_Error);

// replace the subReport in order to pass it the MyDataController

Report3 report3 = new Report3(this.MyDataController);

// force NeedDataSource to fire

report3.DataSource = null;

this.Report3SubReport.ReportSource = new InstanceReportSource() { ReportDocument = report3 };

this.Report3SubReport.ReportSource.Parameters.Add(new Telerik.Reporting.Parameter("parameter1", "=Parameters.parameter1.Value"));

this.Report3SubReport.ReportSource.Parameters.Add(new Telerik.Reporting.Parameter("parameter2", "=Parameters.effectiveDate.Value"));

this.Report3SubReport.ReportSource.Parameters.Add(new Telerik.Reporting.Parameter("parameter3", "=Fields.ID"));

this.Report3SubReport.ReportSource.Parameters.Add(new Telerik.Reporting.Parameter("parameter4", "=Fields.Name"));

}

private DataController MyDataController { get; set; }

private void Report2_NeedDataSource(object sender, EventArgs e)

{

int parameter1 = Convert.ToInt32(this.ReportParameters["parameter1"].Value);

DateTime effectiveDate = Convert.ToDateTime(this.ReportParameters["effectiveDate"].Value);

List<DetailInfo> detailList = this.MyDataController.GetDetailInfoList(parameter1, effectiveDate);

this.DataSource = detailList;

}

void Report2_Error(object sender, ErrorEventArgs eventArgs)

{

throw new Exception(string.Format("{0} Telerik Report Exception: {1}", this.Name, eventArgs.Exception.ToString()), eventArgs.Exception);

}

3. In Report3:

public Report3(DataController dc)

{

//

// Required for telerik Reporting designer support

//

InitializeComponent();

//

// TODO: Add any constructor code after InitializeComponent call

//

// save controller for the NeedDataSource event handler

this.MyDataController = dc;

// force NeedDataSource to fire

this.DataSource = null;

this.NeedDataSource += new EventHandler(Report3SubReport_NeedDataSource);

this.Error += new ErrorEventHandler(Report3SubReport_Error);

}

private DataController MyDataController { get; set; }

private void Report3SubReport_NeedDataSource(object sender, EventArgs e)

{

int parameter1 = Convert.ToInt32(this.ReportParameters["applicantUserFormDetailID"].Value);

DateTime effectiveDate = Convert.ToDateTime(this.ReportParameters["effectiveDate"].Value);

int parameter3 = Convert.ToInt32(this.ReportParameters["skillCategoryID"].Value);

List<MoreDetailInfo> moreDetailInfoList = this.MyDataController.GetMoreDetailInfo(parameter1, parameter2, effectiveDate);

// bind datasource directly to my table. Binding to this.DataSource leaves the table blank.

this.MyTable.DataSource = moreDetailInfoList;

}

void Report3SubReport_Error(object sender, ErrorEventArgs eventArgs)

{

throw new Exception(string.Format("{0} Telerik Report Exception: {1}", this.Name, eventArgs.Exception.ToString()), eventArgs.Exception);

}

Is there a better way to implement this hypothetical report?

General Discussions

answered on 02 Apr 2015