Telerik Forums
Reporting Forum
1 answer
1.4K+ 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 Q2 2011
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!

Roman
Top achievements
Rank 1
 answered on 25 Aug 2011
0 answers
103 views
Hi,

For my report the content of each page has to be in a box. The size of the box will be fixed, it will be like an outline for the report. The content inside will change or might be blank depending on the data. For that I am trying to use a panel in the detail section with border. The default borderwidth is 1pt, which is very thick. Can I reduce the borderwidth? And also for a line shape, I am not able to reduce the width less that 1pt. Is this a correct approach to have a panel for a box outline in the report? When I saw the demo, Dashboard report has 3 tables like that with header but in video it does not show how it got created. This might be a very small thing but any of the documentation has also not explained how to do that. Will it be possible to get the Report Source files for these demo reports so that I can see the properties in Report Designer. I am using Q3 2009 version of Telerik Reporting.

Thanks
kachy
Top achievements
Rank 1
 asked on 24 Aug 2011
3 answers
177 views
Hi

I have to create a report where all the tables and pie charts have to be created dynamically. i.e. the number of tables and pie charts depend on the data received to the report. So, at design time i cant create the controls. Please let me know how do i create them dynamically.

Thanks in advance
Ravindra
Peter
Telerik team
 answered on 24 Aug 2011
1 answer
200 views
I am using the report viewer in RadPane (ASP.Net ajax) and the scroll bars are not showing up in the viewer...

Everything is fine except that... Do you have an idea?

Thank you

Alex Bouchard
Dobromir
Telerik team
 answered on 24 Aug 2011
3 answers
75 views
Hi,

I recently upgraded our reporting tool from Q1 2010 to Q2 2011, and some reports work fine, but others generate an error when re-run. The first time they are run, they work correctly.  They also work consistently from testing within the report assembly / dll.  I'm using the following:

VS.NET 2010 / ASP & VB.NET
SQL Server (2005)
Telerik Reporting 5.1 (5.1.11.713)
Telerik RadControls 11.2.712.0

I've tried everything I can think of, and I haven't figured out what the difference is with the reports that are failing, except they are all in the same assembly.

Thanks in advance,
Ed N.

Ed
Top achievements
Rank 1
 answered on 24 Aug 2011
0 answers
109 views
Hello,

I've just installed the latest (5.1 trial) version of the Telerik Reporting tool and am facing a problem. I can't find the stylesheet property in the properties window. All I can see are Style and StyleName.

Has this something to do with the trial version or has it been changed lately...

Best regards,
Ivan


edit:found out what the problem was... I haven't selected the whole report but rather just one single element...that's why I didn't get the stylesheet option...
Ivan
Top achievements
Rank 1
 asked on 23 Aug 2011
3 answers
136 views
I have created a RadGridView in my application to use as an employee attendance calendar. The datasource is a SQL Server table with 1 column for the name of the month and 31 columns for the days of the month. In the database only the MonthName column has data in it; one record for each month. The columns for the days of the month are empty in the database. Basically this is just a template.

The day-of-the-month columns in the RadGridView are populated using a SQLDataReader. Like this;

Private Sub FillCalendar()
       Dim newFont = New Font("Calibri", 7.0F, FontStyle.Bold)
       Dim EE As Integer
       Dim vbYear As Integer
       Dim Incident As String
       Dim ColIndex As Integer 'Day of the month, also the name of the column
       Dim RowIndex As Integer ' Month of the year, also row index + 1 
       EE = CInt(RadTextBoxElement10.Text) ' Employee id #
       vbYear = CInt(RadDropDownListElement1.SelectedIndex + 2007) 'Year for calendar
       'connection string and mysqlconnect
       Dim connstring As String = ("Data Source=MyServer\SQLINSTANCE;Initial Catalog=DATABASENAME;Persist Security Info=True;User ID=MYUSER;Password=MYPASS")
       Dim conn As New SqlConnection(connstring)
       Dim selectSQL As String
       'create selection query
       selectSQL = ("Select aDay, aMonth, Incidents From View_AttCombined Where (GPID like '" & EE & "') and (aYear like '" & vbYear & "')")
       'create selection command
       Dim cmd As New SqlCommand(selectSQL, conn)
       'set cmd property
       cmd.CommandType = CommandType.Text
       'open database
       conn.Open()
       'create and execute the reader
       Dim myreader As SqlDataReader = cmd.ExecuteReader
       While myreader.Read
           ColIndex = myreader.GetInt32(0)
           RowIndex = myreader.GetInt32(1) - 1
           Incident = myreader.GetString(2)
           Me.RadGridView1.Rows(RowIndex).IsCurrent = True
           Me.RadGridView1.Columns(ColIndex).IsCurrent = True
           Me.RadGridView1.CurrentCell.Value = Incident
           If Len(Me.RadGridView1.CurrentCell.Value) > 3 Then
               Me.RadGridView1.CurrentCell.Font = newFont
           Else
           End If
       End While
       conn.Close()
       Me.AttendanceTableAdapter.Fill(Me.AttendanceDataSet.Attendance, CInt(RadTextBoxElement10.Text), CInt(RadDropDownListElement1.SelectedIndex + 2007))
       Me.AttCalCommentsTableAdapter.Fill(Me.CalCommentDataSet.AttCalComments, CInt(RadTextBoxElement10.Text), CInt(RadDropDownListElement1.SelectedIndex + 2007))
       Me.RadGridView1.CurrentRow = Me.RadGridView1.Rows(0)
       Me.RadGridView1.CurrentColumn = Me.RadGridView1.Columns(1)
   End Sub

Is it possible to use a similar approach to populate the Cells/TextBox's in a report table?
If not, is it possible to use a RadGridView as the datasource for a report table?

I am open to other suggestions.
Peter
Telerik team
 answered on 23 Aug 2011
2 answers
111 views
Is there any way to get the RadAjaxLoadingPanel to work with a Telerik report that is output as a PDF file?  The report takes a long time to generate so I'd like to show a loading screen or have some way to indicate that the pdf file is generating.  If I try to use the RadAjaxLoadingPanel, I'm getting a Sys.WebForms.PageRequestManagerParserErrorException because the code to programatically create a PDF from a Telerik report uses Response.BinaryWrite.

So is there any way to either...

show progress when a pdf file is being programmatically created from a Telerik report

OR

create a pdf file programmatically created from a Telerik report without using Response.BinaryWrite (in which case I could use the RadAjaxLoadingPanel to show progress)
Steve
Telerik team
 answered on 23 Aug 2011
1 answer
135 views
The report viewer works fine on the test site that doesn't use any kind of authentication. once i add form authentication the report viewer stops functioning properly.
From the following thread  I understand that form authentication interferes with the report viewer http handler streaming.
I tried adding the <location> solution mentioned on that thread to no avail.

How can overcome this issue, and prevent the form authentication from interfering with the report viewer?

Thank you,
Ghayth
Steve
Telerik team
 answered on 23 Aug 2011
3 answers
134 views
Hi,
I am evaluting the teleric reporting control for a browser based application - where large # of reports are involved. There would be few specific reports which might need the custom paper size and to be printed on specific printer. Custom paper size is possible to set in report designer as well as during run time. Now I am wondering - whether a specific printer name be set during run time - so that user does not have to select it when ever he prints the report.



Thanks
Ketan Patel
Steve
Telerik team
 answered on 23 Aug 2011
Top users last month
Boardy
Top achievements
Rank 2
Veteran
Iron
Benjamin
Top achievements
Rank 3
Bronze
Iron
Veteran
ivory
Top achievements
Rank 1
Iron
Iron
Rob
Top achievements
Rank 3
Bronze
Bronze
Iron
ClausDC
Top achievements
Rank 2
Iron
Iron
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?