Telerik Forums
Reporting Forum
2 answers
125 views
Hello,

I'm trying to load my first chart using Telerik Reporting. I have this issue:

I want to create a line chart with two series. the data retrieved from sqldatasource is this:

Euribor1Mes    1Y    2.1153391880
Euribor1Mes    2Y    1.5951715250
Euribor1Mes    3Y    1.7828868410
Euribor1Mes    4Y    2.0519780200
...
Euribor1Mes    47Y    3.2136528810
Euribor 1Mes    48Y    3.2181399930
Euribor1Mes    49Y    3.2224216550
Euribor1Mes    50Y    3.2269428250
Libor1Mes    1Y    2.1153391880
Libor1Mes    2Y    1.5951715250
Libor1Mes    3Y    1.7828868410
Libor1Mes    4Y    2.0519780200
...
Libor1Mes    47Y    3.2136528810
Libor1Mes    48Y    3.2181399930
Libor1Mes    49Y    3.2224216550
Libor1Mes    50Y    3.2269428250

The first field is the name of each serie (there are two different), the second field is the X axis data and the third one is the Y axis data.

Can I load two chart series using this data?

Thank you very much.
Elian
Telerik team
 answered on 01 Dec 2011
1 answer
182 views
Hi Telerik Team,

    Is it possible to pass login session (credentials/values) from an asp page to a table datasource in telerik report? if yes, then how do I do it?
    I am using Q1 version. I followed some samples/examples to connect datasource programatically from telerik website but that doesn't produce the results. It causes error message " ExecuteReader: Commandtext property is not initialized for table 1".
    I have login session information in  .aspx page containing reportviewer and one .cs report which is attached to reportviewer.
Would you please reply to dhara.savani@Xerox.com?

Thanks,
Dhara
Peter
Telerik team
 answered on 01 Dec 2011
1 answer
52 views
Hi,

I'm creating my first report, to display an "offer", this offer has an id that I receive as a parameter of my data source.

I created an EntityDataSource, connected it to my data.

I've also added a parameter on the datasource to have only the row with the id in parameter.

Now, I'm a little lost, I've created some textBox, but if I go in the expression editor, in "Fields" I've a "No Data Source", why?

How can I bind the data of my selected row??

Image of my situation
Peter
Telerik team
 answered on 01 Dec 2011
8 answers
2.2K+ views
Hello All,

the report columns I want are not specific so that I am generating them dynamically.
I have a query how to bind image column dynamically, i am trying to bind similar to text-box object. but images not shown.

Please provide way to add image column dynamically.

Thank you in advance.

Michael
Top achievements
Rank 1
 answered on 30 Nov 2011
2 answers
103 views
I have a few issues with using charts (a stacked bar chart in this case) and telerik reporting.  Note that we have the Q3 2011 version of the telerik reporting tools.


The first issue is getting the chart to use the correct "labels" for the x-axis.
I have some data which is similar to the following:

Store    Department    Category   PercentA    PercentB
APN        A                    Start            2                    3
APN        A                    End             5                    6
APN        B                    Start            3                    5
APN        B                    End             6                    9
HWT       B                    Start            4                    8
HWT       B                    End             4                    7
HWT       C                    Start            2                    3
HWT       C                    End             8                    8

I then use this data to generate a stacked bar chart.  I use the Category department as the series, so each bar would be split into two (my actual chart has more than 2 categories, but that works fine).  It would then plot PercentA and PercentB on the Y-axes - again no problems.

What I want to do is to use the Store + Department as the x-axis groups.  I am able to use the Store + Department as a group for the tabular display of data, but not on the chart.  The chart currently only creates 1 bar for each Store.  Is there a way for me to tell the chart to use Store + Department for each bar? 


For the second thing, the labels on the x-axis (store) is intersecting the x-axis itself - please see attached screenshot for what I meant.  Is there a way to tell the chart to keep all x-axis labels under the x-axis line?
Elian
Telerik team
 answered on 30 Nov 2011
1 answer
331 views
I have a XAML drawing brush.  I want it to show in the PictureBox on a report.  But the report only takes an image from System.Drawing and not System.Windows.Media.  Any ideas anyone?

// Grab the XAML DrawingBrush
DrawingBrush db = (DrawingBrush)App.Current.Resources["BugIcon"];
// Create an image (wrong kind of Image though)
Image i = new Image()
{
   Source = new DrawingImage(db.Drawing),
   Height = 300,
   Width = 300
};
// Need to convert Image to System.Drawing.Image.
RenderTargetBitmap renderBmp = new RenderTargetBitmap(300, 300, 96, 96, PixelFormats.Pbgra32);
renderBmp.Render(i);

PngBitmapEncoder encoder = new PngBitmapEncoder();
encoder.Frames.Add(BitmapFrame.Create(renderBmp));

using (MemoryStream stream = new MemoryStream())
{
   encoder.Save(stream);
   System.Drawing.Image i2 = System.Drawing.Image.FromStream(stream);
// This is the Telerik report, and the pb1/pb2 are PictureBox controls
   ((Telerik.Reporting.PictureBox)sr.Items["header"].Items["pb1"]).Value = i2;
   ((Telerik.Reporting.PictureBox)sr.Items["header"].Items["pb2"]).Value = i2;
}
Paul
Top achievements
Rank 1
 answered on 29 Nov 2011
1 answer
92 views
Hey All,


I`ve got a report with predefined groupings, however, I now have to add a new group programmatically. I've figured out how to do it, except that I want to add it at the beginning of the Grouping collection, and when i try Report.Groups.Add(newGroup), it adds it at the end...


Right now i have two levels of grouping.

I want to add a third, but i need this new one to be the topmost grouping level.

How can I do this, if at all possible?

Thanks!
Elian
Telerik team
 answered on 29 Nov 2011
3 answers
100 views
Hi Telerik team,

After update to Q3 2011, the NavigationGroup is not rendering very well.

Here is my Html content:
<asp:Content ID="ReportContent" ContentPlaceHolderID="cphReport" runat="server">
    <div>
        <div>
            <telerik:ReportViewer ID="rvReportTravels" runat="server" Width="1150px" Height="800px"
                Report="ComUT.Reporting.Library.Stops, ComUT.Reporting.Library, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null">
            </telerik:ReportViewer>
        </div>
    </div>
</asp:Content>

Do you have any idea how to solve this problem?

Thanks
Giuliano Caetano
Steve
Telerik team
 answered on 29 Nov 2011
3 answers
444 views

Hi

 

I am trying to export report programmatically, after user changes the page settings for dynamically created report. Report has one column that displays images located on web server. When pdf is generated programmatically file shows error for every image in image column.
Error message:
An error has occured while processing PictureBox 'Imgquestion':Could not find a part of the path 'D:\BaseData\forms\forms\Image\00PlainImage.jpg'.

 

I.e. Its taking absolute path of image. It is necessary to me that export report programmatically according to users inputted settings.

If report get exported (ex. PDF format) using inbuilt export utility of report viewer object, then exported report file (i.e. pdf) would contains images as those displays in report viewer.

 

Please let me know how to fixed this issue.
Michael
Top achievements
Rank 1
 answered on 29 Nov 2011
6 answers
194 views
hi guys,

Im using a objectdatasource and after selecting my data method, and giving values to the data parameters im having problems,  an error apears while processing the report its because some of my parameters are nullable, but im not sure now what value i have to send
i tried nothing null -1  and nothing seems to work, any guesses?
Tomas
Top achievements
Rank 1
 answered on 29 Nov 2011
Top users last month
Jay
Top achievements
Rank 3
Iron
Iron
Iron
Benjamin
Top achievements
Rank 3
Bronze
Iron
Veteran
Radek
Top achievements
Rank 2
Iron
Iron
Iron
Bohdan
Top achievements
Rank 2
Iron
Iron
Richard
Top achievements
Rank 4
Bronze
Bronze
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?