|
fdranguet
France
81 Posts |
 Posted - 12/07/2009 : 06:03:56
|
Hello,
I have a slight issue with scheduling mailing of SQL reports to Excel using Report Portal scheduler: when using a "time event" for scheduling such reports, everything is fine; but when using a "URL trigger", then I have some missing fields. I investigated a bit, and found out that on the mail sent by a "URL trigger", some fields (all those which cannot be recognized as numbers) are written into CDATA section, while this is not happening with a "time event". Example:
Correct one (schedule planned to run every two minutes):
<td bgcolor="LightYellow" >Filler X401</td>
<td bgcolor="LightYellow" align="right">12</td>
<td bgcolor="LightYellow" >004107K </td>
<td bgcolor="LightYellow" align="right">3074057 </td>
<td bgcolor="LightYellow" align="right">11,0 </td>
<td bgcolor="LightYellow" ></td>
<td bgcolor="LightYellow" ></td>
<td bgcolor="LightYellow" ></td>
<td bgcolor="LightYellow" ></td>
Incorrect one (exact same query but with a "URL trigger" that time):
<td bgcolor="" ><![CDATA[Filler X401]]></td>
<td bgcolor="" align="right">12</td>
<td bgcolor="" ><![CDATA[004107K ]]></td>
<td bgcolor="" align="right">3069614 </td>
<td bgcolor="" align="right">11,6 </td>
<td bgcolor="" ><![CDATA[]]></td>
<td bgcolor="" ><![CDATA[]]></td>
<td bgcolor="" ><![CDATA[]]></td>
<td bgcolor="" ><![CDATA[]]></td>
Please help ! Many thanks.
Regards,
François Dranguet
Scott Bader SA
BI Developer
Tel: +33 (0)3 22 66 27 77 |
Edited by - fdranguet on 12/07/2009 06:26:25 |
|
Report Portal
RP Scheduler
