Export to pdf differs from viewer

[Former Member]

Hello,

I have a ASP.NET (v4.5) application which uses Crystal Reports (v. 13.0.14), report files are created using Crystal Reports IX.

One of the reports contains two OLE Objects every one of them containing an image. Depending on the data source one of the images gets suppressed.

When viewed in the viewer everything looks OK. But when exported as an PDF file the visible image is replaced with resized copy of an image contained in the report's footer and not the correct one. It seems it retains the objects size but the content is replaced.

Any idea?

Kind regards,

Lyuboslav Asenov

[former_member11696 · Accepted solution]

How are you linking the images, are you using a formula field pointing to a database field that points to the location of the image or are the images saved in the Database?

Or are they static images save in the Report?

If it's not getting replaced them it suggests the image is not available when exported. Exporting runs the report again.

If the images are static can you attach the report and I'll run it through my app and see what happens.

Use dummy data of course.

Don

[Former Member · Accepted solution]

Thanks for the fast answer. The images (Picture3, Picture4) are static and are found in t1 sub-report. When opened only the green image is seen (it's on top).

Link to the report file:

https://drive.google.com/file/d/0B8krIRjSd5pyOWRMR09nUkhZOTA/view?usp=sharing

Regards,

Lyuboslav Asenov

[former_member11696 · Accepted solution]

Thanks for the report but without saved data nothing I can do with it.

Don

[Former Member · Accepted solution]

Slipped my mind.

Here it is:

Data source (it's a data set exported as xml):

<DataSet>

  <r_auplan>

    <idses>0</idses>

    <name>Webclient, Test</name>

    <cstname>WB 1</cstname>

    <days>1.000000</days>

    <rest>-17.000000</rest>

    <date1>2015-07-31T00:00:00+03:00</date1>

    <date2>2015-07-31T00:00:00+03:00</date2>

    <abr>U</abr>

    <abwname>Urlaub</abwname>

    <isotp>0</isotp>

    <isday>false</isday>

    <yearotp>0</yearotp>

    <restotp>-16.000000</restotp>

    <addotp>0</addotp>

    <getotp>0</getotp>

    <payedotp>0</payedotp>

    <restdays>0</restdays>

    <add2otp>0</add2otp>

    <add3otp>0</add3otp>

    <account>0</account>

    <creat_date>2015-07-31T18:41:02.893+03:00</creat_date>

    <signedby>krasi</signedby>

    <signedon>2015-07-31T18:42:54.78+03:00</signedon>

    <replaceby />

  </r_auplan>

  <r_auplanhist>

    <idses>0</idses>

    <lvlname>Boss</lvlname>

    <username>Druck1</username>

    <confdate>7/31/2015</confdate>

    <status>9</status>

    <descript>aaaaaaaaa</descript>

  </r_auplanhist>

  <r_auplanhist>

    <idses>0</idses>

    <lvlname>Second Level</lvlname>

    <username>krasi</username>

    <confdate>7/31/2015</confdate>

    <status>9</status>

    <descript>fffffff</descript>

  </r_auplanhist>

</DataSet>

And the more complex stuff - parameters:

Parameter p1 is always 0. The other should be added in order on the "order", report level shows whether it is the main report or a sub-report.

<?xml version="1.0" encoding="utf-8"?>

<this.parameters>

    <parameter>

        <Name>lang</Name>

        <Order>1</Order>

        <ReportLevel>0</ReportLevel>

        <Value>"Antrag auf Urlaub_21"</Value>

    </parameter>

    <parameter>

        <Name>lang</Name>

        <Order>1</Order>

        <ReportLevel>1</ReportLevel>

        <Value>"Approval Hierarchy"</Value>

    </parameter>

    <parameter>

        <Name>lang</Name>

        <Order>2</Order>

        <ReportLevel>0</ReportLevel>

        <Value>"Date"</Value>

    </parameter>

    <parameter>

        <Name>lang</Name>

        <Order>2</Order>

        <ReportLevel>1</ReportLevel>

        <Value>"Level"</Value>

    </parameter>

    <parameter>

        <Name>lang</Name>

        <Order>3</Order>

        <ReportLevel>0</ReportLevel>

        <Value>"For"</Value>

    </parameter>

    <parameter>

        <Name>lang</Name>

        <Order>3</Order>

        <ReportLevel>1</ReportLevel>

        <Value>"User"</Value>

    </parameter>

    <parameter>

        <Name>lang</Name>

        <Order>4</Order>

        <ReportLevel>0</ReportLevel>

        <Value>"Station/Department"</Value>

    </parameter>

    <parameter>

        <Name>lang</Name>

        <Order>4</Order>

        <ReportLevel>1</ReportLevel>

        <Value>"confirmed on"</Value>

    </parameter>

    <parameter>

        <Name>lang</Name>

        <Order>5</Order>

        <ReportLevel>0</ReportLevel>

        <Value>"I would like to ask for"</Value>

    </parameter>

    <parameter>

        <Name>lang</Name>

        <Order>5</Order>

        <ReportLevel>1</ReportLevel>

        <Value>"Opinion"</Value>

    </parameter>

    <parameter>

        <Name>lang</Name>

        <Order>6</Order>

        <ReportLevel>0</ReportLevel>

        <Value>"For"</Value>

    </parameter>

    <parameter>

        <Name>lang</Name>

        <Order>7</Order>

        <ReportLevel>0</ReportLevel>

        <Value>"Days remaining"</Value>

    </parameter>

    <parameter>

        <Name>lang</Name>

        <Order>8</Order>

        <ReportLevel>0</ReportLevel>

        <Value>"Up to and including"</Value>

    </parameter>

    <parameter>

        <Name>lang</Name>

        <Order>9</Order>

        <ReportLevel>0</ReportLevel>

        <Value>"To be replaced by"</Value>

    </parameter>

    <parameter>

        <Name>lang</Name>

        <Order>10</Order>

        <ReportLevel>0</ReportLevel>

        <Value>"u1"</Value>

    </parameter>

    <parameter>

        <Name>lang</Name>

        <Order>11</Order>

        <ReportLevel>0</ReportLevel>

        <Value>"The above application incl. Replacement"</Value>

    </parameter>

    <parameter>

        <Name>lang</Name>

        <Order>12</Order>

        <ReportLevel>0</ReportLevel>

        <Value>"is accepted"</Value>

    </parameter>

    <parameter>

        <Name>lang</Name>

        <Order>13</Order>

        <ReportLevel>0</ReportLevel>

        <Value>"is rejected"</Value>

    </parameter>

    <parameter>

        <Name>lang</Name>

        <Order>14</Order>

        <ReportLevel>0</ReportLevel>

        <Value>""</Value>

    </parameter>

    <parameter>

        <Name>lang</Name>

        <Order>15</Order>

        <ReportLevel>0</ReportLevel>

        <Value>"accepted"</Value>

    </parameter>

    <parameter>

        <Name>lang</Name>

        <Order>16</Order>

        <ReportLevel>0</ReportLevel>

        <Value>"considered"</Value>

    </parameter>

    <parameter>

        <Name>lang</Name>

        <Order>17</Order>

        <ReportLevel>0</ReportLevel>

        <Value>""</Value>

    </parameter>

    <parameter>

        <Name>lang</Name>

        <Order>18</Order>

        <ReportLevel>0</ReportLevel>

        <Value>"Applicant's signature"</Value>

    </parameter>

    <parameter>

        <Name>lang</Name>

        <Order>19</Order>

        <ReportLevel>0</ReportLevel>

        <Value>"Day(s) Annual leave"</Value>

    </parameter>

    <parameter>

        <Name>lang</Name>

        <Order>20</Order>

        <ReportLevel>0</ReportLevel>

        <Value>"Hrs. Annual leave"</Value>

    </parameter>

    <parameter>

        <Name>lang</Name>

        <Order>21</Order>

        <ReportLevel>0</ReportLevel>

        <Value>"Pers.No."</Value>

    </parameter>

    <parameter>

        <Name>lang</Name>

        <Order>22</Order>

        <ReportLevel>0</ReportLevel>

        <Value>"Day(s)"</Value>

    </parameter>

    <parameter>

        <Name>lang</Name>

        <Order>23</Order>

        <ReportLevel>0</ReportLevel>

        <Value>"Hrs."</Value>

    </parameter>

    <parameter>

        <Name>lang</Name>

        <Order>24</Order>

        <ReportLevel>0</ReportLevel>

        <Value>"Hrs. remaining"</Value>

    </parameter>

    <parameter>

        <Name>statlay</Name>

        <Order>1</Order>

        <ReportLevel>0</ReportLevel>

        <Value>"0"</Value>

    </parameter>

    <parameter>

        <Name>statlay</Name>

        <Order>2</Order>

        <ReportLevel>0</ReportLevel>

        <Value>"0"</Value>

    </parameter>

    <parameter>

        <Name>statlay</Name>

        <Order>3</Order>

        <ReportLevel>0</ReportLevel>

        <Value>"0"</Value>

    </parameter>

    <parameter>

        <Name>statlay</Name>

        <Order>4</Order>

        <ReportLevel>0</ReportLevel>

        <Value>"1"</Value>

    </parameter>

    <parameter>

        <Name>statlay</Name>

        <Order>5</Order>

        <ReportLevel>0</ReportLevel>

        <Value>"1"</Value>

    </parameter>

    <parameter>

        <Name>statlay</Name>

        <Order>6</Order>

        <ReportLevel>0</ReportLevel>

        <Value>"Holiday"</Value>

    </parameter>

</this.parameters>

Regards

[ido_millet · Accepted solution]

Save the rpt with data (in Crystal Designer: file, Save Data with Report).

Or export to a Crystal Report format (that produces an rpt with saved data). 

[Former Member · Accepted solution]

Here it is auplana4_w_data.rpt - Google Drive

Didn't know that is possible. Exported the report as a CrystalReport.

Regards.

[former_member11696 · Accepted solution]

I got the report with saved data but I don't see the company logo in this report?

And the green check mark, I'll have to check with the DEV Team to see why it's not exporting.

Don