Telerik Forums
Reporting Forum
1 answer
651 views

Hello all,

i have a problem which i cannot solve. It´s a mistery to me.

I have a table where i want to sum up the weight if a second field has a special number in it.

The follwing should sum up every field where the category transporcat is 1,2 or 3. The categoryfield is defined as string but in the case here there are only numbers in it. In this case the transportcat 1 exists one time, 2 exists one time, 3 does not exist. The weight vor cat 1 and 2 is identical with 5. So there are no differences between the data exept the transportcat.

= SUM(IIF(Fields.transportcat=3,Fields.weight,'' )) or = SUM(IIF(Fields.transportcat="3",Fields.weight,'' )) -> Result: '' which is correct

= SUM(IIF(Fields.transportcat=2,Fields.weight,'' )) or = SUM(IIF(Fields.transportcat="2",Fields.weight,'' )) -> Error - Should be '5'

Error: the input format has the wrong format?

= SUM(IIF(Fields.transportcat=1,Fields.weight,'' )) or = SUM(IIF(Fields.transportcat="1",Fields.weight,'' )) -> Result: '5' which is correct

The test data for the IIF comparison is identical except that the value of the transportcat field is different. I can also use other (4,5,6) and it is still working. Only when i use the number 2 it doesn´t ?

Regards Alex

Mads
Telerik team
 answered on 09 Mar 2021
3 answers
540 views
I want to apply five filtering drop-downs on the table. But when i am adding 5 filters they are using AND filtering, which allows me to choose every filter in order to generate table. But i want to generate the table on every single filter. Ex - i have 5 filters - username, sports type, pay time , date and centre. If i select a username then the table will display all the users with that name without filtering other drop-downs. Please help me out to solve this problem. 
Neli
Telerik team
 answered on 08 Mar 2021
1 answer
427 views

Hello,

I want to change the dateformat of telerik reporting datepicker, when I pick any date from datepicker, it fills the date in mm/dd/yyyy format but I want to display it in dd/mm/yyyy. Please help me out to solve this.

Neli
Telerik team
 answered on 05 Mar 2021
6 answers
721 views
I have created a user-defined function that I'm trying to use in an expression to pass to a parameter for a sub-report, but no matter what I do, I continue to get the error "The expression contains undefined function call AddDays()."

Here is my function:
    Public Shared Function AddDays(ByVal dateToModify As Date, ByVal days As Double) As DateTime
        Return dateToModify.AddDays(days)
    End Function

The parameter in my subreport is called "FromDate".  In my main report, I'm trying to set the value of the subreport parameter to this:
=(MyClassName).Utils.AddDays(Now(), 1)

This causes the error every time.  If I just set it to Now() it works (but of course I don't want this).  My function shows up in the list of available user functions in the expression editor.  I have other functions that work just fine.  This one doesn't.

Regards,
Scott

BTW, I'm using Reporting Q3 2008
Mike
Top achievements
Rank 1
 answered on 05 Mar 2021
3 answers
372 views

Hello,

there are many problems with the standalone designer:

  1. When you start it, the window is displayed in the background.
  2. The settings such as width of the right palette and position / size of the Styles window are now kept, so we must always resize them.
  3. If you run the designer on a PC without VisualStudio installed and open the dialog for the value of an HTML text box, a message is displayed saying that mshtml is not installed.
  4. The page watermarks are not displayed, neither in the design view nor in the Preview view.
  5. The Label wizard always displays the size of the labels in inches.
  6. The Designer is only available in English and there is no way to change the resources.
Todor
Telerik team
 answered on 02 Mar 2021
3 answers
133 views

Hello,
I would like to create a report where the user has two checkboxes and has the choice to either show or not display a crosstab and/or graph when generating the report.
I am working with Telerik Report Designer with Telerik Reporting REST service and using HTML5 MVC Report Viewer as a report viewer.

the management of this need is done when defining the report or I have to add js events handler in my report viewer ?

Does any one have an example please?

regards,

Mads
Telerik team
 answered on 01 Mar 2021
3 answers
576 views

I am dynamically pulling in html to display an an htmlTextBox. I've modified the style of my <ul>s like so:

<ul style="padding: 0px">
    <li>test item</li>
</ul>

This is to remove the indentation that naturally occurs with unordered lists. Unfortunately, no matter how I manipulate the padding, the htmlTextBox will indent <li>s. 

Is there any way I can display an unordered list in an htmlTextBox without the indentation that usually occurs?

Neli
Telerik team
 answered on 01 Mar 2021
3 answers
770 views

Do we are trying to come up with a solution for being able to print a Telerik report without viewing it in a HTML5 web application.  Our client is HTML5/Javascript and the backend is RESTful web services and implementation of Websockets using Microsoft SignalR.  Each client connects to the SignalR hub and therefore we have the ability to trigger client JavaScript methods from the web services or trigger hub methods from the HTML5/JavaScript clients.

At times we want to be able to print a report by clicking a button on the UI and have this pop up the bowser printer dialog without previewing the report in the HTML5 report viewer.

Looking for ideas from others that have similar functionality in their web applications.  Approaches taken and results.

Thank you,

Steve

Eric R | Senior Technical Support Engineer
Telerik team
 answered on 26 Feb 2021
3 answers
125 views

Good morning. We use your WPF controls at work. I am looking to purchase another copy of these controls and reporting solution for another company and had a few reporting pre-sales questions, if that is alright.

I have looked at every reporting solution out there and there are many of them, but really none of them have the capability to produce published works. Yours seems to be the closest solution I can find. I saw in your demo that your report book supports a TOC for the entire book, and a TOC for one of the reports within the book (thank you for that example). At the company I am looking to purchase your tools for, I have written a reporting tool to generate our published work. Howbeit, it is 15 years old (on old technology) and I would much rather use a reporting tool like yours.

If you are game, a few questions please. In the following questions, I will refer to each section of the work as a report:

- can the TOC for the report book support both Roman and Arabic numbers? (one report prints Roman page numbers, all the other reports print Arabic page numbers)
- can a report within a report book restart page numbering?
- the report book needs its own cover page, as well as most of the reports within the report book. Do you support this?
- when generating page numbers for the report book, may the incrementing of page numbers skip cover pages?
- several of the reports dynamically reference page numbers in other parts of the report book. Does your reporting solution support page number references that are calculated on the fly (the page number reference in text may reference a past page or future page)? Can I reference tags somehow in the text that resolves these page numbers? If not, may I run the report with these tags set to 0; save off the page numbers as the reports are being generated; cancel it; then run the report again with the tags containing the saved page numbers? I trust I am conveying what I'm wanting to do.
- does your report book, or individual reports, support setting a gutter? I use a 0.3" gutter for both left and right pages so that the enture report book may be three-hole punched.
- for each report in the report book, may I start each of them on the right page? If the prior report ended on the right page, that it would automatically add a blank left page?

Thank you for having a sense of humor to answer these questions, I appreciate it.

Michael
Top achievements
Rank 1
 answered on 25 Feb 2021
1 answer
202 views

It is possible to change the default unit displayed and used in standalone designer? like in property panel, when set width/height of the component, or when measure position.

 

(Note: I'm already aware that ruler unit can be set via snapGridSize, but couldn't seem to find option for general default unit, otherwise)

Dimitar
Telerik team
 answered on 25 Feb 2021
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?