When running a report I want the start and end date parameters to default to the most recent Monday as the start and the next Sunday as the end date?

This is what I have working for something similar which is the first day of last month and the last day of last month...

First Day of Last Month

= Today().AddDays(CDbl(1 - Today().Day)).AddMonths(-1)

Last Day of Last Month

= Today().AddDays(CDbl(- Today().Day))

And this is how I did the weekly defaults in SSRS, but I cannot figure out if the same is possible with Telerik...

Set First Day of previous week (Monday)

=DateAdd(DateInterval.Day, -6,DateAdd(DateInterval.Day, 1-Weekday(today),Today))

Set Last Day of previous week (Sunday)

=DateAdd(DateInterval.Day, -0,DateAdd(DateInterval.Day, 1-Weekday(today),Today))

Hi - not sure if this is common or not, but I just can't find a way to fix this issue - see attached graph. The "Position" vertical axis line is drawn on the left edge of the graph, but I want it to appear on the right edge of the data plot. The axis's labels and title appear in the correct location, just the axis line itself is in the wrong position and cannot find a property or method to correct it.

This graph can support up to 3 Y axes but only 2 are displayed at a time - one on the left, one on the right, and they are programmatically controlled/positioned.

Very desperate for help on this one. Thanks!

Hi,

I am using telerik report designer. I want to insert in my report a section with text and image that wil be different based on the value of a field. This field is a location and I want the section to show a map (can be picture only) and instructions how to get there.

What would be the best way to do that?

I have tried doing a subreport but I have not managed to make it work yet.

Any tips are welcomed!

I'm creating a report using the standalone report designer where I'm using a crosstab (column group) to aggregate data by date over a certain range of dates which is given as a parameter to the report. I would like to display all the dates in the given range in the crosstab, even if some of those dates have no data. I have been banging my head against a wall trying to achieve this for a while, are you able to suggest a solution? I figured I could manipulate my SQL query to ensure that each date has at least one row by doing an outer join with a calendar table but I was wondering if some more convenient solution existed without me having to modify the query itself.

I have a table report with a percentage in one column. I'd like to add a column with a horizontal bar as a visual indicator of the percent value, something like this:

<progress max="100" value="70"> 70% </progress>

I've tried using HtmlEncode and HtmlDecode but it doesn't display correctly. Is there a way to use formatted raw HTML for the value of a column like this?

"<progress max='100' value='" + Fields.Percent + "'> " + Fields.Percent + " % </progress>"

Thanks

I have a header column in a table that is merged across three columns below. I conditionally hide the middle column and want to shrink the width of the merged column to the size of the remaining two columns. 

I've tried multiple ways to do this and haven't been able to get an answer.

See attached examples. I want to hide the Cost Column on certain conditions, and have the width of "Out" be the size of Quantity + Price.

Hello,

I am using Telerik Report Designer. I have a subreport called SubConfStatementDtls that has its own datasource. My columns are ID, Entry Date, Amount, Tax, and Running Total. For the Running Total column, I am adding the Amount and Tax columns. When I use the RunningValue function in the Running Total column, it does not restart for each grouping. My items are grouped by Fields.TransID. 

The formula I have in the RunningTotal column is:

=Format("{0:C}", RunningValue('SubconfStatementSummary', Sum(Fields.stmtBasicAmt + Fields.TaxAmount)))

SubconfStatementSummary is the Name within the Properties section of this subreport. 

The screenshots below are found in the same report when I run it. I was hoping that when I got to a new Item (in this example, Conference Housekeeping) that the Running Total would not carry over from the item before it (Conference Accommodation). 

What am I missing?

Hi,

I would like to ask how to configure the stacked bar graph scale for date time data. When the data is 30 mins interval, the graph draws every interval with very thin bar.  If I set the base unit property to "Hour" the bar is thicker, but it is not showing for every interval. 

Could you suggest the possible configuration setting to draw every data point with thick bar line.

I have attached the screenshots for the existing bar chart configuration and expected bar.

Thank you in advance.

Hello

I am attempting to run the BlazorGridAndReport example from your github repo. It compiles and runs, but I get the yellow bar of death at the bottom of the app once the page loads.The api portion of the app does seem to work. Dev tools does not show any useful information just "Error: the circuit failed to initailize". I have tried updating all the telerik nuget also and that did not make a difference. Any ideas?

I have inserted a picture below to show if I // the report view and run it, it's working as per the second picture, but if I enable the same two line marked in red, then I get an error in the paging number.

Paging number working no issue if I disable the reportviewer as per the second picture.

If I enable the reportviewer then I get the following error - paging number is not showing.