Telerik Forums
Reporting Forum
1 answer
59 views
how to avoid page break in last page of the report. Page Break is allowed in Group footer but in last page it insert blank page please help for this problem
Stef
Telerik team
 answered on 06 Jan 2017
3 answers
818 views
Hi all,
I'm getting a value from a query which is an integer that represents a month. How would I convert this integer to an actual month name for displaying in the report? Is there any specific expression or function to be used as I can't seem to find any?

Thanks,
DK..
Stef
Telerik team
 answered on 06 Jan 2017
1 answer
382 views

I am building reports that I would like to embed a picture in. This way I can deploy the file to clients with the picture in the file.

 

Can this be done.? Currently the picture does not display as the picture file is on my computer and not my customers.

 

THanks. 

Stef
Telerik team
 answered on 06 Jan 2017
5 answers
191 views

Hello Forum

I have a report that contains a pie chart and I want to use the datapointlabelconnector (the little line linking the % to the section of the pie chart) only for sections in the pie chart that are too small to fit the actual datapoint label.  

 

The sections of the pie chart correspond to a series group in the graph.  The expression for the DataPointLabel is:

= Sum(Abs(Fields.Exposure)) / CDbl(Exec('graph2', Sum(Abs(Fields.Exposure))))

 

How can I write a conditional formatting expression for the "DataPointLabelConnectorConditionalFormatting" that will use label connectors only when the datapointlabel value is less than 5%?

 

Thanks,
Derek

Stef
Telerik team
 answered on 05 Jan 2017
8 answers
828 views
Hello.

I have an "ImageModel" class List in a data source item. Every "ImageModel" instance contains byte array "Image" field. I need to create and add pictureBox to the panel for every  "Image" field. I try to do it in the panel's ItemDataBinding event handler:

 private void pnlImg_ItemDataBinding(object sender, EventArgs e)
        {
            var panel =  sender as Telerik.Reporting.Processing.Panel;
         
            var imageList = panel.DataObject["ImageList"] as ICollection<ImageModel>;
         
            var pictureBox = new Telerik.Reporting.PictureBox();

            for (int i = 1; i <= imageList.Count; i+=1)
            {
                pictureBox.MimeType = "image/jpeg";
                pictureBox.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Cm(1.8D), Telerik.Reporting.Drawing.Unit.Cm(1.3D));
                pictureBox.Sizing = Telerik.Reporting.Drawing.ImageSizeMode.ScaleProportional;
                pictureBox.Visible = true;
                pictureBox.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Cm(i%4==0 ? 0 : 1.8D*i), Telerik.Reporting.Drawing.Unit.Cm(1.3D*(i/4)));
                using (var ms = new MemoryStream(imageList.ElementAt(i-1).Image))
                {
                    pictureBox.Value = Image.FromStream(ms);
                }
                pnlImg.Items.Add( pictureBox );
            }
        }

In the result I get the empty panel. I tried to use Telerik.Reporting.Processing.PictureBox() instead Telerik.Reporting.PictureBox(), but there is no ability to create an instance of a Telerik.Reporting.Processing.PictureBox. Is there any ability to create pictureBox programmatically and add it to a Telerik.Reporting.Panel? I'm using Telerik Reporting Q1 2014 Trial Version.

Thanks!

Chris
Top achievements
Rank 1
 answered on 05 Jan 2017
0 answers
47 views

For pie chart, if  DataClass("xxx", 1) then slice gets out of circle.

Please give me any solution.

Ranjith
Top achievements
Rank 1
 asked on 04 Jan 2017
5 answers
218 views
Hi, 

Can i please get some advice on how to incorporate existing reports in to my ASP.Net MVC application?

The are in a separate project inside the same solution and were created with the telerik report designer for visual studio.
The reports run and can be visualised without any issue, however i have no idea how to display these same reports inside of a view in my main application.

I have looked at the existing  documentation and some of the examples avaiable but i cannot achive the same results.

Some examples stated that i need to have an instance of report server running. other examples state that all i need is to add a report viewer, I tried to add one to my app however the report viwer cannot find my reports because it looks for files of extention TRDX which are not the same as my reports, in fact the report server also seems to use TRDX files.

So can i please get som indication into how to get my reports displaying in my app (based on ASP.Net MVC .net 4.5 (Razor)) . And if needed how can the existing reports be converted to the TRDX format?

Links to a walkthrough example would be greatly appreciated.

Regards
Carlos
Top achievements
Rank 1
 answered on 03 Jan 2017
0 answers
130 views
I want to change some properties of a panel located in page footer section. For doing this , I can create  an itemdata binding(or bound) event  in the pagefooter section . But this event maybe fired 12 or 13 time on a report that have only one or two page.  I found if I  could insert my code in item data binding(or bound) of the report , this event only one time is fired . My problem in the events of (except page footer section events) is "not modifying of the  element of pagetfooter section - hear 'my panel  control' " . I want to change properties of page footer section controls  by coding in the events of the report (because events of the Report only fired one time) . In the event of the "Report" I can not change the properties of the page footer section controls .
M
Top achievements
Rank 1
 asked on 02 Jan 2017
0 answers
108 views

Hello, 

      I am using standalone designer to design a table with ten columns. I am setting table columns visibility  based on some conditions. So, number of columns that are displaying will be based on that condition. I need to increases displaying columns width to fit into the page.Please refer the attached screen shot. 

Ramki
Top achievements
Rank 1
 asked on 02 Jan 2017
6 answers
625 views
Hi,

I've got a connectionstring problem, I know these kind of questions have been asked thousands of times before but still I cannot figure out what I'm doing wrong.

Here's a simplified structure of my solution:

DataModelClassLibrary
-includes my Entity Framework Model along with a app.config including my db connectionstring like this:
<connectionStrings>
   <add name="MyModelEntities" connectionString="metadata=res://*/Models.MyModel.csdl|res://*/Models.MyModel.ssdl|res://*/Models.MyModel.msl;provider=System.Data.SqlClient;provider connection string="Data Source=MYSERVER;Initial Catalog=MYDB;Persist Security Info=True;User ID=MyUser;Password=MyPassword;MultipleActiveResultSets=True"" providerName="System.Data.EntityClient" />
 </connectionStrings>

TelerikReportClassLibrary
-here I've defined my reports i've also added a app.config with the same connectionstrings as the app.config
in my DataModelClassLibrary

MyWebProject
-here I've got my actual program and of course it has a web.config again with the same connectionstrings as the app.config
in my DataModelClassLibrary

Now to the problem, if I add a EntityDataSource or a SqlDataSource directly to a report and set it up using one of the
connectionstrings that i've copied to the app.config I'm able to connect to my data and design the report and preview it
within the designer. It also works as expected at runtime.

However recently I wanted to use the ObjectDataSouce so that I could separate out some logic from the report not to make
the report itself too complex and here's where I hit a problem.
I added a class let's say Cars to my TelerikReportClassLibrary which is responsible of retrieving data using my ef model defined in DataModelClassLibrary. I set the report to use a ObjectDataSource and points its select method to a method in the newly created class.
At runtime I can recieve data just fine but if i try to preview the report in the designer I get the following error:
An error has occurred while processing Report 'MyReport':
Exception has been thrown by the target of an invocation.
------------- InnerException -------------
The specified named connection is either not found in the configuration, not intended to be used with the EntityClient provider, or not valid.

I was able to get around the problem using a technique similar to the one described here:
http://www.telerik.com/community/code-library/reporting/general/use-the-connectionstring-from-your-app-s-config-file.aspx
So that I first checked if it can find the configured connectionstring and if not I manually hardcode one using the EntityConnectionStringBuilder

Is this really my only option? Why can't the report designer find my connectionstring?

Tomas
Dilan
Top achievements
Rank 1
 answered on 31 Dec 2016
Top users last month
Anislav
Top achievements
Rank 6
Silver
Bronze
Bronze
Jianxian
Top achievements
Rank 1
Iron
Marco
Top achievements
Rank 3
Iron
Iron
Iron
Jim
Top achievements
Rank 2
Iron
Iron
Nurik
Top achievements
Rank 2
Iron
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?