Questions on Reporting Forum

1 answer

123 views

How to Implement web sessions into Reporting

I am trying to build a report that can be used for (lets says) 50 clients to be used via the web. How can I get the report to auto filter the results by using a session"id"?

For xample : If Client 1 logs in and runs the report, I only want Client 1 information to show.

I cannot seem to find any documentation on this, can someone point me in the right direct or would someone have directions on how to implement this?

I have tried adding the session varible below, I also added a parameter from the front end that was named the same but still no success.

    
             rpt = New ClassReports.PurchaseItemstoDate  
        
                            rpt.ReportParameters(0).Value = Session("role")  
        
                            ReportViewer1.Report = rpt

General Discussions

answered on 04 May 2010

1 answer

87 views

Accessing a subreport's public method

Hi. I have two reports, r1 and r2. r2 is a subreport of r1, and it has a method called m1, which is public. In r1, the subreport's name (which, as I said, references r2) is sb1. How can I access the m1 method through sb1?

To make myself more clear, basically what the m1 method does is to set r2's DataSource, and I need to do it from the parent report, which is r1. Am I trying to do it in the right way? What do you recommend?

Thanks.

General Discussions

answered on 04 May 2010

1 answer

132 views

Silverlight: 'Value cannot be null' when using parameters.

Hi,

I have started using the Telerik Reports and am a bit stumped. In case it matters, I am using the 3.2.9.1211 version of the Silverlight Report Viewer and the 4.0.10.423 version of the engine on the server.

I made a report that didn't use any parameters which successfully loaded in the Silverlight Report Viewer. I then modified the report to accept report parameters for a start time and end time. They are bound to the equivalent parameters in a sql query.

When I run the version with parameters the report viewer finishes with the following message:

Error: Value cannot be null.
Parameter name: typeName

I have checked in the ItemBinding event and the sender appears to have the correct data from the silverlight client. I have tried using string and DateTime data types, in the parameter definition and also sent by the silverlight client.

Though one oddity. I noticed in the report definition defines its type at ReportParameterType.DateTime whereas silverlight sends a System.DateTime. Would that be a cause for problems?

Cheers,
Clint

General Discussions

answered on 04 May 2010

2 answers

276 views

OraclePermission Exception

Hi,
After getting the
"Unable to load one or more of the requested types. Retrieve the LoaderExceptions property for more information."
error about Telerik Reporting, I have applied the steps described in the following thread(Medium Trust issue).

http://www.telerik.com/community/forums/reporting/telerik-reporting/loaderexception-exporting-pdf-report-from-web-page.aspx

After that I started to get this error message about OraclePermission.

"Request for the permission of type 'System.Data.OracleClient.OraclePermission, System.Data.OracleClient, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed."

I've tried to setup trust level in web.config file as in the example but couldn't solve the problem.
<securityPolicy>
<trustLevel name="Custom" policyFile="web_customtrust.config" />
</securityPolicy>
<trust level="Custom" originUrl="" />

Would you give me any walkthrough for this issue?

Thanks in advance.

General Discussions

answered on 04 May 2010

1 answer

101 views

External Reports

Greetings,

Is there anyway to create EXTERNAL reports without having to compile a project?

We currenly use CR which uses a file with .rpt extension and we have the capability to create reports then place then in a reports folder. The page access the list which the users can run without having to recompile the project and have 60 users logout of the application every time we add a report.

Thanks in advance!

General Discussions

answered on 03 May 2010

0 answers

128 views

i face this error external component has thrown an exception

Hi,

this is shanker i am doing one project .Me requirement is print report without showing the telrik report.Its working on developer system .But not worked on other system and server and local server i got this error "external component has thrown an exception" How to solve this problem please give solution of this problem

this my code

if (e.CommandName == "Print")

{

int? fee_receipt_id = int.Parse(e.CommandArgument.ToString());

int? status_code = null;

int? call_user_id = LogonDetails.Instance.sys_lclvar_user_id;

int? call_screen_id = GetScreenId();

int? session_id = LogonDetails.Instance.sys_lclvar_session_id;

string call_ip_address = CommonMethods.CurrentIP;

bool? audit_report_execution = LogonDetails.Instance.sys_lclvar_audit_user_action;

bool? audit_user_action = LogonDetails.Instance.sys_lclvar_audit_user_action;

string status_text = String.Empty;

var printdata = ReportsManager.get_report_fee_receipt(

fee_receipt_id, call_screen_id, call_user_id, session_id, call_ip_address, audit_user_action, audit_report_execution, ref status_code, ref status_text);

if ((!status_code.HasValue) || (status_code.Value != 0))

{

DisplayMessage(false, status_text);

return;

}

string strTitle = LogonDetails.Instance.sys_lclvar_facility_name;

var report = new TelerikComponentsWS.Reports.RepFeeReceipt();

report.DataSource = printdata;

Telerik.Reporting.Drawing.ExternalStyleSheet exx = new Telerik.Reporting.Drawing.ExternalStyleSheet("~\\css\\ReprotStyleSheet.xml");

report.ExternalStyleSheets.Add(exx);

report.ReportParameters[0].Value = strTitle;

using (System.Windows.Forms.PrintDialog printDlg = new System.Windows.Forms.PrintDialog())

{

printDlg.AllowSomePages = true;

printDlg.AllowCurrentPage = false;

printDlg.UseEXDialog = true;

if (System.Windows.Forms.DialogResult.OK == printDlg.ShowDialog())

{

Telerik.Reporting.Processing.ReportProcessor reportProcessor = new Telerik.Reporting.Processing.ReportProcessor();

reportProcessor.PrintReport(report, printDlg.PrinterSettings);

}

////Telerik.Reporting.Processing

//System.Drawing.Printing.PrinterSettings printerSettings = new System.Drawing.Printing.PrinterSettings();

//// Adjust the printer settings if necessary...

//System.Drawing.Printing.PrintController standardPrintController = new System.Drawing.Printing.StandardPrintController();

//printerSettings.PrinterName = "MyHomePrinter";

//// Print the report using the printer settings.

//Telerik.Reporting.Processing.ReportProcessor reportProcessor = new Telerik.Reporting.Processing.ReportProcessor();

//reportProcessor.PrintController = standardPrintController;

//reportProcessor.PrintReport(report, printerSettings);

}

please send replay it's argent

thanks and regards

shanker.B

General Discussions

asked on 03 May 2010

4 answers

148 views

How to hide URL at the bottom while printing reports?

Hi,

While printing Telerik reports, the URL of the page is printed at the bottom and page number at the top.

This is default setting of the browser and we can change it in the browser's page setup.

But is there any way I can change it through code or any property of Telerik reports? Because when I try to do the same thing with Devexpress' XtraReports, I don't see this issue. Which means this thing can be handled through code because they are also using the same PDF engine to print.

I am using Telerik Reporting 2010 Q1 (vesion 2010.1.310).

General Discussions

answered on 02 May 2010

19 answers

726 views

Export to CSV includes text controls?

Hello -
I have a report and when I choose the export to CSV, the report is generated, but it includes the text box controls that I use as labels as well, not just the data values.

So, instead of what I would expect:
"Jones, Janet",555-555-9999,555-555-1222

I see this:
TextBox1,TextBox2,TextBox3,TextBox4,TextBox5
Full Name,Cell Phone,Home Phone,"Jones, Janet",555-555-9999,555-555-1222

Is this a bug? or is there a way to fix this?
thanks
- will

General Discussions

answered on 01 May 2010

4 answers

180 views

Binding to a POCO

I'm new to Telerik reporting and am looking for any examples of binding the report to a class object containing a generic list.

Thanks

General Discussions

answered on 30 Apr 2010

1 answer

91 views

A small problem with populating the filter list

Hi

Firstly - may fantastic tools! I have been working with the ASP.Net and the ease of development and manuals are so good I am about to get the order placed!

Based on this I have been looking at the reporting tool and I have hit a minor problem with trying to define a list of values for filtering (which I would like to do by querying my database).

So far I generated a report that I can filter using a value typed into a text box which works fine however it would be much easier for my users if this value were chosen from a dropdown list (much like the orders example in your excellent demonstration). Ideally this would be populated from a simple query to my SQL server

To this end I selected Filters -> new, picked the parameter I wished to filter on and in "values" selected <new report parameter>. In the available values I set up a new data source that returns the ID I wish to filter on and the text description to show. The query executes OK and all is fine!

When however in the Report Parameter Editor I select 'Display member' (which I assume would display the text), Filters, Sorting or Value member I get the same error of 'The service Teletik.Reporting.IDataItem already exists in the service container. Parameter name: service Type"

Any help you can offer would be much appreciated as this would be much appreciated (I am working in vb.net)

James

General Discussions

answered on 30 Apr 2010