Telerik Forums
Reporting Forum
1 answer
169 views
Hi,

I have a chart that looks like this (see attached image).

How can I hide the "0" labels ?

I checked this: http://www.telerik.com/community/forums/reporting/telerik-reporting/how-do-you-hide-stacked-bar-items-which-are-zero-or-null.aspx

isn't any other way ? Like just iterate though the items that are databound and set Visible = false for labels ?

Many thanks,

Alex


 
Stef
Telerik team
 answered on 16 May 2013
1 answer
120 views
I have a report with a report footer and a page footer
when I add a subreport to the report footer the report adds blank pages with only the page footer, in spite of the fact that the subreport only appears once, at the very end
 - the sub report only has detail, the report header and footer having been set to zero height

this only appears in the page preview / printed page

what is going on here - and more importantly, how can I fix it?
Elliott
Top achievements
Rank 2
 answered on 15 May 2013
0 answers
38 views
So with html/razor code in the View like so:

            <tr id="trBeginDate">
                <td>
                </td>
                <td>
                    @Html.LabelFor(m => m.BeginDate)
                </td>
                <td style="padding-right: 20px;">
                    @Html.TextBoxFor(m => m.BeginDate, new { alt = "date-us", style = "width: 164px;" })
                </td>
                <td>
                    @Html.LabelFor(m => m.BeginTime)
                </td>
                <td style="padding-right: 20px;">
                    @Html.TextBoxFor(m => m.BeginTime, new { style = "width: 109px;" })
                </td>
            </tr>

...does the TextBoxFor() construct/syntax perform two-way binding to the model? That is to say, does this assign the values entered into the textboxes thus generated to the BeginDate and BeginTime model members? I assume so; just want to verify.

Now, to combine the Date and Time values I want to pass into one control, I imagine I can replace the BeginDate and BeginTime on the model with a BeginDateTime, and then change the code above to:

            <tr id="trBeginDate">
                <td>
                </td>
                <td>
                    @Html.LabelFor(m => m.BeginDateTime)
                </td>
                <td style="padding-right: 20px;">
                    @Html.TextBoxFor(m => m.BeginDateTime, new { alt = "date-us", style = "width: 164px;" })
                </td>
            </tr>

...right? But...how do I change the associated Telerik code, which presumably is expecting a Date and a Time, not a combined DateTime?

BTW, I tested using "format code block" for the snippets above, but the preview looked like Dallas warmed over.
Clay
Top achievements
Rank 1
 asked on 15 May 2013
1 answer
280 views
Hey everyone.

I'm currently creating a report from an objectDataSource successfully.  The report includes a few layers of grouping.  Rather than create a single PDF, I want to export several instead, one for each of a certain attribute.  It is noteworthy that the attribute I'd like to split by is not added as a group to the report but it can be if needed.

How does one go about doing this?  I would assume the easiest way is to go through the top level of each report and get the appropriate atttribute, and run it through a foreach.  Within the foreach I would generate a PDF.  However, I'm not sure if this is the best idea, and I don't know how to get data from the report in this way.  (To be more specific, getting parameters from my data source at every top level).

Would anyone have suggestions?  Thanks.
Stef
Telerik team
 answered on 15 May 2013
1 answer
72 views
I am wondering if it is possible to do the following:

I have 4 reports that have 3 totals at the bottom: Cases, Allowance and Dollars
I need to insert a sub report to the report footer to appear immediately under the grand total line that also uses Cases, Allowance and Dollars
I'd like to create one sub report, not 4
is it possible to move and / or resize the textboxes on the sub report to line up with the report being produced?
Elliott
Top achievements
Rank 2
 answered on 14 May 2013
1 answer
90 views
I am sure I must be missing something simple here, but I can't seem to user an ado.net datareader with reporting. Here is a code sample:

Private Sub RptRadIdleTime_NeedDataSource(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.NeedDataSource
        rptHeaderBox.Value = "Report Criteria:" & vbCrLf & "Date Range: " & StartDate.ToShortDateString & " to " & EndDate.ToShortDateString & vbCrLf & _
        "Employee: " & EmployeeName & vbCrLf
 
        Dim cn As New SqlConnection(ConfigurationManager.ConnectionStrings("ConnectionString").ConnectionString)
 
        cn.Open()
 
        Dim cmd As New SqlCommand("ReportIdleTime")
        cmd.CommandType = CommandType.StoredProcedure
        cmd.Connection = cn
        cmd.Parameters.Add(New SqlParameter("EmployeeID", EmployeeID))
 
        Dim p1 As New SqlParameter("Start", SqlDbType.DateTime)
        p1.Value = CDate(StartDate)
 
        Dim p2 As New SqlParameter("End", SqlDbType.DateTime)
        p2.Value = CDate(EndDate)
 
        cmd.Parameters.Add(p1)
        cmd.Parameters.Add(p2)
        Me.DataSource = cmd.ExecuteReader
    End Sub

This yields the following error:

An error has occurred while processing TextBox 'TextBox6': Invalid attempt to read when no data is present.

(And the same error on every other field.)

The same method of connecting works fine with linq-to-sql.

Thanks for any help,

David
Chavdar
Telerik team
 answered on 14 May 2013
4 answers
178 views
Hi!

We have been using Telerik controls for the past 3 years and have built extensive WPF Controls with RadGrids for our customers to view their data. More and more we are getting asked for the ability to have the reports automatically created and emailed in a PDF format every night to them. We built our own service to do this that exports the Grid to a .XPS file to get the identical look and feel of the screen then use a .XPS to PDF converter to do the final conversion so that we didn't have to recreate all of the controls in another format. The challenge is the service is proving unreliable due to having may different dependencies.

My question is:
  • Is there a quick way to leverage our grid to create a report template?
  • How do I use the reporting tools to create pdf and email on a schedule?
  • Is there an example project that you can share that already does this?

Thanks,
Ryan
Stef
Telerik team
 answered on 14 May 2013
5 answers
453 views
Hi,

The data in my report consists of e-mail addresses. If I click on the e-mail address, I want to open outlook containing that address. How to achieve that using HtmlTextBox or TextBox?

Senthil
Top achievements
Rank 1
 answered on 14 May 2013
5 answers
292 views
I had created a Master-Detail report.  In this report, the subreport contains a report which displays the detail data.  I want to change the connection string of the subreport because sometimes the location of the Access database changes.  How can I use code to change the connection string (i.e. database location) for the subreport contained in the Master report?

Thanks.

Chavdar
Telerik team
 answered on 13 May 2013
0 answers
148 views
Hello,

I've been trying to upgrade the Telerik libraries to the latest version but I've been getting the following error during runtime:

{System.IO.FileLoadException: Could not load file or assembly 'Telerik.ReportViewer.Silverlight, Version=7.0.13.426, Culture=neutral, PublicKeyToken=a9d7983dfcc261be' or one of its dependencies. The requested assembly version conflicts with what is already bound in the app domain or specified in the manifest. (Exception from HRESULT: 0x80131053)
File name: 'Telerik.ReportViewer.Silverlight, Version=7.0.13.426, Culture=neutral, PublicKeyToken=a9d7983dfcc261be'
   at VenumBV.Apps.Venum.Views.Views.UserControls.ReportViewerControl.ReportViewerControl..ctor()}



I'm not sure why I'm getting this error. I've looked on the forums and someone said that it was because I didn't reference the DLL's in my website project, but I am. I'm also referencing them in the project that has the actual reports and I'm referencing the Telerik.ReportViewer.Silverlight DLL in the silverlight project that launches the reports.

So I'm not sure what I'm doing wrong here. I've checked and I'm referencing all the correct versions in the 3 different projects and I've installed the latest version of the Reporting controls (with the service pack).

Any help would be appreciated.
Ronald Evers
Top achievements
Rank 1
 asked on 13 May 2013
Top users last month
Rob
Top achievements
Rank 3
Iron
Iron
Iron
Atul
Top achievements
Rank 1
Iron
Iron
Iron
Alexander
Top achievements
Rank 1
Veteran
Iron
Serkan
Top achievements
Rank 1
Iron
Shawn
Top achievements
Rank 1
Iron
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?