Good Afternoon Telerik,

I run a report for the previous month at the beginning of every month. In example, Today's Month is April- I run the report for the entire Month of March. How can I create a Text field within Telerik that will show the previous month in example March and updates every month so if I run it May 1st it'll show April etc..?

I've tried the following functions but kept getting an error. (see screenshot)

= Today(AddMonths() -1)

So, I have a report that I can't seem to filter. I want to filter the report based on the SalesCode.

I absolutely know that SalesCode "LB040" exists, but my report is blank when I run it. If I delete the filter, the report shows all the SalesCodes.

Am I formatting it wrong? Is it in the wrong group? I've tried filtering the StopGroup, but that didn't help.

Thanks for the help!!!

Hello,

I have one table and I am getting values to display from sql data source.

I am displaying only some of values using filter and grouping of data, but I am getting wrong sum as it is taking from data source.

what should I do to get sum of only displayed values.

Thanks in advance.

I'm trying to make a graph interactive so that the table below shows the values for the column I clicked in the graph.

In my attached example "Graph-Table" I want the following to happen:

1. Click on the bar 3/2019
2. Only the 2019 group shows in the table below. All the rest of the years are hidden
3. Click on the bar 1/2018
4. Only the 2018 group shows in the table below. All the rest of the years are hidden

In the attached report, you see I tried adding some interaction, but I don't know how to get it to toggle/filter the data.

I have 3 report parameters. 

Fields.InvYear,

Fields.InvMonth,

Fields.InvQtr

I have 3 corresponding filters:

= Fields.InvYear = = Parameters.Year.Value

= Fields.InvMonth = = Parameters.Month.Value

= Fields.InvQtr = = Parameters.Quarter.Value

The year parameter is required, however I want the user to be able to pick either Month or Quarter. Even if I allow NULL or blank on the Month or Quarter parameters, Telerik says the parameters are required. The filters are hard coded to be AND, which should not make a difference if one of the parameters is blank. How do I create a "blank" entry?

My SQL fields:

Good Morning,

I am trying to generate a simple report using a CSV data source. The data source contains applicant information including their university, name, state, etc. The CSV also contains information on the stage of the application, whether it was a whitepaper or full proposal etc. When trying to generate a simple bar chart of the count of the different stages, (i.e.,  count of how many whitepapers) the field stage also contains the states on the y axis in the chart. It seems the field stage and state are being intertwined when this is not what I want. Is there any solution to this? These fields are clearly separated in the CSV and the data preview when importing the CSV.

Thanks

I am calling a JSON Webservice that does not return a nested object if the values are null.

I am using the value of the nested object (Fields.Orders.Salesperon.Name) in a detail row of my report.

This results in an error for any rows with no salesperson: "The expression containt object 'Name' that is not defined in the current context".

Here's a sample of what's being returned from the webservice:

{
  "Orders": [
    {
      "OrderNumber": 1,
      "Salesperson: { "Name": "Joe Example" }
    },
    {
      "OrderNumber": 2,
      "Salesperson: {}
    }
}

OrderNumber 1 will print fine. The row for OrderNumber 2 will have an error box.

Screenshot from the actual report:

How can I prevent this? I've tried null checks, value binding, conditional formatting... but it all throws an error because it's trying to access the nonexistent "Name" field on a record.

Hi all,

I am new to Telerik and stuck.  Using Report Designer ver. 15.1.21.616.  Have a basic table which has user names and timestamps for when their accounts were activated.  Need to get a simple count of how many were activated in the last 30, 60 and 90 days. Tried with the main (server side) query such as 

Select name, ActionTimeStamp from UserRequest where ActionTimeStamp > AddMonths(Today(),-1)

or,

Select name, ActionTimeStamp from UserRequest where ActionTimeStamp > DATEADD(day, -30, getdate())

to no avail; getting different kinds of errors. 

Tried downloading the whole table (without a WHERE statement) and use an expression imbedded inside a Text Box to get the count. Just to make sure the function works, tried: 

[= AddMonths(Today(),-1)] 

and it works, it gives me the date 30 days before today. So tried to build on AddMonths(). Tried the following, and any combination that I could think of, and yet cannot get any results!!

[= "Recs last month: " + Count(CDate(Fields.ActionTimeStamp) > CDate(AddMonths(Today(),-1)))]

What am I doing wrong?

Greatly appreciate your help; thank you, guys,

Tony