Setting Constraints for a Report Parameter

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 - General » Setting Constraints for a Report Parameter

Setting Constraints for a Report Parameter

Rate Topic

Display Mode

Topic Options

Author

Message

MuraliKrishnan1980

Posted Monday, January 21, 2013 4:23 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, May 08, 2013 12:01 AM
Points: 111, Visits: 1,333

Hi Friends,

I have report which has a Parameter named Account. This Account is a Text Parameter. We can send multiple accounts seperated by Comma. I have a requirement which says that I cannot process more than 5 accounts. So I am looking if there is a way to check this in the Report Parameter.

As a work around, I am checking the no of account passed within the SP used in the Report and I throw an exception if the no of accounts is more than 5. But, I would like to know if we can check this in the Report Parameter itself.

Any help would be appreciated.

Thanks
Murali

Post #1409472

« Prev Topic | Next Topic »

Permissions