I have a view which consists of 4 tabme with 2 outer joins on these tables, however this view takes a very long time to open the main parent table has 1.6 million records in it, the view takes 10 to 15 mins to open, any suggestion that I can use to improve the performace on the view opening...
I have a cross tab report, on which I want the average of something, I have calculated the average in a formula however the crosstab has 10 lines in which there is only a culculated average in one, however the total average is determined on the average of the 10 lines how do I supress tha the...
Thanks
It is such a pity that they have creaded the functions and a simple change of allowing the printdate to be changed ,you have to now build what these functions literally do.
Thanks once again
SkyhiKeeper
Hi Gary
It is actually not a filter that I want to use it for we, need to change the printdate so that the age functions (age0to30) work properly otherwise the aging functions change daily and we would like to run the aging on any day byt backdated.
Terence
How do I set the print date dynamically I do not want to have to go into the set print date and time menu oprion , i want to prime the value from a parameter, How is this possible
Terence
Yes the camera on the server worked fine, It seems that there is no way actually to say to the camera driver which usb port to use, I would asume that if this wa possible then you could use a redirected port.
Have tried to test this and if I look at the printers setup it idicates the new USB Shared port, however I cannot get the local camera working in the terminal server session.....
That looks good, I am not to ofay with vbscript but it loos like it is just a matter of editing a registry key or am I incorrect, following this if it is just the reg key would I be able to edit it through regedt32 ?
When I try and select a hyperlink in a email or when I try select a link in excel i get the following error
"This operation has been canceled due to restrictions in effect on this computer. Please contact your system administrator."
This is a stand alone pc I am the administrator...
Is it possible to pass a field in the resulting report to the mapi export email address ?
eg the report returns
joe soap , 1234, joe@soap.com
is it possible to send the joe@soap.com to the report export so that you don't have to type the address in ?
The user has access to the network, and the database access is adiquate, the user being used to run the report is not the user that is logged on I am using Database authentication. If you logon as administrtor on themachine it works if you log on as the user you get the error, however if 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.