Questions on Reporting Forum

1 answer

107 views

I am wondering if it is possible to do the following:

I have 4 reports that have 3 totals at the bottom: Cases, Allowance and Dollars
I need to insert a sub report to the report footer to appear immediately under the grand total line that also uses Cases, Allowance and Dollars
I'd like to create one sub report, not 4
is it possible to move and / or resize the textboxes on the sub report to line up with the report being produced?

General Discussions

answered on 14 May 2013

1 answer

143 views

Using ado.net's ExecuteReader in ado.net throws error " Invalid attempt to read when no data is present." -- ???

I am sure I must be missing something simple here, but I can't seem to user an ado.net datareader with reporting. Here is a code sample:

Private Sub RptRadIdleTime_NeedDataSource(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.NeedDataSource

rptHeaderBox.Value = "Report Criteria:" & vbCrLf & "Date Range: " & StartDate.ToShortDateString & " to " & EndDate.ToShortDateString & vbCrLf & _

"Employee: " & EmployeeName & vbCrLf

Dim cn As New SqlConnection(ConfigurationManager.ConnectionStrings("ConnectionString").ConnectionString)

cn.Open()

Dim cmd As New SqlCommand("ReportIdleTime")

cmd.CommandType = CommandType.StoredProcedure

cmd.Connection = cn

cmd.Parameters.Add(New SqlParameter("EmployeeID", EmployeeID))

Dim p1 As New SqlParameter("Start", SqlDbType.DateTime)

p1.Value = CDate(StartDate)

Dim p2 As New SqlParameter("End", SqlDbType.DateTime)

p2.Value = CDate(EndDate)

cmd.Parameters.Add(p1)

cmd.Parameters.Add(p2)

Me.DataSource = cmd.ExecuteReader

End Sub

This yields the following error:

An error has occurred while processing TextBox 'TextBox6': Invalid attempt to read when no data is present.

(And the same error on every other field.)

The same method of connecting works fine with linq-to-sql.

Thanks for any help,

David

General Discussions

answered on 14 May 2013

4 answers

211 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

537 views

[Solved] 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

357 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

227 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

90 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

383 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.5K+ 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

257 views

[Solved] 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