Privilege Targeting Within Crystal Reports
-
2/3/2012
A lot of times, some subsections of reports should be shown or hidden based on user privileges. The easiest way to handle this is to take advantage of a little-known feature in SQLDBI that provides this for you. If your report accepts a parameter called SQLDBIUserId or @SQLDBIUserId (if the parameter is fed to a stored procedure), SQLDBI will automatically populate the report parameter with the user ID for the user that is currently logged in and running the report.
Obviously, this is somewhat limited as privileges are rarely granted to individual users, which pushes the work of determining the privilege set onto the report developer. However, SQLDBI also provides the ability to pass the set of groups the current user belongs to the report. This can be done by including a report parameter named SQLDBIGroupIds. This parameter should be set to allow multiple values and should be a numeric type. Unfortunately, Crystal does not allow multiple values to be passed to a stored procedure so there is no option to pass these values to a stored procedure (using something like @SQLDBIGroupIds), but at least the option exists for specifying display options within the report itself.
Diagnosing Large Publisher Files
-
7/11/2011
If you have a site that is generating large publisher files (like > 2MB), one of the first things you may want to check is the contents of the AB_Image table. You can use a query like the following:
SELECT DATALENGTH(Image_Bytes), * FROM AB_Image ORDER BY 1 DESC;
This will allow you to see the size of the images stored in the AB_Image table. In SQLDBI 3.7 (and later), the images are shipped only as needed in the publisher export. In previous versions of SQLDBI, the images are almost always shi... (Read More)
Introducting SQLDBI Tech Tips
-
4/14/2011
Hello, and welcome to Chainbridge Technologies' SQLDBI Tech Tips feed. This feed will provide a series of posts describing various capabilities and features of the SQLDBI product. Please follow us as we take you through some of the new and exciting additions to the product, as well as some of the lesser known, but powerful options the product provides. If there are any topics you would like to get information on, please email us at support@chainbridgetech.com and we will be sure to post it here.... (Read More)