Telerik Forums
Reporting Forum
1 answer
225 views

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?

Stef
Telerik team
 answered on 17 Jul 2015
1 answer
56 views

step 2:

Error Message:"
System.Web.Razor.Parser.TokenizerBackedParser~3[TTokenizer,TSymbol,TSymbolType]"上的GenericArgumnets[0]"
System.Web.Razor.Tokenzier.CSharpTokenizer“违反了类型”
TTokenizer“的约束。

 This is a screenshot!

 Have you an Idea to solve this ? Thank you.

 

Stef
Telerik team
 answered on 17 Jul 2015
3 answers
134 views
Hello All,


There are 4 parameters in my report from COO->VP-->region-->district, which designed in a cascading way.
I setup them all as "auto-refresh". In the first time, it works well.

If I choose Coo1, All for VP , all for region and all for district, once you finish choosing, the report is triggered to run. However, if after reports return, u re-choose a specific VP(VP1), the region and the district still stand as "all" and the report does not trigger to run.

Now, I wanna achieve like this, either the 2nd time I change my VP parameter, then reports can refresh or I change VP parameter then the downstream parameters can be back to "select a value" instead of standing as "ALL".

Who has any idea on this?
Thanks in advance. 

Nasko
Telerik team
 answered on 17 Jul 2015
4 answers
81 views

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

Phil
Top achievements
Rank 1
 answered on 16 Jul 2015
1 answer
134 views
I've seen this question posted in years past but wanted to see if there's been any change to Telerik Reporting to facilitate adding a conditional page break based on report group page number to add a blank page for reports with odd page numbers.This is the only thing I've been able to find that is keeping us from converting to Telerik Reporting over Reporting Services. We mail reports out to thousands of people and need to be able to separate the reports for insertion into different envelopes, pretty hard when the first page of one person's report prints on the back of another person's. We do so much volume it just isn't an option to print on single sides. If anyone knows if this is now possible or of a work-around, I'd be interested in hearing it.
Stef
Telerik team
 answered on 16 Jul 2015
1 answer
183 views

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?

 

 
[EnableCors(origins: "*", headers: "*", methods: "*")]
    public class ReportViewerController : ReportsControllerBase 
    {

protected override ICache CreateCache()
        {
            return Telerik.Reporting.Services.Engine.CacheFactory.CreateFileCache("C:\\TempReportCache");
        }

}

 

 

 

Stef
Telerik team
 answered on 16 Jul 2015
5 answers
327 views
I'm looking at possible solutions for printing from a Windows Service (by "service" I mean a continuous UI-less background process, not a web service).

My question is, can I use and print from Telerik Reporting from within a Windows service, and is that a supported/appropriate use of Telerik Reporting?

I'm aware that the System.Drawing.Printing classes are not supported / not available within a Windows service. I want to check whether that's the case for the Telerik DLLs. I've looked through the documentation and the support forum but I can't see any evidence indicating support or lack of it.

Thanks,

Chris N
Stef
Telerik team
 answered on 16 Jul 2015
6 answers
2.1K+ views

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,&#xD;&#xA;@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.

Eric
Top achievements
Rank 1
 answered on 15 Jul 2015
1 answer
287 views

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

Stef
Telerik team
 answered on 15 Jul 2015
1 answer
789 views

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

Stef
Telerik team
 answered on 14 Jul 2015
Top users last month
Will
Top achievements
Rank 2
Iron
Motti
Top achievements
Rank 1
Iron
Hester
Top achievements
Rank 1
Iron
Bob
Top achievements
Rank 3
Iron
Iron
Veteran
Thomas
Top achievements
Rank 2
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?