I am creating a Report in Hebrew, that means it is right to left.
I have now a Table that is in the following form
aa bb abc x
aa bb def x
aa bb ghi x
cc dd jkl y
cc dd mno y
and what I would like to get is:
aa bb abc x
def
ghi
cc dd jkl y
mno
or at least:
aa bb abc x
aa bb def
aa bb ghi
cc dd jkl y
cc dd mno
Is it possible with the standalone Report Designer to achieve something like that, and if yes how? Is there a way to change the groups from being added to the left side of the table, to be added to the right side?
step 2:
Error Message:"
System.Web.Razor.Parser.TokenizerBackedParser~3[TTokenizer,TSymbol,TSymbolType]"上的GenericArgumnets[0]"
System.Web.Razor.Tokenzier.CSharpTokenizer“违反了类型”
TTokenizer“的约束。
Have you an Idea to solve this ? Thank you.
Here is my scenario:
I have a report with multiple parameters, 2 of which are not working properly. One of these parameters is called 'ParentOrg' and will return a list of all organizations. The other is called 'Org' which takes the parameter value from 'ParentOrg' and makes sure that the same value is not included in the drop down list.
ParentOrg = (1,2,3,4,5,6) and Org = (1,2,3,4,5,6)
But, when the report renders and I have chosen ParentOrg = 3, the Org drop down should only show/allow Org = (1,2,4,5,6).
The report will render with default values, but when I try to change the ParentOrg, the report crashes.
Can someone point me in the right direction?
Thanks,
Phillip
Hi Team,
We have two applications one is asp.net mvc web application which will make call to asp.net web api to get telerik report data as rest api call, till now we are using asp.net in memory cache, now i am trying to store the cache in a shared path, below is the line of code that i updated after adding this all my api POST calls to ReportViewer controller are failing, I see there are two calls being made one is options call the other one is post call, options call is getting 200 as reponse but post is failing with status code 400, I can see some files getting created in shared path "C:\\TempReportCache", please see the attched screenshot "ApiCalls Status code to ReportViewer Api controller.jpg" which controls call trace and their response.
please let me know what is the issue and do i need to update anything else in order to store cache in a shared path?
protected override ICache CreateCache()
{
return Telerik.Reporting.Services.Engine.CacheFactory.CreateFileCache("C:\\TempReportCache");
}
}
My table report cuts off the far right portion of the table and puts it on another line. This happens when I export to Pdf or when I view it in print preview. I am using the latest version (2015 Q2) of the HTML 5 report view. I want the report to appear as it appears in the report viewer when I export it to Pdf.
Here is the report definition:
<?xml version="1.0" encoding="utf-8"?>
<Report Width="11.9999605814616in" Name="AttendanceReport" xmlns="http://schemas.telerik.com/reporting/2012/3.8">
<DataSources>
<SqlDataSource ConnectionString="ZENContext" SelectCommand="exec spReporting_AttendanceReport @InterventionId, @ProgramId, @MethodId, @EventId,
@EducatorId, @City, @Location, @StartDate, @EndDate" Name="sqlDataSource1">
<Parameters>
<SqlDataSourceParameter DbType="String" Name="@InterventionId">
<Value>
<String>= Parameters.InterventionId.Value</String>
</Value>
</SqlDataSourceParameter>
<SqlDataSourceParameter DbType="Int32" Name="@ProgramId">
<Value>
<String>= Parameters.ProgramId.Value</String>
</Value>
</SqlDataSourceParameter>
<SqlDataSourceParameter DbType="String" Name="@MethodId">
<Value>
<String>= Parameters.MethodId.Value</String>
</Value>
</SqlDataSourceParameter>
<SqlDataSourceParameter DbType="String" Name="@EventId">
<Value>
<String>= Parameters.EventId.Value</String>
</Value>
</SqlDataSourceParameter>
<SqlDataSourceParameter DbType="String" Name="@EducatorId">
<Value>
<String>= Parameters.EducatorId.Value</String>
</Value>
</SqlDataSourceParameter>
<SqlDataSourceParameter DbType="String" Name="@City">
<Value>
<String>= Parameters.City.Value</String>
</Value>
</SqlDataSourceParameter>
<SqlDataSourceParameter DbType="String" Name="@Location">
<Value>
<String>= Parameters.Location.Value</String>
</Value>
</SqlDataSourceParameter>
<SqlDataSourceParameter DbType="DateTime" Name="@StartDate">
<Value>
<String>= Parameters.StartDate.Value</String>
</Value>
</SqlDataSourceParameter>
<SqlDataSourceParameter DbType="DateTime" Name="@EndDate">
<Value>
<String>= Parameters.EndDate.Value</String>
</Value>
</SqlDataSourceParameter>
</Parameters>
</SqlDataSource>
</DataSources>
<Items>
<PageHeaderSection Height="1in" Name="pageHeaderSection1">
<Style BackgroundColor="255, 255, 255" />
<Items>
<TextBox Width="2.69999980926514in" Height="0.400000015894572in" Left="0.100000381469727in" Top="0.0999999841054281in" Value="Attendance Report" Name="textBox1">
<Style>
<Font Name="Times New Roman" Size="20pt" />
</Style>
</TextBox>
</Items>
</PageHeaderSection>
<DetailSection Height="2in" Name="detailSection1">
<Items>
<Table DataSourceName="sqlDataSource1" Width="9.80000026226044in" Height="0.4in" Left="0.100000381469727in" Top="0.199999968210856in" Name="table1" StyleName="Corporate.TableNormal">
<Body>
<Cells>
<TableCell RowIndex="0" ColumnIndex="0" RowSpan="1" ColumnSpan="1">
<ReportItem>
<TextBox Width="0.999999988018249in" Height="0.2in" Left="0in" Top="0in" Value="= Fields.InterventionName" Name="textBox15" StyleName="Corporate.TableBody" />
</ReportItem>
</TableCell>
<TableCell RowIndex="0" ColumnIndex="1" RowSpan="1" ColumnSpan="1">
<ReportItem>
<TextBox Width="0.8in" Height="0.2in" Left="0in" Top="0in" Value="= Fields.ProgramId" Name="textBox16" StyleName="Corporate.TableBody" />
</ReportItem>
</TableCell>
<TableCell RowIndex="0" ColumnIndex="2" RowSpan="1" ColumnSpan="1">
<ReportItem>
<TextBox Width="0.8in" Height="0.2in" Left="0in" Top="0in" Value="= Fields.ProgramName" Name="textBox17" StyleName="Corporate.TableBody" />
</ReportItem>
</TableCell>
<TableCell RowIndex="0" ColumnIndex="3" RowSpan="1" ColumnSpan="1">
<ReportItem>
<TextBox Width="0.8in" Height="0.2in" Left="0in" Top="0in" Value="= Fields.MethodName" Name="textBox18" StyleName="Corporate.TableBody" />
</ReportItem>
</TableCell>
<TableCell RowIndex="0" ColumnIndex="4" RowSpan="1" ColumnSpan="1">
<ReportItem>
<TextBox Width="0.8in" Height="0.2in" Left="0in" Top="0in" Value="= Fields.EventId" Name="textBox19" StyleName="Corporate.TableBody" />
</ReportItem>
</TableCell>
<TableCell RowIndex="0" ColumnIndex="5" RowSpan="1" ColumnSpan="1">
<ReportItem>
<TextBox Width="0.8in" Height="0.2in" Left="0in" Top="0in" Value="= Fields.EventName" Name="textBox20" StyleName="Corporate.TableBody" />
</ReportItem>
</TableCell>
<TableCell RowIndex="0" ColumnIndex="6" RowSpan="1" ColumnSpan="1">
<ReportItem>
<TextBox Width="0.8in" Height="0.2in" Left="0in" Top="0in" Value="= Fields.Educator" Name="textBox21" StyleName="Corporate.TableBody" />
</ReportItem>
</TableCell>
<TableCell RowIndex="0" ColumnIndex="7" RowSpan="1" ColumnSpan="1">
<ReportItem>
<TextBox Width="0.8in" Height="0.2in" Left="0in" Top="0in" Value="= Fields.Location" Name="textBox22" StyleName="Corporate.TableBody" />
</ReportItem>
</TableCell>
<TableCell RowIndex="0" ColumnIndex="8" RowSpan="1" ColumnSpan="1">
<ReportItem>
<TextBox Width="0.8in" Height="0.2in" Left="0in" Top="0in" Value="= Fields.ParticipationStatus" Name="textBox23" StyleName="Corporate.TableBody" />
</ReportItem>
</TableCell>
<TableCell RowIndex="0" ColumnIndex="9" RowSpan="1" ColumnSpan="1">
<ReportItem>
<TextBox Width="0.8in" Height="0.2in" Left="0in" Top="0in" Value="= Fields.ParticipationStatusCount" Name="textBox24" StyleName="Corporate.TableBody" />
</ReportItem>
</TableCell>
<TableCell RowIndex="0" ColumnIndex="10" RowSpan="1" ColumnSpan="1">
<ReportItem>
<TextBox Width="0.8in" Height="0.2in" Left="0in" Top="0in" Value="= Fields.StartDate" Name="textBox25" StyleName="Corporate.TableBody" />
</ReportItem>
</TableCell>
<TableCell RowIndex="0" ColumnIndex="11" RowSpan="1" ColumnSpan="1">
<ReportItem>
<TextBox Width="0.8in" Height="0.2in" Left="0in" Top="0in" Value="= Fields.EndDate" Name="textBox26" StyleName="Corporate.TableBody" />
</ReportItem>
</TableCell>
</Cells>
<Columns>
<Column Width="1.00000006103394in" />
<Column Width="0.800000078033429in" />
<Column Width="0.800000078033429in" />
<Column Width="0.800000078033429in" />
<Column Width="0.800000078033429in" />
<Column Width="0.800000078033429in" />
<Column Width="0.800000078033429in" />
<Column Width="0.800000078033429in" />
<Column Width="0.800000078033429in" />
<Column Width="0.800000078033429in" />
<Column Width="0.800000078033429in" />
<Column Width="0.800000078033429in" />
</Columns>
<Rows>
<Row Height="0.2in" />
</Rows>
</Body>
<Corner />
<RowGroups>
<TableGroup Name="Detail">
<Groupings>
<Grouping />
</Groupings>
</TableGroup>
</RowGroups>
<ColumnGroups>
<TableGroup>
<ReportItem>
<TextBox Width="0.999999988018249in" Height="0.2in" Left="0in" Top="0in" Value="Intervention" Name="textBox3" StyleName="Corporate.TableHeader" />
</ReportItem>
</TableGroup>
<TableGroup>
<ReportItem>
<TextBox Width="0.8in" Height="0.2in" Left="0in" Top="0in" Value="Program Id" Name="textBox4" StyleName="Corporate.TableHeader" />
</ReportItem>
</TableGroup>
<TableGroup>
<ReportItem>
<TextBox Width="0.8in" Height="0.2in" Left="0in" Top="0in" Value="Program" Name="textBox5" StyleName="Corporate.TableHeader" />
</ReportItem>
</TableGroup>
<TableGroup>
<ReportItem>
<TextBox Width="0.8in" Height="0.2in" Left="0in" Top="0in" Value="Method" Name="textBox6" StyleName="Corporate.TableHeader" />
</ReportItem>
</TableGroup>
<TableGroup>
<ReportItem>
<TextBox Width="0.8in" Height="0.2in" Left="0in" Top="0in" Value="Event Id" Name="textBox7" StyleName="Corporate.TableHeader" />
</ReportItem>
</TableGroup>
<TableGroup>
<ReportItem>
<TextBox Width="0.8in" Height="0.2in" Left="0in" Top="0in" Value="Event" Name="textBox8" StyleName="Corporate.TableHeader" />
</ReportItem>
</TableGroup>
<TableGroup>
<ReportItem>
<TextBox Width="0.8in" Height="0.2in" Left="0in" Top="0in" Value="Educator" Name="textBox9" StyleName="Corporate.TableHeader" />
</ReportItem>
</TableGroup>
<TableGroup>
<ReportItem>
<TextBox Width="0.8in" Height="0.2in" Left="0in" Top="0in" Value="Location" Name="textBox10" StyleName="Corporate.TableHeader" />
</ReportItem>
</TableGroup>
<TableGroup>
<ReportItem>
<TextBox Width="0.8in" Height="0.2in" Left="0in" Top="0in" Value="Status" Name="textBox11" StyleName="Corporate.TableHeader" />
</ReportItem>
</TableGroup>
<TableGroup>
<ReportItem>
<TextBox Width="0.8in" Height="0.2in" Left="0in" Top="0in" Value="Count" Name="textBox12" StyleName="Corporate.TableHeader" />
</ReportItem>
</TableGroup>
<TableGroup>
<ReportItem>
<TextBox Width="0.8in" Height="0.2in" Left="0in" Top="0in" Value="Start Date" Name="textBox13" StyleName="Corporate.TableHeader" />
</ReportItem>
</TableGroup>
<TableGroup>
<ReportItem>
<TextBox Width="0.8in" Height="0.2in" Left="0in" Top="0in" Value="End Date" Name="textBox14" StyleName="Corporate.TableHeader" />
</ReportItem>
</TableGroup>
</ColumnGroups>
</Table>
</Items>
</DetailSection>
<PageFooterSection Height="1in" Name="pageFooterSection1">
<Items>
<TextBox Width="1.99999968210856in" Height="0.2999607026577in" Left="0.00003941853841146in" Top="0.100000143051147in" Value="=Parameters.TimeRan.Value" Name="textBox2" />
</Items>
</PageFooterSection>
</Items>
<StyleSheet>
<StyleRule>
<Style>
<Padding Left="2pt" Right="2pt" />
</Style>
<Selectors>
<TypeSelector Type="TextItemBase" />
<TypeSelector Type="HtmlTextBox" />
</Selectors>
</StyleRule>
<StyleRule>
<Style Color="Black">
<BorderStyle Default="Solid" />
<BorderColor Default="Black" />
<BorderWidth Default="1px" />
<Font Name="Tahoma" Size="9pt" />
</Style>
<Selectors>
<StyleSelector Type="Table" StyleName="Corporate.TableNormal" />
</Selectors>
</StyleRule>
<StyleRule>
<Style BackgroundColor="28, 58, 112" Color="White" VerticalAlign="Middle">
<BorderStyle Default="Solid" />
<BorderColor Default="Black" />
<BorderWidth Default="1px" />
<Font Name="Tahoma" Size="10pt" />
</Style>
<Selectors>
<DescendantSelector>
<Selectors>
<TypeSelector Type="Table" />
<StyleSelector Type="ReportItem" StyleName="Corporate.TableHeader" />
</Selectors>
</DescendantSelector>
</Selectors>
</StyleRule>
<StyleRule>
<Style>
<BorderStyle Default="Solid" />
<BorderColor Default="Black" />
<BorderWidth Default="1px" />
<Font Name="Tahoma" Size="9pt" />
</Style>
<Selectors>
<DescendantSelector>
<Selectors>
<TypeSelector Type="Table" />
<StyleSelector Type="ReportItem" StyleName="Corporate.TableBody" />
</Selectors>
</DescendantSelector>
</Selectors>
</StyleRule>
</StyleSheet>
<PageSettings>
<PageSettings PaperKind="Letter" Landscape="False" ColumnCount="1" ColumnSpacing="0in">
<Margins>
<MarginsU Left="1in" Right="1in" Top="1in" Bottom="1in" />
</Margins>
</PageSettings>
</PageSettings>
<ReportParameters>
<ReportParameter Name="InterventionId" Type="Integer" AllowNull="True">
<Value>
<String></String>
</Value>
</ReportParameter>
<ReportParameter Name="ProgramId" Type="Integer" AllowNull="True">
<Value>
<String></String>
</Value>
</ReportParameter>
<ReportParameter Name="MethodId" Type="Integer" AllowNull="True" />
<ReportParameter Name="EventId" Type="Integer" AllowNull="True" />
<ReportParameter Name="EducatorId" Text="EducatorId" AllowNull="True" />
<ReportParameter Name="City" AllowNull="True" />
<ReportParameter Name="Location" AllowNull="True" />
<ReportParameter Name="StartDate" Type="DateTime" AllowNull="True" />
<ReportParameter Name="EndDate" Type="DateTime" AllowNull="True" />
<ReportParameter Name="TimeRan" Type="DateTime" AllowNull="True">
<Value>
<String></String>
</Value>
</ReportParameter>
</ReportParameters>
</Report>
Thanks in advance.
Hello people,
I have created "search kind of " functionality by using Report parameter and Filters. It works fine, but now I need to change button text from preview to something else? Whole report is in Finnish and that one button is in English and text is not very descriptive for functionality.
Thanks in advance.
Mikko
I have multiple textboxes in the detail section. If I set visibility of one textbox to false with conditional formatting empty space is visible.
Also I put
textBox3.Height =
new
Telerik.Reporting.Drawing.Unit(0);
in the constructor.
How can I remove that empty space and move below textboxes on top? You can see my report from report designer and report viewer in the attached images.
Thanks