Telerik Forums
Reporting Forum
1 answer
67 views

Is there anyway to print a list of just the columns from that page on a crosstab report?

My report column heading is just a code an I would like to give more detail about that code at the bottom of each page but would only want to explain the codes that have printed on that page. 

For example if I a 2 page report on page 1 the columns that print are ABC, DEF, GHI I would like to print a list after the rows that would look like

ABC - Explanation

DEF- Explanation

GHI - Explanation

I'm not sure if this is possible but I hope my explanation makes some sense.

Thanks

 

Katia
Telerik team
 answered on 16 May 2016
1 answer
277 views
Hello guys, I am trying to configure Telerik Reporting for Html5 in my asp.net mvc 5 application (.Net Framework 4.5). I have another application using asp.net mvc 4 (.net 4.0) that works fine but in mvc 5 and .net 4.5 it fails. I have referenced in my asp.net mvc application the assemblies "Telerik.Reporting" and "Telerik.Reporting.Services.WebApi" (set Copy Local = true) of R2 2016 version of Telerik Reporting. I have configured the handlers in the web.config file too.

In the WebApiConfig.cs file that configure the routes for the web api, I have added the line to configure the routes for telerik reporting api.
public static void Register(HttpConfiguration config)
{
  // Web API routes
  config.MapHttpAttributeRoutes();
 
  config.Routes.MapHttpRoute(
    name: "DefaultApi",
    routeTemplate: "api/{controller}/{id}",
    defaults: new { id = RouteParameter.Optional }
  );
 
  // configure routes for telerik reporting
  Telerik.Reporting.Services.WebApi.ReportsControllerConfiguration.RegisterRoutes(config);
}


The problem is, if I add this line that configure the routes for telerik reporting, I get an error

Could not load file or assembly 'System.Web.Http, Version=4.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35'...

If I remove the line, the application runs fine, but when I try to execute a page with a report, I get another error on the report viewer like this:

Error registering the viewer with the service.
No HTTP resource was found that matches the request URI 'http://localhost:54925/Api/Reports/clients'.


Am I missing something? Is it a problem with the version of .net framework? How can I get it working for asp.net mvc 5 and .net framework 4.5?

Thank you.

Stef
Telerik team
 answered on 14 May 2016
7 answers
631 views
Hi Guys

Is there any way to use the Telerik ReportViewer inside an AngularJS app? From what I've read the report viewer, even the HTML version, is still a server side control and needs ASP.NET to work, is that right ? I want to be able to view our telerik reports from a separate web client app.

Help appreciated

Rav
Stef
Telerik team
 answered on 14 May 2016
1 answer
279 views

I have a report that contains a chart and it has category groups that are somewhat long.  I'd like to either specify the max size of these so that it wraps the text down or be able to insert a line break in the Label formula.  I can't seem to figure out how to do that in the editor and was hoping someone else knew how to do it.  See the screen shot attached for an example of the long labels.  The middle one I'd like to at least have as "Shops at Branson Meadows" on one line and Parking Zone 1 on the second.

Katia
Telerik team
 answered on 13 May 2016
6 answers
216 views

How do I display shapes on a map? I have a list of co-ordinates in WKT format that make up simple polygons. I want to fill each polygon with a colour and display it on a map for the report.

Do I use a choropleth, or a ShapeMapSeries, or something else?

I've tried following this documentation and doing it programmatically, but I get this unhelpful error:

An error has occurred while rendering the report: System.NullReferenceException: Object reference not set to an instance of an object.
   at Telerik.Reporting.XamlRendering.DocumentWriting.PrimitiveWriter.WriteText(TextElement textElement)
   at Telerik.Reporting.XamlRendering.DocumentWriting.PrimitiveElementWriter.Visit(TextElement textElement)
   at Telerik.Reporting.Processing.Primitives.TextElement.Accept(PrimitiveElementVisitor visitor)
   at Telerik.Reporting.XamlRendering.DocumentWriting.XamlGraphWriter.Write(PrimitiveElement primitiveElement)
   at Telerik.Reporting.Processing.GraphWriter.<WriteGraphArea>b__4(PrimitiveElement a)
   at Telerik.Reporting.EnumerableExtensions.ForEach[T](IEnumerable`1 source, Action`1 action)
   at Telerik.Reporting.Processing.GraphWriter.WriteGraphArea(GraphArea graphArea)
   at Telerik.Reporting.Processing.GraphWriter.Write(Graph g)
   at Telerik.Reporting.XamlRendering.DocumentWriting.GraphWriter.WriteDataItemContent(LayoutElement element, ElementPageInfo pageInfo)
   at Telerik.Reporting.XamlRendering.DocumentWriting.DataItemWriter.WriteContent(LayoutElement element, ElementPageInfo pageInfo)
   at Telerik.Reporting.XamlRendering.XamlWriter.WriteStartElement(LayoutElement element, ElementPageInfo pageInfo)
   at Telerik.Reporting.BaseRendering.PageHandler.Telerik.Reporting.Paging.IPageHandler.StartElement(LayoutElement element, ElementPageInfo info)
   at Telerik.Reporting.Paging.PageStartElement.AddToPage(IPageHandler handler)
   at Telerik.Reporting.Paging.PageElementLayer.AddToPage(IPageHandler handler)
   at Telerik.Reporting.Paging.PageElementManager.AddToPage(IPageHandler handler)
   at Telerik.Reporting.Paging.PageCompositionBase.AddElementsToPage()
   at Telerik.Reporting.Paging.PageCompositionBase.SendPhysicalPages()
   at Telerik.Reporting.Paging.PageCompositionBase.OutputPage()
   at Telerik.Reporting.Paging.PageCompositionBase.CreatePages()
   at Telerik.Reporting.Paging.PagerBase.Telerik.Reporting.Paging.IPager.CreatePages(IPageHandler handler, Report report)
   at Telerik.Reporting.BaseRendering.RenderingExtensionBase.Render(Report report, Hashtable renderingContext, Hashtable deviceInfo, CreateStream createStreamCallback, EvaluateHeaderFooterExpressions evalHeaderFooterCallback)

 

Here is an example of the code I'm using:

ObservableCollection<PrettyShape> data = GetTestData();
 
var myReport = new Report();
var detail = new DetailSection { KeepTogether = true };
var testGroup = new MapGroup();
var detailPanel = new Panel
{
    Docking = DockingStyle.Top,
    Size = new SizeU(Unit.Pixel(600), Unit.Pixel(400)),
    Items =
    {
        new Map
        {
            Size = new SizeU(Unit.Pixel(600), Unit.Pixel(450)),
            Location = new PointU(Unit.Pixel(0), Unit.Pixel(50)),
            TileProvider = new GenericTileProvider { UrlTemplate = "url of tile provider goes here - tested in WPF RadMap" },
            Projection = new MercatorProjection(),
            DataSource = data,
            Series =
            {
                new ShapeMapSeries
                {
                    ShapeMapGroup = new ShapeMapGroup(),
                    SeriesGroup = testGroup,
                    ColorData = "=Fields.FillColour",
                    SourceType = new WellKnownTextSourceType { SpatialField = "=Fields.BoundaryPoints" }
                }
        },
        SeriesGroups = { testGroup }
}
detail.Items.Add(detailPanel);
myReport.Items.Add(detail);
 
MyReportViewer.ReportSource = new InstanceReportSource { ReportDocument = myReport };
MyReportViewer.RefreshReport();

 

and here is the data object:

public class PrettyShape
{
  public string BoundaryPoints { get; set; }
  public string FillColour
  {
    get
    {
      //various logic
      return "LimeGreen";
    }
  }
}

 

ObservableCollection<PrettyShape> GetTestData()

{

  var list = new List<PrettyShape>

  {

    new PrettyShape{ BoundaryPoints = "POLYGON ((-22.635025359284 118.120505304517, -22.635025359284 118.103713989258, -22.64653164056320 118.103713989258, -22.64653164056320 118.120505304517))" }

  };

  return new ObservableCollection<PrettyShape>(list);

}

Jeremy
Top achievements
Rank 1
 answered on 13 May 2016
3 answers
337 views

Hi there, 

 

i have a problem while exporting the report to the PDF. 

I am using DFKai-SB for the Traditional Chinese and Simplified Chinese font type, it is fined while I am running on Windows Platform but when i am using a Mac OS, DFKai-SB font type is not support and it can't export the chinese character on the Mac, how can i handle it?

 

Regards, 

 

Jason 

Stef
Telerik team
 answered on 12 May 2016
1 answer
233 views
I have a report setup that is showing borders in the report header and details section, but nothing in there has a border setup on it.  What else would cause this to happen?  The attached file shows the black border that is now appearing.  I checked all the border settings twice and nothing has them setup.  What else could I be missing?  Let me know please, thanks.
Stef
Telerik team
 answered on 12 May 2016
2 answers
605 views

I have a multi-select parameter where I want to set 2 default values (MTD, YTD).  The parameter dropdown allows the user to select which periods they would like to view.  For Each Organization, the periods have different ID's and can have different names.  But there are some commonalities.

Some orgs use YTD, some use FYTD.  SO I need to be able to set my default value something like:

               = Array(Field.ShortName Like '%YTD%' OR Fields.ShortName Like '%MTD%')

However, I have tried this and it does not work.  Does anyone know a solution for this?

Thanks,

Phillip

     

Stef
Telerik team
 answered on 12 May 2016
1 answer
563 views

I am new to Telerik reporting, but have experience in Crystal, so I get the basic ideas.  However, I am working on a report where we need to group it by item # and display the data accordingly.  I am having issues getting the format I am looking for (see below).  How do I get multiple values into the item # group row?  Is it possible?  The issue I have now is that I cannot merge two cells to get the item # line to show correctly.  The table setup keeps throwing me for a loop, so any help in getting this setup would be appreciated.  Thank you.

 

Item #             Item Desc            Current Price    

1234567890   New Item Desc    $15.00

     Orig Price  New Price Effective Date....

      $14.95      $15.00       5/1/2016

      $14.95       $14.96      4/1/2015

1234                Item Desc 2 ......

Stef
Telerik team
 answered on 12 May 2016
2 answers
1.1K+ views
Hi,

is there any way to select report parameter value for parameter with defined data source, when preview report in Report Designer?

I can set value for simple text parametr in Parameter Properties window, but how to select value when parameter with own data source for values?

Thanks a lot!
Kyle
Top achievements
Rank 1
 answered on 11 May 2016
Top users last month
Cynthia
Top achievements
Rank 1
Iron
Toby
Top achievements
Rank 3
Iron
Iron
Iron
Danielle
Top achievements
Rank 1
Iron
Iron
Joel
Top achievements
Rank 3
Bronze
Bronze
Iron
yw
Top achievements
Rank 2
Iron
Iron
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?