Telerik Forums
Reporting Forum
2 answers
565 views
I am working on converting some Crystal Reports over to use Telerik Reporting, and I am stuck on writing a filter for my data. Basically, I have a parameter FacID that is able to be blank, and I will filter the data differently depending on that value. In addition to that, there is also filtering dependent on the value of another parameter ActiveOnly.

Here is what it looked like in Crystal:

IF {?FacID} = "" THEN (
    IF {?LabelType} = "M" THEN (
        {FacilityCustomFields.CFID} = 14 AND
        ({FacilityCustomFields.CFValue} = "Y" OR
            {FacilityCustomFields.CFValue} = "CYCLE") AND
        {FacilityCustomFields_1.CFID} = 13 AND
        IF {?ActiveOnly} THEN
            {Facilities.FacStatus} = "A"
        ELSE TRUE
    ) ELSE IF {?LabelType} = "X" THEN (
        {FacilityCustomFields.CFID} = 14 AND
        {FacilityCustomFields_1.CFID} = 13 AND
        IF {?ActiveOnly} THEN
            {Facilities.FacStatus} = "A"
        ELSE TRUE
    )
) ELSE
    IF {?LabelType} = "C" AND {?CycleGroup} <> "" THEN (
        {FacilityCustomFields.CFID} = 28 AND
        ({FacilityCustomFields.CFValue}[1] = "Y" OR
            {FacilityCustomFields.CFValue} = "PAPER") AND
        {FacilityCustomFields_1.CFID} = 13 AND
        {FacilityCustomFields_1.CFValue} = {?CycleGroup} AND
        IF {?ActiveOnly} THEN
            {Facilities.FacStatus} = "A"
        ELSE TRUE
    ) ELSE (
        {FacilityCustomFields.FacID} = {?FacID} AND
        {FacilityCustomFields.CFID} = 14 AND
        {FacilityCustomFields_1.CFID} = 13 AND
        IF {?ActiveOnly} THEN
            {Facilities.FacStatus} = "A"
        ELSE TRUE
    )
Stef
Telerik team
 answered on 25 Feb 2016
1 answer
1.0K+ views

Hi

I am tracking a technology roadmap and wondered if anyone could provide the EOL dates for any/all of the recent Reporting versions?

I am looking at 7.1 at the moment as our current version but I believe v10 has just been released - so I need to forecast our upgrade

Thanks in advance

Mark

Stef
Telerik team
 answered on 25 Feb 2016
3 answers
784 views
I have a column with different types of Category A, B and C.
eg. How do I write an expression to count the number of Category A?

I tried [=Count(Fields.Status='A')] and [=Count(Fields.Status) where Fields.Status='A']

Please help.
sumith
Top achievements
Rank 1
 answered on 25 Feb 2016
2 answers
118 views
I've been developing application in Visual Studio 2015 with Telerik Reporting while Viewing the the report I got error which has been attached as Report Error, I've attached the report resource and app config. But don't know connection string error. please help me out. Thanks
Stef
Telerik team
 answered on 24 Feb 2016
1 answer
244 views

HI,

 

I have a double grouped report, which contains

GroupHeaderSection

--> GroupHeaderSection

-->-->DetailSection

-->GroupFooterSection

GroupFooterSection

 

This works fine and binds and displays the data correctly, but the borders for the outer group do not render correctly. I have added a couple of screen shots to illustrate. I've removed the text for confidentiality, but each "Blue" and "Grey" section contain a single line of text, and each white details section contains buttleted text. All text is rendered correctly.

In the sample screenshots, Page1_Bottom  contains an extra border line at the bottom of the page, which I think is the closing border from the outermost Group. Looking at Page2_Top, the outer group Header section has a missing top border and I assume has been incorrectly rendered on the previous page.

Our model is very complex and the reports heavily embedded in out wider application so it is very difficult to provide a sample project exhibiting the problem, so ay assistance you could be provide would be greatly appreciated.

Many thanks,

Mark

 

 

 

 

Nasko
Telerik team
 answered on 24 Feb 2016
1 answer
97 views

Hello

How do I get a Telerik report html-textbox bullitlist to show a hyphen instead of number or dot?

I cant find any way of setting the styling for this.

 

regards

Mark

Nasko
Telerik team
 answered on 24 Feb 2016
3 answers
127 views

Hello

I have a table with grand-parentKey, parentKey and childKey

I want to display data in format

grandParentKey1

                  parentKey1

                              Child1

                  parentKey2

                               Child...

grandParentKey2

                   parentKey3

  etc..

 

How do I declare the ParentDataKeyNames and DataKeyNames for this example?

 

Thank you

Raka

 

Viktor Tachev
Telerik team
 answered on 24 Feb 2016
3 answers
126 views

Hello

I can create this RadTreeList with a parent and child key from a table.

However I have the following structure --

Table 1

-----------

ParentId_1    SomeData

1                       <abc>

2                       <abc>

 

Table 2

-----------------

ParentId_2     ParentId_1       Child_Id

Null                  1                      2147

2147                 1                      2176

2176                  1                     2179

2176                   1                    2180

Null                      2                    5283

5283                     2                    20131 etc.

 

I need a result that looks like --

> 1

         > 2147   

                        > 2176

                                          >2179

                                           >2180

>2

                > 5283

                            >20131

 

What I am getting is this--

> 1
         > 2147   
                        > 2176
                                          >2179
                                           >2180
                > 5283
                            >20131

> 2
         > 2147   
                        > 2176
                                          >2179
                                           >2180
                > 5283
                            >20131

 

Is it possible to get the result that I want with data separated in two tables?

If not, can you suggest an alternative?

 

Thanks
Raka

Viktor Tachev
Telerik team
 answered on 24 Feb 2016
2 answers
71 views

Hi,

 

I would like to localise the standard texts in the Silverlight ReportViewer, but I'm not sure how to go about it. If you have a look at the file attached, the "Generating report..." text is an example for what I would like to localise.

Is this possible? I did the same for the RadRichTextBox by adding the RadRichTextBoxResources.resx and RadRichTextBoxResources.en.resx files, and adding the correct keys to the files, translating it to my native language and English.

 I did this by following the documentation and downloading the original resx file for the RadRichTextBox, so I knew which keys to use. Do you guys have this resx file for the ReportViewer with the correct keys for me? 

Thanks for the help.

Ronald
Top achievements
Rank 1
 answered on 23 Feb 2016
2 answers
417 views

I have a Crystal Report I'm replacing and in Crystal you can create a Group Header section that just contains some text boxes. The result is the detail section is bounded by these boxes. If you look at the attached pic of an example, you will see the columns of the detail section are outlined.

 

When I try to create this in Telerik, I get a box around each line in the detail section. There has to be a way to create the effect in Telerik. I'm just baffled as to how to do it.

Stef
Telerik team
 answered on 23 Feb 2016
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?