Telerik Forums
Reporting Forum
1 answer
147 views

Hi... 

   Sir with ur tips i have benifited a lot..

 Now i have doubt in set datasource as global for several reports., 

For example .,  Now i am using more that 40 reports in my project .. for that reports i have create the datasource using 

sqldataadapter from the tool box and passing parameters from the web forms., If i need to change the database means

at that time i need to change the datasource separately for all reports... 

Next i need help for same doubt in the style sheet also... i need to design all reports separately .. but for standard report 

i use external stylesheet but it is not working for me....

Yours 

S.Suriya 

Steve
Telerik team
 answered on 21 Apr 2009
2 answers
169 views
I have a bar chart in a report, and I'm trying to color some of the bars (red) if they are below a certain value.  The two options I am aware of for this are:

1) When NeedsDataSource is fired, populate my own ChartSeries as I iterate through a SqlDataReader.  This allows me to set the FillStyle.MainColor for each ChartSeriesItem I add, and I can set it to Red if I want.  HOWEVER, the short-coming here is that I see no way to control the XAxis labels for each data point, and I want them to display the associated date with each data point (they end up just being 1, 2, 3, 4, etc.).

2) In the NeedsDataSource event, set the DataSource to a DataView.  This also allows me to set the XAxis.DataLabelsColumn property so that I can appropriately label my XAxis.  HOWEVER, if I try to change the color of the bar in the ItemDataBound event by iterating through the series items and setting the color, it doesn't work.  The color never changes.  The color appears to be set the moment it is added to the chart, and is unalterable after that point.

Any solution to this dilemma?

Regards,
Scott

UPDATE: Okay, I have a solution.  It certainly doesn't seem elegant, but it works, but I would still like to know if there is a more direct route.  Seems like #2 above would be easiest, and just access the chart items once they've been added to change their color, but that doesn't seem to work.

The solution I came up with after reading this: http://blogs.telerik.com/blogs/08-06-20/formatting_radchart_labels.aspx

I set the XAxis.AutoScale to false, then manually add each of my ChartAxisItems and set the TextBlock.Text property to the text I want.  This certainly doesn't seem intuitive.

Is there a better way?
Scott
Top achievements
Rank 1
 answered on 21 Apr 2009
1 answer
183 views
I am trying to build a query with a parameter in it and get the following error
"Must declare the scaler variable"

I am using Visual Studio 2008 and telerik reporting Q3
could someone please tell me how to get around this problem
my query string looks like this

SELECT     ProNumber, HoldCodes, Ship, Pieces, Weight, SkidSpaces, SrprhID
FROM         RouteDetail
WHERE     (SrprhID = @Param1)

the excution of the query works fine
thanks
Pete
Steve
Telerik team
 answered on 21 Apr 2009
1 answer
113 views
Hello,
In my application report is being exported successfully in CSV format. But in Excel or any other format, the exported report only shows the title. The data being fetched from database is not displayed in exported report.

For your kind information i have read your help and found something to export reports in pdf and image format.
But the problem is that, in my application the error occurs of "Telerik.Reporting.Processing" namespace.
If i include it then it gives me error of "Telerik.Reporting.Report".

So i kindly request you to provide some suggestion.

Regards,
Ridhz
jain
Top achievements
Rank 1
 answered on 21 Apr 2009
12 answers
684 views
as i read in the forum there is currently no control that supports table view so i have to build it on my own.

i have lists of columns, rows and values and want to create a table out of this using a subreport.
some fixed data is already bound correctly and displayed in the subreport using the NeedDataSource Event in the master report.
because the columns are not fixed i can not use the usual approach in defining all columns and then create the table in the detail section. what is the best approach to get this subreport? should i completly create the report at runtime?
or create the report but add the textboxes manually at runtime?
where do i have to place my code so that i am having the datasource of the subreport and can add my fields according to it?


Steve
Telerik team
 answered on 21 Apr 2009
0 answers
85 views
Hi,
 Can u pls help me out in exporting report into CSV format.
Have got lots of prob in it.


Thanks & Regards
Stella
jain
Top achievements
Rank 1
 asked on 21 Apr 2009
1 answer
123 views
3 quick questions:

1)  To illustrate grouping of several values on a report, I am adding a square shape on the report around several textboxes.  Designer shows me overlap warnings, but when I view it using Report Viewer, the textboxes get pushed to the right of the shape, instead of the shape appearing behind the textboxes.  Is there a setting to allow it to appear as I'm describing?

2) I often use cascading drop down parameters for narrowing down report results.  Whenever I set "MultiValue" to true on a Parameter, the selection box appears at random places on the screen, instead of being attached to the bottom of the control.  If I set "MultiValue" to false, the control behaves as expected.  The random selection box placement only happens using IE8 but works as expected using Chrome/Safari.

3) I am using a sliding pane with a RadMenu to categorize several reports.  Using Chrome/Safari, the RadMenu title text appears as one letter on top of another.  For example, if my title was "Billing Reports", it appears rotated 90 degrees on IE, but looks like this on Safari/Chrome. 
B
i
l
l
i
n
g

R
e
p
o
r
t
s

I am developing on Server2003, Visual Studio 2005, and viewing using IE8, Chrome 1.0.154.53 , and Safari 4.

Thank you!
Steve
Telerik team
 answered on 21 Apr 2009
1 answer
102 views
I have the trial or Telerik reporting.  I went through 2 videos (intro and data) and part of the pdf file.  I have a project with many object data sources already defined.  I am trying to use them in a new Telerik report I added to the project.  I tried going through the wizard, and the only way I could get to the data object names was to go to "Business Object" under choose a data souce type.  Then I choose the App_Code.5zwoels(), and then DataSet1TableAdapters, and the various TableAdapters are listed there.  However, when I choose one, all I get in the data explorer are 3 itesm:  "ClearBeforeFill', "Container" and "Site".  No field names.  What am I missing?
Steve
Telerik team
 answered on 21 Apr 2009
1 answer
106 views

Hi anybody,

 

Good Day!

 

FYI - We own Telerik Reporting service tool.

 

1, I need to implement Bar Code in my report forms in which the Bar codes has to be displayed in the form retrieving the Bar code from the Database.

 

2, Also, I am binding the report form using Telerik Report Viewer Control. The form consists of 3 pages in total. But, I need to display only first two pages of the form in certain cases (i.e,) I need to make the third page invisible on certain conditions.

 

So, please help me with the following,

 

1, Could you please provide me with a sample code on how to implement Bar Code in forms retrieving the bar code numeric values from the database?

 

2, Could you also provide me with a sample code on how to control the number of pages to be displayed at certain conditions in Telerik Report Viewer?

 

Thank you for your help in advance.

Steve
Telerik team
 answered on 21 Apr 2009
3 answers
217 views
I have a asp page running, the user selects to print the details of a certain route, how would I set up the report viewer and telerik report to show the report.

currently the program builds a collection of the information, but I am not sure how to pass that into the report viewer, could someone give me a little example on how this would work.

my setup now is I have an ASP page has the report viewer in it, in that page I am gathering the data needed for the collection, I have a myReport in the class library that the reportviewer is linked to
or does the data collection need to be done in the report class ?

I am trying to follow the examples in the telerik reporting manual, but the example they provide shows how to connect to a database.

thanks



 

Sekar
Top achievements
Rank 1
 answered on 17 Apr 2009
Top users last month
Edmond
Top achievements
Rank 1
Iron
fabrizio
Top achievements
Rank 2
Iron
Veteran
RobMarz
Top achievements
Rank 2
Iron
Fakhrul
Top achievements
Rank 1
Iron
Tejas
Top achievements
Rank 2
Iron
Iron
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?