I have two separate reports that each have a SqlDataSource and are querying a stored proc (different one for each). When I execute the stored proc directly on the database, I get 50 rows. When I execute the stored proc with the same parameters either through the DataSource wizard in the Telerik report designer or querying the report through a web interface, I only get 1 row as a response.

As I mentioned this is happening with two different stored procs. Is there some way to limit results that may be turned on (and I'm missing)?

Has anyone come across anything similar?

Using Reporting Q1 2011
 
Thanks

I have read several threads regarding this error but have not found one similar to what I am experiencing. I am creating several reports for an application and therefore copy/paste (using a telerik prescribed method). I was able to do this for one report, make some modifications and quickly create a new report that has the same style as the original. I went to add the third and on this one I got this error. 

At first I thought there was an issue with duplicate field names, etc. However, this didn't really make sense as their definitions are "private". After deleting fields, etc and getting no where, I ended determining the the issue is related to the sql query string. When I go to configure the datasource using the wizard, I enter the query string and when I attempt to click "Execute Query" this error display. In this query I am selecting similar column names from the database. I renamed the datasource name property and still no luck. Why would my query cause this? I have listed them below. BTW... both queries execute fine in SQL Server Management Studio.

See attachment.

sqlDataSource1
SELECT Groups.*, Softrip.dbo.Suppliers.SupplierName 
FROM Groups LEFT OUTER JOIN Softrip.dbo.Suppliers ON
Groups.SupplierID = Softrip.dbo.Suppliers.SupplierID

sqlDataSource4
SELECT StatusChange.*, Groups.*, Softrip.dbo.Suppliers.SupplierName
FROM StatusChange LEFT OUTER JOIN Groups ON
StatusChange.GroupID = Groups.GroupID LEFT OUTER JOIN Softrip.dbo.Suppliers ON
Groups.SupplierID = Softrip.dbo.Suppliers.SupplierID

Hello.

I have a report which we are rendering as a PDF. This report has one HTMLTextBox, which we wish to use to display the contents of an HTML email. (I am using 2010 Q3).

I'm finding that I can successfully set HTML into the HTMLTextbox in the designer, and have the HTML display in the report. However, if I try to set the HTML into the textbox in my databinding function, the report still shows the data entered in the designer, it has not been overriden with the data from the databinding function. Having no data in the HTMLTextbox in the designer does not change the behavior; in that case in the report the textbox will be empty

So, referencing the code below, the generated report is displaying 'hard coded paragraph", rather than "my paragraph". I have verified that the textBoxContents_ItemDataBound function is being called, that the bodytextbox variable is NOT null, and that when the function exits the bodytextbox.Value is still equal to the HTML set in the method.

Here are some bits of code that I think might be relevant. Thanks for your help!

Hi,

In my report header I have a number of fields placed vertically.  If there is no data for one or more of these fields I would like the fields with data to move up vertically to take the place of the missing fields i.e. same functionality as a vertically oriented stackpanel.  Each field has a matching label with a different format to the data field (if they all had the same format I could achieve this quite simply in a single textbox): 

Contact: John
Phone: 555-555-5555
Fax: 555-555-55555
Email: john@company.com

(e.g. if there was no Fax number for John then the email row would move up to to the position of the Fax row).

I imagine I could do this in code by positioning the fields manually but I'm hoping there is a better way.

What is the recommended method for achieving this?

Thanks,
Steve

We have a report that integrates a number of subreports, and generally only a couple of them will have data for any particular parent item. Is it possible to programmatically hide the subreport if there are no rows?

TIA.

HI there folks

i've just tried to upgrade my solution 

which had been using Telerik Reports Q1 2011

and i've tried upgrading it to Telerik Reports Q2 2011

the upgrade goes through successfully 

but when I try to build I recieve the following error message on all of my Report Designer.cs files

I am using the report controls in our mvvm silverlight application. I am passing in 5 different parameters within a dictionary. the last item in this dictionary is a List<int>. This list contains ids that I will then use against an entity to create my report from. 

I am finding no luck anywhere on how to pass in a generic list as a parameter. Again we are using an MVVM pattern so the examples I have seen online that use codebehind are not much help. I am sure that I am missing something within the report itself that will allow me to use a Generic list.

Hi,
   I have one web solution and trying to create reports. I added a folder "Reports" to that solution and trying to add Telerik Report. It is asking me to add in "app_code" folder. If I click NO, It is just showing code behind file. I can not see the designer. Is there anything I am missing.


Thanks
Chiran

Hi,
I am using Reporting Q1 2011 and am trying to make a report that contains a subreport. I am using a ObjectDataSource for this report. I am not setting the datasource for the subreport, I am using the NeedDataSource event to do that. Problem is, I can't figure out how to refer to the element I need. I downloaded an example from this site http://www.telerik.com/community/forums/reporting/telerik-reporting/sample-for-master-detail-using-object-collection-as-datasource.aspx that shows how to do this, but it's from an older version and the .DataItem property is no longer available. I can't seem to find a current example of how to do this. So how exactly does one gain access to dataitems in a business object so that the datasource of the subreport can be set correctly using Q1 2011?

Thanks

Hi,
I've just updated my reports from the Q3 2010 release to the new Q2 2011 release and on all reports I am now getting the following error when previewing the report in VS: "The source of the report definition has not been specified".

In the code behind the report I manually setup the datasource and it was working perfectly till now.  

Is there some obvious breaking change that has caused this to appear?

Regards,

Jon