Telerik Forums
Reporting Forum
2 answers
1.1K+ views
I have set up a SQLDataSource parameter for a report and can set its value at design time. I need to set the parameter value from a UI element at runtime. This is the code that I have (setting the TypeReportSource dynamically at runtime works fine, and I can query the report's parameter's collection without issue. However, once I update the parameter value, the report still uses the design-time value.

// Specifying the assembly qualified name of the Report class for the TypeName of the report source<br>
ViewerReportSource = new TypeReportSource {TypeName = selectedReport.ReportType.AssemblyQualifiedName};<
br><br>
// create instance of report
<
br>var report = (Report)Activator.CreateInstance(selectedReport.ReportType);
<
br><br>
// Set filters (datasource params)<
br>
var ds = report.DataSource as SqlDataSource;<
br>
ds.Parameters["@UserID"].Value = 999;


the value '999' is not passed into the query (I am using SQL Profiler to see the value passed in by the reporting framework). I see the value I set at design time.
kaczmar2
Top achievements
Rank 1
 answered on 17 Feb 2015
10 answers
3.1K+ views

OK I have looked in the docs to no avail.

Take a look at the attached files. What I want to do is get the value that is in the first section Total

(This is a group footer section in Telerik) in the example the value is 81 and I want to show this value in the report footer section. I want to do the same thing for the next group. Things work great when used under the group, and for the entire report SUM() works but how would I display a group value  that is the result of a SUM() on the group in the report footer?

 

I’m sure this can’t be hard but can’t seem to find the info on what to put into the text box value.

 

I was thinking it might be something like value =  MyReport. sectionNamesGroupFooter(0). Sum(Fields.Count) or something with the 0 representing the first group if I wanted the value of the second group I would use value =  MyReport. sectionNamesGroupFooter(1). Sum(Fields.Count)

 

Thanks

Nasko
Telerik team
 answered on 17 Feb 2015
3 answers
99 views
We are using Telerik Reporting Q3 2014 web report viewer in our MVC 4 project running .net 4.5. 
With our reports that use a textbox that require an integer input, we found an issue with data entry into those fields. This issue is only found in IE8+, Google Chrome, and Firefox are unable to replicate this issue. The issue is that whenever an integer is put into this field it is not being sent back to the report resolver and makes the report parameters inoperable for the report rendering it useless. Is this a known issue? 

I'm wanting to make custom report parameters for drop down lists, so i may be able to make that work with this particular field. If i can put in Kendo Datetime picker that just does a year it would work better... 

     So i guess my question after all this, Using the project that i specified above and using an MVC control for the report viewer, how do i go about creating custom parameters for the options on the report. 
Stef
Telerik team
 answered on 17 Feb 2015
5 answers
329 views
I have a c# dll file which creates a pdf report.
I use:
Log("start rendering")
                Telerik.Reporting.Processing.ReportProcessor reportProcessor = new Telerik.Reporting.Processing.ReportProcessor();
                Telerik.Reporting.Processing.RenderingResult auditAsPdf = reportProcessor.RenderReport("PDF", report, null);
Log("finish rendering")


my application creates dump file in runtime, so I added logs, and I see the first log print but I don't get the "finish" print.
right after I get your print: *** ReportProcessor.Render DONE in 00:00:02.6466816 *** in debug view, the dump file is created.

I use TelerikReporting 3.1.9.701

Any ideas why?

KS
Top achievements
Rank 1
 answered on 17 Feb 2015
1 answer
403 views
Hello,

I'm trying to build up a table-based report where I'm trying to keep the layout as tight as possible width-wise.  I'd like to be able to programmatically set the widths of my columns based on the width of the largest value in the data set so that the columns would be at the minimum width required to not wrap any of the content.  I was looking through the object model for the column and cell objects and couldn't figure out if there was a property that would get me the actual content size.  Do you know if there's a way to accomplish this?  Thanks so much for your help!

Regards,
Brian
Nasko
Telerik team
 answered on 17 Feb 2015
1 answer
197 views
Hi, 

So I have an HTMLTextbox declared inside my report, it's formatted into italic and bold by using HTML Tags like <i> and <b>, the texts were formatted properly but only on Report Viewer (both Print Preview and Interactive layout), I tried exporting it to PDF but when it was converted to a PDF file, all the HTML formatting that I did on the HTMLTextboxes were gone. Can someone explain to me why this is happening? Thanks
Lea
Top achievements
Rank 1
 answered on 17 Feb 2015
1 answer
63 views
We've used the WCF implementation of the ReportService for telerik for quite some time.

Currently, every few days, our deployed project that's hosted on IIS randomly stops returning available reports. The service is still running, however it returns 0 reports. If I redeploy the project it works fine. 

Our setup is a solution with a service project, and 2 reporting projects that have DLL's included in the service project. I checked the bin folder in the deployed project to make sure the DLL's were still in there after the reports stopped returning.

Any ideas? Please help...
Stef
Telerik team
 answered on 16 Feb 2015
3 answers
119 views
Okay Telerik. This is the kind of stuff that hurts my soul when I run into it. 

Some pretty basic stuff (after I have to add connection strings to my devenv.exe.config in order to use entityframework in my data class for designer preview).

I have a class, where I am loading data using EntityFramework in the constructor of this class. Currently, if I load an entity, and try to access a boolean value off of it, I receive a ridiculous error saying: 'Method not found: 'Boolean [NameSpace].[Entity].get_[PropertyName]().' This is not an issue of mis matched entities. If I literally comment out trying to access a boolean field, it works fine. As soon as I attempt to access a boolean value from a pulled entity, it gives me that error.

I haven't run into this issue until today, and quite honestly this was working fine before today. I'd love some feedback because I'm completely dead in the water on this.
Stef
Telerik team
 answered on 16 Feb 2015
1 answer
142 views
I have N number of Panel's that I want to stack vertically in my report. Each of those Panel's contains M number of child Panel's, which I also want to stack vertically. Each of these children contains a one or more TextBox/HtmlTextBox/Table's of an unknown size. I need everything to be dynamically sized, I do no know about the size of anything in advance. The report will be exported to PDF format.

A complete code sample is shown below. It creates 3 root level Panel's and each of these contains 2 child Panel's, which contains 2 TextBox's. Why is some of the content missing?

public partial class Report : Telerik.Reporting.Report
{
    public Report()
    {
        InitializeComponent();
 
        for (int i = 0; i < 3; ++i)
        {
            Panel panel = new Panel()
            {
                Docking = DockingStyle.Top,
            };
 
            for (int j = 0; j < 2; ++j)
            {
                panel.Items.Add(GetPanel(j));
            }
 
            this.detail.Items.Add(panel);
        }
 
        this.detail.Items[0].Style.BackgroundColor = Color.LightBlue;
        this.detail.Items[1].Style.BackgroundColor = Color.LightCoral;
        this.detail.Items[2].Style.BackgroundColor = Color.LightCyan;
    }
 
    private Panel GetPanel(int i)
    {
        Panel panel = new Panel()
        {
            Docking = DockingStyle.Top,
        };
 
        TextBox textBox1 = new TextBox()
        {
            Docking = DockingStyle.Left,
            Location = new PointU(Unit.Mm(0D), Unit.Mm(0D)),
            Size = new SizeU(Unit.Mm(50D), Unit.Mm(0D)),
            Value = i + " - Text Box"
        };
        panel.Items.Add(textBox1);
 
        TextBox textBox2 = new TextBox()
        {
            Docking = DockingStyle.Fill,
            Location = new PointU(Unit.Mm(50D), Unit.Mm(0D)),
            Size = new SizeU(Unit.Mm(124D), Unit.Mm(0D)),
            Value = i + " - Lorem ipsum dolor sit amet, consectetur adipiscing elit. Curabitur eleifend, dolor ac posuere sollicitudin, nisl nisl hendrerit odio, at pulvinar orci odio vitae ante. Phasellus sapien neque, dignissim nec libero id, iaculis fermentum risus. Aliquam erat volutpat. Praesent mattis lorem vel vulputate fringilla. Donec posuere dui vel nisi egestas, sit amet egestas sapien accumsan. Nullam vehicula ac eros sit amet congue. Integer gravida dolor sit amet justo ultricies, ac euismod nisi auctor. Proin et sem laoreet, sollicitudin ipsum sed, pharetra quam. Sed dapibus, erat in hendrerit tincidunt, dui arcu lacinia mi, maximus ullamcorper purus diam ac nisl. Nunc pulvinar ante vel semper posuere. Ut in pretium sapien. Interdum et malesuada fames ac ante ipsum primis in faucibus. Ut sit amet egestas sem. Duis faucibus libero turpis, sit amet finibus nisl hendrerit nec. "
        };
        panel.Items.Add(textBox2);
 
        return panel;
    }
}
Stef
Telerik team
 answered on 13 Feb 2015
2 answers
192 views
Hello,
I'm trying to setup the MVC-report viewer as instructed (http://www.telerik.com/help/reporting/telerik-reporting-rest-implementing-http-service.html)
My other WebApi controllers seem to be working just fine but when the report viewer widget loads, it reaches ReportsController but then fails ( with call to /api/reports/clients)

ExceptionMessage:"Method not found: 'System.Net.Http.HttpResponseMessage System.Net.Http.HttpRequestMessageExtensions.CreateResponse(System.Net.Http.HttpRequestMessage, System.Net.HttpStatusCode, !!0, System.Net.Http.Formatting.MediaTypeFormatter)'."

ExceptionType:"System.MissingMethodException"

StackTrace:"   at Telerik.Reporting.Services.WebApi.ReportsExceptionFilter.OnException(HttpActionExecutedContext context)
   at System.Web.Http.Filters.ExceptionFilterAttribute.OnExceptionAsync(HttpActionExecutedContext actionExecutedContext, CancellationToken cancellationToken)
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at System.Web.Http.Filters.ExceptionFilterAttribute.<ExecuteExceptionFilterAsyncCore>d__0.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at System.Web.Http.Controllers.ExceptionFilterResult.<ExecuteAsync>d__0.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at System.Web.Http.Dispatcher.HttpControllerDispatcher.<SendAsync>d__0.MoveNext()"

Any idea what part have I screwed up?


Petteri
Top achievements
Rank 1
 answered on 12 Feb 2015
Top users last month
Rob
Top achievements
Rank 3
Iron
Iron
Iron
Atul
Top achievements
Rank 1
Iron
Iron
Iron
Alexander
Top achievements
Rank 1
Veteran
Iron
Serkan
Top achievements
Rank 1
Iron
Shawn
Top achievements
Rank 1
Iron
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?