Telerik Forums
Reporting Forum
1 answer
181 views

Hi

 

I have a crosstab that I want to filter on a couple of values. I've setup the filter as I would expect it to work but it's not working. In the "Value" textbox what do I put to make it filter where the values are "Example1" or "Example2"?

This is what I have so far:

I've tried a few different formats but it's not worked so far.

Dimitar
Telerik team
 answered on 19 May 2021
1 answer
1.4K+ views

Hi All,

Having used Crystal Reports VS for years, we recently decided to move to Telerik Reports, however I can't say I am overly impressed with the performance and memory usage!!

I designed a rather simplistic report in both Crystal and Telerik, pushed the same data through (125000 rows / 10 columns) with no calculated formulas, conditional formatting, or images, and results are as follows:

Crystal to PDF = 70 seconds (400MB ram usage)

Telerik to PDF = 180 seconds (1800MB ram usage) with FontEmbedding set to None. If on SubSet, file size will grow from 5MB to 60MB!!

Telerik to XLSX = 380 seconds!

Is Crystal Reports really that well optimized for exporting to PDF! Or is Telerik Reports really that bad??

Looks like we will have to run two sets of reports now or look at alternatives!

Both reports are using ObjectDataSource with data retrieved from a stored procedure and outputs to a DataTable. Data retrieval on both takes approximately 30 seconds, with the rest on rendering! Telerik report is not opened in a Viewer, but rendered directly to PDF, same with the Crystal Report. 

Any tips or suggestions greatly appreciated, but I don't have much faith that it will improve much :(

Cheers

Joe

Todor
Telerik team
 answered on 18 May 2021
2 answers
125 views
Hi,

Is FULL TRUST still required for Telerik Reporting to work?
Claudio
Top achievements
Rank 1
Iron
 answered on 14 May 2021
1 answer
758 views

When I'm trying to use the kendo panel bar, i'm getting an error:

I have the module loaded, 

TypeError: $root.children(...).kendoPanelBar is not a function

core.js:6210 ERROR Error: Uncaught (in promise): TypeError: $root.children(...).kendoPanelBar is not a function
TypeError: $root.children(...).kendoPanelBar is not a function
    at init (telerikReportViewer.js:6368)
    at new SideMenu (telerikReportViewer.js:6364)
    at HTMLDivElement.<anonymous> (telerikReportViewer.js:6571)
    at Object.each (telerikReportViewer.js:279)
    at jQuery.fn.init.push.9qfu.$.fn.<computed> [as telerik_ReportViewer_SideMenu] (telerikReportViewer.js:6569)
    at HTMLDivElement.<anonymous> (telerikReportViewer.js:6591)
    at Object.each (telerikReportViewer.js:279)
    at Object.bind (telerikReportViewer.js:6588)
    at init (telerikReportViewer.js:8100)
    at start (telerikReportViewer.js:8261)
    at resolvePromise (zone-evergreen.js:798)
    at zone-evergreen.js:864
    at ZoneDelegate.invokeTask (zone-evergreen.js:399)
    at Object.onInvokeTask (core.js:28564)
    at ZoneDelegate.invokeTask (zone-evergreen.js:398)
    at Zone.runTask (zone-evergreen.js:167)
    at drainMicroTaskQueue (zone-evergreen.js:569)
    at ZoneTask.invokeTask [as invoke] (zone-evergreen.js:484)
    at invokeTask (zone-evergreen.js:1621)
    at HTMLLinkElement.globalZoneAwareCallback (zone-evergreen.js:1647)
defaultErrorLogger @ core.js:6210
handleError @ core.js:6258
next @ core.js:29184
__tryOrUnsub @ Subscriber.js:183
next @ Subscriber.js:122
_next @ Subscriber.js:72
next @ Subscriber.js:49
next @ Subject.js:39
emit @ core.js:25926
(anonymous) @ core.js:28603
invoke @ zone-evergreen.js:364
run @ zone-evergreen.js:123
runOutsideAngular @ core.js:28506
onHandleError @ core.js:28603
handleError @ zone-evergreen.js:368
runGuarded @ zone-evergreen.js:136
api.microtaskDrainDone @ zone-evergreen.js:670
drainMicroTaskQueue @ zone-evergreen.js:576
invokeTask @ zone-evergreen.js:484
invokeTask @ zone-evergreen.js:1621
globalZoneAwareCallback @ zone-evergreen.js:1647
load (async)
customScheduleGlobal @ zone-evergreen.js:1773
scheduleTask @ zone-evergreen.js:385
onScheduleTask @ zone-evergreen.js:272
scheduleTask @ zone-evergreen.js:378
scheduleTask @ zone-evergreen.js:210
scheduleEventTask @ zone-evergreen.js:236
(anonymous) @ zone-evergreen.js:1928
add @ jquery.js:5282
(anonymous) @ jquery.js:5182
each @ jquery.js:385
each @ jquery.js:207
on @ jquery.js:5181
on @ jquery.js:5906
(anonymous) @ telerikReportViewer.js:8314
ZoneAwarePromise @ zone-evergreen.js:960
(anonymous) @ telerikReportViewer.js:8312
each @ telerikReportViewer.js:279
loadStyleSheets @ telerikReportViewer.js:8310
(anonymous) @ telerikReportViewer.js:8351
invoke @ zone-evergreen.js:364
onInvoke @ core.js:28577
invoke @ zone-evergreen.js:363
run @ zone-evergreen.js:123
(anonymous) @ zone-evergreen.js:857
invokeTask @ zone-evergreen.js:399
onInvokeTask @ core.js:28564
invokeTask @ zone-evergreen.js:398
runTask @ zone-evergreen.js:167
drainMicroTaskQueue @ zone-evergreen.js:569
invokeTask @ zone-evergreen.js:484
invokeTask @ zone-evergreen.js:1621
globalZoneAwareCallback @ zone-evergreen.js:1658
load (async)
customScheduleGlobal @ zone-evergreen.js:1773
scheduleTask @ zone-evergreen.js:385
onScheduleTask @ zone-evergreen.js:272
scheduleTask @ zone-evergreen.js:378
scheduleTask @ zone-evergreen.js:210
scheduleEventTask @ zone-evergreen.js:236
(anonymous) @ zone-evergreen.js:1928
desc.set @ zone-evergreen.js:1279
send @ jquery-3.4.1.min.js:5082
ajax @ jquery-3.4.1.min.js:4822
(anonymous) @ telerikReportViewer.js:383
ZoneAwarePromise @ zone-evergreen.js:960
$ajax @ telerikReportViewer.js:382
get @ telerikReportViewer.js:2054
load @ telerikReportViewer.js:7691
(anonymous) @ telerikReportViewer.js:8345
invoke @ zone-evergreen.js:364
onInvoke @ core.js:28577
invoke @ zone-evergreen.js:363
run @ zone-evergreen.js:123
(anonymous) @ zone-evergreen.js:857
invokeTask @ zone-evergreen.js:399
onInvokeTask @ core.js:28564
invokeTask @ zone-evergreen.js:398
runTask @ zone-evergreen.js:167
drainMicroTaskQueue @ zone-evergreen.js:569
invokeTask @ zone-evergreen.js:484
invokeTask @ zone-evergreen.js:1621
globalZoneAwareCallback @ zone-evergreen.js:1658
load (async)
customScheduleGlobal @ zone-evergreen.js:1773
scheduleTask @ zone-evergreen.js:385
onScheduleTask @ zone-evergreen.js:272
scheduleTask @ zone-evergreen.js:378
scheduleTask @ zone-evergreen.js:210
scheduleEventTask @ zone-evergreen.js:236
(anonymous) @ zone-evergreen.js:1928
desc.set @ zone-evergreen.js:1279
send @ jquery-3.4.1.min.js:5082
ajax @ jquery-3.4.1.min.js:4822
(anonymous) @ telerikReportViewer.js:383
ZoneAwarePromise @ zone-evergreen.js:960
$ajax @ telerikReportViewer.js:382
(anonymous) @ telerikReportViewer.js:2074
invoke @ zone-evergreen.js:364
onInvoke @ core.js:28577
invoke @ zone-evergreen.js:363
run @ zone-evergreen.js:123
(anonymous) @ zone-evergreen.js:857
invokeTask @ zone-evergreen.js:399
onInvokeTask @ core.js:28564
invokeTask @ zone-evergreen.js:398
runTask @ zone-evergreen.js:167
drainMicroTaskQueue @ zone-evergreen.js:569
invokeTask @ zone-evergreen.js:484
invokeTask @ zone-evergreen.js:1621
globalZoneAwareCallback @ zone-evergreen.js:1658
load (async)
customScheduleGlobal @ zone-evergreen.js:1773
scheduleTask @ zone-evergreen.js:385
onScheduleTask @ zone-evergreen.js:272
scheduleTask @ zone-evergreen.js:378
scheduleTask @ zone-evergreen.js:210
scheduleEventTask @ zone-evergreen.js:236
(anonymous) @ zone-evergreen.js:1928
(anonymous) @ http.js:1805
_trySubscribe @ Observable.js:42
subscribe @ Observable.js:28
innerSubscribe @ innerSubscribe.js:67
_innerSub @ mergeMap.js:57
_tryNext @ mergeMap.js:51
_next @ mergeMap.js:34
next @ Subscriber.js:49
(anonymous) @ subscribeToArray.js:3
_trySubscribe @ Observable.js:42
subscribe @ Observable.js:28
call @ mergeMap.js:19
subscribe @ Observable.js:23
call @ filter.js:13
subscribe @ Observable.js:23
call @ map.js:16
subscribe @ Observable.js:23
call @ map.js:16
subscribe @ Observable.js:23
(anonymous) @ Observable.js:91
ZoneAwarePromise @ zone-evergreen.js:960
toPromise @ Observable.js:89
createPDFViewNew @ tasks-v2.component.ts:1978
TaskListV2Component_div_18_Template_span_click_2_listener @ tasks-v2.component.html:124
executeListenerWithErrorHandling @ core.js:15265
wrapListenerIn_markDirtyAndPreventDefault @ core.js:15303
(anonymous) @ platform-browser.js:582
invokeTask @ zone-evergreen.js:399
onInvokeTask @ core.js:28564
invokeTask @ zone-evergreen.js:398
runTask @ zone-evergreen.js:167
invokeTask @ zone-evergreen.js:480
invokeTask @ zone-evergreen.js:1621
globalZoneAwareCallback @ zone-evergreen.js:1647
Show 64 more frames
Plamen Mitrev
Telerik team
 answered on 14 May 2021
1 answer
235 views
I am trying to add telerik reporting to visual studio 2019, but it gives me an error and the report components and the report viewer are not reflected
Todor
Telerik team
 answered on 14 May 2021
1 answer
1.0K+ views
Much like SSRS is there a way in Telerik Reporting to set a number format that is "Blank when Zero"?
Eric R | Senior Technical Support Engineer
Telerik team
 answered on 13 May 2021
5 answers
2.1K+ views
I would like to remove page header, report header, and both footer while exporting to Excel. Is there a way to do this?
Jose
Top achievements
Rank 1
Iron
 answered on 13 May 2021
1 answer
257 views

Hello!

My report has a simple table. A text field is placed under the table. The table and text field have the Docking property set to Top. 
If the table fits on one page, then exporting to pdf is fine. But if the table is divided into several pages, then the text field has the wrong position.

My Telerik.Reporting version is 15.0.21.326.

Dimitar
Telerik team
 answered on 12 May 2021
1 answer
375 views

I want to this field textbox looks the same in the reporting(Respect the whitespaces) in a HtmlTextBox

And HtmlTextBox only show a single whitespaces

 

Todor
Telerik team
 answered on 12 May 2021
1 answer
389 views

I have a  one page report that has a large image that appears conditionally on a second page.  We want this second page to only be the image and not include the header and footer.  When the header settings are set to PrintOnLastPage = False and PrintOnFirstPage = True, it works as intended where it appears on the first page always (whether the report is 1 page or 2 pages) and never on the second page.  The Footer, on the other hand, with the same settings (PrintOnLastPage = False and PrintOnFirstPage = True) will appear at the bottom of the first page on 2 page reports, but disappears entirely when the report is only 1 page.  

I am trying to figure out why the header and footer seem to act differently even though they have the same Behavior settings. I would like the footer to act just like the header- where it always appears on the first page (for 1 and 2 page reports) and never on the second page, if there is a second page.  I apologize if something like this has been asked before, but I could not find anything.

Todor
Telerik team
 answered on 12 May 2021
Top users last month
Jay
Top achievements
Rank 3
Iron
Iron
Iron
Benjamin
Top achievements
Rank 3
Bronze
Iron
Veteran
Radek
Top achievements
Rank 2
Iron
Iron
Iron
Bohdan
Top achievements
Rank 2
Iron
Iron
Richard
Top achievements
Rank 4
Bronze
Bronze
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?