In my application I have to generate paper setter for online and offline test. I have done that so far quite easily, now my requirement is to create a dynamic template, so that while I print report it should fill all data inside created template.
I am also providing what I have achieved still now and what still need to be done more.. Please any one rescue me from here.
There is a stand alone report designer available in Telerik, please anyone guide me to use that. I think that might be suited for my need.
Or if anyone provide me a demo that will be highly helpful.
Hello,
I have a report that has two parameters. When accessing the report parameters from the report CS file, the parameters are in the collection, but the values are blank. Any help would be much appreciated.
Thanks,
Virgil
ReportViewer.aspx
1.
<
form
id
=
"form1"
runat
=
"server"
>
2.
<
div
>
3.
<
telerik:ReportViewer
ID
=
"ReportViewer1"
runat
=
"server"
>
4.
</
telerik:ReportViewer
>
5.
</
div
>
6.
</
form
>
ReportViewer.aspx.cs
01.
protected
void
Page_Load(
object
sender, EventArgs e)
02.
{
03.
int
tableId =
int
.Parse(Request[
"tableId"
]);
04.
int
reportType =
int
.Parse(Request[
"reportType"
]);
05.
06.
string
typeName =
typeof
(BG0001).AssemblyQualifiedName;
07.
08.
var reportSource =
new
Telerik.ReportViewer.Html5.WebForms.ReportSource();
09.
reportSource.Identifier = typeName;
10.
reportSource.IdentifierType = Telerik.ReportViewer.Html5.WebForms.IdentifierType.TypeReportSource;
11.
reportSource.Parameters.Add(
"TableId"
, tableId);
12.
reportSource.Parameters.Add(
"ReportType"
, reportType);
13.
14.
this
.ReportViewer1.ReportSource = reportSource;
15.
}
<
input
id
=
"ReportViewer1_hidden"
name
=
"ReportViewer1_hidden"
type
=
"hidden"
value
=
"{"
documentMapVisible":true,"parametersAreaVisible":true,"scale":1,"scaleMode":"SPECIFIC","viewMode":"INTERACTIVE","printMode":"AUTO_SELECT","reportSource":{"report":"TestReports.Reports.BG0001, TestReports.Reports,
Version
=
1
.0.0.0,
Culture
=
neutral
,
PublicKeyToken
=
null
","parameters":{"TableId":38,"ReportType":3}},"pageNumber":1}">
The code inside the BG0001 report
01.
public
BG0001()
02.
{
03.
//
04.
// Required for telerik Reporting designer support
05.
//
06.
InitializeComponent();
07.
08.
this
.ProcessReportParams();
09.
10.
}
11.
12.
protected
void
ProcessReportParams()
13.
{
14.
this
.teamId =
int
.Parse(
this
.ReportParameters[
"TableId"
].Value.ToString());
15.
this
.reportType =
int
.Parse(
this
.ReportParameters[
"ReportType"
].Value.ToString());
16.
}
Intermediate window test of parameter values
01.
?this.ReportParameters["TableId"]
02.
{Telerik.Reporting.ReportParameter}
03.
AllowBlank: false
04.
AllowNull: false
05.
AutoRefresh: false
06.
AvailableValues: {(none)}
07.
Mergeable: true
08.
MultiValue: false
09.
Name: "TableId"
10.
Text: ""
11.
Type: Integer
12.
Value: ""
13.
Visible: true
I am using Nested sub report for this situation.
e.g.
Master Report - MainReport which contains Sub Report - SubReport1 and that Sub Report - SubReport1 also contain Sub Report - SubSubReport11.
SubReport1 has multiple data - e.g. Product 1,Product 2 etc.
SubSubReport11 has multiple data - e.g. Product 1 details, Product 2 details etc.
How can I bind data source for SubSubReport11 to get data for each product?
I have this type of scenario, so I have used Nested sub reports.
A. Main Report
1. Sub Report 1
a. Sub Sub Report 1 - It contains multiple data...(e.g. Line 1,Line 2,Line 3 etc.)
2. Sub Report 2
a. Sub Sub Report 2 - It contains multiple data...(e.g. Line 1,Line 2,Line 3 etc.)
If any other way to get this,please let me know.
Please give me any idea.
Thanks & Regards,
Bhavika
hi Team,
during run time can we swap rows or realign row order after generating the report.
is It possible to x axis and y axis in chart during run time.
we need to achieve above functionality using telerik reports.
Hi!
I am working on Telerik Reporting and I need to hide panels when the list I use by ObjectDataSource is empty. How can I handle it? Those blue are panels, and just below the lists. But they are not together, do I have to connect them by something like subreport? Do I have to write some code?
Thanks a lot!
Hi,
I'm trying to add reports to a report book and display the report book in a MVC project, but I haven't found a way to do it so far.
Here is the code behind sample
public ActionResult ReportBook()
{
ReportBook reportBook = new ReportBook();
reportBook.Reports.Add(new TelerikReporting.MissionPlanning());
Report report = new Report();
report.DataSource = new UriReportSource() { Uri = "TelerikReporting.AgencyList, TelerikReporting" };
reportBook.Reports.Add(report);
InstanceReportSource instanceReportSource = new InstanceReportSource();
instanceReportSource.ReportDocument = reportBook;
return View("ReportBook", instanceReportSource);
}
and the view code
@model Telerik.Reporting.InstanceReportSource
@(Html.TelerikReporting().ReportViewer()
.Id("reportViewer1")
.ServiceUrl("/api/reports/")
.TemplateUrl("/Reports/templates/telerikReportViewerTemplate-9.1.15.624.html")
.ViewMode(ViewMode.Interactive)
.ScaleMode(ScaleMode.Specific)
.Scale(1.0)
.PersistSession(false)
.ReportSource(Model)
)
This results in an empty report with a "No Report" message. I don't see what I'm doing wrong, it looks like the few samples I've found.
I've managed to display a single report by using a TypeReportSource instead of an InstanceReportSource, but that's not what I need...
​
I am using HTML5 Web Form REST Telerik Reporting Q1 2017. When setup the first report which is using the wizard the report and parameter working properly.
However when I tried to pass the parameter from Querystring (from other web form) the report parameter becomes Null.
Please help me, What is the best workaround or solution for this issue?
=======================================================================
On the Page_Load report viewer I get the value from Querystring :
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
RptQuot1 report = new RptQuot1(Request.QueryString["Parameter1"] as string);
}
}
On the report constructor I added the parameter "Parameter1"
public RptQuot1(string parameter1)
{
InitializeComponent();
this.DataSource = null;
this.ReportParameters["Parameter1"].Value = parameter1;
}
Also on that class I added the NeedDataSource event handler :
public void RptQuot1_NeedDataSource(object sender, System.EventArgs e)
{
Telerik.Reporting.Processing.Report report = (Telerik.Reporting.Processing.Report)sender;
this.sqlDataSource1.Parameters[0].Value = report.Parameters["Parameter1"].Value;
report.DataSource = this.sqlDataSource1;
}