Showing posts with label crystal. Show all posts
Showing posts with label crystal. Show all posts

Thursday, March 22, 2012

alert messages in SSRS

hi,

I am working on migration from crystal reports to SSRS. my crystal report has some alerting formulas, which displays pop-ups at runtime based on some conditions.How do i implement those alerting formulas in SSRS.

Thanks in advance.

I think you can call msgboxes from code, beyond that there isn't anything.

Why are you migrating from Crystal to RS?

Monday, March 19, 2012

aging report

need help in using Aged0To30Days in crystal report 9

this is formula i'm using:

create formula @.test as
if {arinvc.dinvoice} in currentdate to currentdate-30 then
"Aged0To30Days"
else if {arinvc.dinvoice} in currentdate-31 to currentdate-60 then
"AgedAged31To60Days"
else if {arinvc.dinvoice} in currentdate-61 to currentdate-90 then
"AgedAged61To90Days"
else if {arinvc.dinvoice} in currentdate-91 to currentdate-120 then
"AgedAged91To120Days"
else
"others"

this is the error message after i check the formula:

the remain text does not appear to be part of the formula

tnxuse

create formula @.test as
if {arinvc.dinvoice} in [currentdate to currentdate-30] then
"Aged0To30Days"

[ ] brackets i added.

hope this helps|||ok. i'll try it here. tnx|||sorry

i didn't mention earlier

in clause takes comma seperated value like

in [1,2,3,4]