Telerik Forums
Reporting Forum
1 answer
355 views

Hi, 

 

We are looking for a reporting tool (in ASP.NET MVC) which can generate reports on the fly based on the selected input parameters. 

In the model class i will have a list<list<string> which will contain the data to be binded to the report. Attaching a similar report which was dynamically generated on the fly for the reference. 

 

Regards,

Balu

Nasko
Telerik team
 answered on 22 Oct 2015
3 answers
258 views
Hi,
I have a asp.net MVC 4 application and I'm considering to include a reporting tools "telerik reporting".
Are there some example about how to show a report in HTML5 Report Viewer under these constraints:
1. The report is created with standalone telerik report designer and it is save as trdx file in  /App_Data folder,  so Report has to retrieved from /App_Data folder
     (use CustomReportResolver : IReportResolver  ?).

2. The report has to use a ObjectDataSource (eg.: list of object like List<Cars>) and the binding is done at runtime before the reports is shown, the list of object has to got from a repository class

    How to create fields on report at Design Time from ObjectDataSource  in standalone telerik report designer.



Thanks for any advice.


Stef
Telerik team
 answered on 22 Oct 2015
3 answers
490 views

Not sure the best way to explain so I figured I'd give a description and hopefully it'll make sense. :)

I have a cross tab report that uses the 12 months of the year for the rows and 2 consecutive years for the columns, and sum amounts in the details section. (12x2 grid with sum details).

 

My SQL data source has all the details needed, but these details are split up by an account number. So, if I have 100 accounts * 2 years * 12 months = 2400 rows of data in my data source.

(ex: Acct1, Jan, 2012,12units || Acct2, Jan, 2012, 2units || Acct1, Feb, 2012, 8units || etc.)

 

My end goal is to do a grouping by account and do a page break after group​'s footer to get 100 separate data pages (one for each account) each with a cross-tab containing the 12x2 grid ​showing all the details for only that one account. I'm hoping to do it with the single data  source SQL query (as opposed to making 100 separate round trips that may be needed to do each individual account).

 

Ideas? Thanks!

 

Stef
Telerik team
 answered on 22 Oct 2015
3 answers
923 views
I have a table with 3 columns. The 3rd column usually has no data. I want to hide this column if there is no data. How can I do this?
Nasko
Telerik team
 answered on 22 Oct 2015
1 answer
68 views

Hey Telerik People!

Due to some turnover at our company and others taking on more important roles, I have been given the unfortunate privilege of converting some Crystal Reports to Telerik (the old saying about "you know what" rolls down hill comes to mind). The problem here is that I know absolutely nothing about Crystal and very little about Telerik. To make things even better, I know almost nothing about coding or scripting. I haven't done any serious report creation since college when I used MS Access 2003. In my opinion, what's happening here is equivalent to giving an assignment to read War and Peace to a child who's just learned to read.

Now that's out of the way, on to the question part...

A field entitled "ck_Date_Changed" in one Crystal Report has the below expression tied to it:

if {Command.ck_Date_Changed} = Maximum ({Command.ck_Date_Changed}, {Command.ix_Student_Number}) then
false
else
true

The field tracks the date & time changes were made to an account. So far, I've been able to move most of the fields and very basic expressions from Crystal to Telerik. I've even managed to get the report to pull data, however, the report shows a line item for each date & time a change was made to the account. I need it to only show the most recent change. Somehow, the above statement was used to do that in Crystal.

I need to first understand what this expression is doing, then I need help converting it to Telerik friendly language.

I have about 10 of these reports to convert (all different) and some have sub-reports.

Thanks for any assistance anyone provides. Let me know if clarification is needed.

Nasko
Telerik team
 answered on 22 Oct 2015
5 answers
316 views

Hello,

I have a question regarding ReportBook. I send a request like that in JS after a click on a button : 

.telerik_ReportViewer({
    serviceUrl: apiUrl,
    templateUrl: reportUrl,
    reportSource: {
        report: "Reports.Controlling.Controlling, Reports",
        parameters: params
    }
});

 

In an standard report I can access parameters with this line : 

var report = (Report)sender;
var parameter1 = Convert.ToInt32(((object[]) (report.Parameters[BusConstants.ParamOfferId].Value))[0]);

Now I want to do the same with a reportBook. For example, get the paramters and do that : 

if(parameter1)
    Reports.Add(new RegionRevenue(parameter1));
else
{
    Reports.Add(new ProductPartCosts(parameter2));
    Reports.Add(new ServicePerformanceCostReport());
     
}
 

Is it possible (to get parameters the same way and use them to instanciate books) ? Cause I've seen this thread and I think that's not possible : http://www.telerik.com/forums/reports-with-document-map-excel-sheet

Thank you for your help.

Mathieu

​

Stef
Telerik team
 answered on 21 Oct 2015
1 answer
310 views

Hello,

 

I haven't found an answer to my problem although I don't think it is too hard to achieve what I want.

 I don't know how to show the Telerik.Reporting.GroupHeaderSection just once on every page. I don't want it to be shown after every break header if that is not a new page.

 I hope you can help me.

 

Thanks!

Nasko
Telerik team
 answered on 21 Oct 2015
1 answer
275 views

Hi,

I need to Open document automatically using COM components once Export to excel or PDF is completed using Silverlight Report viewer's Export functionality.

It is allowing me to browse folder where I want to export file. Once Export is completed, I need that Export File name and Path. So I can work on open file related functionality.

Can you guide me which event and code, I should use to achieve it?

 

Thanks in Advance,

Shimoli Shah.

Stef
Telerik team
 answered on 21 Oct 2015
1 answer
153 views

Hi

I've created a simple report with the standalone designer and using a ReportViewer on a webpage, I'm able to view the report in the browser. Additionally, I've created an external assembly and I'm able to source data from it using an object data source (works fine in the browser too).

The problem comes in when I try to use a static method in the external assembly. I can see it and works fine in the standalone designer but I get the following error in the web page:

An error has occurred while processing TextBox 'textBox32': The expression contains object 'ReportDataSource' that is not defined in the current context.

 

The text box has the expression:

= ReportDataSource.MyReports.FormatCurrency(Fields.Currency, Fields.Amount, 2)

I've been through the article http://www.telerik.com/support/kb/reporting/report-designer/details/deploying-trdx-(xml-report-definition)-that-uses-external-assembly and made the recommended config changes in the web.config file but I still get the error. It appears this article is specific to desktop and not web applications.

How do I get my method visible in a web environment?

Thanks

Stef
Telerik team
 answered on 21 Oct 2015
1 answer
245 views

i have ReportViewer1 in Report1.aspx with uri= Report1.trdx wich have int parameter "si"

in code page of Report1.aspx.cs i write :

    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {

            //Telerik.Reporting.UriReportSource uriReportSource =  new Telerik.Reporting.UriReportSource();
            //uriReportSource.Uri = "Report1.trdx";
            //Int32 ss = (int)(Session["u_id"]);
            //uriReportSource.Parameters.Add(new Telerik.Reporting.Parameter("si", ss.ToString()));  

            Telerik.Reporting.TypeReportSource typeReportSource = new Telerik.Reporting.TypeReportSource();
            typeReportSource.TypeName = typeof(Report1).AssemblyQualifiedName;
            Int32 ss = (int)(Session["u_id"]);
            typeReportSource.Parameters.Add(new Telerik.Reporting.Parameter("si", ss));
        }
    }
 but not working , helpe me please

​

Stef
Telerik team
 answered on 21 Oct 2015
Top users last month
Will
Top achievements
Rank 2
Iron
Motti
Top achievements
Rank 1
Iron
Hester
Top achievements
Rank 1
Iron
Bob
Top achievements
Rank 3
Iron
Iron
Veteran
Thomas
Top achievements
Rank 2
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?