We have an existing SQL Server login that has specific permissions. We would like to keep this login and have a new windows auth login (FRED) have the same permissions as the SQL login (legacy) without having to recreate the windows auth login with all the permissions of the SQL Server login...
I have a database that has 5M rows of data in it. The table is setup as such:
Invoice Table
Date
Salesperson
State
Cost
We are trying to get a query that shows the 5 sales people with the most sales $ PER STATE.
Thanks for the help.
I have a report created in Crystal 8.0 that has hyperlinks set to a particular field in the database. If this field exceeds 86 characters then other fields start disappearing from the report. The formula I am using for the hyperlink is a follows:
if ({TGD0.FK_L_0_0_2}='') or...
We have an application that uses PESetFieldMapping to remap fields that are no longer in the data to a blank field. We have been successful in using this up to a point. On one report, it always gives us an application error when the report starts to read records. Has anyone else ever...
On a Novell network, that doesn't have DNS, WINS or NDS, how would you go about getting the machine name of a remote computer given that you have the IP Address? (NBTStat doesn't seem to work.)
Any help would be greatly appreciated. Thanks.
On a Novell network, that doesn't have DNS, WINS or NDS, how would you go about getting the machine name of a remote computer given that you have the IP Address? (NBTStat doesn't seem to work.)
Any help would be greatly appreciated. Thanks.
On a Novell network, that doesn't have DNS, WINS or NDS, how would you go about getting the machine name of a remote computer given that you have the IP Address? (NBTStat doesn't seem to work.)
Any help would be greatly appreciated. Thanks.
Is is possible to print the first and last record on a page at the top of that page? This would be used for a Company directory purpose. If this is possible, then how would it be accomplished.
I am using Visual C++ along with CRPE API to export reports via HTML. We need these reports to go out on a scheduled basis with no user intervention. As far as we can tell, there is no way to set the HTML export to go to one page instead of multiple pages without doing so via the dialog popup...
I have a report that I need to let the user specify which ports not to include. The easiest way to do this that I have found is, using a parameter, asking the user for the ports to not include. This parameter then becomes an array. When I try to use the Selection Formula to not include the...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.