i am using crystal 8.5 standard edition. I dont have the "report compiler" people are talking about if you know how i can get it or is it just for dev edition? I just want teh report basically its check register after date is specified automatically export the report to a text file. We are...
Ok i created a custom crystal report we are using macola 7.6.300b and i have the rpt file. How do i integrate it into the menu like AP right after check history under reports. I know i can create a shortcut but thats not what i want to do....
Thanks i will try that here is the text of error i had but I think your reg fix should fix it. Thanks again.
MSL Technical Error Info:
An error occured in MacMSL.dll (ver. 76.300.10.5)
DB Provider Error: Native Error number: 0
Error number: 0x80004005
Timeout expired
COM Error: Error
Code =...
i have a database for a company running on sql srv 7. There are two databases over 1 gig each. They work fine but on reports it takes forever to generate. I do see 40 to 100 locks on database but not much is happening on there while its running the reports. I know that there is a limit set...
ok i got sql 7 desktop edition running with Macola 7.6.300b its about 1 gig in size. Some of the reports run really slow. Is there a way to speed up desktop edition? i know there are limits ... other then upgrading what can i do? I got 3 gigs of ram and raid 5 ....
It is actually a development enviroment ...
Another quick question does the "personal edition" of sql come bundled with std or ent? or is it separate cd??
I had a few questins:
what happens if database exeeds 2 gigs on sql server 7 msde?
(is there a 2 gig limit on sql server 7 pe? and would msde upgrade to pe ? )
Is there a way to upgrade from sql 7 msde to sql server 2k developer? (on a 2k pro machine) After upgrade can the clients still...
just switching between screens was really slow like actually opeing up lets say Customer screen in ar or ap. What i did was to reboot the Macola server and do offline reindex of database its flying now!
we got macola 7.6spb running sql and its very slow switching between screens like ap to ar or opening something up withing each of those modules. Once it opens up its fast ... like reports run fast its just switching between screens is very slow.
ok i got a field its a string ... I need to create a text box that will print lets say one * if the contents contains 10 and ** if contents contains 7.5. The string has alot of alphanumerical data sometimes not just the 10 and 7.5... How do I do this? I am using 8.5.
Thanks
Is there a way to convert report saved in v11 back to version 8.5?? Also cani publish Reports on the web with ability for users to input parameter w/o the C.R. Server ?
Would scripts like this help? Or its pointless just using tuning is a better way ? (which by the way didnt work on my database its named DATA_10 sorry not much knowledge in programming)
/*
Defrag or re-index all indecies
*/
DECLARE @TableName sysname
DECLARE @IndexName VARCHAR(100)
DECLARE...
Hi guys
I found this script on the net to reindex and defrag my databases... doesn’t seem to work ... I am not a programmer so any help would be appreciated. Also is there a way to rebuild them or does this do that to?
/*
Defrag or re-index all indecies
*/
DECLARE @TableName sysname
DECLARE...
hey can someone finetune this sql code to work with macola :) Sorry its rather long....
/*
Defrag or re-index all indecies
*/
DECLARE @TableName sysname
DECLARE @IndexName VARCHAR(100)
DECLARE @indid int
DECLARE cur_tblfetch CURSOR FOR
SELECT name from sysobjects where xtype='U'
OPEN...
Anyone have experience in optimizing the database?
Would you just use the tools in SQL maintenance to resize freespace ... reindex ... or have you guys tried something more? I came across a vendor http://www.quickshift.com they claim to at least double the speed. I am going to try this and will...
How about memory and database size ... how are they related ? I got 2 gigs of ram and 2 databases running one is about 1 gig and other one is about 2 ... will this also impact it?
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.