Telerik Forums
Reporting Forum
1 answer
290 views
I have a report that is a multi-page report. By multi page I mean that each page contains different type of content so I am using the trick of using group headers with page break set before/after to simulate a multi page report.

This has worked fine so far except that now I need one of the pages to contain mailing labels. The way I've done mailing labels in the past, and the way the new label wizard does labels, is to set the detail size to the size of the label and then use the number of columns to duplicate the label for the page.

The problem with this approach for a multi page report is that I can't change the detail of just one page (at least I don't think I can). In this case, am I stuck basically having to lay out the labels for the page (I need only exactly one page of labels for this report) with textboxes and just populate each textbox probably with a loop in the report code behind?
Ivan
Telerik team
 answered on 23 Apr 2008
1 answer
124 views
Is it not possible to convert reports created with CR XI release 2? When I select Crystal Report 11, from the list in the report wizard the next button is grayed out I am assuming this is becauase I am CR XI release 2 installed, and not just CR XI.

I am working with Reporting Q1 2008 and VS 2008.
Milen | Product Manager @DX
Telerik team
 answered on 22 Apr 2008
11 answers
374 views
I have one particular report that, when I export to excel generates the following exception:

Attempting to get range {35,33}{1,4},Merged=False,Parent=Sheet1[0], that intersects with an already merged range.

Chavdar
Telerik team
 answered on 21 Apr 2008
2 answers
473 views
Hi,

I am having problem with conditional formatting feature of telerik reporting for windows application.

(.net framework 2.0 language visual basic 8 and operating system windows xp pro)

I am comparing a datafield and a variable date value and based on that it should filter backcolor of particular textbox which is placed dynamically in detail section of the report.

'FormattingRule1.Filters.AddRange(New Telerik.Reporting.Data.Filter() {New Telerik.Reporting.Data.Filter("=CDate(Fields.S001)", CType(Telerik.Reporting.Data.FilterOperator.GreaterThan, Telerik.Reporting.Data.FilterOperator), "=CDate(""00:07:49"")")})

This is hardcodead things which works fine but if i write these code (below), it throws me an error "Object reference not set to an instance of an object."

Here tItem is a dynamic telerik's reporting textbox
dt.Columns(i).ColumnName is a particular ColumnName which has datetime value and datatype is varchar

    Dim FormattingRule1 As Telerik.Reporting.Drawing.FormattingRule = New Telerik.Reporting.Drawing.FormattingRule
               
    FormattingRule1.Filters.AddRange(New Telerik.Reporting.Data.Filter() {New Telerik.Reporting.Data.Filter("=CDate(""" + averageTime + """)", CType(Telerik.Reporting.Data.FilterOperator.GreaterOrEqual, Telerik.Reporting.Data.FilterOperator), "=CDate(Fields." + dt.Columns(i).ColumnName + ")")})
   
    FormattingRule1.Style.BackgroundColor = System.Drawing.Color.Chocolate
   
    tItem.ConditionalFormatting.AddRange(New Telerik.Reporting.Drawing.FormattingRule() {FormattingRule1})

In short if i replace dt.Columns(i).ColumnName with hardcoaded column name like =CDate(Fields.S001) is not throwing me any error.

It should not be like this.

Help me out.

Thanks
Svetoslav
Telerik team
 answered on 21 Apr 2008
1 answer
66 views
I have a report with 2 groups I am using the following to get the data from a stored procedure.

sqlSelectCommand1

.CommandText = "Exec GetStorsPayroll " + _storeid.ToString() + " , '" + strtdte.ToString() + "' , '" + enddte.AddDays(1).ToString() + "'";

sqlSelectCommand1.Connection = sqlConnection1;

sqlDataAdapter1.SelectCommand = sqlSelectCommand1;

this.DataSource = sqlDataAdapter1;

which returns the data in order of last name then first name. But when the report is displayed it is shows the data in order of the empID group. Is there a way to correct this?

Svetoslav
Telerik team
 answered on 21 Apr 2008
1 answer
62 views
Just a quick question.
I ve been working with rad controls prometheus 2007 q3 and recently we purchased a dev lisence before implementation.
I've downloaded from my licences the RadControls_Q3_2007_SP2_dev_hotfix.zip but I can't find in there the telerik.web.ui.dll which I was working with. do I have to install the individual dll's for each control that i am using?

Any ideas?
Thanks in advance,
Dimitris
Paul
Telerik team
 answered on 21 Apr 2008
1 answer
308 views
 
 
I have been trying to create a Teleric Report which references a Stored Procedure via a DataSet.  I have been unable to place a TableAdapter directly on to a telerik report.  Further I have not been able to place TableAdapter into my visual studio 2008 ToolBox while focused on a Telerik Report.  Anyone else encounter this ?

The work around.  Here is how I have accomplished using the stored proc dataset.  I use the report wizard to create a new dataset, which does not prompt for stored procedures.  Once this is complete, a TableAdapter is automatically placed on the report.  At this point I manually modify the Dataset/TableAdapter to reference a Stored Procedure.  This seems to be a very roundabout way of doing things. 

Is there an easier way ?

Kind Regards
Daniel
Svetoslav
Telerik team
 answered on 18 Apr 2008
12 answers
211 views
Hello Telerik,

I'm having difficulties with the reporting designer interface which makes it very time-consuming to use it at the moment.
I'm trying to build a report which is now 2 pages long and the behaviour described occurs when the vertical scrollbar becomes visible.

1. When I'm at the bottom of the report and I select multiple textboxes in the detail section (by drawing a selection-rectangle), the screen 'jumps' to the top of this section. This seems to happen mostly when I first click beside of the report, that is: the yellow-ish area between the vertical scrollbar and the white report area itself. Subsequent clicking on this area and the yellow-ish part causes the report to jump up and down, resulting in a lot of annoying and unnessesarily clicking/dragging to get back to the place where I was.
2. This behaviour happens also when I have selected a number of textboxes and when I unselect them (by clicking on a bit of white space).
3. Deleting an item at the bottom of the detailsection causes the report again to jump to the top of the section.
4. Inserting a databound item near the top of the section, selecting it again and dragging it into another place causes the report to jump to the bottom of the section. I can no longer see the selected control. Selecting it again causes the same behaviour. And then again and again and again.
5. The screen jumping up and down causes unwanted selections of controls and sometime controls being dragged away from its original spot.

I don't know if there are other users who experience this behaviour. I'm going to have to build numerous reports in the weeks to come and with this behaviour I'm already getting a bit of a head-ache.

I hope you can reproduce this behaviour and, more important, have a solution for it.

Thank you, Geert
Steve
Telerik team
 answered on 18 Apr 2008
1 answer
104 views
Is it possible to ship a runtime report designer that the users of my application can use to design their own reports ?
Svetoslav
Telerik team
 answered on 17 Apr 2008
2 answers
82 views
I'd like to give my users the ability to create their own reports on the fly.

Any recommendations to packages available that I could drop ontop of my SQL Server SP's?

Thanks,

Localman.
Svetoslav
Telerik team
 answered on 17 Apr 2008
Top users last month
Will
Top achievements
Rank 2
Iron
Motti
Top achievements
Rank 1
Iron
Hester
Top achievements
Rank 1
Iron
Bob
Top achievements
Rank 3
Iron
Iron
Veteran
Thomas
Top achievements
Rank 2
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?