Hi,

I have a report that I need to run automatically and generate sets of PDF files to specific folders on a network share drive, each with a unique name. I had setup a quick project with MS Access and was able to do this, although it's a bit buggy. For production I recoded the report into a Winform app using Telerik Reporting Q1 2009. The app does function as intended, but I noted that the machine gobbles all of the memory. I can watch the app run and as it's generating new PDFs, the memory use just continues to climb. I tried to do what I figured would release the memory, but it's not working.

Here's my code, did I miss something? How do I get the application to quit grabbing memory as it runs?

The report has 2 subreports included on the same page.

----Routine start---
        Dim con As New SqlConnection(My.Settings.CCO_MM_DATA)

        Dim sql As String = "usp_RptFaceSheet_ClientList_DIST"
        Try
            con.Open()
            Dim da As New SqlDataAdapter(sql, con)
            Dim ds As New DataSet
            da.Fill(ds)

            'Get Data Table
            Dim dt As DataTable = ds.Tables(0)

            'Display Data
            For Each row As DataRow In dt.Rows
                If Directory.Exists("S:\Development\FaceSheets\" & row(2).ToString) Then
                    Me.ReportViewer1.Report = New TestFaceSheet.Report1

                    TryCast(ReportViewer1.Report, TestFaceSheet.Report1).ReportParameters(0).Value = Int32.Parse(Trim(row(0).ToString))
                    Dim mimType As String = String.Empty
                    Dim extension As String = String.Empty
                    Dim encoding As Encoding = Nothing
                    Dim deviceInfo As Hashtable = New Hashtable
                    deviceInfo("FontEmbedding") = "None"
                    Dim buffer As Byte() = ReportProcessor.Render("PDF", ReportViewer1.Report, deviceInfo, mimType, extension, encoding)
                    Dim fs As New FileStream("S:\Development\FaceSheets\" & Trim(row(2).ToString) & "\[" & Trim(row(1).ToString) & "]ClientInfo.pdf", FileMode.Create)
                    fs.Write(buffer, 0, buffer.Length)
                    fs.Flush()
                    fs.Close()
                    deviceInfo.Clear()
                    fs.Close()
                    ReportViewer1.Dispose()

                End If

            Next
            con.Close()

        Catch ex As Exception
            MsgBox(ex.Message)
        Finally
            con.Close()

        End Try
        End
----Routine end----

I am trying to build a Web Form page to use to test my new report.  But when I drag the ReportViewer control from the toolbox over to my page I am getting this error:

The operation could not be completed. Invalid FORMATETC structure.

Any ideas?
Thanks.
Dan

Hi,

I have created the report and make the formatting using &nbsp; and <br/> ,When I am seeing it on the browser it is perfect what I need ,I am getting  however when i export to PDF the report is showing the &nbsp and <br/> tag.

However we know it is not right ,since export should have to function well and export same as it is showing on the browser as other exporting program do.

Please provide the solution.

Thanks,
Neeraj

 

 

 

Hi,

I have a requirements and I am hoping I can use Telerik to achieve this. I have to print data on premarked Business Card paper, i.e. which has 10 business cards per page (5 rows, 2 columns). I want to be able to print on both sides. I need to be able to print multiple at once, i.e. more than 10 if possible, running to the next page. I should also be able to select the starting point of where to print.

For example. If I print 3 cards the first time, then I need to be able to start from the 4th slot which is in the 2nd row, 2nd column. If this requirement CAN be met, then I need to be able to flip the page and print the back side on the correct places.

Is this possible with Telerik Reporting, do we have any examples?

Thank you.

Hi,

I would like to know if there is a way to change the report from the regular style to be in black and white. I would like this to be changeable either by code or even better using a report parameter to indicate if we want it in black and white or color.
Thanks
Naphtali

I just upgraded a set of reports to Telerik Reporting 3.1.9.701 (Q2 2009).

In my reports, I used the "DetailSection1_ItemDataBound" event to change fields on the report.  I did this with lines like:

Imports T

 

elerik.Reporting
...

Dim section As Processing.DetailSection = DirectCast(sender, Processing.DetailSection)

Now, after the upgrade, the compiler is telling me "Type 'Processing.DetailSection' is not defined."

What am I missing?

Thanks.

 

 

 

 

 

 Sorry, wrong forum.

Hi,
I am on a try basis .I like your reporting tool and as I test it I find myself wondering how to solve one problem.I am an Oracle programmer
and I am trying to write a three tier application for my customers and I am looking for a reporting tool.Yours seems to cover my  needs.
Basically I have one question.Since my customers are used to Oracle reporting I would like the same with your tool.
What I mean is this, all the data will be processed by me into a dataset or datatable locally since my application is not connected direct
to the database but a middle server that sends the data in a format my client understands and inserts into the dataset/datatable.
Once the client has the dataset calls your object like

        report.DataSource = tempDT
        reportViewer.Report = report
        reportForm.Show()
        reportForm.Controls.Add(reportViewer)
        reportViewer.RefreshReport()

I made a project using Telerik reporting that works.It reads a file, creates a dataset of 1511 records which represent 37 pages,
it  takes 15 secs for first page to show on the form  and 10 for rendering the rest.
If my report gets bigger the time grows.What i would like to know if there is a way just like Oracle reports (usually the first page comes
very fast and then if I choose it does the rest) to be able to get the first page very quickly since I prepare the pages in order in mydataset and I do not need ordering or sorting .
If you can show some example of pure data already in the memory of dataset or datatable and manipulate in such a way I show the first page and later I load the rest of the report if I want.This will help me in choozing your product.

thanks in advance

I am sure you are busy , but since I am on trial version time and I would like to test your suggestions
I will appriciate your quick answer because this issue will make us decide to buy your product

Thanks again
 
  

Dear staff,
I am integrating Telerik Reporting on ASP.Net. When I clicking Preview button or export to file to view, there are no current page link on page footer but I print on page directly. I see this link on the page footer. This causes issue when I send invoice to customer.

How to resolve this issue

Thanks