Telerik Forums
Reporting Forum
1 answer
125 views
Hi telerik,

I have xml content in my database, How can i access it in my object datasource, in telerik reporting?
i can deserialise the xml into list of objects, and then i want to set it as object data source dynamically. if possible Please provide me any references on this..

Thanks & regards
Krishna.
Steve
Telerik team
 answered on 30 Aug 2010
1 answer
502 views
Hi Telerik,

My company uses Telerik and unfortunately i m working on reports module. And i need a report design which contains 2 page in design. First page is a custom report like a letter and second page is an attachment page.
And my query returns 40 rows then i need 80 pages in my report with ordered letter and attachment.

I tried lots of ways, for example; i used ReportBook for attachment, page footer or report footer..

When i design my report with letter and attachment in the same page, it seems working but when i press to Export PDF, this time PDF
file is not similar with my report..

This is urgent, I need help..

With Love
Ihsan.
ihsan
Top achievements
Rank 1
 answered on 28 Aug 2010
1 answer
100 views
I have done everything I can think of but no go.
When I try to preview a report in the designer it says could not load file or assembly "Norm.dll version 1.0.0.0 ..." Norm is my mongodb database driver. It is working on my old computer but when I moved to me new computer it throw this error. Why would the designer say this file cant be found It is a reference in the project and all works fine at runtime.
MiddleTommy
Top achievements
Rank 1
 answered on 28 Aug 2010
4 answers
115 views
I have a gridview with several filtered columns (just generic filters, nothing custom).  I want to display the data from the grid in a report and have it respect any filters the user has applied.  The initial data is an observablecollection, when the user requests the report I pass the collection (and some additional info) back to my web service and write xml.  I think pick up the XML in the report with dataset and bind it, that is all working great.  The challenge comes with the filters, I see two ways to approach this:

1) Apply to filters to the collection before sending it to the webservice.  This wont work because when the user closes the report viewer, I have it go back to the grid, and if we filtered the collection they wont be able to unfilter it without starting over.  Unless maybe I maintain a filtered collection and an unfiltered collection, I just thought of that but I am still not sure how to apply the filters in the first place or how to get at just the data the gridview is showing.

2) Pass the filter info the report and then apply the filters to the dataset which the report picks up.

I have been trying to implement number 2 but I am pretty sure I am going about this in completely the wrong way.  What I did is pass in the filter description and then do some string manipulation to so I can do datatable.select.  I got this working for the simple "columnname = value" filters but as I am starting to look at all the others (contains, endswith,startswith, etc), I can see that this is going to be way too complex and I am probably reinventing the wheel (and my wheel is a square).

Please show me the light.
Kjell
Top achievements
Rank 1
 answered on 27 Aug 2010
1 answer
170 views
Hi,I am trying the telerik report, this product is great.
I need to produce report with Chinese language, I have tested with different Chinese font, but if I set the text font to "SimSun" or "NSimSun", then, if I tried to export the report to pdf, error is occurred, and the error is: Object reference not set to an instance of an object.  But if I set the font to other Chinese font, i.e. SimHei, Microsoft YaHei etc. it works well Can you tell me how can I resolve this issue?
Thanks.
Steve
Telerik team
 answered on 27 Aug 2010
3 answers
196 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
152 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
980 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
357 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
69 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
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?