Telerik Forums
Reporting Forum
1 answer
138 views

I want file trdx connect sql stored produre

 

 <DataSources>
    <SqlDataSource ConnectionString="Telerik.Reporting.Examples.CSharp.Properties.Settings.TelerikConnectionString" SelectCommand="SELECT InvoiceDetails FROM dbo.POS_Invoice WHERE LEN(InvoiceDetails) > 0" Name="sqlDataSource1" >
      <Parameters>
        <SqlDataSourceParameter DbType="String" Name="@CompanyId">
          <Value>
            <String>=Parameters.CompanyId.Value</String>
          </Value>
        </SqlDataSourceParameter>
        <SqlDataSourceParameter DbType="String" Name="@BranchId">
          <Value>
            <String>=Parameters.BranchId.Value</String>
          </Value>
        </SqlDataSourceParameter>
      </Parameters>
    </SqlDataSource>
  </DataSources>

 

thank a lot

Stef
Telerik team
 answered on 18 Dec 2015
3 answers
444 views
Howdy,

I am trying to see if a way currently exists to allow dynamic groupheader text changes.  Specifically, I have the following scenario:

I am using C# in a Windows environment with IE8.

I have a subreport that has several lines of header followed by a HtmlTextBox that contains text entered by the user and can span to more than one page.  Users have requested that when the print takes more than 1 page that not only does the groupheader section repeat on every page (which I was able to do via the PrintOnEveryPage property) but that the pages after the first one have a <continued> added to them.

Is there a way to do this that I haven't been able to find.  If not, is it possible in a later release?

Thanks
Hinata
Top achievements
Rank 1
 answered on 18 Dec 2015
1 answer
191 views

Hi,

I was creating a new report which having sub-report.

After final update for telerik report 9.2.15.1126 (Capture_3).

But i couldn't find the tool sub-report in toolbox on designer page (Capture_2).

And later i have noticed that the report designed before the update when i was using telerik report version Q3 of 2012, 

now showing the error on opening that page as shown in attached file below (Capture_1).

Does telerik removed the sub report option from the designer or any other tool is there same as sub report.

 

With Regards,

Mohammed Rafsanjany

Stef
Telerik team
 answered on 17 Dec 2015
1 answer
194 views

Hi,

 I have a requirement for a graph report that is grouped by a property and therefore shows a graph per each group.

 The desired look is for the legend to be at the top of the report and not to be repeated for each graph (number of series 'is'/'can be made to be constant' through each group). Also each graph is to have the same size.

From fiddling around I can think of 2 ways of doing this by hooking up to the ItemDataBinnding or ItemDataBound events:

- Show the legend for the first graph only and somehow make the graph (plot area) height the same as the other graphs.

- Add a dummy group of data that will become the first graph, show the legend only on this one and hide the plot area.

 

It appears that if I set the Visible property of the plot area to false at runtime the plot area is still visible. Also trying to set the plot area height to 0 does not work. Any suggestions?

 

Stef
Telerik team
 answered on 17 Dec 2015
1 answer
74 views
I'm using Silverlight and the MVVM pattern with my current project. I have a listbox where the currently selected item is bound to a single telerik report viewer control. When the user selects an item in the listbox, the selected item changes and triggers the report to be displayed in the report viewer control. This all works as expected. My issue is that when the user goes back to a previously selected report, the report viewer sends a new report request to the server rather than trying to retrieve the cached report. I did a little bit of digging and found the DataContext of the telerik report viewer is a ReportViewerModel that has a CurrentSessionID property. On a new report request the CurrentSessionID is set to null. I'd like to store the CurrentSessionID after a report is rendered. That way if a user goes back to a report that's already been run, I can set the CurrentSessionID. Unfortunately, the CurrentSessionID property is a private property and I can't set it's value. Is it possible to make CurrentSessionID a public property? How can I accomplish this?
 
 
 
 
 
Stef
Telerik team
 answered on 17 Dec 2015
1 answer
138 views

Hi mates,

I have a report with a dataset with some textboxes and a table. There are two dataset, one of the report (dsReport) and another different one of the table (dsTable). This table has two columns, the first one is a subinform and the other one show a value of dsTable. A field of dsReport is used like a paremeter in dsTable with the expression ReportItem.DataObject.id.ToString(). The value of the field that is showed in the second column is showed successfully but if I try to show this same value in the subreport using it like a parameter of the subreport, the value is not showed.

I think it's difficult to explain it so, please, if you need any trdx file, let me know it.

 Thanks a lot in advance.

Cheers.

David Ortega

davortsan
Top achievements
Rank 1
 answered on 17 Dec 2015
1 answer
89 views
which is better to use for caching when using REST Report service
file storage or sql database ??
Stef
Telerik team
 answered on 16 Dec 2015
3 answers
1.1K+ views

Hello, 

I am having a dynamic code based report which generates sales value for certain items. My items are grouped under categories. After each category i am showing a "TOTAL" row to show total value for all items under each category. Thats working fine... Where i am stuck is, i need to show the TOTAL row as BOLD (Font Style). Issue is, the TOTAL row which is added after each category is coming from the Stored Procedure itself. So how can i access Data Value of the CELL in my Report table(Layout) and check if value inside my CELL is "TOTAL" and i make that row as BOLD (Font Style)

I tried the Conditional formatting option that i found on this link http://www.telerik.com/forums/changing-fonts-and-colors-on-a-quot-dynamic-quot-table-based-on-value but this code is in VB and i am working on C#. 

If you can please provide a c# alternative to this it would be greatful

 

Thanks in advance.

Stef
Telerik team
 answered on 14 Dec 2015
5 answers
339 views

Hi,

 I am using ObjectDataSource. I have 4 list objects inside that object.

 In the report design view, I can see all the properties (fields) inside that object but not other 4 sub-objects. How can I make those properties (fields) display in the selection window?

Thank you!

 

 

Stef
Telerik team
 answered on 12 Dec 2015
1 answer
140 views

I have delivery tickets that I need to print.  The number of these can vary from 1 to 30+.  

I can get an individual report to show fine using this syntax in my MVC view.

@{
    var typeReportSource = new TypeReportSource() { TypeName = "Fasttrak.Reports.CarrierTrakDeliveryTicket, Fasttrak" };
        typeReportSource.Parameters.Add(new Telerik.Reporting.Parameter() { Name = "BOLRecId", Value = 16778 });
}
 
@(Html.TelerikReporting().ReportViewer()
        .Id("reportViewer1")
        .ServiceUrl("/api/reports/")
        .TemplateUrl("/ReportViewer/templates/telerikReportViewerTemplate-9.0.15.324.html")
        .ReportSource(typeReportSource)       
        .ViewMode(ViewModes.INTERACTIVE)
        .ScaleMode(ScaleModes.SPECIFIC)
        .Scale(1.0)
        .PersistSession(false)
)

 

I need to be able to bring up multiples of this report together.  I have tried the following and get "No Report" returned in the viewer.

@{
    var reportBook = new Telerik.Reporting.ReportBook();
     
    var test = Activator.CreateInstance(typeof(Fasttrak.Reports.CarrierTrakDeliveryTicket)) as Telerik.Reporting.Report;
    test.ReportParameters["BOLRecId"].Value = 16778;
    reportBook.Reports.Add(test);
     
    var reportDocument = new Telerik.Reporting.InstanceReportSource();
    reportDocument.ReportDocument = reportBook;
     
}
 
@(Html.TelerikReporting().ReportViewer()
        .Id("reportViewer1")
        .ServiceUrl("/api/reports/")
        .TemplateUrl("/ReportViewer/templates/telerikReportViewerTemplate-9.0.15.324.html")
        .ReportSource(reportDocument)       
        .ViewMode(ViewModes.PRINT_PREVIEW)
        .ScaleMode(ScaleModes.SPECIFIC)
        .Scale(1.0)
        .PersistSession(false)
)

 

This is my ReportsController:

using System.Web;
using Telerik.Reporting.Cache.Interfaces;
using Telerik.Reporting.Services.Engine;
using Telerik.Reporting.Services.WebApi;
 
public class ReportsController : ReportsControllerBase
{
    protected override IReportResolver CreateReportResolver()
    {
        var reportsPath = HttpContext.Current.Server.MapPath("~/Reports");
 
        return new ReportFileResolver(reportsPath)
            .AddFallbackResolver(new ReportTypeResolver());
    }
 
    protected override ICache CreateCache()
    {
        return Telerik.Reporting.Services.Engine.CacheFactory.CreateFileCache();
    }
}

 

Any idea why I'm not seeing the ReportBook in the viewer?  

Stef
Telerik team
 answered on 12 Dec 2015
Top users last month
Marco
Top achievements
Rank 4
Iron
Iron
Iron
Hiba
Top achievements
Rank 1
Iron
Iron
Rob
Top achievements
Rank 3
Bronze
Bronze
Iron
Max
Top achievements
Rank 1
Veteran
Iron
Alina
Top achievements
Rank 1
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?