Telerik Forums
Reporting Forum
3 answers
218 views
Hello,
I need to open from a SL4 application a report passing 2 parameters (I open the report using the SL reportviewer inside a RadWindow), I load the report calling a method Load that's got the following code :

private void Load(int u_rapporto, DateTime date)
      {
          if (u_rapporto != 0)
          {
              reportViewer.Height = double.NaN;
              var reportViewerModel = reportViewer.DataContext as ReportViewerModel;
 
              Telerik.Reporting.Service.Parameter paramRapporto = new Telerik.Reporting.Service.Parameter();
              paramRapporto.Name = "Rapporto";
              paramRapporto.Type = typeof(int).FullName;
              paramRapporto.Value = u_rapporto;
 
              Telerik.Reporting.Service.Parameter paramData = new Telerik.Reporting.Service.Parameter();
              paramData.Name = "Data";
              paramData.Type = typeof(DateTime).FullName;
              paramData.Value = date;
 
              List<Telerik.Reporting.Service.Parameter> lst = new List<Telerik.Reporting.Service.Parameter>();
              lst.Add(paramRapporto);
              lst.Add(paramData);
 
              if (reportViewerModel.Parameters != null)
              {
                  reportViewerModel.Parameters.Clear();
 
 
                  reportViewerModel.Parameters.Add(paramRapporto);
                  reportViewerModel.Parameters.Add(paramData);
 
                  reportViewerModel.ApplyReportParametersCommand.Execute(null);
              }
              else
              {
                  reportViewerModel.Parameters = lst;
                  reportViewerModel.ApplyReportParametersCommand.Execute(null);
 
              }
          }
          else
          {
              reportViewer.Height = 0;
          }
      }

this works but due to transmission time it shows for some seconds a message "One or more parameters are not set or have invalid values." This it's due to the fact that when the radwindow load it  calls the webservice...is there a way of changing the text or to hide it?
Thanks in advance

Paolo
Steve
Telerik team
 answered on 27 Aug 2010
1 answer
179 views
We are trying to bind the Telerik ReportService to a secure site and we get the following error in the viewer "An exception occurred during the operation, making the result invalid.  Check InnerException for exception details."

Here is what our web.config file looks like:

<?

 

 

xml version="1.0"?>

 

<!--

For more information on how to configure your ASP.NET application, please visit

http://go.microsoft.com/fwlink/?LinkId=169433

 

 

 

-->

 

<

 

 

configuration>

 

<

 

 

appSettings/>

 

<

 

 

connectionStrings>

 

<

 

 

add name="TestSite.Reports.Properties.Settings.TestDatabase" connectionString="Data Source=test\sqlexpresscreate;Initial Catalog=TestDatabase;Persist Security Info=True;User ID=testuser;Password=test123" providerName="System.Data.SqlClient" />

 

</

 

 

connectionStrings>

 

<

 

 

system.web>

 

<

 

 

compilation debug="false" targetFramework="4.0" />

 

<

 

 

authentication mode="Windows"/>

 

<

 

 

authorization>

 

<

 

 

allow roles="Domain\Group1,Domain\Group2,Domain\Group3" />

 

<

 

 

deny users="*" />

 

</

 

 

authorization>

 

</

 

 

system.web>

 

<

 

 

system.serviceModel>

 

<

 

 

bindings>

 

<

 

 

webHttpBinding>

 

<

 

 

binding name="webHttpBinding">

 

<

 

 

security mode="Transport">

 

<

 

 

transport clientCredentialType="Windows" proxyCredentialType="None"/>

 

</

 

 

security>

 

</

 

 

binding>

 

</

 

 

webHttpBinding>

 

<

 

 

wsHttpBinding>

 

<

 

 

binding name="wsHttpBinding">

 

<!--

 

 

FOR SECURE-HTTPS -->

 

<

 

 

security mode="Transport">

 

<

 

 

transport clientCredentialType="Windows" proxyCredentialType="None"/>

 

</

 

 

security>

 

<!--

 

 

FOR NORMAL (DO NOTHING)-->

 

</

 

 

binding>

 

</

 

 

wsHttpBinding>

 

</

 

 

bindings>

 

<

 

 

behaviors>

 

<

 

 

serviceBehaviors>

 

<

 

 

behavior name="AllMyServiceBehaviors">

 

<

 

 

serviceMetadata httpsGetEnabled="true" httpsGetUrl=""/>

 

<!--

 

 

FOR NORMAL <serviceMetadata httpGetEnabled="true" /> -->

 

<

 

 

serviceDebug includeExceptionDetailInFaults="true"/>

 

</

 

 

behavior>

 

</

 

 

serviceBehaviors>

 

<

 

 

endpointBehaviors>

 

<

 

 

behavior name="scriptEndPointBehavior">

 

<

 

 

webHttp/>

 

<

 

 

enableWebScript/>

 

</

 

 

behavior>

 

</

 

 

endpointBehaviors>

 

</

 

 

behaviors>

 

<

 

 

services>

 

<

 

 

service name="Site.Web.SiteService" behaviorConfiguration="AllMyServiceBehaviors">

 

<

 

 

endpoint bindingNamespace="site.sitesite.org.services" address="wsHttpBinding" binding="wsHttpBinding" contract="PPD.Web.IPPDService" bindingConfiguration="wsHttpBinding">

 

</

 

 

endpoint>

 

</

 

 

service>

 

<

 

 

service name="Telerik.Reporting.Service.ReportService" behaviorConfiguration="AllMyServiceBehaviors">

 

<

 

 

endpoint bindingNamespace="site.sitesite.org.services" address="wsHttpBinding" binding="wsHttpBinding" contract="Telerik.Reporting.Service.IReportService" bindingConfiguration="wsHttpBinding">

 

</

 

 

endpoint>

 

</

 

 

service>

 

</

 

 

services>

 

<

 

 

serviceHostingEnvironment aspNetCompatibilityEnabled="true" multipleSiteBindingsEnabled="true" />

 

</

 

 

system.serviceModel>

 

</

 

 

configuration>

 

Steve
Telerik team
 answered on 27 Aug 2010
1 answer
1.0K+ views
In order to fit a report on a single line I made two fields into groups
the client has no interest in printing their report - they only need the data to export into Excel and want everything on a single line,
no matter how long it ends up being

how do I in Designer delete the group(s)?
when I try to delete the header or footer it says delete the group first

Marianne Seggerman
Steve
Telerik team
 answered on 27 Aug 2010
1 answer
385 views
Can I load a PDF into the Report Viewer of a WinForm in some way?  I want to display a PDF in your viewer without having to create a report.
Steve
Telerik team
 answered on 27 Aug 2010
1 answer
86 views
I have a report that the columns are off for the first couple lines then after that everything is fine.  When I export to pdf everything works as expected as well as previewing in visual studio.

Any suggestions as to which properties would cause this.

I'm using Q2 2010 reporting.

Thanks,
Steve
Telerik team
 answered on 27 Aug 2010
1 answer
140 views
If we select same date in RadCalendar, Selectionchanged fires twice but if we don't select same date it fires only once. Moreover if keep on selecting the same date. the count of SelctionChanged kept increasing.

XAML File

<UserControl x:Class="RadControlsSilverlightApp1.MainPage"
    xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"
    xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml"
    xmlns:d="http://schemas.microsoft.com/expression/blend/2008" xmlns:mc="http://schemas.openxmlformats.org/markup-compatibility/2006"
    mc:Ignorable="d" d:DesignWidth="640" d:DesignHeight="480" xmlns:telerik="http://schemas.telerik.com/2008/xaml/presentation">
  <Grid x:Name="LayoutRoot">
        <telerik:RadCalendar  HorizontalAlignment="Left" Margin="136,133,0,0" Name="radCalendar1" VerticalAlignment="Top" />
    </Grid>
</UserControl>

Code Behind

using System;
using System.Collections.Generic;
using System.Linq;
using System.Net;
using System.Windows;
using System.Windows.Controls;
using System.Windows.Documents;
using System.Windows.Input;
using System.Windows.Media;
using System.Windows.Media.Animation;
using System.Windows.Shapes;

namespace RadControlsSilverlightApp1
{
    public partial class MainPage : UserControl
    {
        public MainPage()
        {
            InitializeComponent();
            radCalendar1.SelectionChanged+=new Telerik.Windows.Controls.SelectionChangedEventHandler(radCalendar1_SelectionChanged);
        }

        private void radCalendar1_SelectionChanged(object sender, Telerik.Windows.Controls.SelectionChangedEventArgs e)
        {
            MessageBox.Show("test");
        }
    }
}

 

 

 

 

 

 

Kaloyan
Telerik team
 answered on 27 Aug 2010
3 answers
172 views
Hi
i have placed my reportViewer.aspx file in folder name viewer which contain reportviewr control and telerik report design file in design folder which use an external style sheet placed in viewer folder and i use it as relative but when i preview report style sheet is missing
if i use style sheet as absolute then it looks fine on my local machine but not on production server.
Plz help me that what i am doing wrong
it is urgent
Steve
Telerik team
 answered on 27 Aug 2010
0 answers
100 views
Hi,
I have a question. I'm creating report that uses ORM data source where i add an object provider for my generated class (TblMainCategory).
this class has the following properties (property TblCategorys references another object Category):
TblMainCategory
Id
Title
TblSubcategoris ->Item ->
                                             Id
                                            Title
            
When i try to drag this column from data explorer i get an error "An error has occured while processing Textbox textbox2:
The expression contains object "TblSubcategory" taht is not defined in the corrent context."

Object provider contains OQL statement :SELECT * FROM TblMainCategoryExtent AS x

I solved issue with making another report that has a parameter that i then bind in main report (so i have to insert it like subreport in my main report).

Well I hope you see my issue.
I read that reporting does not support drill down...so might this be the reason (?)
Sam Ur
Top achievements
Rank 2
 asked on 27 Aug 2010
10 answers
467 views
One shortcoming of all repotring packages I have used is that they offer no form of inheritance, or what one could also call a MasterReport (like an asp.net MasterPage). What I would really like to see is the abililty to create a bacsi report template and then be able to derive my reports from that. I find I waste a lot of time reproducting headers (with grahpics, etc) where the only difference from one report to another is the title.
Steve
Telerik team
 answered on 27 Aug 2010
3 answers
843 views
Hi,

I am trying to use conditional formatting for a report and what I want to do is compare a field to 2 static values and if TRUE, highlight the text. I am unable to get the syntax correct for the condition. This is what I am trying to achieve.

Compare the field "Type" to both an empty string and also to static text "Upset". I tried to do the following the Conditional Formatting Rules dialog

=Fields.Type = Upset

This works fine. But, if I add NULL to this(to compare to empty string)

=Fields.Type = Upset OR = Null

nothing happens. I tried to use the "IN" operator, but no luck in figuring out the syntax. Is there some documentation that I can use as  a reference or can you point me to the correct syntax?

Thanks
Jayesh Goyani
Top achievements
Rank 2
 answered on 27 Aug 2010
Top users last month
Cynthia
Top achievements
Rank 1
Iron
Toby
Top achievements
Rank 3
Iron
Iron
Iron
Danielle
Top achievements
Rank 1
Iron
Iron
Joel
Top achievements
Rank 3
Bronze
Bronze
Iron
yw
Top achievements
Rank 2
Iron
Iron
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?