Telerik Forums
Reporting Forum
1 answer
918 views
How to use printer fonts of type text,
eg draft for epson lx 300 printer (dot matrix printers)?

There are dot matrix printers in some companies and how they have these models of dot matrix printers, change a super fast printing for printing in graphic mode is really unfeasible.

In Crystal Reports I defined fonts in text mode by default opted Draft, with telerik report can not choose sources of Draft type.

Regards
Rubens
Hinata
Top achievements
Rank 1
 answered on 24 Dec 2014
2 answers
722 views
Hi, I am running into a problem with the latest version of the reporting engine (8.2.14.1204).
I have a HtmlTextBox that contains some html (example below) and I want a currency value to be displayed properly formatted, e.g. $100.00. The problem is that I can't make the expression work no matter how I enter it... Assume that the following fields exist in the sql dataset:

Fields.owing    money not null
Fields.prevbalance    money not null

So this is what I want the text to show when the report is run,
Your current owing amount is $115.24 and the previous balance is $75.22. Please....

this is what I have tried in the Html source...
Your current owing amount is {Format("{0:C2}", Fields.owing)} and the previous balance is {Format("{0:C2}", Fields.prevbalance)}. Please....

This yields a error message when the report is run:
textBox1.Value expression [Your current owing amount is {Format("{0:C2}", Fields.owing)} and the previous balance is {Format("{0:C2}", Fields.prevbalance)}. Please....] is not valid:
Error evaluating embedded expression : Unexpected token inside an expression at index 39

What is the correct way to embed field values in text and properly format them? I cannot really split the text into separate textboxes, there is a lot of text that includes legal verbiage with field data embedded in it...

Thank you
Ali M.
Ali Mohamad
Top achievements
Rank 1
 answered on 23 Dec 2014
3 answers
245 views
I am designing a report that processes a massive amount (>3,000,000) of database rows.

I want to have a drill down report where the master report performs an aggregate query, and the query for the child report only gets run when the user expands on the master report node.

Can this be done with a drill down report? Or will it always populate each sub-report at the beginning, whether it's visible or not?
Stef
Telerik team
 answered on 23 Dec 2014
3 answers
133 views
Hi,

We have a Silverlight application and we recently updated to use the latest Telerik UI and Reporting. However, we encountered some issues when passing parameter to the report. It seems that with the latest update of Telerik Reporting, the report cannot capture the parameters passed from ReportViewer. I was able to reproduce the issue in the Telerik Report Examples by changing the following:

1. In MainPage of CSharp.SilverlightDemo project, I've added the ApplyParameters event:

<telerik:ReportViewer Grid.Row="1" x:Name="ReportViewer1" Width="1000" ReportServiceUri="../ReportService.svc"
Report="Telerik.Reporting.Examples.CSharp.ReportCatalog, CSharp.ReportLibrary"
ApplyParameters="ReportViewer1_OnApplyParameters"/>

private void ReportViewer1_OnApplyParameters(object sender, ApplyParametersEventArgs args)
{
  args.ParameterValues["Test1"] = "Test1";
  args.ParameterValues["Test2"] = "Test2";
}

2. In ReportCatalog.cs of CSharp.ReportLibrary project, I've added the following:

public ReportCatalog()
{
//
// Required for telerik Reporting designer support
//
InitializeComponent();

//
// TODO: Add any constructor code after InitializeComponent call
//
ReportParameters.Add(new ReportParameter { Name = "Test1", Type = ReportParameterType.String });
ReportParameters.Add(new ReportParameter { Name = "Test2", Type = ReportParameterType.String });
ItemDataBinding += ReportCatalog_ItemDataBinding;
}

void ReportCatalog_ItemDataBinding(object sender, System.EventArgs e)
{
var test1 = ReportParameters["Test1"].Value;
var test2 = ReportParameters["Test2"].Value;
textBox4.Value = test1 != null ? test1.ToString() : "Test1 null";
textBox8.Value = test2 != null ? test2.ToString() : "Test2 null";
}

When I run the application, I was not getting the values of Test1 and Test2 parameters. This approach works in the previous version of Telerik Reporting.

Can you take a look why it is not working the latest version anymore and advise if there is another way to accomplish this?

Thanks,
Sherwin

Sherwin
Top achievements
Rank 1
 answered on 23 Dec 2014
1 answer
388 views
I need to the Report Graph object displayed correctly at any data.
If a lot of data that establish the minimum size for each bar or auto change the size of the graph depending how much data. If the text can not fit you crop or change the angle of the text. Now I can not even develop it because classes like a Telerik.Reporting.Processing.Grpah is internal.

In your examples, each graph receives static settings. I attached screenshot and my test code https://dl.dropboxusercontent.com/u/15543358/WindowsFormsApplication1.zip


Help me pls.
Ivan Hristov
Telerik team
 answered on 23 Dec 2014
1 answer
111 views
Hello, I am trying to get an image onto the report. I had a previous version that works great. I have trouble updating to the latest version.

Version 5.1.11.928 (Works great)
string resource = HttpContext.Current.Server.MapPath(@".\Images");
resource is "F:\SolutionName\ProjectName\Images"

Upgrade to Version  8.2.14.1204
var resource = HttpContext.Current.Server.MapPath(@".\Content\images");
resource is "C:\LocalFolder\SolutionName\ProjectName\api\reports\clients\083132-aa72\instances\083132-14d3\Content\images"

However, my resources are located "C:\LocalFolder\SolutionName\ProjectName\Content\images" and it doesn't get found.

Please help!


Stef
Telerik team
 answered on 23 Dec 2014
4 answers
1.5K+ views
Hi!

Whenever we install a new font, which we want to use with Telerik Reporting, we have to restart the machine. It works fine after the restart.
We use Telerik Reporting for rendering (ReportProcessor) PDFs in an ASP.NET Web Website (.Net Framework 4). We also tried to restart IIS, but it didnt help. We use the current version of Telerik Reporting. It's a Windows Server 2008. It also doesn't work on my Windows 7 machine.

We need to install new fonts nearly every week, so it would be handy for us not having to restart the server each time. Is there a way or do we miss something?

Thanks for any suggestions,
Chris
KS
Top achievements
Rank 1
 answered on 22 Dec 2014
1 answer
182 views
Hi

why i am getting below error  once i go to report viewer page any ideas?

Telerik.ReportViewer.axd?instanceID=55d9304b12dc415c915d8a35f5ec62d
1&optype=Report&PageIndex=0&RenderID=o0c59229774746bcbeb523912b680dc4&Render
ingFormat=HTML5Interactive

Message:
Object reference not set to an instance of an object.
Hinata
Top achievements
Rank 1
 answered on 22 Dec 2014
6 answers
3.0K+ views
Hi, I have a simple doubt about Telerik Report, how can I add a subreport, is really necessary a separate file? I've been looking about this question and I saw that to add a datasource on the subreport is necessary to point to another report, this information proceeds?
Nasko
Telerik team
 answered on 22 Dec 2014
1 answer
143 views
Hi,

We are working on the reports are we are facing couple of issues as below:

- Parameter is applying properly

I have created a Report and added a Parameter to the report by going through these links:

http://www.telerik.com/help/reporting/designing-reports-parameters-adding-parameters.html

http://www.telerik.com/help/reporting/designing-reports-parameters-expressions.html

Right now when I view the report in Preview the report displays the Input box to accept the Parameter value as well. But when I enter the value and click on Preview the whole data is listed in one complete page and the filter is not getting applying. But one thing I observed is, when I enter wrong data that time the data is not displayed. So, we are not able to handle the Parameters at the moment.

- Page break is not happening

In the current result from the DB I am getting about 190 records. When I created a table using TableWizard option, it's creating data table by creating 190 pages with whole list of data what I have read from the DB.

As mentioned above in the first point, when I applied the Parameter search, it displayed single page result but it's again displaying whole list of data. Here is the code sample of the report file for both the issues:

--------
<?xml version="1.0" encoding="utf-8"?>
<Report DataSourceName="sqlDataSource1" Width="6.5in" PageNumberingStyle="ResetNumberingAndCount" Name="Report1" xmlns="http://schemas.telerik.com/reporting/2012/3.7">
  <DataSources>
    <SqlDataSource ConnectionString="oracleConnection" SelectCommand="Select * from t_member" Name="sqlDataSource1" />
  </DataSources>
  <Items>
    <PageHeaderSection Height="1in" Name="pageHeaderSection1" />
    <DetailSection PageBreak="None" Height="0.400039354960124in" Name="detailSection1">
      <Items>
        <Table DataSourceName="sqlDataSource1" Width="6.29996109008789in" Height="0.4in" Left="0.00003941853841146in" Top="0in" KeepTogether="True" Name="table1" StyleName="Normal.TableNormal">
          <Body>
            <Cells>
              <TableCell RowIndex="0" ColumnIndex="0" RowSpan="1" ColumnSpan="1">
                <ReportItem>
                  <TextBox Width="1.25999223679293in" Height="0.2in" Left="0in" Top="0in" Value="= Fields.V_MEMBER_CODE" Name="textBox6" StyleName="Normal.TableBody" />
                </ReportItem>
              </TableCell>
              <TableCell RowIndex="0" ColumnIndex="1" RowSpan="1" ColumnSpan="1">
                <ReportItem>
                  <TextBox Width="1.25999223679293in" Height="0.2in" Left="0in" Top="0in" Value="= Fields.V_MEMBER_NAME" Name="textBox7" StyleName="Normal.TableBody" />
                </ReportItem>
              </TableCell>
              <TableCell RowIndex="0" ColumnIndex="2" RowSpan="1" ColumnSpan="1">
                <ReportItem>
                  <TextBox Width="1.25999223679293in" Height="0.2in" Left="0in" Top="0in" Value="= Fields.V_NAB_LENDER" Name="textBox8" StyleName="Normal.TableBody" />
                </ReportItem>
              </TableCell>
              <TableCell RowIndex="0" ColumnIndex="3" RowSpan="1" ColumnSpan="1">
                <ReportItem>
                  <TextBox Width="1.25999223679293in" Height="0.2in" Left="0in" Top="0in" Value="= Fields.V_SHORT_NAME" Name="textBox9" StyleName="Normal.TableBody" />
                </ReportItem>
              </TableCell>
              <TableCell RowIndex="0" ColumnIndex="4" RowSpan="1" ColumnSpan="1">
                <ReportItem>
                  <TextBox Width="1.25999223679293in" Height="0.2in" Left="0in" Top="0in" Value="= Fields.V_STATUS" Name="textBox10" StyleName="Normal.TableBody" />
                </ReportItem>
              </TableCell>
            </Cells>
            <Columns>
              <Column Width="1.25999225556827in" />
              <Column Width="1.25999225556827in" />
              <Column Width="1.25999225556827in" />
              <Column Width="1.25999225556827in" />
              <Column Width="1.25999225556827in" />
            </Columns>
            <Rows>
              <Row Height="0.2in" />
            </Rows>
          </Body>
          <Corner />
          <Style Visible="True" />
          <RowGroups>
            <TableGroup Name="Detail">
              <Groupings>
                <Grouping />
              </Groupings>
            </TableGroup>
          </RowGroups>
          <ColumnGroups>
            <TableGroup>
              <ReportItem>
                <TextBox Width="1.25999223679293in" Height="0.2in" Left="0in" Top="0in" Value="V_MEMBER_CODE" Name="textBox1" StyleName="Normal.TableHeader" />
              </ReportItem>
            </TableGroup>
            <TableGroup>
              <ReportItem>
                <TextBox Width="1.25999223679293in" Height="0.2in" Left="0in" Top="0in" Value="V_MEMBER_NAME" Name="textBox2" StyleName="Normal.TableHeader" />
              </ReportItem>
            </TableGroup>
            <TableGroup>
              <ReportItem>
                <TextBox Width="1.25999223679293in" Height="0.2in" Left="0in" Top="0in" Value="V_NAB_LENDER" Name="textBox3" StyleName="Normal.TableHeader" />
              </ReportItem>
            </TableGroup>
            <TableGroup>
              <ReportItem>
                <TextBox Width="1.25999223679293in" Height="0.2in" Left="0in" Top="0in" Value="V_SHORT_NAME" Name="textBox4" StyleName="Normal.TableHeader" />
              </ReportItem>
            </TableGroup>
            <TableGroup>
              <ReportItem>
                <TextBox Width="1.25999223679293in" Height="0.2in" Left="0in" Top="0in" Value="V_STATUS" Name="textBox5" StyleName="Normal.TableHeader" />
              </ReportItem>
            </TableGroup>
          </ColumnGroups>
        </Table>
      </Items>
    </DetailSection>
    <PageFooterSection Height="1in" Name="pageFooterSection1" />
  </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="Normal.TableNormal" />
      </Selectors>
    </StyleRule>
    <StyleRule>
      <Style 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="Normal.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="Normal.TableBody" />
          </Selectors>
        </DescendantSelector>
      </Selectors>
    </StyleRule>
  </StyleSheet>
  <PageSettings>
    <PageSettings PaperKind="Letter" Landscape="False">
      <Margins>
        <MarginsU Left="1in" Right="1in" Top="1in" Bottom="1in" />
      </Margins>
    </PageSettings>
  </PageSettings>
  <Filters>
    <Filter Expression="= Fields.V_MEMBER_CODE" Operator="Like" Value="=Parameters.MemberCode.Value + &quot;%&quot;" />
  </Filters>
  <ReportParameters>
    <ReportParameter Name="MemberCode" Text="Member Code" Visible="True">
      <Value>
        <String>= Parameters.MemberCode.Value</String>
      </Value>
    </ReportParameter>
  </ReportParameters>
</Report>
----

- Table is repeated on the same page

One more observation on another report design was, the data what we read was about 30 records, which got repeated as new table on same page one below the other. The report generated with 15 pages, with same data.

Since we have reports development at the peek now, can some one please reply to these issues with fix as earliest possible with matter of high importance please?

Regards!
Nasko
Telerik team
 answered on 22 Dec 2014
Top users last month
Marco
Top achievements
Rank 4
Iron
Iron
Iron
Hiba
Top achievements
Rank 1
Iron
Iron
Rob
Top achievements
Rank 3
Bronze
Bronze
Iron
Max
Top achievements
Rank 1
Veteran
Iron
Alina
Top achievements
Rank 1
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?