Questions on Reporting Forum

1 answer

125 views

Parameter adding and Page Break issue on Reports

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 + "%"" />
</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!

General Discussions

answered on 22 Dec 2014

12 answers

299 views

WPF ReportViewer hangs on second print

I am using the WPF ReportViewer component inside a modal window (Version 7.0.13.228). When the document is sent to the printer the message box "Printing page .. of .." hangs on the second attempt to print. The print queue shows the document but it seems no data is sent (Pages: N/A, Size: empty). The [Cancel] button does not do anything and the only solution is to abort the program from the task manager.

Is there any way to debug this any further? It has been reported to me by one of my customers who is running the program on a terminal server.

General Discussions

answered on 19 Dec 2014

4 answers

71 views

Any recent/updated video tutorial?

I was really hoping to have more explanation with video tutorials, but all the video tutorials that I found for reporting were a year or older. Even Telerik.TV. Seems like there has been lots more new features and methods deprecated since then, unless you guys made absolutely 0 improvements/changes since then... (which I hope and know is not the case!)

I do subscribe to Pluralsight and I was really hoping that there would be courses available there, but that one is also outdated and it does not have HTML5 examples.

Does Telerik have any intentions on releasing new tutorial videos?

Does anyone know of any resource that would do an end-to-end tutorial on how to set up Telerik Reporting with HTML5?
I have gone through the documentations, but it doesn't go into the details enough.

General Discussions

answered on 19 Dec 2014

3 answers

723 views

Could not load file or assembly 'System.Net.Http.Formatting' error

I have all of my reports in a class library. This is the first report I have created using an object data source class to pull data from three different data sources into one report. (Note: This information is all joined into 1 record, not a sub report type data.)

My object data source looks like:

[DataObject]

class DailyInvoicing{

[DataObjectMethod(DataObjectMethodType.Select)]

public IList<DailyInvoice> GetDailyInvoices(DateTime dateEntered)

{

// Build data set here

}

Then built the report. That all seemed to work well. When go to preview the report, I get the following error:

An error has occurred while processing Report 'DailyInvoicingReport': An error occurred while invoking data retrieval method. Try restarting Visual Studio.

------------- InnerException -------------

Exception has been thrown by the target of an invocation.

------------- InnerException -------------

Could not load file or assembly 'System.Net.Http.Formatting, Version=4.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35' or one of its dependencies. The system cannot find the file specified.

I have restarted VS and even tried a second computer. The reference is in the project AND it is in the bin folder after compiling. I am not sure what might be going on. To add to the strangeness, I thought maybe if I ran it through the rest of my project it might work. Instead I was greeted with the following error:

An error has occurred while processing Report 'DailyInvoicingReport': An error occurred while invoking data retrieval method.

------------- InnerException -------------

Exception has been thrown by the target of an invocation.

------------- InnerException -------------

Unable to load the specified metadata resource.

Any ideas on what I might be missing?

General Discussions

answered on 19 Dec 2014

4 answers

260 views

Page Break in Table or TableGroup

From what I've read there is currently no way to do a page break in a table even at the group level. Are there any plans to add this ability in the future? I build reports dynamically in tables via code so it would not really be possible to do something outside of tables.

General Discussions

answered on 18 Dec 2014

4 answers

812 views

Procedure or function 'expects parameter '@ResId', which was not supplied.

I trying show report in asp.net mvc.

Telerik Report v8.0.14.225

Procedur , javascript , report desing screenshot attached

General Discussions

answered on 17 Dec 2014

3 answers

1.5K+ views

Report is throwing jquery error, please advise!

Hi,

With respect to the this link http://www.telerik.com/forums/report-viewer-is-not-working-on-mvc-need-your-advise!

I had gone through again and found that I had given the entry on root web.config instead of Views\Web.config file. Now this issue is resolved, but we have another issue that we are when ever we are trying to run the report, from jquery we are getting error that:

----
TypeError: jQuery(...).telerik_ReportViewer is not a function<script>

                jQuery(function(){


jQuery('#reportViewer1').telerik_ReportViewer({"serviceUrl":"/api/reports/","templateUrl":"/ReportViewer/templates/telerikReportViewerTemplate.html","reportSource":{"report":"~/Views/TransactionSummary/Report1.trdx","parameters":{}},"viewMode":"INTERACTIVE","scaleMode":"SPECIFIC","scale":1,"persistSession":false,"printMode":"AUTO_SELECT","disabledButtonClass":null,"checkedButtonClass":null});
                });
</script>
----

As matter of urgent, can you please give some input's why we are getting this error? Since I was able to fix the problem, I have not raised separate support ticket for this as suggested in above link.

Along with this issue, I have question which I'll add into new thread.

Hope to hear from you soon.

Regards!

General Discussions

answered on 17 Dec 2014

2 answers

243 views

How do I change column group header value based on parameter

I have a report in the designer I have the column name as "COLUMN ABC". When generating the report I am passing an int parameter, if the parameter = 1, I want the column name to be "COLUMN 123". How do I do this? I can set the report title based on the parameter in the code behind but I cannot seem to change the column name. Looks like an easy task but cannot see a way to do it.

P/S: I've tried setting (Telerik.Reporting.TextBox)table1.ColumnGroups[4].ReportItem.Value but that does not change it when the report is generated.

General Discussions

answered on 16 Dec 2014

1 answer

311 views

'Theres a problem with the file format' when exporting report to PDF to attach in Email message

Hello,

I am having difficulty writing a method that will render my report as a PDf so that I can attach it to an e-mail. Here is my code:

[HttpPost]

[Route("api/supportingreports/email/{reportName}")]

public bool SendReportViaEmail(string reportName)

{

// TODO verify user access to report

try

{

var reportProcessor = new ReportProcessor();

var report = new Report {DocumentName = HttpContext.Current.Server.MapPath(string.Format("{0}{1}.trdx", FileUtility.ReportPath, reportName))};

var instanceReportSource = new InstanceReportSource {ReportDocument = report};

instanceReportSource.Parameters.Add(new Parameter("userId", 3));

instanceReportSource.Parameters.Add(new Parameter("eventId", 0));

instanceReportSource.Parameters.Add(new Parameter("exceptionId", 14));

instanceReportSource.Parameters.Add(new Parameter("employeeId", 3860));

var result = reportProcessor.RenderReport("PDF", instanceReportSource, new Hashtable());

var fileName = report.Name + "." + result.Extension;

var path = Path.GetTempPath();

var filePath = Path.Combine(path, fileName);

var mailMessage = new MailMessage {From = new MailAddress(ConfigurationManager.AppSettings["fromAddress"])};

using (var fs = new FileStream(filePath, FileMode.Create))

{

fs.Write(result.DocumentBytes, 0, result.DocumentBytes.Length);

fs.Seek(0, SeekOrigin.Begin);

var a = new Attachment(fs, report.Name + "." + result.Extension);

mailMessage.Attachments.Add(a);

mailMessage.To.Add(new MailAddress("cbohatka@aztekweb.com"));

mailMessage.Subject = "TEST";

var smtpClient = new SmtpClient();

smtpClient.Send(mailMessage);

}

catch (Exception ex)

{

Debug.WriteLine(ex.Message);

throw;

}

return true; // dummy return

}

I am receiving a PDF attached to my e-mail but it is smaller than expected and display an error message.

Thanks in advance!

General Discussions

answered on 16 Dec 2014

3 answers

180 views

Report Viewer is not working on MVC, need your advise!

Hi!

We are using the Telerik reports and Kendo charts as part of our project. Though we have successfully able to use Kendo charts in our project, we have some issues with respect to using Telerik Report Viewer on MVC application.

With respect to the same one of my colleague has created an thread earlier some time back for support. Since he has used his own account to get the suggestions Telerik had requested him to use 'valid support subscription' account.

Here is his link:

http://www.telerik.com/account/support-tickets/view-ticket.aspx?threadid=877256

Due to we're busy with other things we could not reply to you earlier.

As it's mention in that thread, we had followed the same steps to get the Report Viewer to enable on MVC, but we could not. Right now I am trying to attach isolated project files as zip file with 167 kb size file, since only image type files are allowed to attach, I am not able to send the code. May I know any other way to send you the files?

Hope for the positive response from you at the earliest!

Thanks!

General Discussions

answered on 16 Dec 2014