Telerik Forums
Reporting Forum
3 answers
364 views

Hello,

I have a bar chart in my report and it is getting value from the telerik SQL, so the scenario is :

if i have data from telerik SQL =0.0002356 , then it is shown on bar, but

if i have data from telerik SQL=0.0000000, then it is showing nothing (and it should show 0 on the bar )

 

so, what i want on my report, if i get data less than 1 from my telerik SQL, then it should show 0 for that particular bar in the telerik report run time .(I have implemented this in SQL but there is no use of that in telerik report, because i think the report does not show value 0)

please help.

Katia
Telerik team
 answered on 23 Feb 2017
5 answers
348 views
Initially it worked and then for some unknown reason, the Data Source Type list failed to appear at all.

Would like to know if there's a workaround. Have tried a reinstall of Reporting and that does not change anything.

How can I add a datasource in code that will appear in the designer. Have tried hacking the designer code but that gets overwritten.
An example would be good otherwise it's going to prove difficult to use Reporting at all.

Screen shot attached.

Rute
Top achievements
Rank 1
 answered on 22 Feb 2017
9 answers
354 views
there are few carryover threads in forum nor knowledge base. and I'm really lost.

I need RUNNING page total
----------------------------- page1
1
2
3
page sum:6
----------------------------- page2
carryover:6
1
1
1
page sum:9                        -> sum of all previous pages and this page
-----------------------------page3
2
2
2
page sum:15                        -> sum of all previous pages and this page
grand total: 15                        -> sum of all pages

how can I achieve this ? invoice with multiple pages need previous running totals on top of each page. please, some how it must be done. I use latest telerik reporting version.

my sql is very simple: "select explanation, amount from invoices."

Katia
Telerik team
 answered on 22 Feb 2017
1 answer
79 views

Hello,
i want to print labels in report designer (stand alone).
My fields are all in the detail section. All works fine, but i have one problem.
If the value of one field, for example is three, i need this label three times.
All others just one time.
How can i handel this?
Kindly regards
Ralf

Katia
Telerik team
 answered on 22 Feb 2017
3 answers
345 views
Hello my name is Renè,
I need some help the menu of the HTML5 Reportviewer I need in German.
Have an ASP web application with C # code!
Has anyone a tip how to change the title or texts?
Greetings Renè
Stef
Telerik team
 answered on 22 Feb 2017
1 answer
164 views

Hello.

I have a simple 4 series line graph that is not formatting the lines correctly for 2 of the series.

The UCL and LCL lines are working just fine, but the 'Sum" lines are not.

The markers are correct for the data points though. 

Thanks

Jeff

Katia
Telerik team
 answered on 21 Feb 2017
3 answers
972 views

Do you have an example of how we should be setting our connection string in an asp.net core app. The docs talk about setting an app.config file in the base directory.

Is this supposed to be in the wwwroot folder and if so what format does it need to take?

Normally in these applications we are putting connection strings in an appsettings.json file and the framework has methods to access these.

Is there something that we can override so that the connection string will be read from here?

I have already checked this http://www.telerik.com/support/kb/reporting/details/changing-the-connection-string-dynamically-according-to-runtime-data

but it seems unwieldy because it looks like you have to actually manually update the report source for the report you are rendering...

I would much prefer that I just pull it from my connectionstrings section in appsettings.config like I do in my Startup.cs like so

Configuration.GetConnectionString("DefaultConnection")

and I believe that Configuration can be passed in via DI using IConfigurationRoot?

 

Thanks
AJ

Stef
Telerik team
 answered on 21 Feb 2017
1 answer
161 views

I have a report that is grouped by location, so I have created a 'Locations' group header and footer.  The header contains some titles, and a couple of graphs and the footer contains a row of totals - pretty standard stuff.

The header page containing the graphs have a TextBox with the content =Fields.Location, so for each location, this title represents the location and this works as expected.

The graph on the header page has multiple series (for all locations) and I have applied a filter so the chart data to show only the series for that location: The filter contains the expression: "= Fields.Location = =ReportItem.DataObject.Location". and this works as expected, great.

The problem I have is with the graph title.  I need the chart title to show the name of the location, so in the Graph Title Text I've put "=Fields.Location" - however - this only picks up the first location, and then uses that throughout each location???

How can I get the graph titles to reflect the location properly?

 

Stef
Telerik team
 answered on 21 Feb 2017
3 answers
386 views

Hello,

I have created a report which gets data from SQL Server using SP. in my sp i have created few logical date fields. 

Example:

DATEADD(Day,-6,'2017-02-17') As [Mon Date],

DATEADD(Day,-5,'2017-02-17') As [Tue Date], 
DATEADD(Day,-4,'2017-02-17') As [Wed Date],

DATEADD(Day,-3,'2017-02-17') As [Thu Date],

DATEADD(Day,-2,'2017-02-17') As [Fri Date], 
DATEADD(Day,-1,'2017-02-17') As [Sat Date]

this SP is having few parameters so in report i have created same report parameters to map them with parameters of SP. i executed the SP in SQL Server and it displays all data properly but when i run the report, the logical date fields are showing null value. i don't understand why it is showing null value.

Stef
Telerik team
 answered on 21 Feb 2017
1 answer
255 views

Round (12.500) gives 12. Ideally it should be 13.

Please suggest.

Stef
Telerik team
 answered on 20 Feb 2017
Top users last month
Rob
Top achievements
Rank 3
Bronze
Iron
Iron
Sergii
Top achievements
Rank 1
Iron
Iron
Dedalus
Top achievements
Rank 1
Iron
Iron
Lan
Top achievements
Rank 1
Iron
Doug
Top achievements
Rank 1
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?