Telerik Forums
Reporting Forum
4 answers
134 views
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
Aitor
Top achievements
Rank 1
 answered on 08 Jul 2011
3 answers
422 views
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
Peter
Telerik team
 answered on 07 Jul 2011
1 answer
42 views
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


Steve
Telerik team
 answered on 07 Jul 2011
4 answers
184 views
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 
Navnit
Top achievements
Rank 2
 answered on 07 Jul 2011
1 answer
68 views
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
Steve
Telerik team
 answered on 07 Jul 2011
1 answer
232 views
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. 

Steve
Telerik team
 answered on 07 Jul 2011
1 answer
126 views
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.

Steve
Telerik team
 answered on 07 Jul 2011
1 answer
336 views
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
Steve
Telerik team
 answered on 07 Jul 2011
1 answer
184 views
The report designer and the report project load and run correctly. Everything works however on one of my machines when I click on "Expression" in the context menu I get the following error. Everything else works.

I have tried to install the corresponding WPF controls, remove and add the reference again, add binding redirects, and just about everything else, but it still doesn't work.

Is there anything else to try?
Steve
Telerik team
 answered on 07 Jul 2011
1 answer
100 views
Hi,

I created a very basic report that contains a chart with static data. Other areas on the report shows up fine on Silverlight Report viewer but not the chart. If I change the Background color of the chart to a different color like green - that whole chart space shows up as green box.
Is there a known issue and workaround for this issue?

Thanks,
Jitin
Jitin Vishwakarma
Top achievements
Rank 1
 answered on 07 Jul 2011
Top users last month
Rob
Top achievements
Rank 3
Iron
Iron
Iron
Atul
Top achievements
Rank 1
Iron
Iron
Iron
Alexander
Top achievements
Rank 1
Veteran
Iron
Serkan
Top achievements
Rank 1
Iron
Shawn
Top achievements
Rank 1
Iron
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?