Telerik Forums
Reporting Forum
3 answers
258 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
214 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
257 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
286 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
3 answers
148 views
I'm trying out the new Q2 2011 version 5.1.11.713 features.
I keep reading the "Whats new" section and I'm seeing talk about these new caching features; however I am a little confused.

Does caching only work when using the WCF Reporter Service Implementation?
Can I use the caching features with the standard ASP.net web viewer control?
Will caching work in an out of proc session state set up?

I've been searching through documentation and i can't seem to find hardly any on these subject. 

My reports are larger reports and are throwing out of memory exceptions when running in out of proc session (web farm).
I've read numerous forum post on these issue and have read the design considerations. 
Just wanted to look into the caching options to maybe reduce these errors, but i can't find any documentation or guide on the caching topics.
I would like some more information if anyone could help. 
Any information regarding caching or memory exceptions would be great.
Peter
Telerik team
 answered on 10 Aug 2011
10 answers
1.5K+ views
Is it possible to change the background image on a report based on a parameter or value returned by a function ?

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 function 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?

Is this possible ? if so could someone explain how to achieve this. If this isnt possible is there any work arounds ?

Thanks  
Steve
Telerik team
 answered on 10 Aug 2011
2 answers
216 views
Hi

I have a very simple question : Is it possible to change the value of the label on the X Axis. In fact, what I want is to replace the number under the bar (bar chart) by a date (Look the attached file to see what I mean)? For me, it seem that it should be possible and really easy to do, but I look in the doc and it seem that only number can be set to the X axis label. So, is it right or is it a way to do what I want ?

Thank you,
David
David
Top achievements
Rank 1
 answered on 10 Aug 2011
1 answer
73 views
I have a report containing in section detail chart. If it is rendered to PDF (programmatically) all ok.
If render to a different format (rtf, docx, xls, xlsx, image), all charts are the same as in the last record.
Using Telerik Reporting Q2 2011.
Steve
Telerik team
 answered on 10 Aug 2011
1 answer
182 views
I have a ReporViewer and a bunch of reports.  There are a couple reports where I don't want the toolbar visible. (reportViewer.ToolbarVisible = false).  When switching reports in code, I can set the visibility of the toolbar just fine. But I can't figure out how to set the visibility when switching reports using either the navigation buttons (forward/back) or when a report is viewed by clicking on a link (textbox with Navigate action) in another report.

Is there a way to set the ReportViewer's ToolbarVisibility from within a report?  Or is there an event in the ReportViewer that fires when the Report property is changed?

Thanks,
Justin
Steve
Telerik team
 answered on 10 Aug 2011
0 answers
202 views
I have a report that takes a single parameter and uses that in an ObjectDataSource to query data for the report. I would like to embed that report in the detail section of a master report, which accepts an array of int's as a multivalue parameter. Each element of the parameter array would be passed to the subreport. That way I would get a set of pages, each a subreport. I haven't found an example of how to set this up. Any help would be appreciated.

Steve
neebs
Top achievements
Rank 2
 asked on 10 Aug 2011
Top users last month
Tien
Top achievements
Rank 1
Iron
Krasimir
Top achievements
Rank 3
Bronze
Iron
Iron
Cedar
Top achievements
Rank 1
Iron
Emil
Top achievements
Rank 1
Iron
Kyle Watson
Top achievements
Rank 1
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?