Telerik Forums
Reporting Forum
5 answers
3.2K+ views

I am trying to build a string of multiple fields with line breaks and a formatted date.  However I cannot get the Format function to work.  Here is what I have

{Fields.title}<br />Since<br />Format('{0:MMM yyyy}', {Fields.StartDate})

Trying to get output like

CEO

Since

March 2010

Silviya
Telerik team
 answered on 19 Feb 2019
6 answers
709 views

Hello! I was wondering if anyone could point me to a resource that goes a little further in-depth with how paths are handled in PictureBox items.

I have a set of pictures that I am attempting to display without embedding them in the report. In the Standalone Report Designer, it works. But in the Report Server, I get the error from the title of my thread, even though I've replicated the filepath for the pictures and populated the directory with them.

 

However, there is another set of pictures in the same report stored in the same file that are displaying. But it's location is being built in a data source and they are displaying as expected.

Logan
Top achievements
Rank 1
 answered on 18 Feb 2019
7 answers
564 views
Excuse me, some users will not be able to open the Excel exported by Telerik, which will prompt the following error. How do we deal with this problem?

Thank you!
XBlue
Top achievements
Rank 1
 answered on 18 Feb 2019
0 answers
251 views

Hello

I just migrated a website that was very old and hosted on a very old server too. We now have a Windows server 2016 where I have added this website and configured it and it worked fine until I checked the page with a Telerik Report viewer on it. That page didnt load and gave me error as attached. The version of Telerik.Reporting is 6.0.12.215.

I tried to google it a lot but couldnt find much all I found was to check if Dlls are added in bin folder and I verified they are. Can someone please help me to fix this. Please note that I havent changed a single line of code in fact I don't have access to source code its just the publish files that I have and they still seems to be working all fine on old server. 

Thanks
Nirav

 


Nirav
Top achievements
Rank 1
 asked on 16 Feb 2019
3 answers
924 views

Hi,

I have created a report based on a CSV data source. This data source has two columns where there is one field called 'Quantity'. In the report, I have a text box item which displays the sum of the quantity where I need to take the sum of the CSV data source 'Quantity' field. I can not configure the data source to send the sum of the quantities beforehand so I need to do this sum in the rendering process of the report. Is there a function where I can achieve this?

Thank you. 

Neli
Telerik team
 answered on 15 Feb 2019
7 answers
785 views
I am experiencing a problem with the WinForm Report Viewer and my reports when the user has customized the DPI settings above 100%.  See attached file Windows10_Settings.png of the settings I am referring to.

 

When this setting is 100% all renders well in the report viewer.  Anything over 100% cause the viewer contents to be displayed smaller.  I am not sure how to fix this.

The attached Viewer.png file shows how the report contents shrink on the page.

Silviya
Telerik team
 answered on 15 Feb 2019
3 answers
223 views
Hi! I would like to know if is it possible in a Telerik report with a Group, filtering in the details of the group, a Cross-Tab by the group field...
Thanks a lot for your help.
Neli
Telerik team
 answered on 15 Feb 2019
1 answer
155 views

Hello there,

I'm new with Telerik Reporting and I have a Problem, where I didn't find a solution in the documentation.

Assume we have the same scenario as in the Quickstart-Example "How To: Use the Report Wizard to create a Band Report". With one difference: My DataSource has a further Field named "RowColor". I want a Report where each Row has the Color specified in this field.

How can I achieve that?

 

Best Regards

                        Frank Kruse

Neli
Telerik team
 answered on 15 Feb 2019
1 answer
283 views
Hello,

I've created a report that displays entries grouped by different time periods (year, month, week, ...) in multiple levels.
As a caption for these layers, I have each created a date field that will be displayed in a matching format.
For example, MM.yyyy (MMM.) For month, will be formatted as follows: 01.2018 (Jan).
I also use the groups in my table of contents.
For this I have created corresponding levels and deposited in the group editor in each case a TocText as an expression.
That works so far everything, but is sometimes very complicated.
If you want to have a formatting as above that is very expensive.
The expression looks like this:

The simple variant
= IIf (Len ("" + Fields.ticket_closed_at.Month) < 2,
    "0" + Fields.ticket_closed_at.Month,
    Fields.ticket_closed_at.Month
    ) + "." + Fields.ticket_closed_at.Year

That's easy.
But if you also want the month in short form, as above, I have the following expression:

= IIf (Len ("" + Fields.ticket_closed_at.Month) < 2,
    "0" + Fields.ticket_closed_at.Month,
    Fields.ticket_closed_at.Month
    ) + "." + Fields.ticket_closed_at.Year
 
    + "(" +
 
    IIf (Fields.ticket_closed_at.Month = 1, "Jan",
        IIf (Fields.ticket_closed_at.Month = 2, "Feb",
            IIf (Fields.ticket_closed_at.Month = 3, "Mar",
                IIf (Fields.ticket_closed_at.Month = 4, "Apr",
                    IIf (Fields.ticket_closed_at.Month = 5, "May",
                        IIf (Fields.ticket_closed_at.Month = 6, "Jun",
                            IIf (Fields.ticket_closed_at.Month = 7, "Jul",
                                IIf (Fields.ticket_closed_at.Month = 8, "Aug",
                                    IIf (Fields.ticket_closed_at.Month = 9, "Sep",
                                        IIf (Fields.ticket_closed_at.Month = 10, "Oct",
                                            IIf (Fields.ticket_closed_at.Month = 11, "Nov", "Dec")
                                        )
                                    )
                                )
                            )
                        )
                    )
                )
            )
        )
    ) + ".)"

That works, but nice is different.
And if you still want to localize it is over.
My question on you is:
Is there a way to apply formatting to TocTexte, such as on a text box?
Or maybe there is another way how to solve something?

Frank
Top achievements
Rank 1
 answered on 14 Feb 2019
9 answers
211 views

Hello,

I'm in charge to evaluate the component Report tool for wpf for an integration in our product.

I'm confident to produce standard reporting elements but in the reports we want to edit, we should be able to reproduce a grid like the ones attached in this post.

Is it easily possible with your component ? I don't want to have to draw a grid line by line as it will be necessary with raw pdf technology.

Regards,

Cédric

 

Cedric
Top achievements
Rank 1
 answered on 13 Feb 2019
Top users last month
Miljana
Top achievements
Rank 2
Iron
Iron
Joel
Top achievements
Rank 3
Bronze
Bronze
Bronze
Cynthia
Top achievements
Rank 1
John
Top achievements
Rank 1
Iron
Mozart
Top achievements
Rank 1
Iron
Veteran
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?