Questions on Reporting Forum

1 answer

83 views

group pane?

I might be missing something, but how do I get the group pane to show in Visual Studio 2008?
I'm attaching a screen shot of my environment.

thanks.

General Discussions

answered on 14 Dec 2009

5 answers

328 views

Passing a parameter to subreport SQLSelectCommand

I've been trying to design a report with a subreport. I'm stuck on trying to get the subreport to update with a sql select using a parameter to the sqlselectcommand which calls a stored procedure. I've looked at the invoice demo and have tried to understand the process. I'm just not sure how the Report Parameters and the SqlSelectCommand parameters are able to communicate. If I try and code the parameter initialization in the constructor of the subreport the ReportParameter doesn't exist yet at this point and it errors out.

The main report works fine with the above parameter manipulation as shown below:

    
                    public RenewalList(int KeyPK)  
        
                    {  
        
                        /// <summary>  
        
                        /// Required for telerik Reporting designer support  
        
                        /// </summary>  
        
                        InitializeComponent();  
        
                        this.sqlDataAdapter1.SelectCommand.Parameters["@KeyPK"].Value = KeyPK;  
        
                        this.DataSource = this.sqlDataAdapter1;

But inside the subreport you don't have the ability to hardcode the parameter so I'm not sure how to get the value to an identical type SelectCommand in the subreport. I've set a ReportParameter in the subreport called KeyPK, the main report then sets the subreport with KeyPK = =Parameters.[@KeyPK], I've put a break in the subreport after the InitializeComponent and the parameter is not set to the new value.

Hope I've explainded this sufficiently.

Thanks,
-Sid.

General Discussions

answered on 14 Dec 2009

2 answers

334 views

How Do I Pass Parameters to SubReport Sproc

I need to be able to pass parameters to a subreport sproc at run time, I would perfer session variables but I don't really care, just need to pass the variables.

Here is what I’m talking about. I need a report that shows Maintenance, Oil usage and Meter hours against Power Generators located at 15 different sites. The data needs to be filtered for what ever date range the user passes, usually a month . I don’t use a report viewer, just export the report directly to pdf and let the user save the report. They put a begin date and end date into two text boxes, and clicks the report button.

Main Report datasource is SqlDatasource with a Sproc, it returns Site Name and SiteID, No parameters, I want to see all sites data in this particular report.

Subreport 1 - Oil usage for that site. Table has fields SiteID, DateAdded, QuantityAdded

Parameters(@BeginDate, @EndDate)

Subreport 2 - Meter Hours for that site . Table has fields SiteID, ReadingDate, MeterReading

Parameters(@BeginDate, @EndDate)

Subreport 3 Maintenance performed

Parameters(@BeginDate, @EndDate)

How do I make this work with Telerik Reports??????

Right now I have hard coded the stored procedures as this is the first report I have created but next month I need to be able to provide the user with a way of filtering the report. I am in a real jam here. Any help would be greatly appreciated. Thanks

General Discussions

answered on 14 Dec 2009

5 answers

225 views

Lable ( Report Type ) does not work as multiple column

Sir,

        I trying to use Telerik Reporting ( trail version - Q2 2009 SP1 (3.1.9.807) ) , I am satisfied all reports expect LABEL REPORT TYPE , Because multiple column does not work .

My code as like this :
  public Report9()
    {
        /// <summary>
        /// Required for telerik Reporting designer support
        /// </summary>
        InitializeComponent();

        DataSet Ds = new DataSet();

      // Assign data to Dataset ( Ds) from DataBase

        this.detail.ColumnCount = 2;
        this.DataSource = Ds;

    }

Tools Used : VS 2008 sp1 , SQL Server 2005
I am waiting for your kind reply

Regards ,
          Praveen
          MeshiLogic

General Discussions

answered on 12 Dec 2009

1 answer

164 views

How to manually/programmatically break the page of the telerik report

hello,

I am using telerik report for reporting in my web application. Some reports are huge in sense of pages which takes 2-3 pages to display. The problem is when I run those reports, the information starts to be displayed from the second page. I have used Master/Child reports in it. The Label only of the main report is displayed on the first page if the data is huge. Is there anything if we could cop up with this problem or it also would be better if we could break the report page from a specific section of the report. Please answer the both queries

Please refer to the screenshots I sent.

waiting for your reply,

Sunny Dave

General Discussions

answered on 11 Dec 2009

4 answers

114 views

Managing item and data in reports Events - HELP

I'm using Telerik Q2 2009 Reporting
I want to calculate a count(*) via oql.
I want to use detail itemdatabound of a group footer.
I want to put the result in a textbox I've added in the footer.
I tryed everything but always I got an error,

For example:

Telerik.Reporting.Processing.

DetailSection section = sender as Telerik.Reporting.Processing.DetailSection;

Telerik.Reporting.Processing.

ReportItem commessaItem = (Telerik.Reporting.Processing.ReportItem)section.ChildElements.Find("txtIdCommessa", false)[0];

My textbox is called txtIdCommessa, but I try also with:

Telerik.Reporting.

DetailSection section = sender as Telerik.Reporting.DetailSection;

Telerik.Reporting.

TextBox commessaItem = (Telerik.Reporting.TextBox)section.Items.Find("txtIdCommessa", false)[0];

and i've got an error.

Is it possibile to set value in the event of section
also the command:

txtConteggioUtenze.Value =

"Test";

does not print nothing.

Can anyone suggest me the object to use to handle the value of a text box or the event to use ?
do I have to use the item events to manage their values ?

I'm attaching also the report.cs to have support

General Discussions

answered on 11 Dec 2009

1 answer

83 views

Facing following problems in Telerik Reporting web application?

i am facing the following problems in the Telerik Reporting web application

1. how can we set the required number of records per page in Telerik reporting

2. in my previous report i am having the more number of records (ex., in lacks), suppose i replace the previous one with telerik reporting
i am getting the following error "memory out of exception" how can we fix this issue.

3.if i have more number of record shall i go for telerik reporting or not ?

4.performance of Telerik reporting is very slow, how can we increase this

5.in grouping i want to show number of records present in that group in the group footer, i have tried like this in the group footer
[=Count(Fields.ColumnName)] but it does not gave the number of records in that group, instead same thing is coming in the group footer
(i.e., [=Count(Fields.ColumnName)])

6.how can we add the ms-word in export options?

General Discussions

answered on 11 Dec 2009

1 answer

509 views

how can we restrict the number of records per page in telerik reporting?

i am having the following problems

1) how can we restrict the number of records per page in telerik reporting (web application).

2) telerik reporting is giving the memory out of exception if we have more number of records (more than 1000 record, each record is having minimum of 10 columns approximately) is there any restriction on memory size. if we have restriction on memory size how can we fix that issue.

3) i generated the report, i came in good formatting , after i selecting the export option in pdf , in that the report came in different format i.e., all the things in collapsing, what is the solution for this or am i made any mistake .

General Discussions

answered on 11 Dec 2009

2 answers

209 views

Using a ReportViewer for multiple reports

How, in VB.Net, can I assign different reports to a ReportViewer? I can create a viewer for each report, but that seems very inefficient.

Any help is appreciated.

General Discussions

answered on 10 Dec 2009

1 answer

107 views

Loading a report textbox from code

I am using VB.Net. I want to load the value of a textbox from code, such as: Textbox1.value = "Hello"
or: Textbox1.value = strName.

Obviously it's not that simple. Please advise.

General Discussions

answered on 10 Dec 2009