Telerik Forums
Reporting Forum
0 answers
190 views
Hi,
I am using Telerik table to displaying data but it doesnt seem to do anything.
becausethe stored proc I use to call the data is working and it displays data but in 16 pages
displaying the results in each line in 16 pages.
My proc returns 16 results.
I am using dataset with report viewer.This is the code

public

 

void Acc_setup_report_S6(string strAccountnumber)

 

{

System.Data.OracleClient.

OracleConnection conn = new System.Data.OracleClient.OracleConnection(System.Configuration.ConfigurationManager.AppSettings["ConnStr"].ToString());

 

System.Data.OracleClient.

OracleCommand cmd = new System.Data.OracleClient.OracleCommand();

 

cmd.Connection = conn;

System.Data.OracleClient.

OracleDataAdapter da = new System.Data.OracleClient.OracleDataAdapter(cmd);

 

 

DataSet ds = new DataSet();

 

 

 

try

 

{

cmd.CommandText =

"pkg_csharp_reports.sprocAcc_setup_report_S6";

 

cmd.Parameters.Add(

"account_number_", OracleType.VarChar);

 

cmd.Parameters[

"account_number_"].Direction = ParameterDirection.Input;

 

cmd.Parameters.Add(

"ret_result_", OracleType.Cursor);

 

cmd.Parameters[

"ret_result_"].Direction = ParameterDirection.Output;

 

da.Fill(ds);

 

foreach (DataRow dr in ds.Tables[0].Rows)

 

{

 

// //this.textBox1.Value = dr["description"].ToString();

 

 

this.textBox1.Value = dr["fee"].ToString();

 

 

this.textBox2.Value = dr["payor"].ToString();

 

}

}

 

finally

 

{

cmd.Dispose();

 

if (conn.State == ConnectionState.Open)

 

conn.Close();

conn.Dispose();

}

 

//return ds;

 

}

sree devi
Top achievements
Rank 1
 asked on 28 Aug 2009
1 answer
109 views
Hi,

I seem to be getting a random error when viewing a report. The error is:

An error has occured while processing Report:
The SelectCommand property had not been initialized before calling 'Fill'

I have looked through the help files and this forum but as yet no luck, anyone have any ideas?

Many thanks.
Steve
Telerik team
 answered on 28 Aug 2009
3 answers
281 views
In  MytextBox_ItemDataBound event of MytextBox that resides in my group footer section on my report, I get values of a data bound textbox  (MytextBox ) and i add them and get the result. And i just wannto assign that result to a non-data bound textbox that resides in PageFooter of my report. How can i do that?

I tried this.NonDataBountextBox.Value = tfinalresult.ToString(); in MytextBox_ItemDataBound  evetn, however it did not work.

And how can i do that, in every single report page and assign the result to the non-data bound textbox in every page separately? I mean not all the data bound MytextBox of whole report but ones on every page individually.

Thanks ...

 

Steve
Telerik team
 answered on 28 Aug 2009
8 answers
178 views
I need to pass  values to parameters (@date) there in SQL of DataSet of my Report. I tried following, however it threw exception that "object refrence not set to and instance of object"

Two parameter i added to  my report from Reports design > Properties > ReportParameters is  pCode1 and pCode2 , and i assing their values as follows:

(ReportViewerMizan.Report

as RaporMuhMizan).ReportParameters["pCode1"].Value = TextBoxHesapKodu1.Text;

 

(ReportViewerMizan.Report

as RaporMuhMizan).ReportParameters["pCode2"].Value = TextBoxHesapKodu2.Text;

 

 


No problem upto now, then after that in the following lines i assign values of parameter in SQL of DataSet of my Report(RaporMuhMizan) as follows:

(ReportViewerMizan.Report

as RaporMuhMizan).ReportParameters["pDate1"].Value = RadDatePickerDate1.SelectedDate;

 

(ReportViewerMizan.Report

as RaporMuhMizan).ReportParameters["pDate2"].Value = RadDatePickerDate2.SelectedDate;

and it throws the exception i mentiond above.

 

RaporMuhMizan is the dll of my reports calss library project.

So how can i handle this? Thanks...

 

 

Kem Arda
Top achievements
Rank 1
 answered on 28 Aug 2009
1 answer
101 views

Hello Friends,

In Telerik Report When user click some field in report then i want to give hyperlink to a different report or some screen in my application.

Can anybody know how can i do above thing in Telerik Report ?

Please give me reply as soon as possible.

Thanks in advance.
Steve
Telerik team
 answered on 28 Aug 2009
4 answers
493 views
Hello,
I've got a dataset with 7 table, I've filled the main report page with the data of DataSet.Tables[0], but I'm not able to see the other data in the subreport... I've setted the membersource inside the report to the corresponding column.... anyone can provide me a sample with the how-to?
Thanks
Steve
Telerik team
 answered on 28 Aug 2009
1 answer
221 views
Hi,

I wonder if you can help with me the following scenario I am trying to achieve:

I create a report using the designer wizard and bind a business object to it - lets call it "MyObjectDetails".

The "MyObjectDetails" object has a property called "Features" - which is a generic list of strings.

On the report I drag a Table report item - what I want to do is "bind" the "Features" list of strings to the Table report item so when the report runs the features are displayed in the Table.

I have read your examples and watched your videos and i am very confused on how to achieve this!

Any ideas?
Chris Gillies
Top achievements
Rank 1
 answered on 28 Aug 2009
1 answer
149 views
I created a report in a web application. When I generate the report in my machine it display the data correctly. But after I publish the application in the production server, all the data is displayed disorganized. How can I solve this situation?
Steve
Telerik team
 answered on 27 Aug 2009
1 answer
175 views
Hai!


I  don't know  how to create reporting for xml data....please help me....
Steve
Telerik team
 answered on 27 Aug 2009
4 answers
386 views
Hi, guys.

I have the following scenario.

My report has 2 parameters and uses NeedDataSoure event. In this event I get DataTable with my data and assign to DataSource property of the report. On the page where ReportViewer is I have UI for my 2 parameters and a button. Click event of this button assigns parameters for my report.

As the result I see my report but without data bound in details section. DataTable contains data (check while debugging) for sure but not bound. When I hit Refresh, all is fine.

I've seen this schenario in some video tutorial and there in click event handler was a call of ReportViewer.RefreshReport method. But I cannot find this method now in web form ReportViewer for Q2 2009. Is it replaced by some new one?

Please advise.
Steve
Telerik team
 answered on 27 Aug 2009
Top users last month
Tien
Top achievements
Rank 1
Iron
Krasimir
Top achievements
Rank 3
Bronze
Iron
Iron
Cedar
Top achievements
Rank 1
Iron
Emil
Top achievements
Rank 1
Iron
Kyle Watson
Top achievements
Rank 1
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?