Telerik Forums
Reporting Forum
1 answer
106 views
I am using the latest version of Telerik Reporting. My Report has 3 parameters that use seperate Datasources for each. One of the Datasource objects returns a large dataset. I would like to know how to implement the same  Load on Demand  functionallity as I use on the RadComboBox Controls Load on Demand. 
It would even work if I had the functionallity like Telerik uses on the ComboBox used when you Select your Country on the Create accout page.

Thanks,
DM 

Example from RadComboBox
protected void RadComboBox2_ItemsRequested(object sender, RadComboBoxItemsRequestedEventArgs e)
{
     DataTable data = GetData(e.Text);
}

private static DataTable GetData(string text)
{
     SqlDataAdapter adapter = new SqlDataAdapter("SELECT * from Customers WHERE CompanyName LIKE @text + '%'",
ConfigurationManager.ConnectionStrings["NorthwindConnectionString"].ConnectionString);
adapter.SelectCommand.Parameters.AddWithValue("@text", text);

DataTable data = new DataTable();
adapter.Fill(data);

return data;
}


Steve
Telerik team
 answered on 01 Jun 2012
1 answer
151 views
Hi,

I've using te vs2008 sp1 which is professional edition. i've install the telerik reporting Q1 2012. The installation process runs smoothly. I open the visual studio and the telerik reporting tools is available at the toolbox.

Now, i add a new telerik report file call report1.cs at the app_code folder. It shows error object reference not set to an instance of an object. so i went on to check the reference at the .NET tab inside the "Add Reference". All the references are there.

So what am i missing?
Steve
Telerik team
 answered on 01 Jun 2012
3 answers
171 views
Hello again :)
By default go to page not working? How it enable?
Steve
Telerik team
 answered on 31 May 2012
2 answers
136 views
Hello
It possible to hide navigation buttons and how?

 
Hans
Top achievements
Rank 1
 answered on 31 May 2012
1 answer
836 views
Hi,
I would like to add an automatic number (autoincrementing number/field) to the text under each table and picture in my report, like:
Table {autonumber} shows annual income.. etc.

Is there a way I can create a field, or something that I can insert in a htmlTextbox along with the text, that dynimically auto increments a value with each entry? 
Steve
Telerik team
 answered on 31 May 2012
1 answer
146 views

I would like to limit the number of X-Axis Label Steps to around 3 or 4 labels.  The amount of data displayed on the chart can vary from just 5 points to hundreds and the number of points for each Pen can vary significantly. 

It is my assumption that the “XAxis.LabelStep” property assumes a constant number of points for each ChartSeriesItemCollection.  I had originally set it to

                Chart1.PlotArea.XAxis.LabelStep = Convert.ToInt32(MaxPoints / 3) +1;

But I get a strange group of characters in the upper left portion of the trend and the incorrect number of Labels created.  Given my objective, what would be the ideal way to specify the number of Labels for the X-Axis?

Steve
Telerik team
 answered on 31 May 2012
1 answer
193 views
I have a multivalue parameter named "@CountryID" with the "Allow Null" property = True.  Works fine if I select the null checkbox or select a single value.  BUT, when I select multiple values I get a SQL exception.

SQL to look like this:


"select * from Countries where CountryID IN (isnull(@CountryID,CountryID))"

The error I get when I pass in MULTIPLE VALUES is ... "The isnull function requires 2 argument(s)"

I'm not sure what is happening here ... but it looks like when multiple values are specified the @CountryID isn't being set to something like "1,2,3" as I would expect.

Thanks - Wayde
Steve
Telerik team
 answered on 31 May 2012
1 answer
145 views
I have created a reports library and using it to display multiple charts in reportbook in a project.
It runs fine on my local pc but gives error when put live.
the error it gives -

An error has occurred while processing Chart 'Chart1': A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)

can u suggest where the issue can be?
i've checked the connection string and it is fine.
Steve
Telerik team
 answered on 31 May 2012
7 answers
352 views
I need programetically code to create new  document map in my report.
Gunasekar
Top achievements
Rank 1
 answered on 31 May 2012
2 answers
219 views
IDE : Visual Studio 2010
Reporting Version : Q1 2012 (6.0.12.215)

While I'm trying to assign a ReportSource to a sub report, I get "Object reference not set to an instance of an object.". I had googled this error and came upon this Telerik Post saying to run either in preview or set programatically. I tried both.

Preview Pane :

"Exception has been thrown by the target of an invocation. Object reference not set to an instance of an object."

Programmatically :

"One or more parameters are not set or have invalid values."

After seeing the error, I checked all the parameters and everything seemed to be getting/sending a value. After a few more tries, I finally just took out the parameters and set an ID I knew had data in my database and tried running again. Gave me the same error. I then went through and turned on (Debug -> Exceptions) and set to throw all Common Language Runtime Exceptions, but nothing was thrown.
Jacob
Top achievements
Rank 1
 answered on 30 May 2012
Top users last month
Miljana
Top achievements
Rank 2
Iron
Iron
Joel
Top achievements
Rank 3
Bronze
Bronze
Bronze
Cynthia
Top achievements
Rank 1
John
Top achievements
Rank 1
Iron
Mozart
Top achievements
Rank 1
Iron
Veteran
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?