Telerik Forums
Reporting Forum
1 answer
231 views

I have a use case of trying to make a report that displays tax statements for one or more accounts.  It essentially repeats the whole report for each account, appended together.  I fetch the account data from SQL using a JSON string report parameter.  The report has the following requirements:

Page headers and footers that display some basic report info labels passed in from the JSON string on each page of the report.  

Directly above and below the previously mentioned footers, an extension of these sections that displays more detailed information fetched from sql.  The extended header is pretty basic and can be the same on every page of the report.  The extended footer displays some info that is account-specific and additionally, dynamically shows a payment stub label and table if this is the last page for a specific account's statement (i.e., the detail section's grouped table finished printing on this page).

The detail section displays a grouped table for the account statement that may run across pages but must not push around the header or footer.

Additionally, after the last page of the account statement, there may be one or more additional pages printed with another grouped table about that account.  The layout at this point no longer really matters and any of the aforementioned sections and requirements could be left out.  We particularly would not want the payment stub footer displayed here if possible, or at a minimum have it be blanked out.

Note again that after the account statement and the optional additional pages are printed for an account, this whole procedure may run again for another account in this report which is then appended in this same pdf.

I have attached a basic wireframe to show our use case, since I'm aware this is a lot.  I have a suspicion that this is something that could be accomplished using group headers and footers but could use some pointers on how exactly to configure them to do what we want here.  I mostly have experience writing reports that rely on grouping data sourced tables within the detail section, but this doesn't seem good enough for this report since we need data within the footer which has to have static vertical layout on each page and also match up with which account the detail is displaying.  

I can think of solutions or workarounds for most of these problems, but the footer is especially concerning.  Any help that could be provided to solve at least that issue would be greatly appreciated!  

Chloe
Top achievements
Rank 1
Iron
 answered on 10 May 2022
0 answers
270 views
Hello,
Im trying to implement the SendEmail function in my web app for Telerik Reporting.

My setup is like this:

I tried putting it in both the toolboxArea as global settings.
The Email button in the toolbar when previewing still isnt showing.
Does anyone knows what im doing wrong here?


I also implemented the sendmail message function as explained here: https://docs.telerik.com/reporting/using-reports-in-applications/host-the-report-engine-remotely/telerik-reporting-rest-services/implement-send-mail-message

Kind Regards,

Tristan
Tristan
Top achievements
Rank 1
Iron
 updated question on 09 May 2022
0 answers
145 views

I'm trying to make a graph interactive so that the table below shows the values for the column I clicked in the graph.

In my attached example "Graph-Table" I want the following to happen:

  1. Click on the bar 3/2019
  2. Only the 2019 group shows in the table below. All the rest of the years are hidden
  3. Click on the bar 1/2018
  4. Only the 2018 group shows in the table below. All the rest of the years are hidden

In the attached report, you see I tried adding some interaction, but I don't know how to get it to toggle/filter the data.

Marvin
Top achievements
Rank 2
Veteran
Iron
 asked on 07 May 2022
2 answers
138 views
Hello,

Im trying to disable the TRDP option when creating a new report. i want to only keep TRDX extention.
If possible i want to remove the whole dropdown section in New report and always add the TRDX extention to new files.

Ive also been searching if it is possible to edit/style/add attributes to the GUI views in the web app since the whole reporter is initialized with only a few lines of JS. Is it possible to see the code which generates these views or is this all API based?

Kind regards,

Ueskia
Tristan
Top achievements
Rank 1
Iron
 answered on 06 May 2022
0 answers
165 views

Hello,

I'm new to Telerik Reporting and hope you can point me in the right direction.

I'm working on a WPF application that will need to export a report to PDF. The user does not need to see the report directly prior to it being exported.

 

Currently I have a report file saved as a .trdp file, which I am able to export to PDF based of of existing examples.

Additionally, I've been able to add data to the report prior to printing successfully. I'm simply wondering if what I'm doing is the best way to accomplish my results.

 

I currently create a new UriReportSource and set the Uri to the local trdp file.

I think add parameters, one at a time to the reportSource...

reportSource.Parameters.Add(new Telerik.Reporting.Parameter("LogDate", "5/3/2022"));

 

Once the parameters have been added I use a report processor to render the report.

While this appears to work perfectly fine, I'm wondering if there's a more efficient method, such as passing a JSON string to a report.

If not that's fine and I'll make this work.

 

Any insight is appreciated.

 

Aaron
Top achievements
Rank 1
 asked on 03 May 2022
0 answers
153 views

Hello.

I have a simple report with a PageHeaderSection, DetailSection & PageFooterSection.

There are textboxes in the PageHeaderSection, including ones for column headers.  The ones towards the top of the section show fine but the textboxes for the column headers that are near the bottom of the section do not show in Preview mode.

If I move the column headers up higher in the section, they will show in Preview.  I am using the Windows (standalone) report designer.

Any help is appreciated.

Blair
Top achievements
Rank 1
 asked on 03 May 2022
2 answers
178 views

I would like to upgrade my version of Telerik Reporting from version 13 to 16, but the latest version that works well is 14.0.20.115, then I have some problems. I'm using the Designer for Visual Studio 2019 with the .Net Framework 4.

My report uses the NeedDataSource function to dynamically select the correct ObjectDataSource, but as of version 14.0.22.119 the Member function is never called.   No error is generated, it's just as if the dataSource was not defined. I also tried several other revisions (15.2 and 16.0) and got the same result. If I force a particular objectDataSource in the report, it works but I don't want to copy the same report 3 times just because I have 3 different objectDatasource.

This is what my NeedDataSource function looks like: 

private void MyReport_NeedDataSource(object sender, System.EventArgs e)
{
	CurrentReport = ((Telerik.Reporting.Processing.Report)sender);
	var paramProviderName = CurrentReport.Parameters.Where((param) => param.Key.ToLower() == "providername").Single().Value;

	switch (paramProviderName.Value.ToString())
	{
		case "provider1":
			DataSource = odsProvider1;
			break;
		case "provider2":
			DataSource = odsProvider2;
			break;
		case "provider3":
			DataSource = odsProvider3;
			break;
	}
}

As a second problem, my user functions no longer appear in the Edit Expression popup.

Is there a solution for these 2 problems?

Bridge24
Top achievements
Rank 1
Iron
Iron
 updated answer on 02 May 2022
0 answers
123 views

I working on learning Telerik reporting to replace our current ReportViewer implementations. Right now I'm trying to get a simple test case working. We current make a typed datatable as our report source and have an assortment of parameters to display on the report.  I'm having trouble finding the basic syntax to do this. 

Let's assume I have a the following pieces:

  • Report  - rptTestReport.cs
  • ReportViewer - ReportViewer1
  • Parameter on rptTestReport.cs called prmTestParameter
  • DataTable - dtMyData

How do I assemble all this together, connection the report to the reportviewer, the parameters to the report, and the datatable to the report?

This is what I have so far, but attaching the parameter to the report is wrong.

            UriReportSource reportSource = new UriReportSource();
            reportSource.Uri = "rptTest.cs";
            reportSource.Parameters.Add(new Telerik.Reporting.Parameter("prmTestParameter", "Hello World!"));
            ReportViewer1.ReportSource(reportSource);

I've found documents showing how to hard code the report to the reportviewer, but I need to do it in code.

Can anyone touch up my code with the right syntax to push me in the right direction?

Bernie
Top achievements
Rank 1
Iron
Iron
 asked on 02 May 2022
4 answers
538 views
Hello Where to set the thousand separator in a Web Report Designer?
Mateusz
Top achievements
Rank 1
Iron
 updated answer on 29 Apr 2022
1 answer
534 views

Hi

I have been looking around for a sample and found many links broken or for which the code is not working anymore (dating back from 2007-2010!)

  • I have a dataset containing multiple tables already in memory.
  • This dataset is created by the application (not directly coming from the database).
  • I have created a typed dataset from it to be able to create a report (including sub-reports for additional tables of my dataset)
  • How can I programmatically pass the tables[1] to the sub-report (call it srHoldings)?
  • I don't want to re-query the database, I want to use the dataset already in memory.
Top users last month
Will
Top achievements
Rank 2
Iron
Motti
Top achievements
Rank 1
Iron
Hester
Top achievements
Rank 1
Iron
Bob
Top achievements
Rank 3
Iron
Iron
Veteran
Thomas
Top achievements
Rank 2
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?