Telerik Forums
Reporting Forum
1 answer
134 views
Hi All,
I have a  probem and its urgent I am trying to generate a report tht has 4 sections and two of them r are tables the other sections work fine.
For the tables I am using datasets and in the datadapter I can see the data its returning but for some reason I cannot see it on the report.I am using a reportviewer. am attaching the code for report.cs

public partial class Report1 : Telerik.Reporting.Report
    {
        public Report1()
        {
            /// <summary>
            /// Required for telerik Reporting designer support
            /// </summary>
            InitializeComponent();
            

            this.DataSource = null;
          
            // TODO: Add any constructor code after InitializeComponent call
            //
        }

        private void Report1_NeedDataSource(object sender, EventArgs e)
        {
            this.oracleDataAdapter1.SelectCommand.Parameters["@Account_number"].Value = this.ReportParameters["Account_number"].Value;
            Telerik.Reporting.Processing.Report report = (Telerik.Reporting.Processing.Report)sender;
            report.DataSource = this.oracleDataAdapter1;

        }

and aspx.cs code is
protected void Page_Load(object sender, EventArgs e)
        {
            string strAccountNumber = "000000000000";
            //string strAccountNumber = SQLStatic.Sessions.GetSessionValue(Request.Cookies["Session_ID"].Value.ToString(), "account_number");
          
              Section6.Report1 report = new Section6.Report1();
         
            ReportViewer1.Report = report;
}
please help its urgent.
Steve
Telerik team
 answered on 07 Sep 2009
2 answers
201 views
Hi,

I'm having problems getting my data fields to display in a table. I create all the neccesary columns and rows and all the fields are assigned to static groups. I dont really need the fields to be grouped. I dont use a dataset as a datasource. When the report gets instantiated, it gets a collection as a datasource during runtime. This collection is of type: observablecollection<ITenderLineItem>. ITenderLineItem is an interface that contains a set amount of named properties. The property names are set in the table fields as: =Fields.["Property Name Here"]. This collection is generated in the program beforehand. The report's table generates the correct amount of lines in the detail section when i run it but none of my fields display any values. Its just blank. Is there maybe a tutorial that explains in detail how to create a table and bind it to data? I'm sure that I'm just missing a tiny detail somewhere. Unfortunately I need to use a table because each cell has a border and certain fields are multiline. If i just use textboxes then I don't get a consistent height on all of them per row when one textbox is multilined. Help please. 
Hrisi
Telerik team
 answered on 04 Sep 2009
1 answer
1.3K+ views
I need to check out if two fields are null in dataset Then, if two fields are null, then i wantto set the visible property of layout of detail section( of corresponding records) to false. O do following check:

Expression     Operator           Value
=Fields.X           =                      = Null


And finally how filter of detail section of report looks:
=Fields.X = = Null

However nothing happens. Help pls.
Thanks...


Hrisi
Telerik team
 answered on 04 Sep 2009
1 answer
554 views
Hi I am stuck on a problem. I have 2 tables which are nested on a single report. Both datasources are being set in their needdatasource method respectively.

My problem lies in retrieving a value from the parent table which will populate the child tables based on whatever values which are retrieved from the parent. I just need to retrieve one variable from the parent table once it is populated so that I can populate the child table accordingly.

Basically, I want a master-details / master-child relationship

Thanks
Svetoslav
Telerik team
 answered on 04 Sep 2009
1 answer
107 views
Hi,

I have Created a InvoiceMaster Report, Its working fine.
and a InvoiceDetail report, which have a stored procedure (with parameters) as datasource and this InvoiceDetail report working file separataly (providing report parameters correaponding to each stored procedure parameter).

Now I am using InvoiceDetail report in detail section of InvoiceMaster.

the problem is, how to send report parameters from each item of  InvoiceMaster  to InvoiceDetail.

Thanks in advance....

Svetoslav
Telerik team
 answered on 04 Sep 2009
1 answer
318 views
Hi,

is there a way for me to do this? I've tried doing it but the FormattingRule class does not expose a property that allows me to change the Expression. I'm passing parameters to the report constuctor and based on those parameters the formating conditions need to be set up.

Thanx
Svetoslav
Telerik team
 answered on 04 Sep 2009
1 answer
130 views
Is there a way to create a custom report parameter by deriving from ReportParameter?  Basically I would like to have the Telerik RadComboBox control be a possible parameter so that when a user starts typing in the box the box will load with matching information.

Any help would be greatly appreciated.  This is the one thing that is holding me back from moving forward with Telerik Reporting.

FYI, I know I can create my own custom report parameter area and pass the values in the code behind, but I am trying to avoid this and make things more graceful.
Svetoslav
Telerik team
 answered on 04 Sep 2009
2 answers
97 views
Hi,

is it possible to stream a report (i.e. when a hyperlink is clicked just downoad/open a report) instead of exporting it through the report viewer & if so can you give me a code example (VB preferably)

Regards
Roger
Top achievements
Rank 1
 answered on 03 Sep 2009
2 answers
149 views
Does anyone know of a way to prevent the opening of a browser window on export? Basically you click on the export link and it opens a new window which in turn opens acrobat. So then you have to close acrobat and then close the blank window opened by the reportviewer control.  This behavior does not seem to exist when adding an export button to the grid.

Current behavior: http://demos.telerik.com/reporting/sales-dashboard/demo.aspx
Desired behavior: http://demos.telerik.com/aspnet-ajax/grid/examples/generalfeatures/pdfexport/defaultcs.aspx
Robert
Top achievements
Rank 1
 answered on 03 Sep 2009
3 answers
1.5K+ views
Hi,
1 Ques. I am trying to create a report filter which should use a parameter value which is a variable along with a wildcard report.
I want to get the result for a SQL query like:
"Select users from Usertable where UserName LIKE %@Name%"

I am trying to get the "@Name" from the Parameter. Have enabled the UI for the parameter.

Here is the filter:

Filter:
("=Fields.[Name]", ((Telerik.Reporting.Data.FilterOperator)(Telerik.Reporting.Data.FilterOperator.Like)), "=Trim(Parameters.Name)")});
If have tried following in the value field :
=%Parameters.Name% : Gives Missing Operand for Mod operator.
=Parameters.Name: This works but does an exact match, I need a wildcard support.


2 Ques. Is there a way to enable filter only when the user selects/inputs any value for the parameters in the UI.
I want to display all the records by default. But when I set filters and get the parameter values from UI the report does not display any values by default.

Thank you for your help.

-Brenda.
Svetoslav
Telerik team
 answered on 03 Sep 2009
Top users last month
Chester
Top achievements
Rank 1
Iron
Simon
Top achievements
Rank 1
Iron
Douglas
Top achievements
Rank 2
Iron
Iron
SUNIL
Top achievements
Rank 3
Iron
Iron
Iron
Marco
Top achievements
Rank 3
Iron
Iron
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?