Questions on Reporting Forum

1 answer

124 views

Hi:

i have designed the telerik report using telerik reporting, i am passing 4 parameters to the report.
when i click on preview it is asking for parameters, when i entered first parameter and moved to next parameter, the information i entered in the first parameter is erasing.
The report is getting refreshed.

Any help is appreciated.

Thanks
Venu

General Discussions

answered on 08 Jul 2011

2 answers

118 views

Report Viewer

I want to hidden the same under picture, but I don't know current version supported. Can you help me ?

General Discussions

answered on 08 Jul 2011

4 answers

162 views

Export to PDf Issue:- there is no empty series

Hi,

I am using telerik Silevrlight Reportviewer. I am able to see pie chart with values in Report Viewer but when i try to Export to PDF , instead of pie chart I am getting "There is no empty series". Any help is highly appreciated.

Regards,
Shweta

General Discussions

answered on 08 Jul 2011

3 answers

497 views

Export only data instead of report while exporting to excel in report viewer

Hi

I am using ReportViewer to display the reports and also to export the reports in the required format. Here i want a change in the existing system such that when user tries to export to excel, instead of displaying the report in the excel, we want to display the underlying data in the excel sheet. Please let me know whether the existing system support this functionality?

Thanks in advance
Ravindra

General Discussions

answered on 07 Jul 2011

1 answer

71 views

Silverlight view fails on {word} in text

I have 2 different reports that fail on the Silverlight viewer when I have '{myword}' in the text I'm displaying from a field. The asp.net version shows the correct text.

I get an error:
"The type 'SUNRISE' was not found. [Line: 1 Position: 7039]"

SUNRISE is the text in {SUNRISE} it's at the start of the text if that makes a difference. I'm using version 5.0.11.316

General Discussions

answered on 07 Jul 2011

4 answers

216 views

[Solved] Incorrect information displayed on chart (X-Axis which contains dates)

Hi
I'm having this issue where the information I have in my SQL database is not being reflected on the chart.

My SQL query returns this data below:

raisedBy counter createdon
Risha Wadhwani   13 2010.06.14
Risha Wadhwani   19 2010.06.15
Tufail Khan 4 2010.06.15
Risha Wadhwani   13 2010.06.16

Also see screenshot 'sql.png'

This is the code that I am using to generate the Chart :

private void chart1_NeedDataSource(object sender, EventArgs e)

{

var dataset = new DataSet();

var adapter = new SqlDataAdapter();

var conn =

new SqlConnection("Initial Catalog=****;Data Source=****;User Id=****;Password=****;");

var cmd = new SqlCommand

{

Connection = conn,

CommandType = CommandType.Text,

CommandText =

@"SELECT raisedBy,

COUNT(id) as counter,

createdon FROM

(

SELECT

da.name as raisedBy,

defects.id,

convert(VARCHAR, defects.created_on, 102)

AS

createdon

FROM

defects

LEFT JOIN

[user] da

ON

(defects.raised_by = da.id)

WHERE

defects.id IN(488,490,491,492,493,494,495,496,497,498,499,500,501,502,504,505,506,508,509,511,512,513,514,515,516,517,518,519,520,521,523,524,526,528,529,530,535,536,537,538,539,540,541,542,543,544,545,546,547)

)

table1

GROUP BY

raisedBy,

createdon

ORDER BY createdon ASC"

};

adapter.SelectCommand = cmd;

adapter.Fill(dataset);

DataView view = dataset.Tables[0].DefaultView;

//var chart = sender as Chart;

chart1.PlotArea.XAxis.Appearance.LabelAppearance.RotationAngle = -320;

chart1.PlotArea.XAxis.Appearance.TextAppearance.TextProperties.Color = Color.BlueViolet;

chart1.PlotArea.XAxis.DataLabelsColumn = "createdon";

chart1.DataGroupColumn = "raisedBy";

chart1.PlotArea.XAxis.IsZeroBased = false;

chart1.PlotArea.XAxis.Appearance.ValueFormat = Telerik.Reporting.Charting.Styles.ChartValueFormat.ShortDate;

chart1.PlotArea.XAxis.Appearance.CustomFormat = "MM/dd/yyyy";

chart1.PlotArea.XAxis.LayoutMode = Telerik.Reporting.Charting.Styles.ChartAxisLayoutMode.Between;

chart1.PlotArea.XAxis.LabelStep = 1;

chart1.PlotArea.XAxis.MaxItemsCount = view.Count;

foreach (DataRowView rowView in view)

{

var datedate = DateTime.Parse(rowView.Row.ItemArray[2].ToString());

rowView.Row.ItemArray[2] = datedate;

}

if (chart1 != null) chart1.DataSource = view;

}

And finally, attached is the screenshot to see the Chart that is being rendered.

The problem is that is 'Tufail Khan' column(on the chart) is being displayed under the date '2010.06.14', instead of '2010.06.15' where it should have been, if you look at the result from the SQL result..

Any help on this would be very much appreciated.
Cheers Telerik!

Navnit

General Discussions

answered on 07 Jul 2011

1 answer

90 views

Simple Chart with a "Date" and "Number"

Hello:

I am trying to visualize data froma database which comes in two colums, a "date" and a "number" column. I want to put the date on one of the chart axis and the number on the other. Is that not possible? I am getting design time errors telling that "Date" is not numeric.
Please help.

--t

General Discussions

answered on 07 Jul 2011

1 answer

260 views

SQL Connection String issue

I tried following this instructions

http://www.telerik.com/support/kb/reporting/designing-reports/using-connectionstrings-from-configuration-file.aspx

and it works perfectly on my development machine. The problem is that I get the error below when I deployed on our test server.

Unable to establish a connection to the database. Please, verify that your connection string is valid. In case you use a named connection string from the application configuration file, make sure the name is correct and the connection string settings are present in the configuration file of your application.

The configuration is the same. the only thing different is that it is being pointed to a different database.

Any ideas? Thank you for your feedback.

General Discussions

answered on 07 Jul 2011

1 answer

163 views

Croostab with vertical expansion

I have a simple crosstab report which is working great.
The issue I am encountering is how to keep report on a single printable page while number of rows is rather large.
have total of

6 row group selection ( the actual values of field may be upto 60 character )
2 column group
3 detail values

Typically when you create this report and expand a particulat row during the drilldown( toggle) it will expand horizontally.

Is to possible to expand it vertically, so that actual page size remains fixed and report can grow in height.

See the layout of report in the attached file.
Any suggstion how this can be accomplished.

General Discussions

answered on 07 Jul 2011

1 answer

378 views

[Solved] Pie Chart is not displayed for zero valued data

Hi

I am creating a Pie Chart using Telrik Reporting Controls. When the data is zero for all the items in the datasource, then the chart is not being displayed. In such case, is it possible to display a message for the pie chart "All the values are zero". Please find the attached report for furthur information.

Thanks in advance
Ravindra

General Discussions

answered on 07 Jul 2011