Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sagiraju_m
Starting Member
1 Post |
 Posted - 2006-03-02 : 11:54:48
|
| Iam converting a report from crystal reports to reporting servicesand below is the 2 formulas in CR how can i write it in Reporting services1.//@PREM_INCR_LOSS_RATIOIf {@MEM_PREM} > 0.0000 then Sum ({@TOT_INCR}, {@POL_DATES}, "daily") % {@MEM_PREM}2.WhilePrintingRecords;CurrencyVar POLPREMAMTS; POLPREMAMTS;[/b]Please let me know how to manipulate the while printing records,currency variables and whatever in RS thank u |
|
|
jhermiz
3564 Posts |
Posted - 2006-03-03 : 10:49:35
|
1) Bad subject for the topic.2) There is no concept of whileprintrecords in RS, crystal is hideous3) Post ddl, sample data, and expected output4)you can use =IIF(condition, true, false) to handle your if and perform your sum in any textbox or table cell
Keeping the web experience alive -- [url]http://www.web-impulse.com[/url]RS Blog -- [url]http://weblogs.sqlteam.com/jhermiz[/url] |
 |
|
|
|
|
|
Hi