Telerik Forums
Reporting Forum
1 answer
180 views

I have a multi valued parameter where a user can select multiple users to filter a report.  If I choose user A, B and C, the report will show only items associated with those user A, B and C.

When I try to do this using  [= Join(",",Parameters.Leaders.Label)], I do not get the desired results.  I get the following:

Header: A, B, C

A Details

Header: A, B, C

B Details

Header: A, B, C

C Details

I want to be able to group the report by these users so that each section is unique with the following results:

Header A

A Details

Header B

Details

Header C

C Details

Is this possible?  To split out each value selected in a multi valued parameter and group uniquely be each?  I think the trick is that A, B and C are not fields.  They are parameter values.

 

Thanks,

Phillip

Katia
Telerik team
 answered on 26 Feb 2016
1 answer
154 views

I am trying to see if there is a way to load the bar chart with the data in the format that I currently have.

I am trying to create a chart that would look like the attached bar chart, where the data is supplied in the current format

RowTitle                Mean    Median YourEndFndn YourEndFndnBench
Current Quarter     2.3        2.3        2.9                  4.2
Year To Date        -1.6       -1.9      -1.9                  -.4
1 Year                  -1.6       -1.9       -1.9                  -.4
etc.

Is there a way to create the bar chart with the data in this order or will I have to convert it to another format for the bar chart to be displayed?

 

 

 

 

 

 

 

Stef
Telerik team
 answered on 26 Feb 2016
1 answer
450 views

Hi,

is it possible to use font-awesome and css inside a text expression?

something like

<i class='fa fa-alarm-icon icon-red'></i>

where fa-alarm-icon and icon-red are declared on my style.css

*.icon-red {color: red; font-size: 1.3em;}

.fa-alarm-icon{position:relative;}
.fa-alarm-icon:before {content:"\f12a";}

 

Thank you

Stef
Telerik team
 answered on 25 Feb 2016
2 answers
495 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
916 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
733 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
100 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
193 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
59 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
102 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
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?