Keeping Your Spry Tables in Sync with Your ColdFusion Reports
June 12 2008 by 
admin
Do you give your customers the option of printing a ColdFusion report of the tables you create with Spry? If so, keep the report and the table in sync using this tip.First when converting your query data to XML, use the sortOnLoad and sortOrderOnLoad attributes:
[Warning: I sometimes work in the financial sector and I take my examples straight form my current projects. You'll find no foo=bar here, but I'm sure you can figure out what I'm doing. If not, comment or email.]
[Warning: I sometimes work in the financial sector and I take my examples straight form my current projects. You'll find no foo=bar here, but I'm sure you can figure out what I'm doing. If not, comment or email.]
<!--- Create an XML document containing the Customer's leases and their reclaimed value at lease end --->
< scr i pt language="javascript">
var dsleaseEndings = new Spry.Data.XMLDataSet("/xml/leaseEnding.xml", "leaseEnding_report/vehicle", { sortOnLoad: "DRLASTNAME", sortOrderOnLoad: "descending" });
</script>
Then use the ds_SortOrder and ds_SortColumn variables in your link to build your ColdFusion report. (note the curly {} brackets containing spry data)
<a href="/reports/leaseEndingsReport.cfr?custID=#CustID#&coName=#name#&sortOrder={ds_SortOrder}&column={ds_SortColumn}" target="_blank">Print</a>
Within report builder, create a SQL statement with an order By cluse that contains the URL variables:
Select ....
From ....
Where ...
ORDER BY #param.column# #param.sortOrder#
Posted in Spry | 
2 comments
Aug 29, 2009 at 1:30 PM
Hey. Health consists of having the same diseases as one's neighbors. Help me! Please help find sites for: Wholesale handmade glycerine soap. I found only this - <a href="http://www.saeon.ac.za/Members/Soap/handmade-soap-uk">handmade soap uk</a>. From electric soil he began a mold for life and institution and wanted sitting and appearing bulls by a practical construction, rene princeteau. Like wide century, delicate accessories were gradually followed particularly by many boards, and were almost thought by objects. Thanks :mad:. Yorick from Emirates.
Nov 12, 2009 at 11:47 PM
This is a cool screen idea ! It is very interesting indeed.Thank you for your info.i love to read all info.