Telerik Forums
Reporting Forum
3 answers
2.4K+ views
Hello,
a simple question:
i have a sort of dashboard page where are shown  5 tables.
Each table has a datasource , each datasoure is the collection resulting by LINQ statements.

Let say one of this tables haas 2 columns. How i can get the sum of the values of a column and put the result at the fott of that column?

COL1    COL2
a            2
b            3
              5 =====> this is what i'am asking for 

thanks
Steve
Telerik team
 answered on 12 Aug 2011
2 answers
128 views
I'm using Telerik 5.0.11.510  and I'm unable to get Arial to appear bold on my font if the size is < 7.5pt.  Is there a fix I can get for this?
Shane
Top achievements
Rank 1
 answered on 12 Aug 2011
1 answer
152 views
Hi,

I have a report containing a subreport with figures that I want to subtotal on each page (for only the figure displayed on each individual page) and then I want a grand total for the subreport figures on the last page (all figures across all pages).

Currently I have the grand total working but unfotunately I cant find a way to do a subtotal per page. I basically need something like how the PageExec() works to allow me to sum up the data on that page, but obviously subreports dont have a page footer so this doesn't work. I have tried the Exec() but I can't set the scope to only the data on the page. Maybe if there was a way for passing the Exec() a scope with just the data on display on the page this would work but I guess the PageExec() was built to do this but without subreports in mind.

Please can anyone help me with this problem?

Thanking you in advance
Peter
Telerik team
 answered on 12 Aug 2011
1 answer
157 views
So far I have enjoyed the telerik rich suite of products.  My customer really likes the dashboard I created for them in silverlight using your chart tools.  Thanks for your great tools!

This issue has to do with reporting.

I just updated to 5.1.11.713 Q2  (from 2011 Q1 reports).  I had production reports working and they were pulling the connection string information from the Web.config of the reporting Service.  I also had them working in the designer.  I was happy about it.

According to this article here:
http://www.telerik.com/community/forums/reporting/telerik-reporting/passing-connection-string-to-sub-report.aspx  I shouldn't have been able to do that.  But I promise that I did.

Additionally in the article you consider it best practices to continue to use the settings file instead of the web.config file.  In the above example, I didn't use a settings file, but now the SQL Data source automatically generates it.  This causes a problem when you have multiple environments ie (development, test, production) and you have to recompile your code for each deployment.  For separation of powers, it isn't practical to have a developer change the settings file and republish it to each environment.
 

For some reason it appears that the upgrade broke this setup.  I didn't think it would be possible, but so far the solution evades me ... I need to be able to run my reports in the designer for testing them, and I need to be able to compile/publish once, and then just change the web.config for each environment I deploy to.

Could you please provide an example of how I can run my reports in VS2010 IDE designer, while still not depending on the settings settings file in deployment to various environments but depending on the web.config of the service.


Steve
Telerik team
 answered on 12 Aug 2011
1 answer
116 views

Hello:
Any help is appreciated with this error.

I do not get this error when I run the report on my local machine, but only when I deploy it to a different server (Win 2K8 R2).

I researched on the web and found that there is no support yet for MVC 3, but I was wondering whether anyone out there had the issue and found a solution.

Please let me know any specific information regarding the application that will help you answer.

Here is the code for my view:
==

 

<%

@ Page Language="C#" Inherits="System.Web.Mvc.ViewPage<BVReport>" %>

<%

@ Register Assembly="Telerik.ReportViewer.WebForms, Version=5.0.11.510, Culture=neutral, PublicKeyToken=a9d7983dfcc261be"

Namespace="Telerik.ReportViewer.WebForms" TagPrefix="telerik" %>

<

script runat="server">

protected override void OnPreRender(EventArgs e)

{

rvReport.Report = ViewData.Model;

base.OnPreRender(e);

}

</

script>

<!

DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">

<

html>

<head runat="server">

<title>BVReport</title>

<style type="text/css">

html#html, body#body, form#form1, div#content, center#center

{

border: 0px solid black;

padding: 0px;

margin: 0px;

height: 100%;

}

</

style>

</head>

<body>

<form id="Form1" runat="server">

<telerik:ReportViewer Width="100%" Height="100%" ID="rvReport" runat="server" />

</form>

</body>

</html>

Steve
Telerik team
 answered on 11 Aug 2011
4 answers
114 views
We have a ReportViewerExtension that casts an instance of Telerik.ReportViewer.WebForms.HttpHandler as IHttpHandler.  This has worked for years, but no longer runs after installing Q2 2011, throwing a run-time error that "Unable to cast object of type 'Telerik.ReportViewer.WebForms.HttpHandler' to type 'System.Web.IHttpHandler'."
Any ideas what happened (and how to resolve)?
Best,
Scott
Chavdar
Telerik team
 answered on 11 Aug 2011
3 answers
188 views
Hi Guys

We are using the reporting module to produce a printable document out of our database system. Some of the input fields that form the record we are reporting on use the RadEditor to allow our users to be more descriptive with their input.

The problem we are seeing at the moment is, when we export the report to RTF, the actual html which is input in the report is being shown in the exported document.

Everything works OK when viewing in the report viewer.

Any thoughts?

Shane
Peter
Telerik team
 answered on 11 Aug 2011
1 answer
171 views
Hi,
when i try and run a complex stored procedure using sqldatasource:

      this.sqlDataSource1.SelectCommandType = Telerik.Reporting.SqlDataSourceCommandType.StoredProcedure  ;
      this.sqlDataSource1.SelectCommand = "myProc";
      crosstab1.DataSource = sqlDataSource1;

 it does NOT return any results.

if i use text:      this.sqlDataSource1.SelectCommandType = Telerik.Reporting.SqlDataSourceCommandType.Text   ;
      this.sqlDataSource1.SelectCommand = "EXEC myProc";
      crosstab1.DataSource = sqlDataSource1;


This used to work until i had to upgrade to:  4.2.10.1221

What do i need to do, 
i need to execute as StoredProc as i pass in parameters.etc.

I've verified if i made a simple proc, and do:

      this.sqlDataSource1.SelectCommandType = Telerik.Reporting.SqlDataSourceCommandType.StoredProcedure  ;
      this.sqlDataSource1.SelectCommand = "mySimpleProc";
      crosstab1.DataSource = sqlDataSource1;

it also works.

The complex proc has temp tables, and calclations,etc...

Also when using the crosstabwizard or reporting wizard, the columns comeback but executing the the proc "myProc" also does NOT give results in preview.



Frank Flores
Top achievements
Rank 1
 answered on 11 Aug 2011
4 answers
213 views

 I want to apply a watermark type image on the report but want to change it dependant on the state of the document content i.e. if i had a Perameter that returned a string of "Draft" i would want to apply the Draft image to the whole report likewise if the function returned "Approved" i would want to apply the Approved image instead?
arellano
Top achievements
Rank 1
 answered on 11 Aug 2011
2 answers
241 views
I'm very new to telerik reporting, I'm sure I'm missing something;

I have a simple report that has a text box
I have the following classes in the report.cs
class DealerDataSource
{
    public IEnumerable<CalDealer> GetDealerInfo()
    {
        DAdbDataContext xxx = new DAdbDataContext();
 
   //     Dealer deal = db.Dealers.First(d => d.DealerId == 2);
        CalDealer cd = new CalDealer();
        cd.Title = "Test";
        yield return cd;
    }
}
 
public class CalDealer
{
    public string Title { get; set; }
}

 

 

When I add the data context and go to preview the report it gives the error of
"object reference not set to an instance of an object". 
It compiles OK -

If I take out DAdbDataContext xxx = new DAdbDataContext(); the report previews fine.


I know the data context is good as I'm using it in the code behind of a page.

 

 

 Thanks!!

Ron

 


Ron
Top achievements
Rank 1
 answered on 10 Aug 2011
Top users last month
Rob
Top achievements
Rank 3
Bronze
Bronze
Iron
Sergii
Top achievements
Rank 1
Iron
Iron
Dedalus
Top achievements
Rank 1
Iron
Iron
Lan
Top achievements
Rank 1
Iron
Doug
Top achievements
Rank 1
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?