Telerik Forums
Reporting Forum
10 answers
1.0K+ views
I am attempting to build a report with the Q2 2011 reporting tools but am running into numerous issues that are really confusing me. The report itself is part of an existing web project (not in a separate library) where an existing web.config has connection strings specified. When I try to create a new SQL data source the connection strings box lists all of my connections that show up in Server Explorer, but it won't list anything in my web.config. When I let the wizard create a new connection entry (which is identical to the existing one) the report generates  until I add a table and link it to the data source (which it created). At that point it tells me it can't connect to the DB because the connection name may be incorrect. I've confirmed the connection string it created is in the web.config but it still acts like it can't find it. I know the connection strings themselves aren't an issue as I created a new project, copied from the "old" web.config to the new one and they show up in the wizard and everything functions great. The database definitely isn't going down either as it is running on my local box.

Any ideas on what might cause this? I also tried an ObjectDataSource (using my LinqToSql objects) and in the code-behind of the report set the data source of that to a linq query but it won't run it (it was setup in the constructor).
Peter
Telerik team
 answered on 12 Apr 2013
1 answer
113 views
Hello,

I have download and install the actual Telerik Reporting TRIAL. I will try to make a sample but when i drag the ReportViewer-Control to a WPF-View.

It come a error up: "Telerik.Windows.Controls is missing"

What is missing? Which licenses I must buy if I want to use only "Telerik Reporting"?
Stef
Telerik team
 answered on 12 Apr 2013
1 answer
74 views
I've been trying to resolve this issue for over a week now and there's a huge demo of my customer's new site this week and I just cannot solve this issue.  It seems like such a minor thing yet it's causing a huge headache.  I finally tracked down what was causing it but I cannot seem to get around it.

I have a report that has a table inside of it with a 2nd data source.  It displays the data perfectly except for the fact that the text is right up alongside the table cells. If I try to add padding to the table cells it causes some serious display problems.  I've attached two screen shots.  One is the HTML Preview of my report Without padding and one With padding.

This display issue only occurs in HTML not in Print Preview and it exports just fine.  They preview the report through the Telerik WebForm Report Viewer however so I need it to show up appropriately in HTML.

Milen | Product Manager @DX
Telerik team
 answered on 11 Apr 2013
3 answers
126 views
Hello,

I want to generate reports from a Silverlight application. As I saw from the demo, I need to have a ReportViewer in a user control, set the Report Service URI, and set the name of the report. How can I pass the data context of the report from Silverlight to the reporting service?
Peter
Telerik team
 answered on 11 Apr 2013
3 answers
112 views
Hi Telerik Team.
I am new on Telerik reporting and I have looked for any information about what I want to do but any success.
I am trying to do a report which the source is an object I create from my model, which model has a navigation property which is a collection.
For example I create an Object ClassRoom(name, grade, code, amount students, etc) and I have a collection of student belong to that ClassRoom (which is a navigation property in my model), I also have a navigation property in my Entity Studen which is subjtects (Math, English, Spanish, etc), when I create my Object ClassRoom (my datasource) I CANT access to the collections when I am doing my report.
Please if someone can tell me what can I do? I would like to show in my report for example:

ClassRoom 1
Grade First
Code CLAS001
Amount Student 30

Details
Peter   12 years old   Math-9   English-8  Spanish-6
Tom     12 years old   Math-9   English-8  Spanish-6
Pep     12 years old   Math-9   English-8  Spanish-6
Rick     12 years old   Math-9   English-8  Spanish-6

In other things my Object is this was: ClassRoom has Students and Students has Subjects (there are navigation properties collections)
Thanks in advance!
Peter
Telerik team
 answered on 11 Apr 2013
1 answer
254 views
Hi,
       I am am trying to export a report programmatically to then attach to an email. The report runs correctly and is save as expected, I just cannot get the parameter values to pass through to the report, I have followed the advice in the following two articles:

The report being used is used elsewhere in the website in a ReportViewer control wheer it's parameters are set prgramatically and it works correctly.

This is the code I am using is below:
public static string ExportToPdf(string documentName,int periodId, int pupilId)
   {
       ReportProcessor reportProcessor =  new ReportProcessor();
       Hashtable deviceInfo = new Hashtable();
 
       InstanceReportSource instanceReportSource = new InstanceReportSource ();
 
       instanceReportSource.ReportDocument= new ARView2();
       instanceReportSource.ReportDocument.DocumentName = documentName;
 
       instanceReportSource.Parameters.Add(new Telerik.Reporting.Parameter("PeriodID", periodId));
       instanceReportSource.Parameters.Add(new Telerik.Reporting.Parameter("PupilID", pupilId));
 
       RenderingResult result = reportProcessor.RenderReport("PDF", instanceReportSource, deviceInfo);
 
       string fileName = result.DocumentName + "." + result.Extension;
       string filePath = Path.Combine(Path.GetTempPath(), fileName);
 
       using (FileStream fs = new FileStream(filePath, FileMode.Create))
       {
           fs.Write(result.DocumentBytes,0,result.DocumentBytes.Length);
       }
 
       return filePath;
   }

Do you have any ideas as to why my reports is not receiving the parameters as passed to it. This code is setting the parameters via code but using a ReportViewer to see the result, this works as expected.
if (e.Item.Level == 0) return;
 
           string[] parms = e.Item.Value.Split(':');
 
           int periodId = Convert.ToInt32(parms[0]);
           int pupilId = Convert.ToInt32(parms[1]);
 
           var rpt = new ARView2
               {
                   DocumentName = string.Format("{0} {1} {2}",cbPermittedPupils.Text.Trim().Replace(",",""),
                                                       pbARList.SelectedItem.Text.Trim(),
                                                       ((RadPanelItem)pbARList.SelectedItem.Parent).Text)
               };
 
           rvAR.ReportSource = new InstanceReportSource { ReportDocument = rpt };
           rvAR.ReportSource.Parameters.Add(new Parameter("PeriodID", periodId));
           rvAR.ReportSource.Parameters.Add(new Parameter("PupilID", pupilId));
           rvAR.RefreshReport();


 I am using Q3 2012 (6.2.12.1017) in an ASP.NET 4 website.

Thanks

Chris


Chris
Top achievements
Rank 2
 answered on 11 Apr 2013
3 answers
546 views
I have a report that has anywhere from 1 to 6 pages depending upon the amount of data. At the very last page, at the very bottom of that last page, I need to do some summary data.

I tried the footer, but that showed up at the bottom of every page. I tried group footer, but that just showed up at the end ot the group--which sometimes was at the top or middle of the page. Any thoughts of how I could accomplish this?
Squall
Top achievements
Rank 1
 answered on 11 Apr 2013
9 answers
1.4K+ views

How can I pass the datasource to a subreport from a page?

Ex: "ReportViewer1.Report.SubReport.DataSource = ds"

[]'s

Henrique

Arun
Top achievements
Rank 1
 answered on 10 Apr 2013
2 answers
170 views
Hi

I have a report of a some complex nature, in which a bunch of subreports and/or sections are included inside the detail section.  The problem is that the report starts showing detail section data on the second page.  Quite obviously the solution for this problem would be to set the KeepTogether property to false on the detail section (I have them already on each sub report object) but I cannot be done in such section.

How could I achieve the detail section dividing so data gets display on the first page?

Any suggestions would be appreciated!

Neftali Figueroa
nfigueroa
Top achievements
Rank 1
 answered on 10 Apr 2013
1 answer
59 views
Hi,
I have several textboxes in the report. They are all set CanGrow according to the amount of text inside them.But there is a problem in it.
When the text is long, the text  will overstep boundary of the textbox. But the textbox actually has grown, like the following picture.

Any known issues or pointers to what the problem may be?

Regards
Milen | Product Manager @DX
Telerik team
 answered on 10 Apr 2013
Top users last month
Rob
Top achievements
Rank 3
Iron
Iron
Iron
Atul
Top achievements
Rank 1
Iron
Iron
Iron
Alexander
Top achievements
Rank 1
Veteran
Iron
Serkan
Top achievements
Rank 1
Iron
Shawn
Top achievements
Rank 1
Iron
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?