Questions on Reporting Forum

1 answer

91 views

Hi all. We're developing a WPF project with Telerik Rad Controls for WPF and Telerik Open Access for our ORM. Now, we're moving to the reporting phase, and we want to use Telerik Reporting as well, but there are a couple of questions that I need to ask before we can decide to use it over Reporting Services:

Does your ReportViewer support both local and remote processing modes? We need to be able to handle reports both locally and from a reporting server.
Do you have an auto refresh feature for the report, like th one ein Reporting Services?

Thanks a lot.

General Discussions

answered on 12 Feb 2010

3 answers

101 views

Setting Which Report to Display

We are looking to convert some Crystal Reports to use telerik. We have a subweb that displays all our reports based on report display type and what report is to be displayed.

All report requests are directed to the same page which takes a uniqueidentifier id to determine which report to display. We take our XML report data and convert it to a dataset to be used by the report.datasource. What I can't figure out is how to specify which report to use. A previous post said to use the following instead of instead of the IReportDocument syntax.

Dim report As Telerik.Reporting.Report = New Report()

report.DataSource = myDataSet

ReportViewer1.Report = report

ReportViewer1.DataBind()

So, my question is, how do I specify which report to use? We have hundreds of reports and would like to stick with our convention of having one aspx page that includes the report viewer. The included VB.ReportLibrary would then have the report templates.

Thank You for your help

General Discussions

answered on 11 Feb 2010

1 answer

113 views

Group Footer total

Dear Telerik team,

How do I do it if I want to show a footer group on Textbox2 value that is based on the header group textbox1 value.
eg. I want to include textbox1 value, into textbox2 expression,
say if textbox1 value = "1" then display "a" otherwise blank --this is for the textbox2 expression.

Please help,

Regards

General Discussions

answered on 11 Feb 2010

1 answer

134 views

Repeat background image in serie item

Hi,
Is it possible to repeat the background image in a serie item like it is in plain html?

    
            item.Appearance.FillStyle.FillType = Telerik.Reporting.Charting.Styles.FillType.Image; 
        
            item.Appearance.FillStyle.FillSettings.ImageDrawMode = Telerik.Reporting.Charting.Styles.ImageDrawMode.Align; 
        
            item.Appearance.FillStyle.FillSettings.BackgroundImage = "/Media/status/whiteStrike.gif";

Regards,
Mattias

General Discussions

answered on 11 Feb 2010

1 answer

56 views

page display problem

Telerik team,
I have report page. In the detail section of the page, I programmatically generate some spreadsheets and charts.
The generated page always have 2 pages. the first page only display the header section and the detail section and footer section always go to the second page, No Matter how long the detail and footer section will be.
Pages should not be display in such way.
Do you know what kind of report setting will result in this issue ?
Thanks in advance.
Qixiong

General Discussions

answered on 11 Feb 2010

1 answer

131 views

Reports with business objects

Hello there,

I'm creating reports using business objects, and something odd is happening, let say that I add to the datasource of the report a list of 14 items, the report is designed to render a page per item, and for some reason it start to generate pages until the report viewer throws a message saying "out of memory", that's in the page 32 or so when the report should generate only 14 pages. For reports with 10 items or less the report is generated perfectly fine.

Can you help me with any hint of what is causing this???

Thanks in advance.

General Discussions

answered on 10 Feb 2010

1 answer

134 views

Problem with subreport binding, error due the textbox(design) after the report generated

Hi,

I am working on Telerik Reporting. I am trying to design a report which has a subreport.
I have taken a report item >> assigned a query in the report wizard >> assigned the fields in the detail section of main report. In the properties of the main report i have given a parameter and filter properties. Now i dragged a subreport item into the detail section.
Designed another report (parameter and filter properties were given) in the same above way and assigned this report as a ReportSource to the subreport (in the main report).
Now i am assigning a dataset to the datasource of main report and subreport. Below two lines were written in the NeedDataSource event of Subreport for Conditional basis.

" Dim

item As Processing.ReportItemBase = DirectCast(sender, Processing.ReportItemBase)

Me.SubReport1.Parameters(0).Value = item.DataObject("CF ID") "

When i am trying to generate the report i am facing an error saying that -
" An error has occured while processing textbox 'textbox6'.
The expression contains object CF_Name that is not defined in the current context. "

Here in the design all the fields were assigned through the Query from the wizard.

Can you please explain me what could be the mistake in this process and it would be very helpfull if you can provide a sample application or a doucument (I have done the above process following the guide in telerik site) regarding this "Master - Child report."
This is a very very urgent requirement. Thank you.

Regards,
Prasad.

General Discussions

answered on 10 Feb 2010

1 answer

89 views

Formatting Report Items at ItemDataBining

Hi all,

I'm facing a huge difficulty trying to get a Report formatting certain items at ItemDataBinding.

My idea would be to build a "general purpose" report able to show informations from a DataSource and displaying each item of those datas in tow possible different ways:

As a Label + TextBox
As a Label + CheckBox

My DataSource looks like:

                    Private Sub Report_NeedDataSource(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.NeedDataSource         
                    Dim oRowList As New List(Of MyDataRow)         
                    oRowList.Add(New MyDataRow("Sezione 1", 1, "Nome del candidato", "Mario"))         
                    oRowList.Add(New MyDataRow("Sezione 1", 1, "Cognome del candidato", "Rossi"))         
                    oRowList.Add(New MyDataRow("Sezione 1", 1, "Data di nascita", "20/05/1960"))         
                    oRowList.Add(New MyDataRow("Sezione 2", 1, "Indirizzo", "Via Milano, 18"))         
                    oRowList.Add(New MyDataRow("Sezione 2", 1, "Cap", "20100"))         
                    oRowList.Add(New MyDataRow("Sezione 2", 1, "Città", "Milano"))         
                    oRowList.Add(New MyDataRow("Sezione 2", 1, "Provincia", "MI"))         
                    oRowList.Add(New MyDataRow("Sezione 3", 1, "Animale preferito", ""))         
                    oRowList.Add(New MyDataRow("Sezione 3", 2, "Gatto", "X"))         
                    oRowList.Add(New MyDataRow("Sezione 3", 2, "Cane", ""))         
                    oRowList.Add(New MyDataRow("Sezione 3", 2, "Pappagallo", "X"))         
                     
                     
                    CType(sender, Telerik.Reporting.Processing.Report).DataSource = oRowList         
                     
                End Sub         

...and as you can see I'm binding it to the report at the NeedDataSource Event.

The Class MyDataRow contains:

Group Field
Type field
Label field
Text field

Although this is a static reprsentation of my DataBase it is well functional to my explanation.

My Report Contains a Grouping, based on the "Group" field, and two TextBox bounded to the Label field and to the Text field of my MyDataRow. If I run the Report I can see all my datas correctly bounded.

The problem raises when I try to intervene on formatting of the two TextBox fields at DataBinding. Code follows:

                    Private Sub DetailSection1_ItemDataBinding(ByVal sender As Object, ByVal e As System.EventArgs) Handles DetailSection1.ItemDataBinding         
                    Dim ProcessingDetail As Telerik.Reporting.Processing.DetailSection = CType(sender, Telerik.Reporting.Processing.DetailSection)         
                    Dim oDataRow As MyDataRow = CType(ProcessingDetail.DataObject.RawData, MyDataRow)         
                     
                    If oDataRow.Type = 2 Then         
                     
                        T_Label.Size = New SizeU(New Unit(18, UnitType.Cm), New Unit(0.5, UnitType.Cm))         
                        T_Label.Location = New PointU(New Unit(1, UnitType.Cm), New Unit(0, UnitType.Cm))         
                     
                        T_Text.Style.BorderColor.Default = Color.Black         
                        T_Text.Style.BorderStyle.Default = BorderType.Solid         
                        T_Text.Style.BorderWidth.Default = New Unit(2, UnitType.Point)         
                        T_Text.Size = New SizeU(New Unit(0.5, UnitType.Cm), New Unit(0.5, UnitType.Cm))         
                        T_Text.Location = New PointU(New Unit(0, UnitType.Cm), New Unit(0, UnitType.Cm))         
                        T_Text.Style.TextAlign = HorizontalAlign.Center         
                        T_Text.Style.Font.Bold = True         
                     
                    End If         
                End Sub         

As you ca see, if the Type field of my Datasource is "2" what I do is format my two TextBoxes in such a way that they look like a CheckBox and a label following. HERE RAISES THE PROBLEM !

What comes out of my report is that the formatting gets applied only after the first "Record" of my data source has been parsed. Attached You'll find a screen shot of what happens when I get to bind the part of the data source containing Records of type "2".

I'm relatively new to programming and especially with Telerik components, so I might have posted a "stupid" problem, but I'm going nuts.

Thanks for any help provided.

Lorenzo

General Discussions

answered on 10 Feb 2010

1 answer

175 views

Converting XML to Datasource

One of the requirements for converting our existing reports is that they be backwards compatible. We currently have an assortment of reports that include xsl reports and crystal reports. Both use xml data as their datasource. I have looked at several examples in the forums that convert xml to built in classes for report design and how to convert the xml to a dataset at runtime. None of the examples showed how to do this with multiple level xml shown in the attached example. Can you help me with converting the attached example for use in a report. And, is there a simple way to do this? I have hundreds of reports to convert.

Thank You for your help

Here is the xml example:

<creditreport ReportCategory="2" ReportType="2" ReportTitle="Credit Summary Report" ExposureDate="Most Recent" Associate="All Business Associates" CreditExposureProfile="All Contracts" PhysicalExposure="Length of Contract" FinancialExposure="Length of Contract" Note="Note Field" CreatedDate="12/12/2005 10:23:30 AM">
<associate SellerID="29" AssociateID="EA0452AB-873A-485F-A81A-6174EB65D4E2" AssociateName="Bill's Test" ExposureDate="12/6/2005">
<profile BeginningBalance=".00" BuyerCreditLimit="No Credit" EstimatedValue=".00" AvailableCredit="No Credit" />
</associate>
<associate SellerID="29" AssociateID="F8C42696-9F6C-4876-B7FF-BE673313DE30" AssociateName="BP" ExposureDate="12/6/2005">
<profile BeginningBalance="100000.00" AssociateID="F8C42696-9F6C-4876-B7FF-BE673313DE30" CreditProfileID="52D0EC5D-857B-4560-9A8B-BDF496FABEB1" ProfileName="1,000,000 LC" BuyerCreditLimit="1000000" EstimatedValue="2273096.11" AvailableCredit="-1273096.11" />
<profile BeginningBalance="200000.00" AssociateID="F8C42696-9F6C-4876-B7FF-BE673313DE30" CreditProfileID="CD4612B0-A30D-4D49-A972-CEDD52695318" ProfileName="Default Contracts" BuyerCreditLimit="5000000" EstimatedValue="1174770.40" AvailableCredit="3825229.60" />
</associate>
<associate SellerID="29" AssociateID="2E63F5E4-5DF2-4609-9046-0CC25B33AC49" AssociateName="Duke" ExposureDate="12/6/2005">
<profile BeginningBalance="300000.00" AssociateID="2E63F5E4-5DF2-4609-9046-0CC25B33AC49" CreditProfileID="6DAB56EB-6D39-4F1B-A654-D9E651D536EA" ProfileName="Default" BuyerCreditLimit="500000" EstimatedValue="30307948.20" AvailableCredit="-29807948.20" />
<profile BeginningBalance="400000.00" AssociateID="2E63F5E4-5DF2-4609-9046-0CC25B33AC49" CreditProfileID="9C559583-291F-411A-8E09-C0F7DF1ADFB5" ProfileName="No Credit" BuyerCreditLimit="No Credit" EstimatedValue="-246830681.93" AvailableCredit="No Credit" />
<profile BeginningBalance="500000.00" AssociateID="2E63F5E4-5DF2-4609-9046-0CC25B33AC49" CreditProfileID="BF9A2D43-E227-4488-A016-2787001EFE71" ProfileName="Unlimited" BuyerCreditLimit="Unlimited" EstimatedValue="2640000.00" AvailableCredit="Unlimited" />
</associate>
</creditreport>

General Discussions

answered on 10 Feb 2010

1 answer

144 views

HtmlTextBox + Expression + User Function

When using a HtmlTextBox I am unable to utilize an Expression to call a User Function that returns a string. I get the following error:

Name cannot begin with the '-' character, hexadecimal value 0x2D. Line 1, position 8.

Now if I use a built in function like Trim, which also returns a string, it works fine... if I replace the HtmlTextBox with a regular Textbox it also works fine... so what is it about the HtmlTextBox that I'm missing...

General Discussions

answered on 09 Feb 2010