1 answer

143 views

Use declare in report datasource

Is there away to create a report based on the following SQL querie:

declare @date smalldatetime

select @date = GETDATE()

select @date = CONVERT(varchar(12),getdate(),101)

SELECT PEERS.COMPANY_NAME, PEERS.ASN, EXCHANGES.EXCHANGE_NAME, PEERINGS.CREATED

FROM EXCHANGES

INNER JOIN PEERINGS ON EXCHANGES.EXCHANGE_ID = PEERINGS.EXCHANGE_ID

INNER JOIN PEERS ON PEERINGS.PEER_ID = PEERS.PEER_ID

WHERE PEERINGS.CREATED BETWEEN @date + '00:00' AND @date + '23:59'

It appears that the use of declare is not supported.

General Discussions

answered on 12 Jan 2011

0 answers

65 views

Silverlight report font size binding

I'm using Telerik reporting in my silverlight project and there is one problem here. I need to bind the size of the textbox font to some property in my ViewModel on server side, before report starts to render. I need this cause this value can be changed dynamically.
Is there any solution?

General Discussions

asked on 12 Jan 2011

0 answers

110 views

Dynamically created reports

Hello,
I am working on a project where I am creating reports dynamically and exporting them out to either pdf or excel. To accomplish this task, I am using the ReportProcessor and RenderingResult classes. My process is a daily process that runs and exports a standard set of reports for each person in a group of employees.
I am having a problem figuring out the best way to handle my next step. There are occasions when for a particular employee, there will be no data for a report. My thought for each report, when I set the data source in the OnNeedDataSource method, I check the row count and if no rows exist then create an error for the report. Then the RenderResult has a way to check and see if the report has any errors. If there is an error, I can keep it from exporting out a blank report.
This is just my thought on how to accomplish this. Any help on how I can either accomplish this or another way to suppress blank reports would be greatly appreciated.

Thanks,
Jeff

General Discussions

asked on 11 Jan 2011

2 answers

141 views

Creating a report using EntityDiagrams and LINQ

I would like to create a report using a specific LINQ query with a where clause. I cannot figure out how to bind my Report1 to that LINQ query. Is it after the InitializeComponent(); in the code-behind page? Or is it in its own function? After I bind that, how do I bind controls, such as a textbox, to that function in the designer page? Do you have a sample project that I can use as an example?

General Discussions

answered on 11 Jan 2011

11 answers

180 views

Serialization error

Hello,

I recently put together a website in Sitefinity (3.6) on one or our development servers. Everything worked fine, but when I transferred it to our client's hosting it is giving me a serialization error. In particular, this occurs when I go to edit a page and it somehow has set Overlay back as default (although I used Custom). Nothing on the page is editable. When I try to change it back to Custom I get this error:

Server Error in '/' Application.

Serialization error.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Runtime.Serialization.SerializationException: Serialization error.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:


            [SerializationException: Serialization error.]
   Telerik.Personalization.Data.NolicsProvider.Set(String userName, String keyName, String moduleName, T value, Transaction transaction) +430
   Telerik.Personalization.Data.NolicsProvider.SaveModuleValue(String userName, String keyName, String moduleName, T value) +107
   Telerik.Personalization.Data.NolicsProvider.SaveModuleValue(String keyName, String moduleName, T value) +46
   Telerik.Personalization.Data.NolicsProvider.SaveGlobalValue(String keyName, T value) +40
   Telerik.Personalization.PersonalizationManager.SaveGlobalValue(String keyName, T value) +35
   Telerik.Cms.Web.UI.ToolBar.SelectSkin_SelectedIndexChanged(Object sender, EventArgs e) +113
   System.Web.UI.WebControls.ListControl.OnSelectedIndexChanged(EventArgs e) +111
   System.Web.UI.WebControls.DropDownList.RaisePostDataChangedEvent() +134
   System.Web.UI.WebControls.DropDownList.System.Web.UI.IPostBackDataHandler.RaisePostDataChangedEvent() +10
   System.Web.UI.Page.RaiseChangedEvents() +165
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1485

Version Information: Microsoft .NET Framework Version:2.0.50727.4206; ASP.NET Version:2.0.50727.4209

The site is on a Rackspace cloud server.

I'm lost as to what is causing this. Any help would be very much appreciated.

Thanks,

Matt

General Discussions

answered on 11 Jan 2011

1 answer

140 views

NeedDataSource order of firing

I have a report that contains a Telerik.Reporting.Table and a Telerik.Reporting.Chart. If I add an event handler for the NeedDataSource event on all three (the report, the table and the chart) in which order will the events fire? In the debugger the event for the report fires first and then the others fire, but is this always the case?

General Discussions

answered on 11 Jan 2011

1 answer

189 views

ReportViewer Height

I'm trying to get my ReportViewer to use all the available vertical space on my WebForm. I've seen numerous posts that say I have to set the entire doc tree to "style='height: 100%'", but I've done that, and my ReportViewer is still scrolling vertically.

The issue may be complicated by the fact that my ReportViewer is on a content page and the <html>, etc., tags are in the master page.

Here's my ReportViewer page:

<%@ Page Title="" Language="vb" AutoEventWireup="false" MasterPageFile="~/WlacSchedule.Master" CodeBehind="MyPlannerReport.aspx.vb" Inherits="WLAC.MyPlannerReport" %>

<%@ MasterType VirtualPath="~/WlacSchedule.Master" %>

<%@ Register TagPrefix="telerik" Assembly="Telerik.ReportViewer.WebForms" Namespace="Telerik.ReportViewer.WebForms" %>

<%@ Assembly Name="Telerik.ReportViewer.WebForms" %>

<asp:Content ID="Content1" ContentPlaceHolderID="cphHead" runat="server">

</asp:Content>

<asp:Content ID="Content2" ContentPlaceHolderID="cphMenu" runat="server">

</asp:Content>

<asp:Content ID="Content3" ContentPlaceHolderID="cphMain" runat="server">

<center id="center">

<telerik:ReportViewer ID="ReportViewer1"

Height="100%"

runat="server"

ShowParametersButton="False"

Width="100%"

ZoomMode="PageWidth">

</telerik:ReportViewer>

</center>

</asp:Content>

And here's my Master Page: (The content area containing the ReportViewer is "cphMain", about twenty lines from the end of the page.)

<%@ Master Language="VB" AutoEventWireup="false" CodeBehind="WlacSchedule.master.vb" Inherits="WLAC.WlacSchedule" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml" style="height: 100%">

<head runat="server">

<%--<title>West Los Angeles College</title>--%>

<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />

<meta http-equiv="imagetoolbar" content="no" />

<meta name="robots" content="index, follow" />

<meta name="author" content="West Los Angeles College" />

<meta name="copyright" content="copyright, West Los Angeles College" />

<meta name="generator" content="hand-coded" />

<meta name="homepage" content="www.wlac.edu" />

<link rel="shortcut icon" href="/favicon.ico" type="image/x-icon" />

<meta name="MSSmartTagsPreventParsing" content="TRUE" />

<meta http-equiv="expires" content="0" />

<meta http-equiv="pragma" content="no-cache" />

<link rel="stylesheet" type="text/css" href="general/wlac-schedule.css" media="all" />

<link rel="stylesheet" href="general/wlac-schedule-print.css" type="text/css" media="print" />

<script type="text/JavaScript" language="Javascript" src="general/pagescript.js"></script>

<script type="text/javascript" src="general/swfobject.js"></script>

<script type="text/javascript" src="general/planner.js"></script>

<!--[if lte IE 6]>

<link rel="stylesheet" type="text/css" href="general/ie-6-fix.css" media="all" />

</style>

<![endif]-->

<meta name="description" content=

"Schedule of Classes and Planner for West Los Angeles College: Through innovative programs and responsive Community services, West Los Angeles College empowers students to succeed."

/>

<style type="text/css" media="all">

/* styles for this page only */</style>

<link href="general/p7EPM04.css" rel="stylesheet" type="text/css" media="all" />

<script type="text/javascript" src="general/p7EPMscripts.js"></script>

<link href="general/wlac_Ed.css" rel="stylesheet" type="text/css" />

<link href="general/PlannerClasses.css" rel="stylesheet" type="text/css" />

<title>West Los Angeles College</title>

<asp:ContentPlaceHolder ID="cphHead" runat="server">

</asp:ContentPlaceHolder>

<telerik:RadStyleSheetManager ID="RadStyleSheetManager1" runat="server" />

</head>

<body style="height: 100%">

<form id="form1" runat="server">

<div>

<telerik:RadScriptManager ID="RadScriptManager1" runat="server">

<Scripts>

<%-- Needed for JavaScript IntelliSense in VS2010 --%>

<%-- For VS2008 replace RadScriptManager with ScriptManager --%>

<asp:ScriptReference Assembly="Telerik.Web.UI" Name="Telerik.Web.UI.Common.Core.js" />

<asp:ScriptReference Assembly="Telerik.Web.UI" Name="Telerik.Web.UI.Common.jQuery.js" />

<asp:ScriptReference Assembly="Telerik.Web.UI" Name="Telerik.Web.UI.Common.jQueryInclude.js" />

</Scripts>

</telerik:RadScriptManager>

<telerik:RadAjaxManager ID="RadAjaxManager2" runat="server" RestoreOriginalRenderDelegate="false">

</telerik:RadAjaxManager>

<div id="wrapper">

<div id="header">

<div id="skip">

<a href="#content">Skip to Main Content</a>

</div>

<div id="header-right">

<a href="http://www.cccapply.org/applications/CCCApply/apply/West_Los_Angeles_College.html" title="Apply Online">

<img src="images/nav-applyonline.jpg" alt="Apply Online" width="197" height="31"

border="0" /></a>

<div class="headerlink">

View <a href="http://www.wlac.edu/scheduleofclass/schedulecalendar.html">WLAC ACADEMIC

CALENDAR</a>

</div>

<div id="header-left">

<a href="http://www.wlac.edu/">

<img src="images/nav-homelogo.jpg" alt="West LA College HOME" width="181" height="108"

border="0" /></a>

</div>

<h1>

West Los Angeles College Schedule of Classes and Planner</h1>

</div>

<div id="elevator">

<asp:ContentPlaceHolder ID="cphMenu" runat="server">

</asp:ContentPlaceHolder>

<div id="pcs">

<div id="p7EPM_1" class="p7EPM04">

<div id="p7EPMt_1" class="p7epm_trigs">

<ul>

<li class="t1"><a href="#p7EPMc1_1" id="p7EPMtrg1_1"></a></li>

<li class="t2"><a href="#p7EPMc1_2" id="p7EPMtrg1_2"></a></li>

</ul>

<div class="p7epm_ie5clear">

</div>

<div id="p7EPMdw_1">

<div id="p7EPMw1_1" class="p7epm_cwrapper">

<div id="p7EPMc1_1" class="p7epm_content pan1">

<div id="pcs-top">

<div id="pcs-top-col1">

<img src="images/header-pcs.png" alt="Printed Classs Schedules and Policies" width="297"

height="35" />

</div>

<div id="pcs-top-col2">

Lorem ipsum dolor sit amet, consectetur adipiscing elit. Etiam a diam enim, nec

vulputate felis. Aliquam ligula arcu, tincidun.</div>

<div id="pcs-top-col3">

<img src="images/nav-closepanel.gif" alt="Close this panel" width="82" height="16"

onclick="P7_EPMctl('p7EPMtrg1_1','close')" /></div>

</div>

<div id="pcs-col1">

<ul id="col1-list">

<li><a href="App_Data/test.pdf">

<img src="images/pdf-fall2010.png" alt="Fall Classes 2010 [PDF]" width="286" height="33" /></a></li>

<li><a href="App_Data/test.pdf">

<img src="images/pdf-winter2011.png" alt="Winter Classes 2011 [PDF]" width="286"

height="33" /></a></li>

<li><a href="App_Data/test.pdf">

<img src="images/pdf-spring2011.png" alt="Spring Classes 2011 [PDF]" width="286"

height="33" /></a></li>

<li><a href="App_Data/test.pdf">

<img src="images/pdf-summer2011.png" alt="Summer Classes 2011 [PDF]" width="286"

height="33" /></a></li>

</ul>

</div>

<div id="pcs-col2">

<p>

<a href="App_Data/test.pdf">

<img src="images/pdf-howtoenroll.png" alt="How To Enroll [PDF]" width="198" height="34" /></a></p>

<ul>

<li>Dates to Know</li>

<li>Who May Apply</li>

<li>How To Enroll</li>

<li>About Matriculation</li>

<li>How To Add/Drop Classes</li>

<li>Fees & Financial Aid</li>

<li>List of Majors/Certificates</li>

<li>Empezar el Proceso</li>

</ul>

</div>

<div id="pcs-col3">

<p>

<a href="App_Data/test.pdf">

<img src="images/pdf-thingstoknow.png" alt="Things To Know / Policies [PDF]" width="234"

height="34" /></a></p>

<ul>

<li>For High School Students</li>

<li>Transfer Honors Program</li>

<li>Transfer Requirements (UC, CSU, IGTCE)</li>

<li>Graduation Requirements</li>

<li>Graduation Petition Process</li>

<li>Services for Students</li>

<li>Policies: Student Code of Contact, Academic Policies, Financial Policies, Non-Discrimination,

Legal Protections, Crime Stats, Other</li>

<li>Off-Campus Locations</li>

<li>Admissions Check List</li>

<li>Paper Application</li>

</ul>

<p>

</p>

</div>

</div>

<div id="p7EPMw1_2" class="p7epm_cwrapper">

<div id="p7EPMc1_2" class="p7epm_content pan2">

<div id="help_content">

<!-- Flash content:

1) It sits inside the Div IDed "help_content".

2) A reference to the swfobject.js script can go here, or in the <head>. I put it in the <head>.

3) Please upload the Flash file too! It's called helppanel.swf and it goes right next to all of your pages.

4) The way it works: helppanelcontent div is set to be display:none.

EXCEPT if you're a spiderbot or have no Flash or an older version, or if you have JavaScript turned off.

Then it displays instead of the Flash file. -->

<div id="helppanelcontent">

<img src="images/helpflash.jpg" alt="Help Panel" width="990" height="250" />

</div>

<script type="text/javascript">

var so = new SWFObject("helppanel.swf", "movie", "990", "250", "8", "#FFFFFF");

so.addParam("menu", "false");

so.write("helppanelcontent");

</script>

</div>

<!--[if IE 5]><style>.p7epm_trigs {width: 100%;} .p7epm_ie5clear {clear: both;} .p7epm_content, .p7epm_content li a {height: 1%;}</style><![endif]-->

<!--[if IE 6]><style>.p7epm_trigs, .p7epm_content div {zoom: 1;} .p7epm_trigs a {height: auto !important;}</style><![endif]-->

<script type="text/javascript">

<!--

P7_opEPM('p7EPM_1', 0, 1, 1, 0, 0, 1000, 0, 0, 250, 1, 1, 0);

//-->

</script>

</div>

<div id="content" style="height: 100%">

<div id="content-wrap" style="height: 100%">

<asp:ContentPlaceHolder ID="cphMain" runat="server">

</asp:ContentPlaceHolder>

</div>

</div>

<div id="footer">

West Los Angeles College - 9000 Overland Avenue - Culver City, CA 90230 - 310-287-4200

- <a href="http://www.lacolleges.net/" target="_blank">LAColleges.net</a> - <a href="http://www.laccdbuildsgreen.org/" target="_blank">

LACCDBuildsGreen.org</a>

</div>

</div>

</div>

</form>

</body>

</html>

Any help would be appreciated.

General Discussions

answered on 11 Jan 2011

1 answer

158 views

increase the report size in report viewer

dear support,

I have just made an plain report in telerik reporting, without any conditional formating or calculated fields. See the report displayed is in very small area. How to increase the height ? My report viewer width and height is 100%. in report designer it is showing perfect but in final is something else.
find the attached files

General Discussions

answered on 10 Jan 2011

3 answers

117 views

reportviewer - wont display correctly in firefox

i have a problem in firefox where the reportviewer can print the report but the report itself doesnt display and the dropdown for export is disabled. everything looks fine in IE however which is what is confusing me. any idea what could be causing this?

any help would be great. thanks

General Discussions

answered on 10 Jan 2011

3 answers

249 views

Report formatting problem when adding dynamic subreport

(I am using the latest version of Q3 release.)
I created a master report which contains a list of dynamically generated sub-reports.

foreach (ParameterValuesReportDataSource ds in dss)

{

IndividualParameterReport subreport = new IndividualParameterReport(ds);

SubReport subReport = new SubReport();

subReport.ReportSource = subreport;

detail.Items.Add(subReport);

}

I expected these sub-reports to be displayed one by one on the same page. However, the result report are splited into two pages, as shown in noDocking_page1.png and noDocking_page2.png.
Later I found that if I add a line: subReport.Dock = System.Windows.Forms.DockStyle.Top, sub-reports can be displayed within one page.
But they are kinda overlay, and still show two pages with the second page is empty, as shown in docking_page1.png and docking_page2.png.

Can anyone help with it? Thank you in advance.

Cheers,

VH

General Discussions

answered on 10 Jan 2011