Telerik Forums
Reporting Forum
8 answers
159 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
83 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
459 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
180 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
122 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
143 views
Hai!


I  don't know  how to create reporting for xml data....please help me....
Steve
Telerik team
 answered on 27 Aug 2009
2 answers
324 views

Hi,

In telerik Report , can i calculate age from DOB that i get for each record in my query.

Is there any datetime functions or formula fields available like in crystal reports for doing above thing?

Please reply me as soon as possible.

Thanks in advance.
Kaushal Shah
Top achievements
Rank 1
 answered on 27 Aug 2009
4 answers
356 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
5 answers
397 views
I am trying to find the best way to pass a parameter to a report in my web app. Here is what I have done so far:

I have built a seperate class that holds my reports called "MyTelerikLib".
I built a report called "DepartmentReport.vb"
I added a SqlDataAdapter to the report called "SqlDataAdapter1"
    I configured the adapter to use an existing stored procedure that has a parameter called "@DepartmentID"
    If I hard code the SqlDataAdapter parameter value it works fine in preview mode
 
I have a webform in my main project with a ReportViewer on it and I assigned  "DepartmentReport.vb" as it's report.
I would like to be able to dynamically add the value to SqlDataAdapter1 during the reports OnLoad event.

I really want to get the parameter from a session variable but Hard Coded it to 7 here to test it.
Here is what I have been trying on the reports webform Page_Load event:
Protected  
 
   
 
Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load   
 
    Dim rv As Telerik.Reporting.Report = New DepartmentReport()   
    rv.ReportParameters("DepartmentID").Value = 7   
    Me.ReportViewer1.Report = rv   
 End Sub   
 
   
AkAlan
Top achievements
Rank 2
 answered on 26 Aug 2009
1 answer
111 views
Hello,
I'm trying to use the Telerik Reporting and I've created a dataset via visual studio 2008.
I've to use an old set of store procedures that have columns name with spaces and . (I know it's an horror, I tried to ask the DBA for a change but no way).
The problem is that Telerik Reporing doesn't like the . in the column name (I receive an out of boundaries exeption) ... is there a way to escape it?
Thanks

Paolo
Milen | Product Manager @DX
Telerik team
 answered on 26 Aug 2009
Top users last month
Edmond
Top achievements
Rank 1
Iron
fabrizio
Top achievements
Rank 2
Iron
Veteran
RobMarz
Top achievements
Rank 2
Iron
Fakhrul
Top achievements
Rank 1
Iron
Tejas
Top achievements
Rank 2
Iron
Iron
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?