or
5 answers
120 views
I have designed a report that I need to programmatically set the connection string
my report viewer code is
Here is my data source deceleration from the XML file:
How do I programmatically set the connection string "hippo"?
Thanks!
my report viewer code is
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load Try If Not IsPostBack Then Dim uriReportSource As New Telerik.Reporting.UriReportSource() Dim r As reportObj = daoFactory.GetreportObjDao.GetById(New Guid(Request.QueryString("ID")), False) Dim path As String = System.Web.HttpRuntime.AppDomainAppPath + "Temp\" path += ClientID.ToString() + "\" + r.FileName uriReportSource.Uri = path Me.trv.ReportSource = uriReportSource End If Catch ex As Exception error(ex) End Try End SubHere is my data source deceleration from the XML file:
<DataSources> <SqlDataSource ConnectionString="hippo" SelectCommand="select top 1 fl.license, f.*, a.* from t_facility_license fl inner join t_facility f on f.facilitylicenseguid = fl.facilitylicenseguid outer apply ( select top 1 * from t_address where foreignkeyguid = f.facilityguid and addresstype = 'Physical' ) a where fl.facilitylicenseguid = @FacilityLicenseGuid order by f.createdate" Name="FacilityLicense"> </SqlDataSource></DataSources>How do I programmatically set the connection string "hippo"?
Thanks!
Stef
Telerik team
answered
on
30 Sep 2013
1 answer
164 views
Is it possible to have a Telerik Report connect to an IBM i Access for Windows ODBC data source? Or is this not a compatible database type for Telerik? If it is possible, does it require a certain version of Telerik Reporting? I'm currently using Q3 2011.
Stef
Telerik team
answered
on
30 Sep 2013
2 answers
286 views
Hi,
I am getting the following errors while try to run report from silverlight report viewer.
Previously it was working with the licensed version 7.1.13.612 and currently I am using updated version 7.1.13.802
in Telerik.Reporting.dll, Telerik.Reporting.Service.dll, Telerik.ReportViewer.Silverlight.dll
Please help me to find out the solution of this bug for client release.
Error in silverlight report viewer :
Error: System.Reflection.TargetInvocationException : An exception occurred during the operation, making the result invalid. Check InnerException for exception details.
at System.ComponentModel.AsyncCompletedEventArgs.RaiseExceptionIfNecessary()
at Telerik.Reporting.Service.SilverlightClient.ListRenderingExtensionsEventArgs.get_Extensions()
at Telerik.ReportViewer.Silverlight.ReportViewerModel.OnListRenderingExtensionsCompleted(Object sender, ListRenderingExtensionsEventArgs e)
------------- InnerException: -------------
System.ServiceModel.CommunicationException : The remote server returned an error: NotFound.
at System.ServiceModel.Channels.Remoting.RealProxy.Invoke(Object[] args)
at proxy_2.EndListRenderingExtensions(IAsyncResult )
at Telerik.Reporting.Service.SilverlightClient.ReportServiceClient.OnEndListRenderingExtensions(IAsyncResult result)
at System.ServiceModel.ClientBase`1.OnAsyncCallCompleted(IAsyncResult result)
------------- InnerException: -------------
System.Net.WebException : The remote server returned an error: NotFound.
at System.Net.Browser.AsyncHelper.BeginOnUI(SendOrPostCallback beginMethod, Object state)
at System.Net.Browser.BrowserHttpWebRequest.EndGetResponse(IAsyncResult asyncResult)
at System.ServiceModel.Channels.HttpChannelFactory.HttpRequestChannel.HttpChannelAsyncRequest.CompleteGetResponse(IAsyncResult result)
------------- InnerException: -------------
System.Net.WebException : The remote server returned an error: NotFound.
at System.Net.Browser.BrowserHttpWebRequest.InternalEndGetResponse(IAsyncResult asyncResult)
at System.Net.Browser.BrowserHttpWebRequest.<>c__DisplayClassa.<EndGetResponse>b__9(Object sendState)
at System.Net.Browser.AsyncHelper.<>c__DisplayClass4.<BeginOnUI>b__0(Object sendState)
Error in Fiddler :
HTTP/1.1 404 Not Found
Content-Length: 1565
Content-Type: text/html; charset=UTF-8
Server: Microsoft-HTTPAPI/2.0
Date: Wed, 25 Sep 2013 16:16:04 GMT
<?xml version="1.0" encoding="utf-8"?>
<!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">
<head>
<title>Service</title>
<style>BODY { color: #000000; background-color: white; font-family: Verdana; margin-left: 0px; margin-top: 0px; } #content { margin-left: 30px; font-size: .70em; padding-bottom: 2em; } A:link { color: #336699; font-weight: bold; text-decoration: underline; } A:visited { color: #6699cc; font-weight: bold; text-decoration: underline; } A:active { color: #336699; font-weight: bold; text-decoration: underline; } .heading1 { background-color: #003366; border-bottom: #336699 6px solid; color: #ffffff; font-family: Tahoma; font-size: 26px; font-weight: normal;margin: 0em 0em 10px -20px; padding-bottom: 8px; padding-left: 30px;padding-top: 16px;} pre { font-size:small; background-color: #e5e5cc; padding: 5px; font-family: Courier New; margin-top: 0px; border: 1px #f0f0e0 solid; white-space: pre-wrap; white-space: -pre-wrap; word-wrap: break-word; } table { border-collapse: collapse; border-spacing: 0px; font-family: Verdana;} table th { border-right: 2px white solid; border-bottom: 2px white solid; font-weight: bold; background-color: #cecf9c;} table td { border-right: 2px white solid; border-bottom: 2px white solid; background-color: #e5e5cc;}</style>
</head>
<body>
<div id="content">
<p class="heading1">Service</p>
<p>Endpoint not found.</p>
</div>
</body>
</html>
service tracelog error :
The incoming HTTP request's URI 'http://localhost:8080/' does not match any service operation.
app.config file :
<appSettings>
<add key="DhaaniReportURL" value="http://localhost:8080/" />
<add key="ClientSettingsProvider.ServiceUri" value="" />
<add key="NetworkMachinesConnStr" value="uid=root;password=;host=.;database=NetworkMachines;protocol=pipe;pipename=mysql;pooling='True';Min Pool Size=10;Max Pool Size=500" />
</appSettings>
<system.serviceModel>
<bindings>
<basicHttpBinding>
<binding name="BasicHttpsBindingConfig" maxReceivedMessageSize="2147483647" maxBufferSize="2147483647" receiveTimeout="00:30:00" sendTimeout="00:30:00">
<readerQuotas maxArrayLength="2147483647" maxStringContentLength="2147483647" />
</binding>
</basicHttpBinding>
</bindings>
<serviceHostingEnvironment aspNetCompatibilityEnabled="true" />
<services>
<service name="ReportingWCFWindowsService.ReportService" behaviorConfiguration="ReportServiceBehavior">
<host>
<baseAddresses>
<add baseAddress="http://localhost:8080/" />
</baseAddresses>
</host>
<endpoint address="ReportService" binding="basicHttpBinding" contract="Telerik.Reporting.Service.IReportService">
<identity>
<dns value="localhost" />
</identity>
</endpoint>
<endpoint address="ReportService/resources" binding="webHttpBinding" behaviorConfiguration="WebBehavior" contract="Telerik.Reporting.Service.IResourceService" />
<endpoint address="" binding="webHttpBinding" behaviorConfiguration="WebBehavior" contract="ReportingWCFWindowsService.IClientAccessPolicy" />
<endpoint address="mex" binding="mexHttpBinding" contract="IMetadataExchange" />
</service>
</services>
<behaviors>
<serviceBehaviors>
<behavior name="ReportServiceBehavior">
<serviceMetadata httpGetEnabled="true" />
<serviceDebug includeExceptionDetailInFaults="false" />
</behavior>
</serviceBehaviors>
<endpointBehaviors>
<behavior name="WebBehavior">
<webHttp />
</behavior>
</endpointBehaviors>
</behaviors>
</system.serviceModel>
Note :
When I run the service base address in browser it works fine. URL : http://localhost:8080/
ReportService.cs :
[ServiceContract]
public interface IClientAccessPolicy
{
[OperationContract, WebGet(UriTemplate = "/ClientAccessPolicy.xml")]
Stream GetPolicy();
}
[System.Runtime.Serialization.KnownType(typeof(object[]))]
public class ReportService : ReportServiceBase, IClientAccessPolicy
{
static string sReportURL = ConfigurationSettings.AppSettings["DhaaniReportURL"].ToString();
static readonly Uri baseUri = new Uri(sReportURL);
protected override Uri BaseAddress
{
get { return baseUri; }
}
protected override string ApplicationPath
{
get
{
//return System.IO.Path.GetDirectoryName(System.Windows.Forms.Application.ExecutablePath) + "\\";
//Make sure that the ApplicationPath property always returns a valid directory path that ends with a slash (/) or a backslash (\)
return System.IO.Path.GetDirectoryName(System.Windows.Forms.Application.ExecutablePath) + "\\"; // for WinForms applications
//return System.Web.HttpContext.Current.Request.PhysicalApplicationPath; // for ASP.NET applications
}
}
public Stream GetPolicy()
{
var fs = new FileStream(Path.Combine(this.ApplicationPath, "clientaccesspolicy.xml"), FileMode.Open);
var bytes = new byte[fs.Length];
fs.Read(bytes, 0, bytes.Length);
fs.Close();
if (WebOperationContext.Current != null)
{
WebOperationContext.Current.OutgoingResponse.ContentType = "application/xml";
}
return new MemoryStream(bytes);
}
}
SummaryReport.cs :
public partial class SummaryReport : Report
{
public SummaryReport()
{
InitializeComponent();
}
public List<Machine> GetReportData(string pcs, DateTime startTime, DateTime endTime, double dHours, bool isCustom)
{
string sInstallationName = string.Empty;
string sInstallationAddress = string.Empty;
string sVersionInfo = string.Empty;
InitConn();
List<Machine> lstMachine = new List<Machine>();
return lstMachine;
}
Report.xaml.cs :
repViewer = new ReportViewer();
repViewer.RenderBegin += new RenderBeginEventHandler(repViewer_RenderBegin);
repViewer.ReportServiceUri = new Uri(App.p_ReportEndPoint);
repViewer.Report = "ReportingWCFWindowsService.SummaryReport, ReportingWCFWindowsService";
void repViewer_RenderBegin(object sender, RenderBeginEventArgs args)
{
args.ParameterValues["pcs"] = machines.TrimEnd(',');
args.ParameterValues["startTime"] = p_DTStart;
args.ParameterValues["endTime"] = m_EndDateForResult;
args.ParameterValues["dHours"] = m_Hours;
args.ParameterValues["isCustom"] = isCustom;
//progIndicator.Stop();
}
I am getting the following errors while try to run report from silverlight report viewer.
Previously it was working with the licensed version 7.1.13.612 and currently I am using updated version 7.1.13.802
in Telerik.Reporting.dll, Telerik.Reporting.Service.dll, Telerik.ReportViewer.Silverlight.dll
Please help me to find out the solution of this bug for client release.
Error in silverlight report viewer :
Error: System.Reflection.TargetInvocationException : An exception occurred during the operation, making the result invalid. Check InnerException for exception details.
at System.ComponentModel.AsyncCompletedEventArgs.RaiseExceptionIfNecessary()
at Telerik.Reporting.Service.SilverlightClient.ListRenderingExtensionsEventArgs.get_Extensions()
at Telerik.ReportViewer.Silverlight.ReportViewerModel.OnListRenderingExtensionsCompleted(Object sender, ListRenderingExtensionsEventArgs e)
------------- InnerException: -------------
System.ServiceModel.CommunicationException : The remote server returned an error: NotFound.
at System.ServiceModel.Channels.Remoting.RealProxy.Invoke(Object[] args)
at proxy_2.EndListRenderingExtensions(IAsyncResult )
at Telerik.Reporting.Service.SilverlightClient.ReportServiceClient.OnEndListRenderingExtensions(IAsyncResult result)
at System.ServiceModel.ClientBase`1.OnAsyncCallCompleted(IAsyncResult result)
------------- InnerException: -------------
System.Net.WebException : The remote server returned an error: NotFound.
at System.Net.Browser.AsyncHelper.BeginOnUI(SendOrPostCallback beginMethod, Object state)
at System.Net.Browser.BrowserHttpWebRequest.EndGetResponse(IAsyncResult asyncResult)
at System.ServiceModel.Channels.HttpChannelFactory.HttpRequestChannel.HttpChannelAsyncRequest.CompleteGetResponse(IAsyncResult result)
------------- InnerException: -------------
System.Net.WebException : The remote server returned an error: NotFound.
at System.Net.Browser.BrowserHttpWebRequest.InternalEndGetResponse(IAsyncResult asyncResult)
at System.Net.Browser.BrowserHttpWebRequest.<>c__DisplayClassa.<EndGetResponse>b__9(Object sendState)
at System.Net.Browser.AsyncHelper.<>c__DisplayClass4.<BeginOnUI>b__0(Object sendState)
Error in Fiddler :
HTTP/1.1 404 Not Found
Content-Length: 1565
Content-Type: text/html; charset=UTF-8
Server: Microsoft-HTTPAPI/2.0
Date: Wed, 25 Sep 2013 16:16:04 GMT
<?xml version="1.0" encoding="utf-8"?>
<!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">
<head>
<title>Service</title>
<style>BODY { color: #000000; background-color: white; font-family: Verdana; margin-left: 0px; margin-top: 0px; } #content { margin-left: 30px; font-size: .70em; padding-bottom: 2em; } A:link { color: #336699; font-weight: bold; text-decoration: underline; } A:visited { color: #6699cc; font-weight: bold; text-decoration: underline; } A:active { color: #336699; font-weight: bold; text-decoration: underline; } .heading1 { background-color: #003366; border-bottom: #336699 6px solid; color: #ffffff; font-family: Tahoma; font-size: 26px; font-weight: normal;margin: 0em 0em 10px -20px; padding-bottom: 8px; padding-left: 30px;padding-top: 16px;} pre { font-size:small; background-color: #e5e5cc; padding: 5px; font-family: Courier New; margin-top: 0px; border: 1px #f0f0e0 solid; white-space: pre-wrap; white-space: -pre-wrap; word-wrap: break-word; } table { border-collapse: collapse; border-spacing: 0px; font-family: Verdana;} table th { border-right: 2px white solid; border-bottom: 2px white solid; font-weight: bold; background-color: #cecf9c;} table td { border-right: 2px white solid; border-bottom: 2px white solid; background-color: #e5e5cc;}</style>
</head>
<body>
<div id="content">
<p class="heading1">Service</p>
<p>Endpoint not found.</p>
</div>
</body>
</html>
service tracelog error :
The incoming HTTP request's URI 'http://localhost:8080/' does not match any service operation.
app.config file :
<appSettings>
<add key="DhaaniReportURL" value="http://localhost:8080/" />
<add key="ClientSettingsProvider.ServiceUri" value="" />
<add key="NetworkMachinesConnStr" value="uid=root;password=;host=.;database=NetworkMachines;protocol=pipe;pipename=mysql;pooling='True';Min Pool Size=10;Max Pool Size=500" />
</appSettings>
<system.serviceModel>
<bindings>
<basicHttpBinding>
<binding name="BasicHttpsBindingConfig" maxReceivedMessageSize="2147483647" maxBufferSize="2147483647" receiveTimeout="00:30:00" sendTimeout="00:30:00">
<readerQuotas maxArrayLength="2147483647" maxStringContentLength="2147483647" />
</binding>
</basicHttpBinding>
</bindings>
<serviceHostingEnvironment aspNetCompatibilityEnabled="true" />
<services>
<service name="ReportingWCFWindowsService.ReportService" behaviorConfiguration="ReportServiceBehavior">
<host>
<baseAddresses>
<add baseAddress="http://localhost:8080/" />
</baseAddresses>
</host>
<endpoint address="ReportService" binding="basicHttpBinding" contract="Telerik.Reporting.Service.IReportService">
<identity>
<dns value="localhost" />
</identity>
</endpoint>
<endpoint address="ReportService/resources" binding="webHttpBinding" behaviorConfiguration="WebBehavior" contract="Telerik.Reporting.Service.IResourceService" />
<endpoint address="" binding="webHttpBinding" behaviorConfiguration="WebBehavior" contract="ReportingWCFWindowsService.IClientAccessPolicy" />
<endpoint address="mex" binding="mexHttpBinding" contract="IMetadataExchange" />
</service>
</services>
<behaviors>
<serviceBehaviors>
<behavior name="ReportServiceBehavior">
<serviceMetadata httpGetEnabled="true" />
<serviceDebug includeExceptionDetailInFaults="false" />
</behavior>
</serviceBehaviors>
<endpointBehaviors>
<behavior name="WebBehavior">
<webHttp />
</behavior>
</endpointBehaviors>
</behaviors>
</system.serviceModel>
Note :
When I run the service base address in browser it works fine. URL : http://localhost:8080/
ReportService.cs :
[ServiceContract]
public interface IClientAccessPolicy
{
[OperationContract, WebGet(UriTemplate = "/ClientAccessPolicy.xml")]
Stream GetPolicy();
}
[System.Runtime.Serialization.KnownType(typeof(object[]))]
public class ReportService : ReportServiceBase, IClientAccessPolicy
{
static string sReportURL = ConfigurationSettings.AppSettings["DhaaniReportURL"].ToString();
static readonly Uri baseUri = new Uri(sReportURL);
protected override Uri BaseAddress
{
get { return baseUri; }
}
protected override string ApplicationPath
{
get
{
//return System.IO.Path.GetDirectoryName(System.Windows.Forms.Application.ExecutablePath) + "\\";
//Make sure that the ApplicationPath property always returns a valid directory path that ends with a slash (/) or a backslash (\)
return System.IO.Path.GetDirectoryName(System.Windows.Forms.Application.ExecutablePath) + "\\"; // for WinForms applications
//return System.Web.HttpContext.Current.Request.PhysicalApplicationPath; // for ASP.NET applications
}
}
public Stream GetPolicy()
{
var fs = new FileStream(Path.Combine(this.ApplicationPath, "clientaccesspolicy.xml"), FileMode.Open);
var bytes = new byte[fs.Length];
fs.Read(bytes, 0, bytes.Length);
fs.Close();
if (WebOperationContext.Current != null)
{
WebOperationContext.Current.OutgoingResponse.ContentType = "application/xml";
}
return new MemoryStream(bytes);
}
}
SummaryReport.cs :
public partial class SummaryReport : Report
{
public SummaryReport()
{
InitializeComponent();
}
public List<Machine> GetReportData(string pcs, DateTime startTime, DateTime endTime, double dHours, bool isCustom)
{
string sInstallationName = string.Empty;
string sInstallationAddress = string.Empty;
string sVersionInfo = string.Empty;
InitConn();
List<Machine> lstMachine = new List<Machine>();
return lstMachine;
}
Report.xaml.cs :
repViewer = new ReportViewer();
repViewer.RenderBegin += new RenderBeginEventHandler(repViewer_RenderBegin);
repViewer.ReportServiceUri = new Uri(App.p_ReportEndPoint);
repViewer.Report = "ReportingWCFWindowsService.SummaryReport, ReportingWCFWindowsService";
void repViewer_RenderBegin(object sender, RenderBeginEventArgs args)
{
args.ParameterValues["pcs"] = machines.TrimEnd(',');
args.ParameterValues["startTime"] = p_DTStart;
args.ParameterValues["endTime"] = m_EndDateForResult;
args.ParameterValues["dHours"] = m_Hours;
args.ParameterValues["isCustom"] = isCustom;
//progIndicator.Stop();
}
Stef
Telerik team
answered
on
30 Sep 2013
3 answers
62 views
Hi,
We have a report with 40 number of columns. We want to show that report in a such way that, user will be able to do paging with columns also.What I mean is, we want to show only 10 number of columns on first page.And then when user will click on next columns, then it should show next 10 columns and so on.
So can you please let me know is it possible to implement such column paging functionality with Q3-2010 reporting controls.
Also while doing so can we also make available both paging for user i.e.Physical paging and logical paging(Column Paging).
Thanks,
Sachin.
We have a report with 40 number of columns. We want to show that report in a such way that, user will be able to do paging with columns also.What I mean is, we want to show only 10 number of columns on first page.And then when user will click on next columns, then it should show next 10 columns and so on.
So can you please let me know is it possible to implement such column paging functionality with Q3-2010 reporting controls.
Also while doing so can we also make available both paging for user i.e.Physical paging and logical paging(Column Paging).
Thanks,
Sachin.
Stef
Telerik team
answered
on
30 Sep 2013
2 answers
598 views
Hi All,
I am using Q3 2008 version of Telerik Reporting.
I have 1 report which contains a subreport in it.
Subrport is for each row (e.g. For each Date field in main report I am showing events for the dates in the subreport below that row).
I have aligned the report and subreport properly.
When I do export to excel a blank row gets created between tow main report records event regardless of whether there is data exists in subreport or not.
(If subreport has multiple rows for a record then there is no blank row between s8ubreport records but still it shows a blank row between tow main report records).
If I remove subreport from the main report and do export to excel then there is no blank row betwen two records.
Is this a correct scnerio that if there is any subreport then it takes a row for that subreport?
If not then can anyone please let me knowm what could be missing?
Best Regards,
Hrushikesh.
I am using Q3 2008 version of Telerik Reporting.
I have 1 report which contains a subreport in it.
Subrport is for each row (e.g. For each Date field in main report I am showing events for the dates in the subreport below that row).
I have aligned the report and subreport properly.
When I do export to excel a blank row gets created between tow main report records event regardless of whether there is data exists in subreport or not.
(If subreport has multiple rows for a record then there is no blank row between s8ubreport records but still it shows a blank row between tow main report records).
If I remove subreport from the main report and do export to excel then there is no blank row betwen two records.
Is this a correct scnerio that if there is any subreport then it takes a row for that subreport?
If not then can anyone please let me knowm what could be missing?
Best Regards,
Hrushikesh.
Dada
Top achievements
Rank 1
Rank 1
answered
on
30 Sep 2013
4 answers
155 views
Hi, I have an image with details listed below in a PictureBox which in report designer shows desired size 6cm / 4cm and when using webview it prints and pdfs ok at 6x4 but the html render in the browser shows at (I'm guessing) 700px / 470px (only shows a small portion of the image as its constrained within the picturebox size of 6x4)
I'm happy with the output to print and pdf but is there a way of scaling the image so it also looks in the html render?
I tried the sizing options by these didn't seem to make any difference, also tried reducing the image rez so it fitted it all outputs ok but the print and pdf quality suffered too much.
Image dimensions:
H-Res: 300
Phy-Dim: 700, 470
PixelFormat: Format24bppRgb
RawFormat: Png
V-Res: 300
cheers
Martin
I'm happy with the output to print and pdf but is there a way of scaling the image so it also looks in the html render?
I tried the sizing options by these didn't seem to make any difference, also tried reducing the image rez so it fitted it all outputs ok but the print and pdf quality suffered too much.
Image dimensions:
H-Res: 300
Phy-Dim: 700, 470
PixelFormat: Format24bppRgb
RawFormat: Png
V-Res: 300
cheers
Martin
Imran
Top achievements
Rank 1
Rank 1
answered
on
28 Sep 2013
4 answers
244 views
Hi,
I'm running the VS.Net 2010 and the Q3 2010 release of Telerik Reporting. I'm not sure how I can get the Crosstab wizard to launch. I see all the other Telerik Reporting controls in my Toolbox but not the Crosstab Wizard. I've tried uninstalling and reinstalling the Telerik Reporting software and also looked for it in "Add Items" under the Telerik Reporting tab in my toolbox. Not sure what is going on.
Thanks
Eric
I'm running the VS.Net 2010 and the Q3 2010 release of Telerik Reporting. I'm not sure how I can get the Crosstab wizard to launch. I see all the other Telerik Reporting controls in my Toolbox but not the Crosstab Wizard. I've tried uninstalling and reinstalling the Telerik Reporting software and also looked for it in "Add Items" under the Telerik Reporting tab in my toolbox. Not sure what is going on.
Thanks
Eric
Sebastian
Top achievements
Rank 1
Rank 1
answered
on
27 Sep 2013
5 answers
330 views
Hi,
I am using Telerik Reporting Q2 2010 in silverlight 4 application. To show report, I am using Telerik reportviewer in xaml file.
My requirement is to update status in database if report is printed and its very crucial requirement.
I tried several ways and looked into Telerik help as well as googling but could not found any meaningful solution.
Please help me finding a solution or at least a workaround.
A quick help will be greatly appreciated.
-Jono
I am using Telerik Reporting Q2 2010 in silverlight 4 application. To show report, I am using Telerik reportviewer in xaml file.
My requirement is to update status in database if report is printed and its very crucial requirement.
I tried several ways and looked into Telerik help as well as googling but could not found any meaningful solution.
Please help me finding a solution or at least a workaround.
A quick help will be greatly appreciated.
-Jono
Stef
Telerik team
answered
on
27 Sep 2013
1 answer
158 views
Hi,
I'm aware that this product is in Beta, so I figured I'd point out a bug I found. When attempting to apply parameters to my report, the javascript fails and I get the following response:
It happens in this block here:
Also, and this is a side note, when the page loads, the report is received through the api fine, but it does not actually load the report into the report viewer until I hit the refresh icon. Should I manually call for a refresh? I noticed the sample code provided on the announcement blog post does not require a manual refresh and just properly loads the report on page load.
Thanks
I'm aware that this product is in Beta, so I figured I'd point out a bug I found. When attempting to apply parameters to my report, the javascript fails and I get the following response:
Uncaught TypeError: Object #<Object> has no method 'applyParameters' parametersArea.js:509(anonymous function) parametersArea.js:509b.event.dispatch jquery-1.9.1.min.js:3v.handleIt happens in this block here:
var $previewButton = $("<button class='k-button trv-parameters-area-preview-button'></button>") .html("Preview") .appendTo($footer) .on("click", function () { controller.applyParameters(); /* if ($validator.validate()) { controller.applyParameters(); } else { alert("Invalid parameter values!"); } */ });Also, and this is a side note, when the page loads, the report is received through the api fine, but it does not actually load the report into the report viewer until I hit the refresh icon. Should I manually call for a refresh? I noticed the sample code provided on the announcement blog post does not require a manual refresh and just properly loads the report on page load.
Thanks
Chavdar
Telerik team
answered
on
27 Sep 2013
1 answer
82 views
Hi
With our current product we use Crystal for reporting. Report designers create the Crystal rpt file, a stored procedure for the data, and some report meta information to go into our database (the name of the rpt file, name of report, the stored procedure to use, the parameters that can be passed).
We then have an ASP site which reads the database to get the meta information of all the reports that are available on it's database. The site allows the user to navigate through and run the report they want, specifying the parameters as per the meta information. The Crystal report viewer then renders the report.
The site can also save the users parameter input to be run as a scheduled report later (a windows service checks the db periodically and renders the report to pdf for email)
This means that the ASP site never changes, report writers just need to know crystal and sql, and new reports can be added on the fly.
So, we are now looking for a modern, non-crystal solution, for our new product. One proposal is ASP.MVC with Telerik Reporting. I've seen that there is a standalone designer which is good and there are self contained trdx files. But is there the ability to create and drop in new reports on the fly like we have with our current crystal solution - without any changes to the mvc compiled code?
And if so are there any documents/guides/examples on getting that going?
Many Thanks
With our current product we use Crystal for reporting. Report designers create the Crystal rpt file, a stored procedure for the data, and some report meta information to go into our database (the name of the rpt file, name of report, the stored procedure to use, the parameters that can be passed).
We then have an ASP site which reads the database to get the meta information of all the reports that are available on it's database. The site allows the user to navigate through and run the report they want, specifying the parameters as per the meta information. The Crystal report viewer then renders the report.
The site can also save the users parameter input to be run as a scheduled report later (a windows service checks the db periodically and renders the report to pdf for email)
This means that the ASP site never changes, report writers just need to know crystal and sql, and new reports can be added on the fly.
So, we are now looking for a modern, non-crystal solution, for our new product. One proposal is ASP.MVC with Telerik Reporting. I've seen that there is a standalone designer which is good and there are self contained trdx files. But is there the ability to create and drop in new reports on the fly like we have with our current crystal solution - without any changes to the mvc compiled code?
And if so are there any documents/guides/examples on getting that going?
Many Thanks
Elian
Telerik team
answered
on
27 Sep 2013
