We are using the WebForms report viewer and I was wondering if there is a way to get SQL Server Row Level Security to work with Telerik Reports that have a SqlDatasource?

Is there a way to execute SP_SET_SESSION_CONTEXT before the SelectCommand is executed?

Hello ,

is there any possibility to use the report Parameter or the value of a filed as a report name?

the DocumentName is a fixed Name while i want to have something like date or ….

thanks

I have a crosstab table with an unknown number of rows and columns, and my reports are ending up with blank pages because the crosstab table grows off the page to the right.

Is there any way to limit the number of columns per page in a crosstab table?

I have read the article, How to: Create Multi-Column Report - Across the Page and Then Down, but the steps aren't working for my crosstab table. I can make it work for regular tables and list items, but not crosstab tables.

Is there anything I can do to prevent the blank pages from being added to my report?

Thanks!

Ps. I asked a very similar question 18 months ago, and Stef suggested using a custom PageSettings' PaperKind and PaperSize. Unfortunately, I only have access to the standalone Report Designer, and I don't seem to have access to those fields. Maybe there's something I'm missing?

I am not sure how to accomplish this.  We want to create a static method, that would be used by multiple reports (ie converting a binary to an image).  Currently, I am having a hard time trying to figure this out.  I know we can use custom methods in the report layout, but only if they exist as a static method of that report layout.  

Also, we are designing reports that inherit from a base or abstract report layout (might only have a header and/or footer band with common controls).  Is there a way to create these methods at the parent level of the class so that all inherited reports see that method? 

Now, I have been messing around with inheritance on the reports and trying to create a method at the parent level and see if the inherited reports can see the method, but they don't.  I have also tried creating a Static Class in the namespace, creating a static method in that class, yes, the reports, when rendered can't see them either.

Any help for this will be greatly appreciated.

Thanks

Mark

We have a table that has 3 independent keys which point to a single second table; each of these keys is independent and represents a separate relationship. An example might be a single order which can relate to multiple salespeople.

Something like this:

Table 1

• Table 1 PK
• FK1 => Table 2 PK
• FK2 => Table 2 PK
• FK3 => Table 2 PK
• Column A
• Column B

Table 2

• Table 2 PK
• Column C
• Column D

I would expect to be able to connect the two tables, automatically adding multiple duplicate columns from the second table in my result set (perhaps with a prefix or suffix derived from the foreign key). So we might see something like this:

Joined table (expected)

• Table 1 PK
• Column A
• Column B
• FK1 Table 2 PK
• FK1 Table 2 Column C
• FK1 Table 2 Column D
• FK2 Table 2 PK
• FK2 Table 2 Column C
• FK2 Table 2 Column D
• FK3 Table 2 PK
• FK3 Table 2 Column C
• FK3 Table 2 Column D

When I try to include both tables in the query builder, the second table only appears once in the resulting columns. Additionally, no matter how I set up the relationships, the query builder attempts to group all 3 relationships together (join on FK1 = T2 PK AND FK2 = T2 PK AND FK3 = T2 PK). This is not reflective of the data model. We also only see one set of table 2's columns in the result, something like this:

Joined table (actual)

•  Table 1 PK
• Column A
• Column B
• Table 2 PK
• Table 2 Column C
• Table 2 Column D

Is there any way to do what I'm trying to do using the query builder? Or will I need to write manual SQL for this? Thanks!

Hi all,

I have a Telerik report that is working as expected.  The report list items in several pages.

The report consist of several columns displaying items' fields.

Once I add a barcode control to the items' columns, the report begin to produce a blank page after every single page.

I am sure that the barcode is behind this issue as once I remove the barcode control things are back to normal.

Even If I add a textbox instead of barcode the report print as expected.

I have tried all the available features to get rid of the added blank page but could not.

Please advise and many thanks

ps. I am using Telerik Reporting Q1 2016

ReportViewer has property of the type ReportSource, which does not have connectionstring property, but has parameters

How can I set connection string in runtime for the report that ReportViewer shows?

C# sample will be much appreciated.

Thanks!

     Hi

This is unrelated to my other question. I have fiddled a bit with the latest example and incorparated it in my solution. But now the icons do not appear to show completely. And i have an extra panel to the left i do not want.

Any idea how to fix the icons and hide panel?