Telerik Forums
Reporting Forum
2 answers
84 views

Hi,

Could you please help in solving this issue.I have 4 parameters:

-StartDate is a custom datetime picker param

-EndDate is a custom datetime picker param

-Campus is a builtin param bound to an sql datasource with both value and display text.

-Vehicle Numbers is is a builtin param bound to an sql datasource with both value and display text and mutilvalue enabled.This param is cascading from Campus param,so when picking a campus the vehicle numbers gets filtered

 

The problem I am facing is that when I pick a campus, the vehicle numbers are filtered but the start and end date values are lost.I feel the whole parameter area in being refreshed so the values entered are not restored.

.ParameterEditors(pe => pe.DateTimeEditor("createDateTimeEditor"))

 

function createDateTimeEditor(placeholder, options) {
       
        var dateTimePickerElement = $("<input type='text' style='width: 100%;' />");
        dateTimePickerElement.appendTo(placeholder);
      
        var parameter,
              valueChangedCallback = options.parameterChanged,
              dateTimePicker;
 
        function onChange() {
            var val = dateTimePicker.value();                
          
            valueChangedCallback(parameter, val);
        }
 
        return {
            beginEdit: function (param) {
 
                parameter = param;
                 
                $(dateTimePickerElement).kendoDateTimePicker({
                     
                    change: onChange
                });
 
                dateTimePicker = $(dateTimePickerElement).data("kendoDateTimePicker");
            }
        };

Environment:

-ASP.NET MVC 5

.-NET 4.5

-Latest Reporting package

 

Thanks in advance

Madani

 

HCT-CERT
Top achievements
Rank 1
 answered on 22 Jan 2017
1 answer
562 views

Hello, 

       I am using Telerik Reporting R3 2016 and displaying report result as PDF Document. I am using Roboto Fonts, i have installed these fonts in my development machine which is working fine. PDF Content embed as Roboto. But in Production server contents are gets displaying in Microsoft Sans Serif Font.

        I have Installed Roboto(TrueType) font in production server and restarted production machine. But still it is not working. I have checked in Windows\Fonts Folder, my fonts are there. Am i need to change any other configuration to get Roboto font in PDF?

Stef
Telerik team
 answered on 20 Jan 2017
1 answer
615 views

I want a table column right from a column of which I set the visibility to false with a visibility binding expression to take the free space availalble.

How can I achieve this?

Katia
Telerik team
 answered on 20 Jan 2017
2 answers
214 views

Using 10.2.16.1025, VS Professional 2015, Win 10, SQL Server 2016.  I have built several SQL stored procedures to fetch data, integrated them into Entity framework and have successfully used them for both main report datasources and as lists of values for report parameters, accessing them as Entity DataSources.

However, one stored procedure does not work right.  After adding it to a new Entity datasource for a report parameter, the column names in its output dataset are not displaying, just an unusable thing named 'item'.

When the wizard gets to Select a Context Member, I pick this:

Method: RptUtlTimeZone(Nullable<Int32> systemTimeZoneId, Nullable<Boolean> returnResultSet, String& zoneMsName) : List<RptUtlTimeZoneReturnModel>
Type: Myriad.Pc.Data.SqlServer.PointCentricContext
Assembly: Myriad.Pc.Data.SqlServer, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null

Looks similar to all the other stored procedures that work correctly.  Note that it does have the output data set definition List<RptUtlTimeZoneReturnModel>

The Wizard completes, I go to Data Explorer and all I see is "item".

Here is part of the file from Visual Studio which describes the output data set - RptUtlTimeZoneReturnModel.cs

    public partial class RptUtlTimeZoneReturnModel
    {
        public System.Int32? SystemTimeZoneId { get; set; }
        public System.String ZoneMSName { get; set; }
    }

and this looks fine.

But why does Data Explorer not display the proper columns in the output data set?  Thanks.

 

Stef
Telerik team
 answered on 20 Jan 2017
1 answer
92 views

Hello
Our application provides a Telerik report which can be exported to Word. Some of our customers are complaining that they are not able to insert a manual page break in the exported file by using CTRL+Enter.

Because the report extends over several pages, the whole page is packed in an outer table. CTRL+Enter inserts a page break in front of the table instead at the current cursor position.

Do you have any suggestions to solve this issue?

Regards, Markus

 

Stef
Telerik team
 answered on 19 Jan 2017
2 answers
557 views

I have a binding expression for the Height property of a Picturebox. The height depends on a boolean value.

=IIF(Fields.LiftVanesUsed,"0,9cm","1,2cm")

The height of the picturebox becomes around 10 times larger than the height that is provided in the expression.

How to return the height from an expression?

 

Stef
Telerik team
 answered on 19 Jan 2017
1 answer
114 views

Has anyone found a limitation for character length on the query write for Telerik Report Designer?  I have a lengthy oracle query that is over 30,000 characters and performs about 56 counting operations based on case statements to create a report.  The query works in sql Developer, but I am not able to paste the entire query into the query editor.

 

Stef
Telerik team
 answered on 19 Jan 2017
1 answer
108 views

Hi, We have a silverlight application. We are using this technique to pass data to report parameters using a WCF service (the reports locate in another class library application):

public void SaveBtn()
{
    var deviceInfo = new NameValueDictionary();
    var parameters = new NameValueDictionary();
 
    parameters.Add("name", name);
    // other fields
 
    var serviceClient = new ReportServiceClient(new Uri(App.Current.Host.Source, "../ReportService.svc"));
    serviceClient.RenderAsync("IMAGE",
        "ReportProject.Reporting.Letter.Preview, ReportProject.Reporting, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null",
        deviceInfo,
        parameters);
    serviceClient.RenderCompleted += new EventHandler<RenderEventArgs>(serviceClient_RenderCompleted);
}
 
 
void serviceClient_RenderCompleted(object sender, RenderEventArgs e)
{
    var result = e.RenderingResult;
    File.WriteAllBytes("f:/file.tiff", result.DocumentBytes);
}

 

This process works fine in local host. But when we publish silverlight web application in IIS when SaveBtn is called this exception will be thrown (the attached image):

[Async_ExceptionOccurred]
 
.....

 

 

As I mentioned this process works on local host. 

PS: We followed this technique for using WCF Telerik Reporting Service.  

We also added a file called clientaccesspolicy.xml to root of the report project (the class library I mentioned):

<access-policy>
  <cross-domain-access>
    <policy>
      <allow-from http-request-headers="*">
        <domain uri="*"/>
      </allow-from>
      <grant-to>
        <resource path="/" include-subpaths="true"/>
      </grant-to>
    </policy>
  </cross-domain-access>
</access-policy>

 

Any idea? Thanks in advance.

 

Stef
Telerik team
 answered on 19 Jan 2017
9 answers
249 views

Yesterday I installed a service pack of new version of Telerik (Telerik_Reporting_Trial_Installer_R3_2016_SP1_10_2_16_1025) as suggested by Telerik to resolve few bugs in version R3_2016_10_915 - After the upgrade, when i opened my application where the report viewer is plugged in, it asked to run upgrade wizard and it upgraded files on my machine, please see attached (Telerik Upgrade Wizard.png) to see list of files it upgraded - Though doing all this resolved my initial issue, but now in report viewer in our web api, it is showing tool bar at the bottom of the viewer which is kind off odd.

Can you please guide me how shall i re-position my toolbar for it to appear on the top again - 

 

 

Katia
Telerik team
 answered on 19 Jan 2017
2 answers
388 views

Hi there
I tried different setting for docking and anchoring but the panels in exported report are always overlapping instead of „stacking“.
Can you please help me with this issue?
Many thanks
Markus

Markus
Top achievements
Rank 1
 answered on 18 Jan 2017
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?