Telerik Forums
Reporting Forum
2 answers
232 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
111 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
612 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
130 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
124 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
280 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
418 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
3 answers
137 views

Hi,

So the report I'm trying to create is kinda funky, and I've found that a table seems to be my best bet for this, but I can't quite get the subreport to do what I want it to do. So here's the basic layout:
________________________________________________________________
|Detial|Detail                |subreportdetail    | subreportdetail |detail | detail | detail|
|_____|_____________|______________|_____________|_____|_____|_____|

Unfortunately, the vertical lines are a must, and must grow with the detail section.  Is there a way to do this or am I just gonna tear my hair out?

Stef
Telerik team
 answered on 18 Jan 2017
16 answers
522 views
I am attempting to test Reporting in MVC 6, however, I am unable to find the Nuget package referenced in the documentation. Can someone please attach this package, or provide a link to where they can be found?
Stef
Telerik team
 answered on 18 Jan 2017
19 answers
368 views
I have a report where one parameter is to choose a user id (from a list, returned by a stored proc)
There is no default value, and you MUST select a user id before running the report.
For some reason, even though there is no default value and the user hasn't chosen an item, when the page loads, the report renders, without the needed parameter being supplied, which causes a missing parameter exception.

Can I 

a) Prevent the autoload altogether?
b) If not, is it a bug that is autorenders when a parameter hasnt been supplied?

    <ReportParameter Name="UserID" Type="Integer" Visible="True" AllowBlank="False">
      <AvailableValues DataSourceName="sqlDataSource2" DisplayMember="=Fields.Name" ValueMember="= Fields.ID" />
      <Value>
        <String></String>
      </Value>
    </ReportParameter>
Katia
Telerik team
 answered on 18 Jan 2017
Top users last month
Rob
Top achievements
Rank 3
Bronze
Iron
Iron
Sergii
Top achievements
Rank 1
Iron
Iron
Dedalus
Top achievements
Rank 1
Iron
Iron
Lan
Top achievements
Rank 1
Iron
Doug
Top achievements
Rank 1
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?