Search results for query: *

I read it VERY cafefully, followed instructions and I got: Configuration option 'allow updates' changed from 0 to 1. Run the RECONFIGURE statement to install. Msg 259, Level 16, State 1, Line 2 Ad hoc updates to system catalogs are not allowed. Configuration option 'allow updates' changed...

Hi, I am trying to update a sid field of a database I moved from another server. using update sys.syslogins set sid=0x1E05CBC760218744B42F05FD36E6E333 where name = 'WORKSITEMP' I am getting this error: Msg 259, Level 16, State 1, Line 1 Ad hoc updates to system catalogs are not allowed. what...

Hello, When in INFOVIEW, looking at a report instance. under the schedule link, there are additional scheduling options. Database logon, filters, format, print settings, server groups, events, parameters how do I remove these...

Hello, I want to modify the error message that come up on the logon page in red when a user attempts to logon and has no user name in the enterprise system. What csp page do I modify? I have been looking everywhere. Help!!!!! Thanks in advance.

Hi, Include me in the request as well, this would be a great benefit. TIA; mbfloyd@cps-satx.com

Hello all, How could the sort order in Instance manager be changed. Sort by date instead of by name. Thanks mbfloyd

Thanks alot, mdwyer this works great. And yes I would be interested in grant/deny privileges based on groups, however I have searched other threads and have not been lucky so far. I'll keep checking...again thanks alot. mbfloyd

Thanks mdwyer for your response; I am having a problem with restricting the options; Here is my code: // ADD DATABASE LOGON OPTION TO ACTION LIST IF REPORT REQUIRES IT if(rpi.NeedsLogon) Response.Write("<option value='dblogon'>"+L_DATABASELOGON); // ADD PARAMETERS...

Thanks for your response, However I did used the Advanced option and was unable to get the desired results.

Hello all, I am trying to limit the options available to the users in the Customizing options drop down list. It seems that if I allow the users to schedule or run a report, they also have access to the database logon, destinations, printer options, format, parameters. I would like...

Hi, I am trying to display a max record from multiple tables. example: select a.cust_name, a.cust_address, a.cust_num, b.cust_amt, c.cust_cat from a, b, c where a.cust_num = b.cust_num GROUP BY b.cust_amt order by a.cust_name asc I am getting all records, but I need the max cust_amt record for...

OK..I understand. Unfortunately I am using SAP r/3 Tables for reporting and I know its an Oracle database engine, but the SAP layer allows no access to the database except through basis and that would be a nightmare getting authorization. But I will keep the suggestion in mind just in case...

Thanks for your quick responses, I am using the formula suggested in the first response because the field does have a comma after the last name. It works perfect. THANKS ALOT However the second response suggests a list clean up. How would I proceed with a list cleanup? Thanks

Hello, I am trying to use a field that contains {lastname, firstname middle} to create a report. I want to create a last name search parameter. But how do I do it if what I'm searching on is the left part of a field. I hope I explained this clearly. I am using crystal 8.5. thanks in advance.

Hello there, I am trying to create a custom input parameter. Where I would like to be prompted for last name and all those specific last names appear on the report. sounds simple but I'm stuck on stupid right now. thanks in advance

We currently have the BW and R/3 reporting solution. Our BW system is currently being upgraded, so we are trying to report from R/3. We have the software connections in place and are able to access the R/3 tables, but we are still experimenting with report creation using functions, clusters, and...

Hello, is it possible to make a connection from crystal 8.5 to SAP r/3 logical databases for reporting. if so, please help and explain. Thanks in Advance

Hello, I am trying to create a batch file that retrives a text file (comma delimited)thats created daily and runs an update stored procedure that updates and inserts new records. Such as new employees or updates employees data. Key is employee number and/or table id number. Please help Thanks...

Whenever I restart sql server my users lose access to the tempdb database. foxdev explained that I'm using this database as a default database. How do I not use this database as a default and continue to let my users have access to the database. Please help!!!

I need some help with the tempdb database. Everytime I restart sql server my user logins become invalid. I get a message that server user is not a valid user of database tempdb. Then I have to go an give each user tempdb access for them to use the application. I know I'm doing something...