Telerik Forums
Reporting Forum
2 answers
125 views
I've just migrated over from Crystal reports to Telerik.  I have created an unbound report and want to add a chart.  The report itself does not have a data source.

I've added the chart from the toolbox.  When I right-click the chart a wizard pops up.  I've selected the type of chart that I want (bar) and have gone to the data tab.  On the top of the data-tab it says "To dynamically populate the chart with data, use the NeedDataSource event".

Ok, where is it, and how do I use it?  The video training I've seen is in a different version.  He clicks an icon shaped like a lightning bolt and it pops right up.  I do not have that icon, nor can I find it.

Please help.

Squall
Top achievements
Rank 1
 answered on 18 Jul 2011
1 answer
102 views
I'm using Q3 2010
I have a report with a parameter
First, I need this parameter to be not essential
I mean if it is empty the report displays all the data from the data source

Second,
When I try to apply a filter with a 'Like' operator it gives me an error like this
http://i56.tinypic.com/zy7rs2.jpg

and this applies to some other operators too
So, I tried to apply the filter programmatically like this
this.Filters.Add("=Fields.Name", Telerik.Reporting.Data.FilterOperator.Like, "=Parameters.paraName.Value");
in the report constructor

But when I run the report
it makes the filter as an '='
I mean it returns the records only when the parameter value is exactly the same
Ahmed
Top achievements
Rank 1
 answered on 17 Jul 2011
1 answer
116 views
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
Tim
Top achievements
Rank 1
 answered on 16 Jul 2011
14 answers
953 views
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
  
Chris @ Intrinsic
Top achievements
Rank 1
 answered on 15 Jul 2011
5 answers
430 views
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!

        private void InitializeComponent()
        {
            this.textBoxContents.Location = new Telerik.Reporting.Drawing.PointU(new Telerik.Reporting.Drawing.Unit(0.700118362903595D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(1.2142907381057739D, Telerik.Reporting.Drawing.UnitType.Inch));
            this.textBoxContents.Name = "textBoxContents";
            this.textBoxContents.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(5.7998027801513672D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.28570938110351562D, Telerik.Reporting.Drawing.UnitType.Inch));
            this.textBoxContents.Value = "<html><p>hard coded paragraph.</p></html>";
            this.textBoxContents.ItemDataBound += new System.EventHandler(this.textBoxContents_ItemDataBound);
      }
 
   private Telerik.Reporting.HtmlTextBox textBoxContents;

        private void textBoxContents_ItemDataBound(object sender, EventArgs e)
        {
            Telerik.Reporting.Processing.HtmlTextBox bodytextbox = sender as
                Telerik.Reporting.Processing.HtmlTextBox;
            if (bodytextbox != null)
                bodytextbox.Value = "<html><p>My paragraph.</p></html>";
        }
Mark
Top achievements
Rank 1
 answered on 15 Jul 2011
4 answers
155 views
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
Stephen
Top achievements
Rank 1
 answered on 15 Jul 2011
1 answer
156 views
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.
Steve
Telerik team
 answered on 15 Jul 2011
4 answers
148 views
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


'Telerik.Reporting.ReportParameter' does not contain a definition for 'UI' and no extension method 'UI' accepting a first argument of type 'Telerik.Reporting.ReportParameter' could be found (are you missing a using directive or an assembly reference?
IT
Top achievements
Rank 1
 answered on 15 Jul 2011
1 answer
458 views
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.
Steve
Telerik team
 answered on 15 Jul 2011
2 answers
120 views
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
Steve
Telerik team
 answered on 15 Jul 2011
Top users last month
Anislav
Top achievements
Rank 6
Silver
Bronze
Bronze
Jianxian
Top achievements
Rank 1
Iron
Marco
Top achievements
Rank 3
Iron
Iron
Iron
Jim
Top achievements
Rank 2
Iron
Iron
Nurik
Top achievements
Rank 2
Iron
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?