I dont know what I have done wrong. I have a chart, the chart needs a datasource. This is my NeedDataSource-method

private

 

void companyBooking_NeedDataSource(object sender, System.EventArgs e)

 

{

Telerik.Reporting.Processing.

Chart companyBookingChart = sender as Telerik.Reporting.Processing.Chart;

 

companyBookingChart.DataSource =

this.bokadoktornDataSetTableAdapter1.GetData();

 

}

In the InitializeComponent()-method I have this eventHandler.
this.companyBookingChart.NeedDataSource += new System.EventHandler(this.companyBooking_NeedDataSource);

This is my database-sqlquery, (Works fine)

SELECT YEAR(BookedDate) AS Year, MONTH(BookedDate) AS Month, CONCAT(u.FirstName, ' ', u.LastName) AS FullName, Count(*) AS NoOfBookings
FROM         Bookings b
INNER JOIN Users u ON u.Id = b.BookedById
INNER JOIN CompanyUsers cu ON cu.Id = u.Id
WHERE cu.CompanyId = 1
GROUP BY u.Id, MONTH(BookedDate), YEAR(BookedDate)
ORDER BY NoOfBookings DESC;

When I preview my report nothing happends. I dont know why, everything worked fine until I added my chart. Is it something wrong with my NeedDataSource-method.

Thanks
/Emil

 

Hi
In a textbox in detail section, i have to display either low or medium or high based upon the value of another textbox(in detail section), which takes value from the database. Where should i write the if condition statements?

Hey folks,

I got a weird and annoying problem here in my report:

When using a CheckBox element in a Telerik Report it alway appears blue in color. To avoid that, I decided to create my own icons for CheckedImage and UncheckedImage. Unfortunately I can't attach this gifs to this post. But they are just squares with a border of 1px and a widht/height of 13px. The checked one is just a filled square.

But whatever I do - in mein PDF Export. The icon is a little bit bigger than the original one. An ugly effect is then, that my square has either a 2px border on the left, on the right, on top OR at the bottom, which doesn't look nice on the screen and on a printed out document.

What am I doing wrong?

Thanks in advance

In the help file (Telerik_Reporting_2009_2_701_manual.chm) you say that "All exporting format extensions and the data processing are part of Telerik.Reporting.Processing.dll" However in the KB (http://www.telerik.com/support/kb/reporting/general/deploying-telerik-reporting.aspx) you do not mention that file.

I have a previous version running.
 -- What old Telerik dlls can I remove from the references?
 -- What references do I need to deploy the Q2 2009 reports in win forms?

Thanks,

Matthew

Hi,
I was testing the latest build (3.1.9.807) for the medium trust support with this code:


But I'm getting security exception:

Hi,

I have a StackedBar100 chart in my report, everything works fine, but the problem is the appereance of the percentage result in the Bar.
For example: If I have a bar divided in two or more... the first value appears in the botton of the second part of bar and the other value appears in the top of the second part of the bar. I'd like to see each value appearing inside the correct bar.
Is that possible??

Another Question: I think this code is not good... maybe there is an easy way to do that with the same result.. isnt there??

Thanks...

Code:


    DataTable GetData()
        {
            DataTable dataTable = new DataTable();
            dataTable.Columns.Add("Descricao", typeof(string));
            dataTable.Columns.Add("Qtd1", typeof(int));
            dataTable.Columns.Add("Qtd2", typeof(int));
            dataTable.Rows.Add(new object[] { "A", 3, 5 });
            dataTable.Rows.Add(new object[] { "B", 2, 5 });
            dataTable.Rows.Add(new object[] { "C", 5, 5 });
            return dataTable;
        }


    private void chart2_NeedDataSource(object sender, EventArgs e)
        {
            try
            {
                DataTable dt = new DataTable();
                dt = GetData();


                Telerik.Reporting.Processing.Chart chart = sender as Telerik.Reporting.Processing.Chart;
                chart2.Series.Clear();
                
                ChartSeries s = null;

                for (int i = 0; i < dt.Columns.Count -1; i++)
                {
                    s = new ChartSeries();
                    s.Type = ChartSeriesType.StackedBar100;
                    s.Appearance.LegendDisplayMode = ChartSeriesLegendDisplayMode.Nothing;
                    s.DefaultLabelValue = "#%";
                    
                    
                    chart2.Series.Add(s);

                    foreach (DataRow row in dt.Rows)
                    {
                        ChartSeriesItem item = new ChartSeriesItem();
                        item.YValue = Convert.ToDouble(row[i+1]);
                        s.AddItem(item);

                    }
                    
                }

                foreach (DataRow row in dt.Rows)
                {
                    s.PlotArea.XAxis.AutoScale = false; //false permite gerar o xaxis com os valores que eu definir
                    s.PlotArea.XAxis.AddItem((string)row["Descricao"]);

                }


            }
            catch (Exception ex)
            {
                throw new Exception(ex.Message);
            }
        }

hi
When i am adding a second report file in the solution i m getting errors .I would be thankful if anyone helps me in adding two reports in a single solution

I need to change the order of the formats listed in the Export dropdown.  I know I can rename and hide formats, but is there a way to reorder them?

Thanks,
-Stephen

I need to include hyperlinks in my reports when they are rendered in the Web Viewer.  I'm currently using Q3 2008 and everything works fine.  I set the text of the textbox to include HTML like <a href="google.com">Click Me</a>.

I'm in the process of upgrading to Q1 2009, but it looks like my approach doesn't work anymore.  It seems the size of the textbox gets calculated based on the size of the text (including all the HTML code) so the textbox gets really large (even though when the browser processes the text, it's considerably smaller). 

So if I have a textbox who's Text is set to <a href="http://AReallyReallyReallyReallyReallyReallyLongLink.com">Q</a>, the textbox takes up a huge area but it ends up being only 1 characeter.

I thought I might be able to use the HtmlTextBox but it seems to completly ignore (and remove) hyperlinks.

Any suggestions?

Thanks,
-Stephen

Hi,

I'm using Telerik Reporting to create various reports consisting of a page header/footer with 3 groups with headers and footers. When I initially set it up it worked fine for a one page report. If the report grows more than 2 pages it will insert a full page of whitespace inbetween pages. I thought it could be the footers so i made them invisible, set their height to 0, still didn't work. I don't know what could be causing these random pages of whitespace. Have you ever encountered this problem with whitespace pages before or do you have some help for me?

Thanks a million