Telerik Forums
Reporting Forum
12 answers
326 views
I am trying to set up multiple sub reports within an unbound main report.  Each has its own sqldatasource connecting to MS Access tables.  Individually the subreports work fine.  Placing each one individually into the main report they work fine but if I put both in, one of them does and one of them doesn't - I get the  'An error has occurred while processing TextBox 'dateDataTextBox':
The expression contains object 'CalDate' that is not defined in the current context.'  error.

Here is the weird bit - I tried this with two subreports that, by chance, have the same field name (completely different source tables though).  And the report with the error showed the field value from the other report.  In other words one report is looking at the other's datasource.  The datasources have different names, though they have the same connection string. 

This is all just working in the report designer. Using Q3 2010 in VS2010.  Does anyone have any ideas?

Thanks
Clive
Peter
Telerik team
 answered on 04 Oct 2011
1 answer
259 views
I have a base report class which defines a common header and footer for all reports.  By default the base report is setup as Letter size page in portrait orientation.    It is possible for the reports that inherit the base report class to override the page size and orientation.

My footer has the Page number in the left hand corner and copy right information in the right.  The copy right text box is set with an anchor of the lower right corner and the bottom and to be right aligned  However when a report changes the page orientation or size the copy right text box doesn't move right with the additional width.  

How do I move it to the right when the report changes the page size?

Attached is an image of the issue.
Peter
Telerik team
 answered on 04 Oct 2011
3 answers
80 views
What is the best way to get a large amount of dynamic, non-data source data into a report.

For example, on an invoice the header contains contact details for the company and vendor.  If these details are not in the data source, what's the best way to pass it into the report?  

For example, here's how I run a report now.

This  report uses a DataObject class as it's data source, with a method that returns a List for the actual data source.  

var r = new ProfitSystemReports.SalesByCategory();
r.ReportParameters["startDate"].Value = Model.StartDate;
r.ReportParameters["endDate"].Value = Model.EndDate;
ReportViewer1.Report = r;

In this case, the parameters are used to filter the report.  Should one use a bunch of parameters to hold the extra data?  Or, create user-defined functions that return the needed values?  What if the DataObject class also had public properties, could they be accessed from the report?

In this case, I'm using Reporting 5.1, with ASP.NET 3.5 and MVC 3 with the web viewer.
Steve
Telerik team
 answered on 04 Oct 2011
3 answers
630 views
Hello All -
This is my first foray into Telerik Reports and while I've done some reading on how to get started, please bear with me if I do ask something that is fairly basic.

Here is what I want to do -
I have a Stored Procedure that has 2 input params and returns me a set of records, I display this in a Report (table) and then I want to chart the output.

Now, when charting (pie chart) I first want to filter my data, i.e. not all rows from the SP output need to make it to the chart. To do this, I create a Custom report and in the constructor for the report I make the SP call, get the data into a Dataset and then use a DataView to filter out what I want. But bear in mind that the End User can select parameters to run the report (the 2 input params to the SP) and then click the Preview button to pull the data, however in doing so the report just shows the old data, for I have not captured the Preview button click and wired it into my Logic for filtering data.

How do I go about doing this?

Thanks.
Peter
Telerik team
 answered on 04 Oct 2011
6 answers
423 views
Hi,

I want to know how, if possible, I can put a chart in a group and this chart show the info about this group. I tried to put my chart in the footer Group (where it should be), but I don't know how to specify the group in wich it is. Let's said that I want to make a rapport about the number of gummies inside a gummies machine. My rapport should look like this:

Machine 1
Gummies Color  Gummies Number
Red 150
Green 29
Yellow  87

My chart (pie) should be here and will show the % for each color

Machine 2
...

So, I have three values : The machine number (group) , the colors (details) and the number(details). So, for my chart, I should create a serie and I guess the name of each items of this serie will be the color of the gummies and the value will be the number of gummies with this color. But I tried it this way and it doesn't work. 

Thank you in advance for your answer.
David

Steve
Telerik team
 answered on 04 Oct 2011
2 answers
212 views
Hi all,

I was looking for a simple solution to disabling the print button and the export button with the SL report viewer.  What I am trying to accomplish is the following.

I'm trying to create an initial load screen (report) similar to the report provided in the example folder (VS2010 C#).  In that example it lists those available reports for viewing and you are able to click the appropriate report you would like to view.

I'm going about a similar initial load page (rptSplash), but I would like to restrict the ability to print / export this specific page.  I looked in the Viewer for a binding event to try and check the currently (newly) bound report but didn't see such an event to use.

Can you please provide a little guidance or a suggestion.

Thanks,
Mark

[Title of thread should read Print & Export]
Mark
Top achievements
Rank 1
 answered on 04 Oct 2011
12 answers
321 views
Hi,

In my web site project in VS2005, trying to create a report from converting an existing Cystal Report v11.5 SP2 with the wizard, I get the 'Requires Crystal Report 11' message with nowhere to go forward from there (and I think I've included every CR reference I require). Does 'Requires Crystal Report 11' mean ONLY Crystal 11 and not 11.5?

Thanks
Sylvain
Steve
Telerik team
 answered on 04 Oct 2011
1 answer
79 views
Quick Background ...

MVC 2 Web application that uses Telerik Q2 2011 Report viewer.  There are 2 web servers in a load balanced environment.  The session state is out of process (AppFabric).

I understand that the report viewer stores quite a bit of information in the session.  What I am struggling to understand is when the memory is released (in other words, the session variables are removed)  ... from my testing, it appears that it is only released when the session ends (user log out or session timeout)

This is a lot of overhead. I am looking for strategy I can use to clean the report viewer session variables manually after the report has been viewed?  Are the session keys always the same?  

Thanks in advance for any help or suggestions.

Annmarie
Peter
Telerik team
 answered on 03 Oct 2011
0 answers
59 views
Can anyone suggest me did telerik supports all of the (telerik + rad + adope flash player)  
Rakesh
Top achievements
Rank 1
 asked on 03 Oct 2011
1 answer
66 views
Hello,

  During export to Word the report processor splits the table to separate tables - one table per page (see picture).
 
 Is it possible avoid the table splitting, is it possible to have only one big table in the Word document?

  It is necessary to simplify the formating of the document for end users (now the user need to format each table on each page in case if he needs to change somethings).

Thanksm
-Andrey Popov
Steve
Telerik team
 answered on 03 Oct 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?