Posts Topics Forums Images
Search videos from message boards Videos Search messages from microblogs Microblogs Search messages from imdb.com Imdb Search messages from yuku.com Yuku Search messages from lefora.com (free forums) Lefora
My account: Login | Sign Up
Loading... 

Thread: Limit What Records From Table Can Be Seen
Started 1 month ago by jannoth
I have an unusual problem ... Somehow, I need to develop a report to be run by various users with varying rights to see data. They'd all be using CRXI (ie not just a Viewer) and be on a LAN. Basically, I have no idea whether it's possible to link to a certain table BUT hide sensitive data from certain users? Eg, by password / LAN username / magic??? Can anyone help please?
Site: Tek-Tips Forums  Tek-Tips Forums - site profile
Forum: Business Objects: Crystal Reports 2 Data Access  Business Objects: Crystal Reports 2 Data Access - forum profile
Total authors: 3 authors
Total thread posts: 11 posts
Thread activity: no new posts during last week
Domain info for: tek-tips.com

Other posts in this thread:

Turkbear replied 1 month ago
Hi, If they are using the full CR, the only way I see to limit what they see is to create separate views of the data in the database and only grant each user access to 'their' view based on the user/pass combo they enter when connecting to the datasource. To Paraphrase:"The Help you get is proportional to the Help you give.."
Size: 596 bytes
Customize:  Customize "<b>Reply 1</b>: Limit What Records From Table Can Be Seen :: Business Objects: Crystal Reports 2 Data Access :: Tek-Tips Forums"

jstangel replied 1 month ago
Is your report using a Business View? If so, you can use row and column security to hide data based on their Enterprise rights.
Size: 193 bytes
Customize:  Customize "<b>Reply 2</b>: Limit What Records From Table Can Be Seen :: Business Objects: Crystal Reports 2 Data Access :: Tek-Tips Forums"

jannoth replied 1 month ago
The report isn't designed yet but at least initially, the data will be in a straight SQL table. But, using an SQL View instead would be no problem, except that I don't know the meaning of "Business View" - I'll try to look it up ASAP ... unless you would care to explain please? Thank you. J
Size: 385 bytes
Customize:  Customize "<b>Reply 3</b>: Limit What Records From Table Can Be Seen :: Business Objects: Crystal Reports 2 Data Access :: Tek-Tips Forums"

jstangel replied 1 month ago
In CRXI you can create a business view on Enterprise. Personally I love them and they are very simple to create and if you have a lot of different tables you regularly report off of, they are extremely useful. Basically you have a central place where you pull in all of your tables and link them. Then you add fields from the tables and can rename the fields. As db's often have odd names for ...
Size: 903 bytes
Customize:  Customize "<b>Reply 4</b>: Limit What Records From Table Can Be Seen :: Business Objects: Crystal Reports 2 Data Access :: Tek-Tips Forums"

jannoth replied 1 month ago
Thanks - loads to play with now (so much that I don't know!). I really appreciate it. J
Size: 168 bytes
Customize:  Customize "<b>Reply 5</b>: Limit What Records From Table Can Be Seen :: Business Objects: Crystal Reports 2 Data Access :: Tek-Tips Forums"

jstangel replied 1 month ago
Just a little hint. When we changed to CRXI here from CR9, the powers that be decided to make me responsible for the entire server (which I had no experience in) instead of just writing reports. I got myself "The Complete Reference Crystal Reports XI" and it has been an invaluable tool. I have continued using it as a reference even 2 years later. It walks you through a lot of things ...
Size: 992 bytes
Customize:  Customize "<b>Reply 6</b>: Limit What Records From Table Can Be Seen :: Business Objects: Crystal Reports 2 Data Access :: Tek-Tips Forums"

jannoth replied 1 month ago
Wow, you have been so helpful, thanks jstangel. I'm in the UK and just checked Amazon - the 2008 version is actually cheaper than CRXI - weird, huh? I guess I'll also start bugging our IT Dept to upgrade cos 2-3 of the new features are quite nifty. Cheers again!
Size: 356 bytes
Customize:  Customize "<b>Reply 7</b>: Limit What Records From Table Can Be Seen :: Business Objects: Crystal Reports 2 Data Access :: Tek-Tips Forums"

Turkbear replied 1 month ago
Hi, Just to add my 2c into this: I did not use Business Views even though we had the full set of Business Objects tools because I did not want to be limited in what reporting system we might want to use in the future ( or even now, with other apps) - there is not much, if anything, you can do with Business Views that cannot be done with the database's own view creating ability and those views ...
Size: 782 bytes
Customize:  Customize "<b>Reply 8</b>: Limit What Records From Table Can Be Seen :: Business Objects: Crystal Reports 2 Data Access :: Tek-Tips Forums"

jstangel replied 1 month ago
Absolutely correct Turkbear, I do have some reports I don't use my business views for. In my specific case, I don't have the knowledge (or access) to create views from my databases so I love being able to take full advantage of the business view capabilities. Your specific reporting needs should definitely be considered to determine what works best. No problem jannoth, glad I could be of ...
Size: 753 bytes
Customize:  Customize "<b>Reply 9</b>: Limit What Records From Table Can Be Seen :: Business Objects: Crystal Reports 2 Data Access :: Tek-Tips Forums"

Turkbear replied 1 month ago
Hi, As with most IT stuff, you use the tools that you need to get the job done. Whatever gets you through the day is a good thing.... To Paraphrase:"The Help you get is proportional to the Help you give.."
Size: 494 bytes
Customize:  Customize "<b>Reply 10</b>: Limit What Records From Table Can Be Seen :: Business Objects: Crystal Reports 2 Data Access :: Tek-Tips Forums"

 

Top contributing authors

Name
Posts
jannoth
4
user's latest post:
Limit What Records From Table...
Published (2009-11-09 04:08:00)
Wow, you have been so helpful, thanks jstangel. I'm in the UK and just checked Amazon - the 2008 version is actually cheaper than CRXI - weird, huh? I guess I'll also start bugging our IT Dept to upgrade cos 2-3 of the new features are quite nifty. Cheers again!
jstangel
4
user's latest post:
Limit What Records From Table...
Published (2009-11-09 11:35:00)
Absolutely correct Turkbear, I do have some reports I don't use my business views for.&nbsp;&nbsp;In my specific case, I don't have the knowledge (or access) to create views from my databases so I love being able to take full advantage of the business view capabilities.&nbsp;&nbsp;Your specific reporting needs should definitely be considered to determine what works best. No problem jannoth, glad I could be of...
Turkbear
3
user's latest post:
Limit What Records From Table...
Published (2009-11-09 12:00:00)
Hi, As with most IT stuff, you use the tools that you need to get the job done. Whatever gets you through the day is a good thing.... &nbsp; To Paraphrase:"The Help you get is proportional to the Help you give.."

Related threads on "Tek-Tips Forums":

Limit records based on login  Tek-Tips Forums - site profile Microsoft: Access Modules (VBA Coding) - forum profile Limit records based on login
Limit records based on login
Limit records returned by a Totals query according to Max...  Tek-Tips Forums - site profile Microsoft: Access Queries and JET SQL - forum profile Limit records returned by a Totals query according to Max field
Limit records returned by a Totals query according to Max field
Save top N number of records in table and delete rest of...  Tek-Tips Forums - site profile Microsoft SQL Server: Programming - forum profile Save top N number of records in table and delete rest of records
Save top N number of records in table and delete rest of records
Selecting records where joining table has most records  Tek-Tips Forums - site profile MySQL AB: MySQL - forum profile Selecting records where joining table has most records
Selecting records where joining table has most records
How to transfer specific records from Table_1 to Table_2?  Tek-Tips Forums - site profile Microsoft: Access Tables and Relationships - forum profile How to transfer specific records from Table_1 to Table_2?
How to transfer specific records from Table_1 to Table_2?
How do I exclude records in one table based on a second...  Tek-Tips Forums - site profile Business Objects: Crystal Reports 1 Formulas - forum profile How do I exclude records in one table based on a second table?
How do I exclude records in one table based on a second table?
Combine PK with Table Records and Insert into other table  Tek-Tips Forums - site profile Microsoft: ASP.NET - forum profile Combine PK with Table Records and Insert into other table
Combine PK with Table Records and Insert into other table
Crystal Server records limit?  Tek-Tips Forums - site profile Business Objects:Crystal Enterprise - forum profile Crystal Server records limit?
Crystal Server records limit?
Limit the number of shown records  Tek-Tips Forums - site profile Business Objects: Crystal Reports 1 Formulas - forum profile Limit the number of shown records
Limit the number of shown records
Table resizes with window, but set maximum limit?  Tek-Tips Forums - site profile HTML, XHTML & CSS (Cascading Style Sheets) - forum profile Table resizes with window, but set maximum limit?
Table resizes with window, but set maximum limit?

Related threads on other sites:

Does Access still limit #records in a table? Where do i...  Discussions in microsoft.public.access.reports - site profile microsoft.public.access.reports - forum profile Does Access still limit #records in a table? Where do i fix? in microsoft.public.access.reports
Does Access still limit #records in a table? Where do i fix? in microsoft.public.access.reports
Limit records in a table  MDBMakers.com - Powered by vBulletin - site profile Database Design - forum profile Limit records in a table
Limit records in a table
Just seen a 'Deep Stack' Pot-Limit Holdem table on Full...  Twitter / tmte - site profile tmte - forum profile Just seen a 'Deep Stack' Pot-Limit Holdem table on Full Tilt. Possibly the daftest thing ever! Doh! 10:48 AM May 15th from Echofon
Just seen a 'Deep Stack' Pot-Limit Holdem table on Full Tilt. Possibly the daftest thing ever! Doh! 10:48 AM May 15th from Echofon
Does Access still limit #records in a table? Where do i fix?  Microsoft Office (Excel, Word) forum - OfficeFrustration - site profile Setting Up & Running Reports - forum profile Does Access still limit #records in a table? Where do i fix?
Does Access still limit #records in a table? Where do i fix?
So is the Master P phase finally gone... Did No Limit...  Message Board Basketball Forum - InsideHoops - site profile Off the Court Lounge - forum profile So is the Master P phase finally gone... Did No Limit Records have a Limit?
So is the Master P phase finally gone... Did No Limit Records have a Limit?
G-Unit Records Vs No Limit Records  www.realestniggas.com - site profile Da Lounge - forum profile G-Unit Records Vs No Limit Records
G-Unit Records Vs No Limit Records
No Limit Records vs. Cash Money Records  Nike Talk - Message Board - Yuku - site profile Music - forum profile No Limit Records vs. Cash Money Records
No Limit Records vs. Cash Money Records
How to: Limit records to logged in user's records  Iron Speed - site profile Iron Speed Designer V2.X - forum profile How to: Limit records to logged in user's records
How to: Limit records to logged in user's records
Help Updating records table from table  MSDN Forums - site profile Transact-SQL - forum profile Help Updating records table from table
Help Updating records table from table
InDesign tip: Need a super-tall table cell? You can...  Twitter / dblatner - site profile dblatner - forum profile InDesign tip: Need a super-tall table cell? You can increase the maximum cell height limit in Table &gt; Cell Options &gt; Rows & Columns. 07:26 AM September 04, 2008 from web
InDesign tip: Need a super-tall table cell? You can increase the maximum cell height limit in Table &gt; Cell Options &gt; Rows & Columns. 07:26 AM September 04, 2008 from web
Thread profile page for "Limit What Records From Table Can Be Seen" on http://www.tek-tips.com. This report page is a snippet summary view from a single thread "Limit What Records From Table Can Be Seen", located on the Message Board at http://www.tek-tips.com. This thread profile page shows the thread statistics for: Total Authors, Total Thread Posts, and Thread Activity