Telerik Forums
Reporting Forum
1 answer
77 views
Hi Everyone;

Suppose our application needs to provide user a way for them to create an email template that some content are static and some content come from database and sort of creates a email-marge. Like:

Dear <<Customer.FirstName>>;
We would like to notify that your balance amount of <Customer.Balance>> is over due.


The content is not created by developer like a regular report where developer designs the report and binds database fields in the report. In this case the user enters the content and anything in << >> (I only used this as a sample) comes from database at runtime and produces an email to be sent out.

What's the best way to offer end user an email mailmerge?

Thanks!
Stef
Telerik team
 answered on 08 Apr 2014
3 answers
132 views
When I create a report in VS2012 I am using background colors for a couple fields.  The color I am using is RGB (39, 39, 88).  When I run the program and look at the output excel report, the colors are different RGB (51,51,51).  See attached screen shots for example.  the first image labeled DesignTime.png is what I see in VS2012.  The second image labeled Output.png is the output excel report.

Any help would be appreciated.
Thanks
-Matt
KS
Top achievements
Rank 1
 answered on 08 Apr 2014
1 answer
74 views
I designed a report using an ObjectDataSource, usually placed contrloles TextBox and HtmlTeextBox kind in panes in the section header and footer, and when rendering the report, it disappears the entire panel without displaying any errors or displayed message, why is this happening? 

As I correct? 

I include a picture with the preview in the designer and another to the already generated report. I hope I can help identify whats wrong whit my report.

My Unique Customer ID is: YQ544656

Thanks is advance
Nasko
Telerik team
 answered on 08 Apr 2014
1 answer
197 views
Hi all,
I have been trying different things to try and get this to work but keep running into walls.
My setup is:

Visual Studio 2012 - Winforms - Telerik Reporting 2013 Q3
SQL Server 2008R2 backend.

Master table
name: JSA1
Key Field: JSAID
Field1
Field2
Field3
Field4

Detail Table
name: tblSteps
Key Field: STEPID
FK Field: JSAID
Field1
Field2
Field3
Field4

Foreign key is setup properly in SQL Server.
I have 2 stored procedures that select records from each of the tables.
I can preview the reports individually with an entered parameter value and they both work fine.
What I want to accomplish is to be able to pass the parameter to BOTH the main report and the subreport.
I followed the Master Detail guide, and that works ok, but it is slow since it has to return ALL of the detail table before it filters then down to the records I want.

I call the master report using a form with a reportviewer on it and pass the parameter to the main report as follows
 Dim instanceReportSource As New Telerik.Reporting.InstanceReportSource()
                instanceReportSource.ReportDocument = New Reporting.VWIDetail()
                instanceReportSource.Parameters.Add(New Telerik.Reporting.Parameter("JSAID", GlobalVariables.VWILinkDetail))
                ReportViewer2.ReportSource = instanceReportSource
               ReportViewer2.RefreshReport()

How can I pass that parameter to the sub report in the same way?




Nasko
Telerik team
 answered on 08 Apr 2014
1 answer
78 views
Hi,

We are using Q1 2014 version of telerik for reporting.
We have a scenario where the user can select the export option before he creates a report.

Suppose, if he selects pdf and  clicks on create report, the report should be displayed in new window in pdf format.
same for all the other output types( tiff,excel..etc.)

How can we acheive that? Any help would be appreciated.


Many thanks,
Manognya.K
Stef
Telerik team
 answered on 08 Apr 2014
2 answers
496 views
Hello,

i set a filter to check if my value (from Database) is a String. I don't know how to do it properly. So i use my own Function:

Public Shared Function CheckForAlphaCharacters(ByVal StringToCheck As String) As Boolean
 
    Try
        Dim i As Integer = 0
        For i = 0 To StringToCheck.Length - 1
            If Char.IsLetter(StringToCheck.Chars(i)) Then
                Return True
            End If
        Next
        Return False
    Catch ex As Exception
        Return False
    End Try
 
End Function

An this is how i define the filter. (I also added a screenshot)

= MIR.Web.ZinsCheck.Hilfsfunktion.CheckForAlphaCharacters(CStr(Fields.Beschäftigungsverhältnis2)) = True = = True

What I want is, if the Value is Empty the row not visible.

So this wont work. What i'm doing wrong?

But I am also open to other solutions!

Thank you,
Daniel
Daniel
Top achievements
Rank 1
 answered on 07 Apr 2014
1 answer
125 views
Hello,

I'm migrating a set of reports from InProc session state to SQL Server sessions state (and have read the design considerations document at least 40 times.)  I'm using an object data source in a report and was wondering if someone could clarify if I understand correctly

1)  ObjectDataSource parameters must be primitive types.  i.e., I can not assign a "ReportCriteria" object as a parameter, but must assign ReportCriteria.StartDate, ReportCriteria.EndDate, ReportCriteria.ZipCode, etc as individual parameters?

2)  If I add a sorting binding to a column header and click it, the DataObjectMethod that my ObjectDataSource is assigned to will be called again and I have to take the database hit two times?   If this is the case and not a misunderstanding on my part, is there a reccommended approach to not hit the database multiple times?

3)  Are there any real world examples available anywhere in the documentation or videos?  I feel like everything I see works against the "best case" scenarios of clean data and no weird customer requirements?

Many thanks!

Joe
Nasko
Telerik team
 answered on 07 Apr 2014
1 answer
106 views
Hi,

I am attempting to create a Console Application to schedule the creation of reports programmatically.  I found your example for creating PDF-files that seems easy enough.

I added a reference to Telerik.Reporting.  I also added "using Telerik.Reporting.Processing;".  Visual Studio 2010 intellisense seemed to accept the syntax and I was presented with intellisense "period-alternatives" (and no squiggly red underlines).

However, when I then attempted to build the project, I received the following error-message:
"The type or namespace name 'Telerik' could not be found (are you missing a using directive or an assembly reference?)"

Versions:
Telerik Reporting Q1 2014
Visual Studio 2010 (SP1)
.Net 4.0

Questions:
1. Are there known "issues" using Telerik Reporting with Console Applications?
2. Where else could I possibly reference the Telerik dll?
3.  Since this is a very common need, could you provide sample code for a Console Application?

Thanks in advance!
Stef
Telerik team
 answered on 07 Apr 2014
6 answers
297 views
Hello,

since I using Telerik Reporting Version 7.1.13.612 I have trouble with my Zebra TLP 2844 Printer.
Instead ob Landscape the Printer prints in Portrait Mode. When I used the Version 6.1.12.611 the Printer worked well.

Do I need to change any settings?

Stef
Telerik team
 answered on 07 Apr 2014
3 answers
157 views
I found an old post with a sample for a SubReport to display hierarchical data.  There was an error in it that I cannot seem to fix.  I created my SubReport and have it working recursively.  But when I add it to my main report in the details section, it works for the first data item, but when it adds the subreport for the second data item it gives an error because there is already a SubReport with that name.  So, I add a SubReport to my details section, it automatically names it subReport1.  When I run the report the first item in my details section runs beautifully.  When it gets to the second item the Subreport displays an error because it is also named subReport1.  The Name property of Telerik.Reporting.Processing.SubReport only allows getting, not setting, so I can not programmatically rename it on ItemDataBinding.  What would the work around be for this?
Hinata
Top achievements
Rank 1
 answered on 07 Apr 2014
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?