Telerik Forums
Reporting Forum
0 answers
87 views
I am trying to convert an application that uses MQL Reporting Services to telerik Reporting. I favor the design, layout, and ease of implementation using telerik's product; however, I am at a serious crossroads concerning charting (since I already pay for telerik's product it seems rather un-frugal use of money and time using another product). The charting part of the reporting lacks seriously in design-time configuration and in printing (whether to paper, pdf, excel, etc). It seems as if the charting component is just an afterthought and now just sits in the toolbox un-enhanced so it can be touted as a feature without any further development...a web page bitmapped component slapped into the reporting toolbox.
 
I understand that a charting component is a complicated piece; but this product has already been out a couple years and fancy-type stuff is being added to puff up the feature set while this 'bread and butter' functionality gets ignored. For the most part, I cannot use this product in fear someone will want a chart and I will NOT be able to produce a professional out.

Perhaps I am in the minority and either the ability to actually print a report on paper or charting is not used by anyone.

Am I one of only a few people that this affects?

John
John S.
Top achievements
Rank 1
 asked on 05 Jan 2011
1 answer
1.1K+ views
Reporting Q3 2010.

I have a report and all it has is a detail section. In the details section I have a table that has only one column. In the column I have a sub report. I want there to be a page break after each instance of the sub report (i.e. after each detail or row on main report). I tried to add a page break on the sub report itself after the details section but that does not work.

Thanks,

Billy Jacobs
Peter
Telerik team
 answered on 05 Jan 2011
1 answer
250 views
Hi,

We have a SharePoint 2007 farm hosting several pages containing various terlerik controls. One specific page produces reports thanks to Telerik Reporting. The page works on our development environments but fails in Test and QA environments. Those are both set as follow:

VMWare 3.5.0 build-213532
Windows 2003 Std x64 SP2
4 GB RAM
IIS 6.0
Sharepoint 2007 SP 2 - 12.0.0.6421

We receive the following error:

Server Error in '/' Application. Attempted to read or write protected memory. This is often an indication that other memory is corrupt.
The stacktrace points to the System.Drawing.Gdip.GdipSaveImageToStream method - Please see file attached.

We followed many leads (web.config, users' rights, database, asp temporary folders, perfmon....) but could not sort this issue. The event viewer does not show any event related to that issue. The SharePoint ULS do not show any line related to this issue. The IIS logs do not show any lines related to this issue. There is no memory or cpu peaks occurring any time on the server.

The page is built with a Telerik.ReportViewer.WebForms.ReportViewer  hosting a Telerik.reporting.Report. This report contains 8 charts using various fields from a result set returned by a stored procedure. To improved performance, this sproc is called once - the data is retrieved for the first chart only and reused to bound the 7 other charts (every chart NeedDataSource event points to Chat1_NeedDataSource method).

Interestingly, if we select incorrect parameters before requesting the report execution hence retrieving some invalid data that causes most charts to fail (6 out of 8), the remaining charts are rendered correctly. This seems consistent with the error message, that is, the more charts are being rendered the more risks of the error occurring.

This is the only page using Telerik.Reporting. Other pages use Telerik controls (including RadChart) but do not display the issue. The size of each chart checked on development environments is around 7Kb. The size of the chart created on another page via RadChart is 35Kb.

Have you ever seen anything like this?

Please let me know which information you need to help us.

Thanks,
Best regards,

Youss'

Steve
Telerik team
 answered on 05 Jan 2011
3 answers
244 views
OK, I'm using a ObjectDataSource. I know the Data Source works fine, because if I plug it into a telerik grid I have no issues at all.

When I try to show it in the report viewer in aspx I have to go through a lot of stuff, but the report works... so it's not a show stopper.

It would be nice to be able to view small changes I make on the report with the designer preview instead of having to run my project every time I want to see if a font change looks right or not.

The error message I'm getting is: 
An error has occurred while processing Report 'HealthInspectionRpt':
Exception has been thrown by the target of an invocation.
------------- InnerException -------------
Object reference not set to an instance of an object.


this is in the designer.

when I view it with a report viewer on an aspx page, this is how I have to load it from the code behind...
if (!Page.IsPostBack)
      {
            Telerik.Reporting.ObjectDataSource obDS = new Telerik.Reporting.ObjectDataSource();
            obDS.DataSource = typeof(HealthInspectionRptData);
            obDS.DataMember = "GetHealthInspectionReport";
            obDS.Parameters.Add(new Telerik.Reporting.ObjectDataSourceParameter("ProgramYear",typeof(int),    
                  (int)min2ProgramYearChosen));
             obDS.Parameters.Add(new Telerik.Reporting.ObjectDataSourceParameter("ProgramID",typeof(int),
                  (int)mudtProgramID));
                              
             Telerik.Reporting.Report rpt = new HealthInspectionRpt();
                 
             rpt.DataSource = obDS;
 
             rptViewer.Report = rpt;               
             rptViewer.RefreshReport();
                 
             //HealthInspectionRpt hInspRpt = new HealthInspectionRpt(min2ProgramYearChosen, min4SponsorID, mudtProgramID);                               
             //rptViewer.Report = hInspRpt;
}

I was thinking that the commented out part here at the bottom would have covered it... but it gives me the same error as the designer.

Anyone ever run into this issue?

Thanks,

Dustin
Steve
Telerik team
 answered on 04 Jan 2011
1 answer
72 views
Hi,

Since most of the time the reports generated in my project are huge and time-taking, i was wondering if there is any mechanism by which Telerik Reporting could output the instantaneous percent complete status during report generation. It would add more appeal to the site and keep the end-user more informed.

Thanks,
Danny.
Steve
Telerik team
 answered on 04 Jan 2011
5 answers
789 views
  I have a report which has some table controls on it. This report also has embedded subreports on it. I have the requirement of taking some info about the user(username) from my web app and passing it as a parameter to my telerik report. I have watched the video for paramterized queries (here) and am trying to model after this. It works....only sort of... 
   What is weird is that the parameters are passed just fine to my subreports . I use the NeedDataSource Event to do so. For some reason, when I try to pass the parameters to the queries (I am calling stored procs) that populate the table controls(again these controls are directly on the report),  these values get lost somehow.   Very weird, as I would think the the exact opposite would potentially be the case.
  I turned sql profiler on and I can see the queries running for the table controls with a blank string " " for the parameters that are suppose to be passed. Even weirder is if I make the paramers visible in the automatic UI, (while making absolutely certain that no value has been hardcoded for them in the properties window of Visual Studio, Value field is blank) I do in fact see the values in the automatic UI that are supposed to be passed to the report.  I tried using the different events(NeedDataSource, ItemDataBound, etc) to bind the table controls but to no avail.
   Based on what I'm experiencing I would think there is something about the report life cycle that I am currently not understanding, but I am not sure. Below are my code snippets with comments. If you can offer any direction I would be greatly appreciative. -Jason
//this from my .aspx codebehind  
 
 
public partial class reporting_rep_invprodby_newlook2 : System.Web.UI.Page  
{  
    protected void Page_Load(object sender, EventArgs e)  
    {  
            string username = User.Identity.Name;  
            MasterReport report1 = new MasterReport();  
            ReportViewer1.Report = report1;  
            //setting the value of Param1 in the line below  
            report1.Param1 = username;  
     }  
 ------------------------------------------------------------------------------  
 
//this from the telerik report codebehind  
     
 
// Here is a sample query where the value for @ousername_vc   
//(this.ReportParameters["ousername_vc"].Value) gets lost  
   
SqlConnection connSomsys = new SqlConnection(@"Server=cmdivst004\Jason08;Integrated Security=false;Database=QuoteDB; Persist Security Info=True;User ID=gggg;Password=gggg");  
 
SqlCommand selectLastYearTot;  
selectLastYearTot = new SqlCommand("sprocgetOrdertotlastyear", connSomsys);  
 
selectLastYearTot.CommandType = CommandType.StoredProcedure;  
 
selectLastYearTot.Parameters.AddWithValue("@ousername_vc"this.ReportParameters["ousername_vc"].Value);  
 
adapter3.Fill(dataSet3);  
this.table3.DataSource = dataSet3;  
 
//this is for one of the subreports in the NeedDataSource Event   
//for the subreport, it works fine  
 
SqlConnection connSomsys = new SqlConnection(@"Server=cmdivst004\Jason08;Integrated Security=false;Database=QuoteDB; Persist Security Info=True;User ID=cmdiapp;Password=adiadmin");  
Telerik.Reporting.Processing.SubReport report =(Telerik.Reporting.Processing.SubReport)sender;  
 
SqlCommand selectCommand;  
selectCommand = new SqlCommand("sprocgetaccountingorders", connSomsys);  
selectCommand.CommandType = CommandType.StoredProcedure;  
//works fine right here line below  
selectCommand.Parameters.AddWithValue("@ousername_vc"this.ReportParameters["ousername_vc"].Value);  
SqlDataAdapter adapter = new SqlDataAdapter(selectCommand);  
DataSet dataSet = new DataSet();  
adapter.Fill(dataSet);  
report.InnerReport.DataSource = dataSet;  
connSomsys.Dispose();  
 
//Here is the property I created to take in the value of the username  
//much like the video  
   public string Param1  
        {  
 
            get 
            {  
                return (string)this.ReportParameters["ousername_vc"].Value;  
            }  
            set 
            {  
                this.ReportParameters["ousername_vc"].Value = value;  
            }  
        }  
 
         
Sebastian
Top achievements
Rank 1
 answered on 04 Jan 2011
2 answers
141 views
I'm curious whether or not Telerik is already working toward speeding up Telerik Reporting with the new printing features of Silverlight 5.  I have worked with Telerik Reporting for the last 6 months and it's very nice but very slow. 

thanks,

Tim
Timothy Kelley
Top achievements
Rank 1
 answered on 03 Jan 2011
0 answers
90 views
I am trying to set up multiple parameters for a report.  The first has a datasource that lists a series of dates from a table.  This is no problem. What I want to do is calculate an 'end date' value for the second parameter based on the date selected in the first parameter and then pass the two parameters to the SQL statement that is the datasource for the report.  I know how to accomplish the second part and have written the calculation procedure I need in a class module.  What I can't figure out is how to invoke the procedure when the user selects a date in the first parameter. Thanks for any suggestions
Chuck Harrington
Top achievements
Rank 1
 asked on 31 Dec 2010
2 answers
102 views
hi,

i need to show dates calender grid/matrix in the report like
---------------------------------
jan       01 02 03 ... 31
Qty           7    2
Mar     01 02 03 ... 31
Qty       3       6
---------------------------------
so what is the best way to design that matrix consider that more rows might be required beside the Qty. i thought of doing that fully in the code-behind by formatting the matrix as html then include it in the detail section. please recommend the best flexible approach to design that?

thanks,
Mazen Bteddini
Top achievements
Rank 1
 answered on 31 Dec 2010
2 answers
120 views
Hello,

I have used crystal reports a little bit, but I am totally new to Telerik Reporting. I have successfully created a report with a sub report, but I need help with how to do something. I am basically creating a receipt, but instead of each item being repeated as text, the item will be displayed as a certificate. Basically, the customer can purchase one set of different types of certificates. Each set can have a different amount of certificates. Some certificates have 2 per package and some can have 5. I have successfully created a report that displays the customer address information and summary information. I have also created a sub report in that report that gets each item the customer purchased and uses an image as the background with text over the top to be printed out to create the certificate. So if they purchased two sets of certificate it will display two certificates currently. What I haven't been able to figure out is how to repeate the certificate in the report to match the number of certificates that come in a package. I do get the value telling me how many certificates come per package, I just don't know how to use it to repeat the output. Is that possible? If so, how can I make that happen?

I hope I have explained this clearly. I am not always the best at explaining things.

Thank you.

Ben
Benjamin
Top achievements
Rank 1
 answered on 31 Dec 2010
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?