Telerik Forums
Reporting Forum
3 answers
255 views

     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.

 

 

David
Top achievements
Rank 1
Iron
Veteran
Iron
 answered on 27 Dec 2017
0 answers
125 views

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.
Kulasegaran
Top achievements
Rank 1
 asked on 27 Dec 2017
0 answers
76 views

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.

Ammar
Top achievements
Rank 1
 asked on 25 Dec 2017
1 answer
115 views

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.

 

kmnd
Top achievements
Rank 1
 answered on 22 Dec 2017
1 answer
222 views

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/

Todor
Telerik team
 answered on 22 Dec 2017
1 answer
336 views
I am interested in whether there is compatibility between Telerik Reporting and Microsoft Reporting. For example, in Microsoft Reporting, data can be passed as a Collection object to the ReportDataSource. Would Telerik Reporting accept in a similar way a Collection object (assuming the Data Source Object is set to ObjectDataSource)? Do Report Parameters behave similarly? In general, I am trying to determine how much of a (data structure) reorganization might be needed to switch from Microsoft to Telerik Reporting. Thanks.
Todor
Telerik team
 answered on 22 Dec 2017
0 answers
89 views
public TestReport()
        {
            var report1 = DeserializeReport(@"~\ReportBook.trdx");
            var report2 = DeserializeReport(@"~\ReportBook2.trdx");
            report1.DataSource = "DefaultConnection";
            report2.DataSource = "DefaultConnection";
            this.Reports.Add(report1);
            this.Reports.Add(report2);
            Reports[0].ReportParameters["templateId"].Value = 0;
            Reports[0].ReportParameters["scheduleId"].Value = 1953;
            Reports[1].ReportParameters["templateId"].Value = 0;
            Reports[1].ReportParameters["scheduleId"].Value = 1953;
        }
Aris
Top achievements
Rank 1
 asked on 22 Dec 2017
1 answer
169 views

Hi all, I have 2 SQL DataSources for my Telerik reporting. In coming time may be I need more than 10 SQL DataSource. Each SQL DataSource is applied for different table and each SQL DataSource refer different table in Database. The common thing between two tables is Parameter (that is "Product Code") and it will remain common for all SQL DataSources even in Future. 

I can able to successfully make the connection with database and when I run query in SQL DataSource it is giving me output but when I try to get same output in Table Wizard then I get an error: "Object reference not set to an instance of an object". Let me tell you I used same parameter for already existing two tables and I am trying to use it for third table, that time I am getting this error.
Can you please help?? Thank You

Todor
Telerik team
 answered on 21 Dec 2017
1 answer
162 views

Hi Telerik, I am asking question that has already answered in some other thread but not applicable in my case. I want to display list of images horizontally EG:

Img1    Img2    Img3

Img4    Img5

I can see in other threads that I can achieve it by using Group Explorer by setting property Field.MyDataIndex/3 and Field.MyDayaIndex%3 but the field that asked for is not there in my DataSource. In my case I am only getting "FileData" in DataSource nothing else. 

 

Can you please help me how can I achieve List of Images displayed horizontally.?

Thank You

Katia
Telerik team
 answered on 21 Dec 2017
1 answer
154 views

I store the xml layout of the report in my database, and use a custom resolver to create a ReportInstance when rendering the report. This all works great.

But when I start to use the "Navigate to report" action, I can't get it to work. In the winform reportviewer, I see the correct behavior. I can click on the textbox, and the 2nd report renders. Hower in the HTML5 ReportViewer, that textbox is not a click target.

I found this post https://www.telerik.com/forums/html5-reportviewer-navigate-to-reports-action-not-working, which says that it is by design when you use a custom resolver. Is there a workaround to still make it a click-target?

Silviya
Telerik team
 answered on 20 Dec 2017
Top users last month
Cynthia
Top achievements
Rank 1
Iron
Toby
Top achievements
Rank 3
Iron
Iron
Iron
Danielle
Top achievements
Rank 1
Iron
Iron
Joel
Top achievements
Rank 3
Bronze
Bronze
Iron
yw
Top achievements
Rank 2
Iron
Iron
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?