Telerik Forums
Reporting Forum
5 answers
288 views
Hi,

   I'm having chart in detail section. I need to bind the chart based on the item value of the report. I directly bind the chart in the detail_ItemDataBound without NeedDataSource event for the chart. I didn't get the chart. Then i try adding NeedDataSource event for the chart. But this gets executed before detail_ItemDataBound. Again I didn't get the chart. Then i tried detail_ItemDataBinding event to get value. Later i use the function for binding chart which i call in detail_ItemDataBound or in detail_ItemDataBinding. Still i didn't get the chart. All i get is there is no or empty series.

How can i bind the chart which is in detail section?

Here is the code which i use the bind the chart. Assume dt is DataTable holding data.
if (dt.Rows.Count > 0)
                {

                    for (int i = 0; i < dt.Rows.Count; i++)
                        total += Convert.ToInt32(dt.Rows[i]["Cnt"]);

                    Telerik.Reporting.Processing.Chart chtCur = sender as Telerik.Reporting.Processing.Chart;
                   
                    this.chtCur.Series.Clear();
                    this.chtCur.ChartTitle.TextBlock.Text = "Factors";
                    for (int i = 0; i < dt.Rows.Count; i++)
                    {
                        Telerik.Reporting.Charting.ChartSeries chartseries = new Telerik.Reporting.Charting.ChartSeries();
                        Telerik.Reporting.Charting.ChartSeriesItem item = new Telerik.Reporting.Charting.ChartSeriesItem();
                        item.Label.TextBlock.Text = dt.Rows[i]["Val"].ToString() + "\n" + (Convert.ToInt32(dt.Rows[i]["Cnt"]) / total * 100).ToString() + "%";
                        item.Name = dt.Rows[i]["Val"].ToString();
                        item.YValue = Convert.ToInt32(dt.Rows[i]["Cnt"]) / total * 100;
                        chartseries.Type = Telerik.Reporting.Charting.ChartSeriesType.Pie;
                        chartseries.Name = dt.Rows[i]["Val"].ToString();
                        chartseries.Items.Add(item);
                        this.chtCur.Series.Add(chartseries);
                    }
                    pnlCur.Visible = true;
                }
                else
                    pnlCur.Visible = false;

Please help.
Thanks in advance.
Steve
Telerik team
 answered on 01 Jun 2010
1 answer
188 views
I've a report with 9 sub-reports all in detail section. I specified page break in the sub-reports. In Designer Preview, i see 12 pages for the entire report. When i view the report from report viewer, i see only one page comprising all the reports. But when i export it to pdf, i can see the 12 pages in the pdf. Why does the report in reportviewer behaves differently? It should be same as in preview is it? Is there anyway to show the report correctly in the reportviewer?

Another problem is,
I've a PictureBox object having a big image (say A4 size). In Designer Preview, i'm able to see the image clearly. But when i view from reportviewer, i cannot see full image or i don't see image at all. But when i export to pdf, i'm able to see the image in the pdf. Why does this happens? Any solution to fix this?
Peter
Telerik team
 answered on 01 Jun 2010
2 answers
134 views

Hi

Is there a way to get an error message(or code)  when the contents of a htmltextbox isn’t supported (eg: <TABLE> tag)?  

Many thanks

Girard Loic
Top achievements
Rank 1
 answered on 31 May 2010
1 answer
111 views
Thanks for blog at http://blogs.telerik.com/kevinbabcock/posts/09-02-06/bind_your_telerik_reports_to_xml_data.aspx

and thanks for the VB source code. It sure helps when learning VB and Visual Studio and Telerik Reporting at the same time.

I've checked out the code for Class Entity to define the XML fields and it makes sense how my XML is four nodes deep.

Can I get some help please to create the required code? Many thanks

Nick
Top achievements
Rank 1
 answered on 31 May 2010
3 answers
278 views
Hey there guys.

I have a strange problem with a report of mine.

Basics:
UnitOfMeasure is cm (i'm from germany)
Paperkind is A4
Landscape is false
Margins are set to 10mm each side
Got some normal datafields from a dataset and a picturebox
The items are filled as they should.
Picturebox is set to ScaleProportional

Issue:
I want my report with 2 columns.
Its an labeled report and the bounds, margins, paddings and so on are as set as the 2 cloumns will fit on the document.
The designer is showing me the second column but if i run the report in my application, the second column will not appear.
The first column is as long as the whole document (it looks like streched).

I've tried various settings on the meassures but nothing will work.

Hopefully some of you has an idea how to fix my issue.

Regards, Tom

[UPDATE]
The problem occurs only if the picturebox value is set by the following code:
this.pictureBox1.Value = "= snvMain.GlobalParams.getImageToArticle(Fields.artnr)";
The function called returns the ImagePath as string.
Reportviewer even loads the image in the Picturebox and later its getting an GDI+ error too.

Slowly but sure it drives me to despair :/
Steve
Telerik team
 answered on 28 May 2010
1 answer
197 views
Hi There,

I am trying telerik reports, what i wanted do is to include the Datatable schema from a xml file, use these fields to design report, and then bind data to this runtime (As I used to do this in Crystal Reports). But on Forum I found that in Telerik XML Schema is not available at design time.
    I tried the anather way i.e. Adding the DataSet to Project (Not filling Table using TableAdapter) and use DataTable from this DataSet, But Ahhhh, I cant see this dataset while assining or adding new datasource, neither as CurrentDataSource nor as ProjectDataSource.


I hope I am clear, and you get what exactly I wanted to say,

Is there any solution for this, I mean to say, to use table schema at design time and assign datasource at runtime as i used to do in Crystal Report.
Imp: your query builder does not help me a lot beacuse I use MySQL, and it does not supports MySQL Stored Procedures.


Thanx for the Help.
Steve
Telerik team
 answered on 28 May 2010
2 answers
124 views
Hello community,

I have a question about creating a crosstab report and wanted to get the community's thoughts before submitting a request ticket.  First off, the data is structured in the following format:

Category    Subcategory    Item        Value
January        1                       Apple       100
January        1                       Orange    50
January        2                       Apple       300
January        2                       Orange    75
February      1                       Apple       95
February      1                       Orange    60
...

The report needs to look like this:
January    Sub 1    Sub 2
Apple         100        300
Orange      50          75
February  Sub 1    Sub 2
Apple         95          ...
Orange      60          ...
...

The biggest restriction to this report is that the data is retrieved from a web service in this format, all at once.  Each category to me looks like a crosstab of Subcategory, Item, and Value, such as:
[=Category?]            [="Sub " + Fields.Subcategory]
[=Fields.Item]           [=Avg(Fields.Value)]

Though, I'm unsure how to repeat this cross tab for each category using the same data.  Assigning the corner [=Fields.Category] doesn't work (which makes sense but I'm not sure how to make it work.  Any help would be greatly appreciated.
Aaron
Top achievements
Rank 1
 answered on 28 May 2010
3 answers
228 views
Hi All,

I am newbie to Telerik Reporting. In SSRS table I have an option to set Details grouping with parent group. 

I want to display records in the following format.

Name                                            Level                 Debit                    Credit               Balance

Root Name 1                                 1                         ..............                 ..........              ..............
   Subroot Name 1                         2                         ..............                 ..........              ..............
       Sub root Name 1.1                 3                         ..............                 ..........              ..............  
       Sub root Name 1.2                 3                         ..............                 ..........              ..............  
            Sub root Name 1.2.1         4                         ..............                 ..........              ..............  
       Sub root Name 1.3                 3                         ..............                 ..........              ..............  
   Subroot Name 2                         2                         ..............                 ..........              ..............
   Subroot Name 3                         2                         ..............                 ..........              ..............
Root Name 2                                 1                         ..............                 ..........              ..............
.....etc.,

In the resultset each account has it parent. So In SSRS Details Grouping, I set Group on expression to Code (field name) and Parent group on PCode (field name). How do I achieve this in telerik report?

Also Is it possible to set toggled by another report item?

Steve
Telerik team
 answered on 28 May 2010
3 answers
91 views
Hello,

I was wondering if there was a "raw" or proprietary format you can export the report data to.  

Within our application, we can generate a report and the user can export to whatever format they would like to through the report viewer.  What I'd like to do is save off that report in a raw format that can later be used to re-generate the report through the viewer.  This will enable users who may not have adobe installed to save it in their own format.  It will also remain data independent, so that any user can see exactly what was printed.

Is this possible?

Thanks in advance,

Craig



PS.  Sorry for the duplicate post, the server said there was an error and to try again.  I did not see a way I could delete this post...
Steve
Telerik team
 answered on 28 May 2010
1 answer
145 views
Hi,
I have created 3 reports.
For e.g names of the report are A,B,C
 Report A -  is Main
SubReport B is subreport of A
Subreport C is the subreport of B

My problem is that, if I put subreport C in the detail section of Subreport B, it displays the data- for all records except first.
But  I want to display it in the Footer of B. When I put the Subreport C in the footer section of Subreport B, it does not display any data - just displays the labelheaders.

I would appreciate help with this.

Thanks,
Manisha
Peter
Telerik team
 answered on 28 May 2010
Top users last month
Chester
Top achievements
Rank 1
Iron
Simon
Top achievements
Rank 1
Iron
Douglas
Top achievements
Rank 2
Iron
Iron
SUNIL
Top achievements
Rank 3
Iron
Iron
Iron
Marco
Top achievements
Rank 3
Iron
Iron
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?