Hello Guys, 

How I can to make my query to receive a parameter using '%like%'?

I tried this 3 options below but its dont working ( last(5ª) line )

SELECT PSR.NOME, CO.NOME, FU.NOME, CO.ATIVO,CO.ID_PSR
FROM COLABORADOR CO
LEFT OUTER JOIN PSR ON PSR.ID_PSR = CO.ID_PSR
LEFT OUTER JOIN FUNCAO FU ON FU.ID_FUNCAO = CO.ID_FUNCAO
WHERE PSR.NOME LIKE %@Nome_PSR%

SELECT PSR.NOME, CO.NOME, FU.NOME, CO.ATIVO,CO.ID_PSR
FROM COLABORADOR CO
LEFT OUTER JOIN PSR ON PSR.ID_PSR = CO.ID_PSR
LEFT OUTER JOIN FUNCAO FU ON FU.ID_FUNCAO = CO.ID_FUNCAO
WHERE PSR.NOME LIKE '%@Nome_PSR%'

SELECT PSR.NOME, CO.NOME, FU.NOME, CO.ATIVO,CO.ID_PSR
FROM COLABORADOR CO
LEFT OUTER JOIN PSR ON PSR.ID_PSR = CO.ID_PSR
LEFT OUTER JOIN FUNCAO FU ON FU.ID_FUNCAO = CO.ID_FUNCAO
WHERE PSR.NOME LIKE @Nome_PSR


Follow in attachment

Hello, I am creating a report with telerik report Q1 2012 I have this error when running the application:

Message: Unhandled Error in Silverlight 4 Application
Code: 4004    

Category: ManagedRuntimeError       

Message: System.InvalidCastException: Specified cast is not valid.


   at Telerik.ReportViewer.Silverlight.ZoomConverter.Convert(Object value, Type targetType, Object parameter, CultureInfo culture)
   at System.Windows.Data.BindingExpression.ConvertToTarget(Object value)
   at System.Windows.Data.BindingExpression.UpdateTemporaryValue()
   at System.Windows.Data.BindingExpression.GetValue(DependencyObject d, DependencyProperty dp)
   at System.Windows.DependencyObject.EvaluateExpression(DependencyProperty property, EffectiveValueEntry oldEntry, EffectiveValueEntry& newEntry)
   at System.Windows.DependencyObject.EvaluateBaseValue(DependencyProperty property, EffectiveValueEntry oldEntry, EffectiveValueEntry& newEntry, ValueOperation operation)
   at System.Windows.DependencyObject.EvaluateEffectiveValue(DependencyProperty property, EffectiveValueEntry oldEntry, EffectiveValueEntry newEntry, ValueOperation operation)
   at System.Windows.DependencyObject.UpdateEffectiveValue(DependencyProperty property, EffectiveValueEntry oldEntry, EffectiveValueEntry& newEntry, ValueOperation operation)
   at System.Windows.DependencyObject.RefreshExpression(DependencyProperty dp)
   at System.Windows.Data.BindingExpression.SendDataToTarget()
   at System.Windows.Data.BindingExpression.SourceAcquired()
   at System.Windows.Data.BindingExpression.System.Windows.IDataContextChangedListener.OnDataContextChanged(Object sender, DataContextChangedEventArgs e)
   at System.Windows.Data.BindingExpression.DataContextChanged(Object sender, DataContextChangedEventArgs e)
   at System.Windows.DataContextChangedEventHandler.Invoke(Object sender, DataContextChangedEventArgs e)
   at System.Windows.FrameworkElement.OnDataContextChanged(DataContextChangedEventArgs e)
   at System.Windows.FrameworkElement.OnAncestorDataContextChanged(DataContextChangedEventArgs e)
   at System.Windows.FrameworkElement.NotifyDataContextChanged(DataContextChangedEventArgs e)
   at System.Windows.FrameworkElement.OnAncestorDataContextChanged(DataContextChangedEventArgs e)
   at System.Windows.FrameworkElement.NotifyDataContextChanged(DataContextChangedEventArgs e)
   at System.Windows.FrameworkElement.OnAncestorDataContextChanged(DataContextChangedEventArgs e)
   at System.Windows.FrameworkElement.NotifyDataContextChanged(DataContextChangedEventArgs e)
   at System.Windows.FrameworkElement.OnAncestorDataContextChanged(DataContextChangedEventArgs e)
   at System.Windows.FrameworkElement.NotifyDataContextChanged(DataContextChangedEventArgs e)
   at System.Windows.FrameworkElement.OnAncestorDataContextChanged(DataContextChangedEventArgs e)
   at System.Windows.FrameworkElement.NotifyDataContextChanged(DataContextChangedEventArgs e)
   at System.Windows.FrameworkElement.OnAncestorDataContextChanged(DataContextChangedEventArgs e)
   at System.Windows.FrameworkElement.NotifyDataContextChanged(DataContextChangedEventArgs e)
   at System.Windows.FrameworkElement.OnPropertyChanged(DependencyProperty dp)
   at System.Windows.DependencyObject.RaisePropertyChangeNotifications(DependencyProperty dp, Object oldValue, Object newValue)
   at System.Windows.DependencyObject.UpdateEffectiveValue(DependencyProperty property, EffectiveValueEntry oldEntry, EffectiveValueEntry& newEntry, ValueOperation operation)
   at System.Windows.DependencyObject.SetValueInternal(DependencyProperty dp, Object value, Boolean allowReadOnlySet, Boolean isBindingInStyleSetter)
   at Telerik.ReportViewer.Silverlight.ReportViewer.Initialize()
   at Telerik.ReportViewer.Silverlight.ReportViewer.OnApplyTemplate()
   at System.Windows.FrameworkElement.OnApplyTemplate(IntPtr nativeTarget)     

Line: 121
Char: 5
Code: 0
URI: http://localhost:1133/js/utilitarios.js

I hope someone can help me, is my first application using telerik report

Hi,

i'm trying to create a table in telerik reporting.
My problem is that i cannot make manually the same height for every row in the table.
I'm trying to use "make same height" function, but doesn't work (maybe i cannot use it right).
Can u explain me how it works?

Thank u! (sorry for my bad english)

We have been using reportviewer for over a year and just did an update from 2012 Q3 to 2013 Q1 and now under the Export (disk) icon all of the export options no longer display.

How do I get them back?

I added table using table wizard and it gives the following error on the report.

An error has occurred while processing Table 'Table1': Login failed for user

I am using a sql data source.

Hi Team,

I have a requirement where we have several tables defined in the report. And we have to apply different styles to these tables in the code behind based on some data. I referred the following links which gives an idea.

http://www.telerik.com/help/reporting/style-using-styles-to-customize-reports.html

http://www.telerik.com/help/reporting/style-understanding-style-selectors.html

But I am not able to see a property called "Stylesheet" in the properties section of my report. I am not sure if I am missing anything.

I have attached a screen shot of where I am looking for it. Please guide me on how to actually add different stylenames at design time and access them in the code behind.

Thanks,
Nagesh

Hi,

We recently upgraded our app to silverlight 5, and telerik tools and reporting Q3 2012.  We've noticed a change in printing behaviour with the silverlight report viewer running in native printing mode.

Previously you had to select the orientation every time via the print dialog if you wanted to deviate from the printers default orientation, regardless of the setting on the report.  I understand the reasons for that.

Now, if you print a portrait report to a portrait printer, it prints fine.  However, if you print a landscape report to the printer, without changing orientation to landscape on the printer, it prints in landscape but shunts the entire report to the right by about half a centimetre or thereabouts, potentially causing the very right hand side of the report to be lost.  It does the same thing if you print a portrait report to a printer in landscape orientaion (that is to say it prints in portrait but shunts the report to the right).

Is page orientation meant to work in SL5 with telerik reporting and the report viewer?  Is there a setting we've got wrong somewhere?

If this isn't behaviour you've come across I'll need to scan a print to upload as it obviously only happens to an actual printed page.

Hi all,

I am new to Telerik Reporting, and I have to make the chart shown in Picture1. For now, I have achieved the result shown in Picture2.
Ideally, the resulting chart should be exactly identical to Picture1, but for now the main goal is adding  the labels "CEO", "CFO", etc.  above the bars, and  the numbers in the yellow circles.

I have no idea on how to do this; can anyone point me in the right direction?

Thanks in advance,

Gianfranco

Hello,

to get a jump start in reporting.

Is it in any way possible to import Word or Excel reporting documents as a template(utilizing the format), into report designer, and then continue to work with them in Report designer ? (remember Word/Excel may be saved in xlsx, xml or html format).

Any tricks we do not know about ?

SwanB

I have a report that works fine when all report's parameters have values that make the data source get records.