Questions on Reporting Forum

8 answers

358 views

List records with variable number of images

Hi guys,

I have the following datatable where question/answer records grouped by group name and might have the optional multiple photos.

Group Question Answer Photo PhotoIndex
G1 Q1 A1 photo1.jpg 1
G1 Q1 A1 photo2.jpg 2
G1 Q1 A1 photo3.jpg 3
G1 Q2 A2
G2 Q3 A3 photo4.jpg 1

I would like to display the report where each question/answer record also shows the corresponding images just below it using cross-down approach (let's say 2 images per line):

G1
-----------------------------------
Q1 A1
-----------------------------------
photo1.jpg photo2.jpg
photo3.jpg
-----------------------------------
Q2 A2
-----------------------------------

G2
-----------------------------------
Q3 A3
-----------------------------------
photo4.jpg
-----------------------------------

My approach was to use the List with two textboxes for question/answer and then placing the second List with the picturebox just below the question/answer textboxes. The first list was grouped by Fields.Group while for the picturebox list I was creating the row group with expression "Fields.PhotoIndex/2" and the column group "Fields.PhotoIndex%2" (following this post ).
But the photos always displayed vertically.

Any suggestions on how to achieve this layout, especially related to the images. There might be several images per question / answer record in my report, while some questions might have none.

Thanks,
Sergey.

General Discussions

answered on 02 Jan 2018

23 answers

2.2K+ views

Temporary Table in Stored Proc

I have been using the reporting with the SqlDataAdapter that points to a stored procedure. I have had no problems up until now. the stored procedure i'm trying to use, uses temporary tables inside it. it still returns a resultset just as if i used the select statement with a 'real' table. when i try and select the stored proc with the sqldataadpater, i get this message:

invalid object name #tempteams (which is the name of the temporary table within the stored proc).

any suggestions to get around this?

thanks,
susan

General Discussions

answered on 30 Dec 2017

0 answers

183 views

Print button cause app crash in WPF ReportViewer

Hi all,

facing quite strange behavior in WPF application where print button in Telerik ReportViewer does not show Print Dialog, insteadd the application crashes.

any ideas

Thanks

General Discussions

asked on 30 Dec 2017

0 answers

164 views

Telerik Reporting R3 2016 SP1 Not Working In Windows Server 2012 Virtual Machine(Azure & AWS)

Hi All,

I Deploy a Web Application in Windows Server 2012 Virtual Machine.The UI is Working fine.But the Report is not Working.But It works fine in Local host and the godaddy Sever.Same code is used for all environment i attached the Screen shot.Please any one try to help me to Resolve the Problem.

Thank you...

General Discussions

asked on 30 Dec 2017

2 answers

674 views

Getting a simple report parameter to work (ASP.NET MVC)

I am having a problem getting a report parameter to work in an MVC application. The goal is to have the report results filtered by student number. I have the parameter and filter configured in the report designer. I can apply the student number to the report when running the report in the designer so this problem is isolated to the MVC application specifically. Here is some of the key code that (I think) should be sufficient to understand what I am trying to do:

Inside HomeController:

public ActionResult StudentReport()
{
var uriReportSource = new UriReportSource();
uriReportSource.Uri = "Report1.trdp";
uriReportSource.Parameters.Add(new Parameter("StudentNumber", "120432"));
return View();
}

Inside StudentReport.cshtml:

<body>
@(Html.TelerikReporting().ReportViewer()
.Id("reportViewer1")
.ServiceUrl(Url.Content("~/api/reports"))
.ReportSource(new UriReportSource() { Uri = "Report1.trdp" })
.ViewMode(ViewMode.Interactive)
.ScaleMode(ScaleMode.Specific)
.Scale(1.0)
.PersistSession(false)
.PrintMode(PrintMode.AutoSelect)
.EnableAccessibility(false)
)

</body>

The error I am getting is: An error has occurred while processing Report 'Report1': Cannot perform '=' operation on System.Double and System.String.

General Discussions

answered on 28 Dec 2017

3 answers

264 views

[Solved] New Question: Loading ADO.Net Datatable to objectdatasource

Could someone please explain to me how to do the following. I have the following ADO.NET table created in the report source (shown below). How do I make the data available in a report.

Our company has been creating a DataSet.xsd in the solution and then add a report dataset that is set to the table in the DataSet.xsd. Then we add a ObjectDataSource, set it's DataSource to the DataSet in the report and then bind the report (ie: set the report datasource) to the ObjectDataSource. This will make it's fields available in the report. Note: We load the ObjectDataSource in the report source, ie: DataSet.ObjectDataSource.Load(dtSource). The problem with this method is that it requires you to add a new table for your report to the DataSet.xsd everytime you want to pass something that hasn't already been created to the xsd.

Is there a way to just add a blank dataset to the report, set a ObjectDataSource.DataSource to the dataset and then just load the dataset in the source? ie: Skip the DataSet.xsd part?

dt As New DataTable
Dim row As New DataRow

dt.Columns.Add("Id", GetType(Integer))
dt.Columns.Add("FirstName", GetType(String))
dt.Columns.Add("LastName", GetType(String))

row = dt.NewRow()

row("Id") = 1
row("FirstName") = "John"
row("LastName" = "Smith"

dt.Rows.Add(row)

Thanks in advance.

General Discussions

answered on 27 Dec 2017

0 answers

135 views

Telerik Report - Windows task scheduler

I have Telerik report with a sub report attached. Both have .trdx extension
There is a exe program which passes parameters to the main report and call to print.

The report prints fine when clicking the print button of the exe program.

But when the exe is scheduled using windows task scheduler it gives an error saying
"Could not find file 'C:\Windows\system32\MySubreportName.trdx'."

Please help.

General Discussions

asked on 27 Dec 2017

0 answers

83 views

Upgrade WPF Telerik Report To 11.2.17.1025

Hi Team,

I had to upgrade Telerik Report Designer from 11.0.17.222 to 11.2.17.1025,

It is working well for Telerik HTML viewer But in WPF, it is previewing the report well, but when I export the report to PDF, the report is very bad, I attached two files, one for the exported report from the pervious version and anther from the new one.

It is affect in many thing all of the Images is not working fine, it streched and the images is far away from the table

Thanks,

Ammar Assem.

General Discussions

asked on 25 Dec 2017

1 answer

127 views

report refresh and documentname issue

Hi. I have a report and I set report's documentanme in Needdatasource event like below:

((Telerik.Reporting.Processing.ProcessingElement)(sender)).Report.DocumentName = string.Format("{0}{1}_Report", dto.Name,dto.Surname);

I wrote this code before setting the report's Datasource. (I also try after setting the report's datasource).

When I click export button on report, it downloads document right name(for exmaple johnwhite_Report). Then I click refresh. Then I click export button again. This time, document name becomes Report. It does not show person name and surname.

Why does this happen. Any idea?

Thanks in advance.

General Discussions

answered on 22 Dec 2017

1 answer

232 views

WPF ReportViewer cookie behavior

I am trying to use the WPF report viewer with Telerik Reporting REST service deployed on a web farm using FileStorage. Previously, with the WCF service and Silverlight viewer, I was able to deploy on a web farm using cookie-based persistence on our load balancer. After migrating to the WPF viewer, it appears as though the WPF client is not persisting cookies properly between sessions.

When I first load a report, the viewer registers a new client, the response contains a Set-Cookie header, and then subsequent requests to create instance, create document, get document info, and get document page all include the persistence cookie.

If I refresh the report, however, the viewer makes a request to get report parameters or create a new instance and does _not_ include the persistence cookie with the request.

Does the WPF report viewer create a new HttpClient with each request? It should be using a shared singleton instead, as per: https://docs.microsoft.com/en-us/azure/architecture/antipatterns/improper-instantiation/

General Discussions

answered on 22 Dec 2017