-----------------------------------------------------------
New Message on BDOTNET
-----------------------------------------------------------
From: ksramesha_gmail_com
Message 3 in Discussion
Hi Shrinath,
thanks for your quick reply.
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1118354&SiteID=1&mode=1
by browsing above URL I got some information, according to it we can implement
this in two ways.
displaying message through Label in report
this option is simple & straight forward
displaying in pop-up
this second option is difficult where, report can works in the report
designer (in preview),but it doesn't work on the server after i deployed it to
the
server.deploy successfully,why does it give me the message that is Error during
processing of 'fromYear' report parameter.(rsReportParameterProcessingError).
the Detail Description for the both option is as follows
displaying message through Label in report.
drag a Rectangle from the toolbox. Set the Border Color to red (this is the
standard for an error message). Drag a texbox into your rectangle place the
message "
Date From should not be later than Date To.". Into the Rectangle properties, go
to the Hidden properties under the Visibility property of the rectangle then
add this expression:
=IIF(Parameters!StartDate.Value > Parameters!EndDate.Value,false,true)
displaying in pop-up.
You need to add a function to validate the parameters.
Go to the Report Properties under the Report menu and place this code to the
Code Tab.
Function CheckSignificantDate(StartDate as Date, EndDate as Date) as Integer
Dim msg as String
msg = ""
If (StartDate > EndDate) Then
msg="Start Date should not be later than End Date"
End If
If msg <> "" Then
MsgBox(msg, 16, "Report Validation")
Err.Raise(6,Report) 'Raise an overflow
End If
End Function
Then go to the Report Parameters and Add named it Validate with the datatype is
string. Checked the Hidden and Allow blank value ckeckboxes. In
Available Values choose Non-Queried and from Default Values choose Non-Queried
in right side of textbox then press the FX button then paste this code.
=CODE.CheckSignificantDate(<parameterStartdate>.Value,<parameterEnddate>.Value)
Regards,
Ramesh KS
On 1/17/07, shri <[EMAIL PROTECTED]
> wrote:
New Message on BDOTNET
SQL 2005 Reportingservices - Validating 2 date fields (ex: "StartDate" should n
Reply
Reply to Sender
Recommend
Message 2 in Discussion
From:
shri
Hi Ramesh,
I don't think there is any easy solution to this. Even we had this issue, the
solution was to educate the user. There might be some work around (custom code
or API level changes - not sure) OR you may plan to get this information from
your web application and then call the report. But once the report is rendered,
you really don't have the control...
I would also be interested in hearing any solution to this issue.
Regards,
Shrinath Inamdar
View other groups in this category.
To stop getting this e-mail, or change how often it arrives, go to your
E-mail Settings.
Need help? If you've forgotten your password, please go to
Passport Member Services.
For other questions or feedback, go to our
Contact Us page.
If you do not want to receive future e-mail from this MSN group, or if you
received this message by mistake, please click the "Remove" link below. On the
pre-addressed e-mail message that opens, simply click "Send". Your e-mail
address will be deleted from this group's mailing list.
Remove my e-mail address from BDOTNET.
-----------------------------------------------------------
To stop getting this e-mail, or change how often it arrives, go to your E-mail
Settings.
http://groups.msn.com/bdotnet/_emailsettings.msnw
Need help? If you've forgotten your password, please go to Passport Member
Services.
http://groups.msn.com/_passportredir.msnw?ppmprop=help
For other questions or feedback, go to our Contact Us page.
http://groups.msn.com/contact
If you do not want to receive future e-mail from this MSN group, or if you
received this message by mistake, please click the "Remove" link below. On the
pre-addressed e-mail message that opens, simply click "Send". Your e-mail
address will be deleted from this group's mailing list.
mailto:[EMAIL PROTECTED]
