Questions on Reporting Forum

4 answers

184 views

Automated Exporting and Emailing PDF versions of a Grid

Hi!

We have been using Telerik controls for the past 3 years and have built extensive WPF Controls with RadGrids for our customers to view their data. More and more we are getting asked for the ability to have the reports automatically created and emailed in a PDF format every night to them. We built our own service to do this that exports the Grid to a .XPS file to get the identical look and feel of the screen then use a .XPS to PDF converter to do the final conversion so that we didn't have to recreate all of the controls in another format. The challenge is the service is proving unreliable due to having may different dependencies.

My question is:

Is there a quick way to leverage our grid to create a report template?
How do I use the reporting tools to create pdf and email on a schedule?
Is there an example project that you can share that already does this?

Thanks,
Ryan

General Discussions

answered on 14 May 2013

5 answers

468 views

Open Outlook or use mailTo

Hi,

The data in my report consists of e-mail addresses. If I click on the e-mail address, I want to open outlook containing that address. How to achieve that using HtmlTextBox or TextBox?

General Discussions

answered on 14 May 2013

5 answers

312 views

Change Connection String in Subreport

I had created a Master-Detail report. In this report, the subreport contains a report which displays the detail data. I want to change the connection string of the subreport because sometimes the location of the Access database changes. How can I use code to change the connection string (i.e. database location) for the subreport contained in the Master report?

Thanks.

General Discussions

answered on 13 May 2013

0 answers

158 views

System.IO.FileLoadException, can't get reporting to work after upgrade

Hello,



I've been trying to upgrade the Telerik libraries to the latest version
but I've been getting the following error during runtime:



{System.IO.FileLoadException: Could not load file or assembly
'Telerik.ReportViewer.Silverlight, Version=7.0.13.426, Culture=neutral,
PublicKeyToken=a9d7983dfcc261be' or one of its dependencies. The
requested assembly version conflicts with what is already bound in the
app domain or specified in the manifest. (Exception from HRESULT:
0x80131053)

File name: 'Telerik.ReportViewer.Silverlight, Version=7.0.13.426, Culture=neutral, PublicKeyToken=a9d7983dfcc261be'

   at VenumBV.Apps.Venum.Views.Views.UserControls.ReportViewerControl.ReportViewerControl..ctor()}





I'm not sure why I'm getting this error. I've looked on the forums and
someone said that it was because I didn't reference the DLL's in my
website project, but I am. I'm also referencing them in the project that
has the actual reports and I'm referencing the
Telerik.ReportViewer.Silverlight DLL in the silverlight project that
launches the reports.



So I'm not sure what I'm doing wrong here. I've checked and I'm
referencing all the correct versions in the 3 different projects and
I've installed the latest version of the Reporting controls (with the
service pack).



Any help would be appreciated.

General Discussions

asked on 13 May 2013

1 answer

57 views

DataObject Error

We just upgraded to the latest release of the Report components and are now receiving an error about No Default item for ResultSet when accessing the set.DataObject("fieldname") like below. The datasource is a SQLDataSource and all this worked prior to the upgrade.

Private Sub activityTable_NeedDataSource(ByVal sender As Object, ByVal e As System.EventArgs) Handles activityTable.NeedDataSource

Dim tbl As Telerik.Reporting.Processing.Table = TryCast(sender, Processing.Table)

Dim sect As Processing.ReportSection = TryCast(Processing.ElementTreeHelper.FindChildByName(tbl.Report, "ReportHeaderSection1", True).FirstOrDefault, Processing.ReportSection)

Dim data As Object = sect.DataObject

Dim cutoffdate As Date, managedbypartnerid As Integer

Dim totalduetextbox As Processing.ProcessingElement = Processing.ElementTreeHelper.GetChildByName(sect, "payStubAmountDueTextBox")

Dim totaldueaftertextbox As Processing.ProcessingElement = Processing.ElementTreeHelper.GetChildByName(sect, "payStubAmountDueAfterTextBox")

Dim autopaytextbox As Processing.ProcessingElement = Processing.ElementTreeHelper.GetChildByName(sect, "autopaytext")

If data IsNot Nothing Then

cutoffdate = data.Item("UsageCutOffDate")

managedbypartnerid = data.Item("ManagedByPartnerId")

End If

General Discussions

answered on 13 May 2013

4 answers

310 views

Setting multiple value to a multivalued integer parameter

Hi,
I am using telerik reporting, here i have a multivalued parameter on the report which is of type Integer,
I want to set value to this parameter from the client side..

Currently i am using the below code and it doesn't work..

List<int> values= new List<int>();
values.Add(1);
values.Add(2);

args.ParameterValues["Parameter1"] = values;

and also tried this.

Int[] values= {1,2,4};
args.ParameterValues["Parameter1"] = values;

Thanks

General Discussions

answered on 13 May 2013

15 answers

1.4K+ views

Hi There,

I was hoping someone could point me in the right way to display the header of a table on each new page. I've tried adding in groups, but this seems to assume that you have seperate objects (some text boxes for the header and some for the details), which in the case of a table is not what is available.

I've tried setting the 'ColumnHeadersPrintOnEveryPage' property to true, but this doesn't seem to have any affect, am I missing something here?

Cheers,

Doug

General Discussions

answered on 13 May 2013

2 answers

212 views

Change error message text

Hi,

When opening a page that has not yet had it's search criteria filled in and sent off to generate a report I get the "The source of the report definition has not been specified." message showing inside the report viewer section. That is all fine as it's expected behavior.

However, I want to change the text of the error that gets shown - is there a way to do this?

I want to make it say something like "Please fill in search criteria then press the search button."

Regards

Jon

General Discussions

answered on 13 May 2013

1 answer

159 views

problem with grouping multi-level table

Hello there,
I have this data structure:
{Id, Phases, Ring}
My content is
Id goes from 1:16
Phases is a random string
for each Id there are four Rings so Ring goes from 1:4
so the data I have is
{1, "xx", 1}, {1, "xy", 2}, {1, "**", 3},{1, "fd", 4},
{2, "dk", 1}, {2, "%", 2}, {2, "T*", 3},{2, "sd", 4},
...
{15, "kk", 1}, {15, "ll", 2}, {15, "**", 3},{15, "ff", 4},
{16, "yy", 1}, {16, "uu", 2}, {16, "U*", 3},{16, "pp", 4},

I want to show this data in a report with the following layout (ignoring the edges and font types of course)
Id = 1
Ring 1 2 3 4
Phase xx xy ** fd

id=2
Ring 1 2 3 4
Phase dk % T* sd

...

id=15
Ring 1 2 3 4
Phase kk ll ** &&

id=16
Ring 1 2 3 4
Phase yy uu U* pp

What I did is created thee lists list1 (parent), list2 (child), list 3(child)
list2 and list3 are within list1 (in design mode as shown in rptexplorer.jpg)
"id=" (textBox1) and "Fields.Id"(textBox3) belong to panel2 (within list1)
"Ring" (textBox4) and "Phases" (textBox6) are labels that belong to list2
Fields.Ring (textBox7) and Fields.Phase (textBox8) are data fields that belong to list3

I also have groupings
on list1 I have a Row Group equals to "=Fields.Id"

on list2 I don't have any Groups

on list3 I have a Row Group equals to "=(Fields.Ring-1)/4" and a Column group equals to "(Fields.Ring-1)%4"

when I run the report I only have the first sequence of data (though the layout is fine) like this:

Id = 1
Ring 1 2 3 4
Phase xx xy ** fd

id=2
Ring 1 2 3 4
Phase xx xy ** fd

...

id=15
Ring 1 2 3 4
Phase xx xy ** fd

id=16
Ring 1 2 3 4
Phase xx xy ** fd

What am I doing wrong? do I have something missing? please help!!!

General Discussions