T O P I C R E V I E W |
fdranguet |
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 |
1 L A T E S T R E P L I E S (Newest First) |
admin |
Posted - 12/07/2009 : 21:54:07 Thank you for reporting this problem. It will be fixed in the next build. |
|
|