Multiple textBoxes with Navigate to url action in cell

[Ganesh Shivshankar]

Hi,

I have a requirement where in the report I need to dynamically generate textboxes with navigate to url actions based on the data bound to it. I'm connecting to a sqldatasource.

I tried the following. Placed a Panel in the cell. Hooked up to the ItemDataBound event. But I'm not able to reach to that particular field in the DataObject. If I can get to it I can generate TextBoxes on the fly and add to the panel. Is this possible to do?

Cheers,
Ganesh

[Ganesh Shivshankar]

Hi,

Could someone please let me know if this can be done? This is a very critical requirement for us.

Thanks.

[Ganesh Shivshankar]

Hi,

Can this be taken into consideration?? We need an answer to decide whether to go ahead with this tool or not. Please can this be prioritised?

Thanks.

[Chavdar]

Hello Ganesh,

The best approach to implement this functionality is to use a Table/Crosstab/List item in the report definition and bind it to a data source which contains the respective URLs. During the report processing the reporting engine will take care of creating as many items as needed so you do not have to do this programmatically. For the Target Url in the Hyperlink action of the cell item you can use an expression which gets the url from a field in the data source,  for example: =Fields.Url.

Please note, that this is just a general guideline as we are not aware of you actual report layout and data. To help you further we will need more information about your scenario. For example, your specific case may require use of User Functions, Bindings, accessing parent data object, etc. so we will appreciate if you elaborate a bit more on it.
 
Kind regards,
Chavdar
the Telerik team

[Ganesh Shivshankar]

Thanks for the reply.

Here is my scenario. For each row in the dataobject I have the following fields (assume)
- Fields.Name
- Fields.Age
- Fields.Assistants (semi colon separated list of names and ids : name1~1;name2~2)

I want the Fields.Assistants to be converted into a series of hyperlinks. So now in that cell If i place a table how do I set its datasource to be Fields.Assistants? And how do I get it to generate the textboxes in it?

Thanks.

[Ganesh Shivshankar]

Hi,

I have managed to get it working with Table. However the items seems to be generated vertically. Is it possible to generate them horizontally?

Cheers,
Ganesh

[Chavdar]

Hi Ganesh,

For a semi-column separated list of values it might be more convenient to use the HtmlTextBox item and render anchor tags. Consider implementing an user function which will accept as an argument the semi-column separated list and will return an html markup with the corresponding <a> tags. For example:

public static string CreateUrls(string namesList)
{
    const string urlTemplate = "<a href='http://www.{0}.com'>{0}</a>";

    var names = namesList.Split(';');
    var sb = new StringBuilder();
    foreach (var name in names)
    {
        var url = string.Format(urlTemplate, name.Trim());
        if (sb.Length > 0)
        {
            sb.Append(", ");
        }
        sb.Append(url);
    }

    var s = sb.ToString();
    return s;
}

The Value property of the HtmlTextBox item should be then set to "=CreateUrls(Fields.Assistants)".

Greetings,
Chavdar
the Telerik team

[Ganesh Shivshankar]

HI,

I have looked at this solution before. The problem is anchor elements dont work in silverlight (i.e. when report is hosted out of silverlight viewer). I need something that would work here !

Thanks.

[Chavdar]

Hello Ganesh,

Anchor elements in the HtmlTextBox item should be interactive in all report viewers. However, we did a major refactoring of our XAML rendering extension (which Silverlight viewer uses) in order to address a couple of more important issues in Q1 2011 SP1 (see Release Notes) and this might have affected the interactivity. We will investigate the problem and fix it accordingly for the next internal build or service pack release. For the moment you can revert back to the official Q1 2011 release if there are no critical issues for your solution. I am sorry for the inconvenience.

Kind regards,
Chavdar
the Telerik team

[Ganesh Shivshankar]

Thanks Chavdar.

Can you give the link to the version previous to the sp1?

[Chavdar]

Hello Ganesh,

You can download it from your account by selecting the Telerik Reporting download page and then continue to the Go to all product versions page. There you can find a download link to the Q1 2011 version of Telerik Reporting.

Greetings,
Chavdar
the Telerik team

[Ganesh Shivshankar]

I downloaded version 5.0.11.328. Now when I run the report in silverlight I'm getting a whole load of binding errors in silverlight.

System.Windows.Data Error: BindingExpression path error: 'NavigateBackCommand' property not found on 'SilverlightReporting.ViewModel' 'SilverlightReporting.ViewModel' (HashCode=41650091). BindingExpression: Path='NavigateBackCommand' DataItem='SilverlightReporting.ViewModel' (HashCode=41650091); target element is 'Telerik.Windows.Controls.RadButton' (Name=''); target property is 'Command' (type 'System.Windows.Input.ICommand')..

System.Windows.Data Error: BindingExpression path error: 'NavigateForwardCommand' property not found on 'SilverlightReporting.ViewModel' 'SilverlightReporting.ViewModel' (HashCode=41650091). BindingExpression: Path='NavigateForwardCommand' DataItem='SilverlightReporting.ViewModel' (HashCode=41650091); target element is 'Telerik.Windows.Controls.RadButton' (Name=''); target property is 'Command' (type 'System.Windows.Input.ICommand')..

System.Windows.Data Error: BindingExpression path error: 'RefreshReportCommand' property not found on 'SilverlightReporting.ViewModel' 'SilverlightReporting.ViewModel' (HashCode=41650091). BindingExpression: Path='RefreshReportCommand' DataItem='SilverlightReporting.ViewModel' (HashCode=41650091); target element is 'Telerik.Windows.Controls.RadButton' (Name=''); target property is 'Command' (type 'System.Windows.Input.ICommand')..

System.Windows.Data Error: BindingExpression path error: 'MoveToFirstPageCommand' property not found on 'SilverlightReporting.ViewModel' 'SilverlightReporting.ViewModel' (HashCode=41650091). BindingExpression: Path='MoveToFirstPageCommand' DataItem='SilverlightReporting.ViewModel' (HashCode=41650091); target element is 'Telerik.Windows.Controls.RadButton' (Name=''); target property is 'Command' (type 'System.Windows.Input.ICommand')..

System.Windows.Data Error: BindingExpression path error: 'MoveToPreviousPageCommand' property not found on 'SilverlightReporting.ViewModel' 'SilverlightReporting.ViewModel' (HashCode=41650091). BindingExpression: Path='MoveToPreviousPageCommand' DataItem='SilverlightReporting.ViewModel' (HashCode=41650091); target element is 'Telerik.Windows.Controls.RadButton' (Name=''); target property is 'Command' (type 'System.Windows.Input.ICommand')..

System.Windows.Data Error: BindingExpression path error: 'PageNumber' property not found on 'SilverlightReporting.ViewModel' 'SilverlightReporting.ViewModel' (HashCode=41650091). BindingExpression: Path='PageNumber' DataItem='SilverlightReporting.ViewModel' (HashCode=41650091); target element is 'System.Windows.Controls.TextBox' (Name=''); target property is 'Text' (type 'System.String')..

System.Windows.Data Error: BindingExpression path error: 'IsMoveToPageEnabled' property not found on 'SilverlightReporting.ViewModel' 'SilverlightReporting.ViewModel' (HashCode=41650091). BindingExpression: Path='IsMoveToPageEnabled' DataItem='SilverlightReporting.ViewModel' (HashCode=41650091); target element is 'System.Windows.Controls.TextBox' (Name=''); target property is 'IsEnabled' (type 'System.Boolean')..

System.Windows.Data Error: BindingExpression path error: 'PageCount' property not found on 'SilverlightReporting.ViewModel' 'SilverlightReporting.ViewModel' (HashCode=41650091). BindingExpression: Path='PageCount' DataItem='SilverlightReporting.ViewModel' (HashCode=41650091); target element is 'System.Windows.Controls.TextBlock' (Name=''); target property is 'Text' (type 'System.String')..

System.Windows.Data Error: BindingExpression path error: 'MoveToNextPageCommand' property not found on 'SilverlightReporting.ViewModel' 'SilverlightReporting.ViewModel' (HashCode=41650091). BindingExpression: Path='MoveToNextPageCommand' DataItem='SilverlightReporting.ViewModel' (HashCode=41650091); target element is 'Telerik.Windows.Controls.RadButton' (Name=''); target property is 'Command' (type 'System.Windows.Input.ICommand')..

System.Windows.Data Error: BindingExpression path error: 'MoveToLastPageCommand' property not found on 'SilverlightReporting.ViewModel' 'SilverlightReporting.ViewModel' (HashCode=41650091). BindingExpression: Path='MoveToLastPageCommand' DataItem='SilverlightReporting.ViewModel' (HashCode=41650091); target element is 'Telerik.Windows.Controls.RadButton' (Name=''); target property is 'Command' (type 'System.Windows.Input.ICommand')..

System.Windows.Data Error: BindingExpression path error: 'PrintReportCommand' property not found on 'SilverlightReporting.ViewModel' 'SilverlightReporting.ViewModel' (HashCode=41650091). BindingExpression: Path='PrintReportCommand' DataItem='SilverlightReporting.ViewModel' (HashCode=41650091); target element is 'Telerik.Windows.Controls.RadButton' (Name=''); target property is 'Command' (type 'System.Windows.Input.ICommand')..

System.Windows.Data Error: BindingExpression path error: 'IsExportEnabled' property not found on 'SilverlightReporting.ViewModel' 'SilverlightReporting.ViewModel' (HashCode=41650091). BindingExpression: Path='IsExportEnabled' DataItem='SilverlightReporting.ViewModel' (HashCode=41650091); target element is 'Telerik.Windows.Controls.RadComboBox' (Name=''); target property is 'IsEnabled' (type 'System.Boolean')..

System.Windows.Data Error: BindingExpression path error: 'RenderingExtensions' property not found on 'SilverlightReporting.ViewModel' 'SilverlightReporting.ViewModel' (HashCode=41650091). BindingExpression: Path='RenderingExtensions' DataItem='SilverlightReporting.ViewModel' (HashCode=41650091); target element is 'Telerik.Windows.Controls.RadComboBox' (Name=''); target property is 'ItemsSource' (type 'System.Collections.IEnumerable')..

System.Windows.Data Error: BindingExpression path error: 'SelectedRenderingExtension' property not found on 'SilverlightReporting.ViewModel' 'SilverlightReporting.ViewModel' (HashCode=41650091). BindingExpression: Path='SelectedRenderingExtension' DataItem='SilverlightReporting.ViewModel' (HashCode=41650091); target element is 'Telerik.Windows.Controls.RadComboBox' (Name=''); target property is 'SelectedItem' (type 'System.Object')..

System.Windows.Data Error: BindingExpression path error: 'HasDocumentMap' property not found on 'SilverlightReporting.ViewModel' 'SilverlightReporting.ViewModel' (HashCode=41650091). BindingExpression: Path='HasDocumentMap' DataItem='SilverlightReporting.ViewModel' (HashCode=41650091); target element is 'Telerik.Windows.Controls.RadToggleButton' (Name=''); target property is 'Visibility' (type 'System.Windows.Visibility')..

System.Windows.Data Error: BindingExpression path error: 'IsDocumentMapVisible' property not found on 'SilverlightReporting.ViewModel' 'SilverlightReporting.ViewModel' (HashCode=41650091). BindingExpression: Path='IsDocumentMapVisible' DataItem='SilverlightReporting.ViewModel' (HashCode=41650091); target element is 'Telerik.Windows.Controls.RadToggleButton' (Name=''); target property is 'IsChecked' (type 'System.Nullable`1[System.Boolean]')..

System.Windows.Data Error: BindingExpression path error: 'IsToggleDocumentMapEnabled' property not found on 'SilverlightReporting.ViewModel' 'SilverlightReporting.ViewModel' (HashCode=41650091). BindingExpression: Path='IsToggleDocumentMapEnabled' DataItem='SilverlightReporting.ViewModel' (HashCode=41650091); target element is 'Telerik.Windows.Controls.RadToggleButton' (Name=''); target property is 'IsEnabled' (type 'System.Boolean')..

System.Windows.Data Error: BindingExpression path error: 'HasParameters' property not found on 'SilverlightReporting.ViewModel' 'SilverlightReporting.ViewModel' (HashCode=41650091). BindingExpression: Path='HasParameters' DataItem='SilverlightReporting.ViewModel' (HashCode=41650091); target element is 'Telerik.Windows.Controls.RadToggleButton' (Name=''); target property is 'Visibility' (type 'System.Windows.Visibility')..

System.Windows.Data Error: BindingExpression path error: 'IsParametersAreaVisible' property not found on 'SilverlightReporting.ViewModel' 'SilverlightReporting.ViewModel' (HashCode=41650091). BindingExpression: Path='IsParametersAreaVisible' DataItem='SilverlightReporting.ViewModel' (HashCode=41650091); target element is 'Telerik.Windows.Controls.RadToggleButton' (Name=''); target property is 'IsChecked' (type 'System.Nullable`1[System.Boolean]')..

System.Windows.Data Error: BindingExpression path error: 'IsToggleParametersAreaEnabled' property not found on 'SilverlightReporting.ViewModel' 'SilverlightReporting.ViewModel' (HashCode=41650091). BindingExpression: Path='IsToggleParametersAreaEnabled' DataItem='SilverlightReporting.ViewModel' (HashCode=41650091); target element is 'Telerik.Windows.Controls.RadToggleButton' (Name=''); target property is 'IsEnabled' (type 'System.Boolean')..

System.Windows.Data Error: BindingExpression path error: 'IsParametersAreaVisible' property not found on 'SilverlightReporting.ViewModel' 'SilverlightReporting.ViewModel' (HashCode=41650091). BindingExpression: Path='IsParametersAreaVisible' DataItem='SilverlightReporting.ViewModel' (HashCode=41650091); target element is 'System.Windows.Controls.Border' (Name='ParametersAreaPane'); target property is 'Visibility' (type 'System.Windows.Visibility')..

System.Windows.Data Error: BindingExpression path error: 'ParameterModels' property not found on 'SilverlightReporting.ViewModel' 'SilverlightReporting.ViewModel' (HashCode=41650091). BindingExpression: Path='ParameterModels' DataItem='SilverlightReporting.ViewModel' (HashCode=41650091); target element is 'Telerik.ReportViewer.Silverlight.ReportParametersControl' (Name=''); target property is 'ItemsSource' (type 'System.Collections.IEnumerable')..

System.Windows.Data Error: BindingExpression path error: 'ApplyReportParametersCommand' property not found on 'SilverlightReporting.ViewModel' 'SilverlightReporting.ViewModel' (HashCode=41650091). BindingExpression: Path='ApplyReportParametersCommand' DataItem='SilverlightReporting.ViewModel' (HashCode=41650091); target element is 'Telerik.Windows.Controls.RadButton' (Name=''); target property is 'Command' (type 'System.Windows.Input.ICommand')..

System.Windows.Data Error: BindingExpression path error: 'IsPreviewButtonVisible' property not found on 'SilverlightReporting.ViewModel' 'SilverlightReporting.ViewModel' (HashCode=41650091). BindingExpression: Path='IsPreviewButtonVisible' DataItem='SilverlightReporting.ViewModel' (HashCode=41650091); target element is 'Telerik.Windows.Controls.RadButton' (Name=''); target property is 'Visibility' (type 'System.Windows.Visibility')..

System.Windows.Data Error: BindingExpression path error: 'IsDocumentMapVisible' property not found on 'SilverlightReporting.ViewModel' 'SilverlightReporting.ViewModel' (HashCode=41650091). BindingExpression: Path='IsDocumentMapVisible' DataItem='SilverlightReporting.ViewModel' (HashCode=41650091); target element is 'System.Windows.Controls.Border' (Name='DocumentMapPane'); target property is 'Visibility' (type 'System.Windows.Visibility')..

System.Windows.Data Error: BindingExpression path error: 'IsMoveToPageEnabled' property not found on 'SilverlightReporting.ViewModel' 'SilverlightReporting.ViewModel' (HashCode=41650091). BindingExpression: Path='IsMoveToPageEnabled' DataItem='SilverlightReporting.ViewModel' (HashCode=41650091); target element is 'Telerik.Windows.Controls.RadTreeView' (Name='DocumentMapTreeView'); target property is 'IsEnabled' (type 'System.Boolean')..

System.Windows.Data Error: BindingExpression path error: 'SelectedDocumentMapNode' property not found on 'SilverlightReporting.ViewModel' 'SilverlightReporting.ViewModel' (HashCode=41650091). BindingExpression: Path='SelectedDocumentMapNode' DataItem='SilverlightReporting.ViewModel' (HashCode=41650091); target element is 'Telerik.Windows.Controls.RadTreeView' (Name='DocumentMapTreeView'); target property is 'SelectedItem' (type 'System.Object')..

System.Windows.Data Error: BindingExpression path error: 'DocumentMapNodes' property not found on 'SilverlightReporting.ViewModel' 'SilverlightReporting.ViewModel' (HashCode=41650091). BindingExpression: Path='DocumentMapNodes' DataItem='SilverlightReporting.ViewModel' (HashCode=41650091); target element is 'Telerik.Windows.Controls.RadTreeView' (Name='DocumentMapTreeView'); target property is 'ItemsSource' (type 'System.Collections.IEnumerable')..

System.Windows.Data Error: BindingExpression path error: 'Error' property not found on 'SilverlightReporting.ViewModel' 'SilverlightReporting.ViewModel' (HashCode=41650091). BindingExpression: Path='Error' DataItem='SilverlightReporting.ViewModel' (HashCode=41650091); target element is 'System.Windows.Controls.TextBox' (Name='ViewerError'); target property is 'Text' (type 'System.String')..

System.Windows.Data Error: BindingExpression path error: 'Zoom' property not found on 'SilverlightReporting.ViewModel' 'SilverlightReporting.ViewModel' (HashCode=41650091). BindingExpression: Path='Zoom' DataItem='SilverlightReporting.ViewModel' (HashCode=41650091); target element is 'Telerik.Windows.Controls.RadSlider' (Name=''); target property is 'Value' (type 'System.Double')..

System.Windows.Data Error: BindingExpression path error: 'AvailableZoomValues' property not found on 'SilverlightReporting.ViewModel' 'SilverlightReporting.ViewModel' (HashCode=41650091). BindingExpression: Path='AvailableZoomValues' DataItem='SilverlightReporting.ViewModel' (HashCode=41650091); target element is 'Telerik.Windows.Controls.RadComboBox' (Name=''); target property is 'ItemsSource' (type 'System.Collections.IEnumerable')..

System.Windows.Data Error: BindingExpression path error: 'Zoom' property not found on 'SilverlightReporting.ViewModel' 'SilverlightReporting.ViewModel' (HashCode=41650091). BindingExpression: Path='Zoom' DataItem='SilverlightReporting.ViewModel' (HashCode=41650091); target element is 'Telerik.Windows.Controls.RadComboBox' (Name=''); target property is 'Text' (type 'System.String')..

I'm not sure what's going on here.

[Ganesh Shivshankar]

Ok. The problem was I had set a DataContext for my view in which the SilverlightReportViewer was hosted. But it did not give me binding errors when I used the SP1 dll's.

I'm able to preview the report in the report designer, but the report viewer is straight away failing. Not able to check the inner exception as well. Attaching the report viewer error.

[Ganesh Shivshankar]

Sorry ! My bad. Its working now.

Thanks for all the help.

[Ganesh Shivshankar]

Do the textboxes support tooltips?

[Steve]

Hi Ganesh,

As noted in the Known limitations of Telerik Reporting thread, tooltips are not supported.

All the best,
Steve
the Telerik team

[Ganesh Shivshankar]

Thanks Steve.

A quick question though. How does the report handle paging? Say I have a sqldatasource, and a stored proc is bound to my report.

• Now when I page through the report, does it call the stored procedure each time for each page?
• How does it manage the no of records to take and how many to skip? The reason I'm asking is if it is going to call the procedure each time (which does not take paging parameters) on page change then I think it is not that efficient. Either I have to pass the paging parameters to the procedure so that records for only that page are fetched.

Please let me know so that I completely understand this.

Thanks.

[Steve]

Hello Ganesh,

• No. The data from the database server is pulled as per your query once, the whole report is rendered and only its pages are requested upon paging. Also when you print/export, the data has been cached upon the first request and is taken from the cache.
• The number of records is controlled by your database query. Generally speaking you cannot interfere/control the paging process of the report. Probably the only way to influence it is by the number of detail sections that can fit on a single page i.e. if you have 40 records and a page can fit 10 records, then you would have 4 pages. If you decrease the detail so that 20 records fit on a single page, then you would have 2 pages. But of course when you have a complex layout, such "manual" calculations are not appropriate.

Kind regards,
Steve
the Telerik team