Questions on Reporting Forum

1 answer

136 views

Parameter dropdown does not reflect changes when date is changed

I have a report which has three report parameters:
StartDate - DateTime
EndDate - DateTime
Item - Integer - (Drop down AvailableValues from a stored procedure via data source)

Auto refresh is set to false for all three parameters.

If there is no data for the default values when the report comes up in the report viewer and the user does not use the popup menu to select a date and only highlights the day and changes the value and tabs/clicks away, the drop down list does not call the stored procedure to display the values based on the new date. If the popup menu is used, it works fine.

We have this in several reports, any idea how to work around this?

General Discussions

answered on 23 Jul 2013

1 answer

139 views

StrokeCollection to PictureBox

Hi,
I'm using C# and the Reporting Framework. In my program a user is making a signature on a tablet computer into a InkCanvas Control.
Out of this InkCanvas Control i can get the StrokeCollection. Now I'm transforming this StrokeCollection to a picture and then pass it to a picturebox on the report. Is it else possible to pass that data to the picturebox?

Regards Markus

General Discussions

answered on 23 Jul 2013

2 answers

286 views

Binding Property of Report

Hello all
I am new with Report and I would binding a field of my Report (not a field of DataSource)
MyReport.cs

public partial class MyReport : Telerik.Reporting.Report

{

public string MyString

{

get { return "Demo Telerik Report"; }

}

public EntiteDatabase()

{

//

// Required for telerik Reporting designer support

//

InitializeComponent();

//

// TODO: Add any constructor code after InitializeComponent call

//

}

And in my TextBox, I tried to bind with this expression "=Report.MyString" but it's dosen't work.
It's possible ?
I wouldn't use static method because this field could depending parameters of my report or others ...

thanks for help

General Discussions

answered on 23 Jul 2013

1 answer

150 views

Organizing a Reporting Framework

Hello,

I want to use Reporting for a series of reports for my organization - the site is based in DotNetNuke.

I've used reporting before and am reasonably comfortable with it all... but I'm curious if anyone has any suggestions for broadly how to organize the reports. I would like to make a central library of reports and a report controller of sorts that handles permissions, access, and parameters. Then, I'll probably make a DNN module that shows reports matching some set of conditions.

But, before I dive in with this, I'm wondering if anybody has any suggestions or thoughts on how to organize and handle many reports. What's the best way to make sure that individual reports get the right parameters? What's the best way to store a list of reports and parameters? Are there any features of functions of Telerik's framework that apply specially in this sort of context?

Thanks,

Mike

General Discussions

answered on 22 Jul 2013

1 answer

169 views

running a macro

in the following code would it be possible to pass code that deletes a page break and reformats the footer on the docx that the report is converted to. I am thinking p.invokemethod(method name) or something like that. This is a workaround to auto page break place in docx document at end of page. I do not want to add to my app.config as earlier post suggests.

Telerik.Reporting.Processing.RenderingResult result = TelContractrp.RenderReport("DOCX", TelContractirs,deviceInfo);

string dContract = DateTime.Now.ToString().Replace("/", "");

dContract = dContract.Substring(0, 12);

dContract = dContract.Replace(":", "");

string fileName2 = result.DocumentName + "_" + dContract + "." + result.Extension;

string filePath2 = System.IO.Path.Combine(saveLocation, fileName2);

FileStream fs = new FileStream(filePath2, FileMode.Create);

fs.Write(result.DocumentBytes, 0, result.DocumentBytes.Length);

fs.Close();

System.Diagnostics.Process p = new System.Diagnostics.Process();

p.StartInfo.UseShellExecute = true;

p.StartInfo.FileName = filePath2;

p.Start();

General Discussions

answered on 22 Jul 2013

3 answers

301 views

How to filter Report Sqldatasource in ASP.net Page load event.

Folks

Using RadControls for ASP.NET AJAX Q1 2013 SP2 with Reporting version = 7.1.13.705. In my report I have a SQLDatasource (i.e. SQLDatasource2).

I would like to Filter that Datasource in Page load event of ASP.net not inside Report NeedDataSource event.

This works in Report NeedDataSource event.

private void TestReport1_NeedDataSource(object sender, EventArgs e)

{

//Take the Telerik.Reporting.Processing.Report instance

Telerik.Reporting.Processing.Report report = (Telerik.Reporting.Processing.Report)sender;

string stsql = "SELECT M.ManagerID, C.FirstName + ' ' + C.LastName AS Name, E.Gender FROM  (SELECT DISTINCT ManagerID  FROM HumanResources.Employee) AS M INNER JOIN";

stsql += " HumanResources.Employee AS E ON M.ManagerID = E.EmployeeID INNER JOIN Person.Contact AS C ON E.ContactID = C.ContactID WHERE (E.Gender = N'F') ORDER BY Name";

this.sqlDataSource2.SelectCommand = stsql;

}

But I would like to filter the Datasource in Page load event of asp.net. I came up with this..

Protected void Page_Load(object sender, EventArgs e)

{

if (!IsPostBack)

{

Report1 myReports = new Report1();

Reports.TestReport1 myReport = new Reports.TestReport1();

string stsql = "SELECT M.ManagerID, C.FirstName + ' ' + C.LastName AS Name, E.Gender FROM  (SELECT DISTINCT ManagerID  FROM HumanResources.Employee) AS M INNER JOIN";

stsql += " HumanResources.Employee AS E ON M.ManagerID = E.EmployeeID INNER JOIN Person.Contact AS C ON E.ContactID = C.ContactID WHERE (E.Gender = N'F') ORDER BY Name";

// Need help here to filter SQLDatasource2..

}

Any help is appreciated. I use Asp.net Ajax a lot, trying to implement Telerik Reporting along with Webforms in a new project. Thanks

gc_0620

General Discussions

answered on 22 Jul 2013

1 answer

106 views

Problems Creating proper Column Chart

I am using Visual Studio 2012 .
I created a business Object , created a Telerik Report and have it successfully connected to the business object data source.
The method that gets the data returns a DataTable . I have a column for event Id and another one for duration and If I use a table I am able to see 40 rows with their specific event Id and event duration.

NOW when I use the graph wizard, select the clustered column, select the data source, I put the eventId in Categories and Duration in Values. When I try to preview the report I obtain 40 different empty graphs. Why is that? What am I doing wrong?
I want the information of all the rows to be in ONE graph.

Any help is appreciated!
Thanks!

General Discussions

answered on 22 Jul 2013

1 answer

81 views

Problem with Printing a generated Document

Hey,

i´v a Little Problem with the Printing Function in the ReportViewer. I want to print an generated Document automaticly, but when i´m opening the Form, i can´t Print the Document, becouse it is not generatet in the Moment. The Generation takes about ca. 1 - 2 Seconds.

Now my Question. How can i check automaticly if the Generation of the Document is finish?

Thangs a lot.
Dee

General Discussions

answered on 22 Jul 2013

5 answers

474 views

Install .otf font

Hi

I have installed a new font in c:\windows\fonts Folder
I restarted the pc

I can use the new font in Windows Office Word.

But i can't see the new font in telerik reporting designer, why ?

Thanks for any anyswer.

General Discussions