Log in to start a topic

Grapecity ActiveReports8 PageReport not showing all off the data fields

Posted by: jim on 3 October 2017, 4:14 am EST

  • jim

    Posted 3 October 2017, 4:14 am EST

    I have version 8 and in visual studio when I Preview all is correctly shown. However, when I deploy the Windows App to its destination, Only part of the fields are shown.

    I have copied the needed version 8 DLLS , the .exe and the Pagereport1.rdlx to the server.

    What am I missing so it will run correctly?

    Thanks,

    Jim

  • grapecity

    Posted 4 October 2017, 6:18 pm EST

    Hi Jim,

    I tested this issue by deploying one of the installed samples to a machine where no AR is installed and found that report loads absolutely fine.

    I tested this issue with samples called “PageUnboundData”

    \Documents\ComponentOne Samples\ActiveReports 8\Page Reports\FPL\Data\C#\PageUnboundData\

    Here are the steps I followed to run the exe:

    1. I copied the bin folder to another machine.
    2. I copied the report to Desktop
    3. I placed the data in:

      Documents\ComponentOne Samples\ActiveReports 8\Data\NWIND.mdb
    4. Ran the exe and it showed the report with no issues.

    Please make sure that you have shipped the data along with the Exe and placed it at correct location.

    Regards,

    Deepak Sharma

  • jim

    Posted 5 October 2017, 3:24 am EST

    I want to make the Page Report output be in the body of an email. Here is my code snippet.

    Viewer output (Pages 4 - 6) of the attachment.

    'Load rdlx report I designed in ActiveReports Report Designer

    pr.Load(New System.IO.FileInfo(newpath + “PageReport1.rdlx”))

    pr.Run()

    Dim pd As New PageDocument(pr)

    Viewer1.LoadDocument(pd)

    When I comment out the viewer and attempt to email here is the snippet:

    'Load rdlx report I designed in ActiveReports Report Designer

    pr.Load(New System.IO.FileInfo(newpath + “PageReport1.rdlx”))

    pr.Run()

    Dim pd As New PageDocument(pr)

    ’ Viewer1.LoadDocument(pd)

        '   Exit Sub

    Dim emre As New GrapeCity.ActiveReports.Export.Html.Page.EmailRenderingExtension()
    pd.Render(emre, Nothing)
    _mail = emre.MailMessage

    _mail.IsBodyHtml = True
    
    _mail.BodyEncoding = System.Text.Encoding.UTF8


    _mail.From = New System.Net.Mail.MailAddress("DownloadStatus@Xxxxxxx.XXX")
  
    _mail.To.Add("jim@fixxbxxxxx.xxx)

    _mail.Subject = "DownLoad Status Test"
  
    ' set the default smtp server & send it 
    Smtpmail.Send(_mail)

    This produces the partial report (pages 1 - 3) of attachment.

    What is wrong with my code?

    JimPageReport1.zip

  • jim

    Posted 5 October 2017, 6:56 am EST

    here is the pagereport

  • jim

    Posted 5 October 2017, 6:57 am EST

  • grapecity

    Posted 5 October 2017, 10:42 pm EST

    Hi Jim,

    I am having no trouble exporting the data from a Page report and then sending it in an email. Please refer to the attached sample application and follow the steps below to run the application:

    1. Change the path for page report and Reels.mdb(contained in the attachment).
    2. Change the email address in the code for both sender and receiver and provide the password. Use a gmail email address for sender.
    3. Run the sample and make sure that the file is loaded corectly in the viewer.
    4. Click on button to send the email.

    Please check the email and let me know if you face any issues. I have used AR Version 8.3.634.0. I have also attached the email received by the receiver.

    In case the issue still persists, please provide me your sample application to debug further.

    Regards,

    Deepak Sharma

    AREmailPageReport.zipARPage Report Email Test.zip

  • grapecity

    Posted 5 October 2017, 10:44 pm EST

    Hello,

    I have attached the sample and email in one attachment this time, please refer to the same.

    Thanks,

    Deepak SharmaAREmailPageReport_withEmail.zip

  • jim

    Posted 6 October 2017, 3:35 am EST

    OK, I am not having a problem getting it to eMail a document. See my PageReport1.zip attached before.

    Page 4 is the report printed from the viewer1. After this my code is as follows:

    Dim pd As New PageDocument(pr)

    pr.Run()

    Viewer1.LoadDocument(pd)

    ’ Exit Sub

        Dim Smtpmail As New System.Net.Mail.SmtpClient
    Smtpmail.Host = "EmailServer"
    Dim _mail As New System.Net.Mail.MailMessage
    Dim myClient As New WebClient()
    Console.WriteLine("Setting up eMail Message")
    Dim emre As New GrapeCity.ActiveReports.Export.Html.Page.EmailRenderingExtension
    pd.Render(emre, Nothing)
    _mail = emre.MailMessage

    _mail.IsBodyHtml = True
   
    _mail.BodyEncoding = System.Text.Encoding.UTF8

    _mail.From = New System.Net.Mail.MailAddress("DownloadStatus@Firstbankms.com")
    '  _mail.To.Add("richardd@firstbankms.com")
    _mail.To.Add("jim@firstbankms.com")
    '  _mail.To.Add("brendam@firstbankms.com")
    _mail.Subject = "DownLoad Status Test"
    '    _mail.Body = mystring
    ' set the default smtp server & send it 
    Smtpmail.Send(_mail)

    The email result is pages 1 and 2. Only a partial amount of the data is shown in the email so it must be related to the Render statement.

    Dim emre As New GrapeCity.ActiveReports.Export.Html.Page.EmailRenderingExtension

    pd.Render(emre, Nothing)

    _mail = emre.MailMessage

    So it works in the viewer: In the Preview of the viewer but not in the email message.

    How can I debug this?

  • jim

    Posted 6 October 2017, 7:11 am EST

    Here is my project zipped. You will need to change the path in the DataSource1 with Report Explorer.

    You will also need to change the email code to go to what you need.

    When Run, you can the difference between the viewer1 and the email.

    PageReportDoodle.zip

  • grapecity

    Posted 9 October 2017, 2:31 am EST

    Hi Jim,

    This working fine at my end. I tested the application you sent after changing the Data source connection string and SMTP settings code. I have attached the email.

    When I tried to run the sample with your SMTP code it gave me “WebException: The remote name could not be resolved: ‘EmailServer’”.

    Please you can try using the gmail account(my sample application) and test again with the same report.

    Also you may first load the report in viewer to see report is working fine before rendering it to email.

    Thanks,

    Deepak Sharma

  • jim

    Posted 10 October 2017, 3:15 am EST

    OK: Here is the latest. We have an in house Microsoft Exchange server ver 2014. Of all of the emails, they were being shown to you were from an outlook 2016 client. These show the partial email page.

    I have my iPhone also getting these same emails. When I look at them with the iphone, they are displayed correctly. What can I look at that explains this? Is there a format ie

    _mail.IsBodyHtml = True

    _mail.BodyEncoding = System.Text.Encoding.UTF8

    that could be causing the discrepencies?

    Jim

  • grapecity

    Posted 10 October 2017, 9:01 pm EST

    Hi Jim.

    In my sample application I sent the email from a gmail account to an outlook account. I opened the email in Outlook client and did not find anything missing.

    The email’s body is all HTML and it should be displayed correctly in all browsers. I don’t think the encoding of email can cause the missing of report part.

    Could you please send the email in HTML format(like I sent) so that I can see what part of the report is missing exactly.

    Thanks,

    Deepak Sharma

Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels

  • © 2023 MESCIUS inc. All Rights Reserved.  ·  1.800.858.2739

    All product and company names herein may be trademarks of their respective owners.