Search results for query: *

Its cool. there was a dead notes session running in the background. For some reason this does not effect the manual running of the dts but it stops the sql job in its tracks. SOmething to keep in mind for futur reference.

Hi I have a DTS on our server and when I log on to the machine and manually execute the dts it runs through fine. However when I schedule it and start the job it get through the first step and then stops. I does not error or anything just sits there saying it is running but it is not. Not sure...

This is still not solved some one must have an idea for a solution.

When you link a parameter to a 'list of values' the default value box is no longer available.

Thanks will check that lot out.

Ok here is the skinny I open a version 9 report in XI and save it as XI version. Link the parameters to "list of values" we have set up. Then I run the report. In each of the parameters appears as '...' The next is the drop down list is '...All' After that appears the list of values If you...

Hi Sorry for putting up 2 post but this is a new topic. As in last post I am changing all our v9 crystal reports to xi we currently use crystal enterprise to display the reports to the users on our intranet. We have infoview (which i believe is the xi equivilent) however we dont like the...

Hi I am currently working on converting my companies 1000 or so crystal 9 reports to crystal XI. Some of the reports we have have 15 parameters and how it is currently worked is that all the parameters are defaulted to 'All' and the user can pick things they want to change and limit the result...

Hi I have had to re write a very complex report twice now and with the same outcome. As soon as i try to upload a report into crystal enterprise it corrupts this file and any backups of the file i have Crystal support are giving me the run around by not using english speaking staff. Can anyone help.

Its cool I have done an if. THanks everyone thats great.

THat did work however i cant now save it in place he he he.

Still allows them to save if they do the alt+f4

hey yogia that worked perfectly solving my full screen problem now it is just the saving problem.

Hey CaptainD Yeah they only have access to the ceels that they should however when it closes down (alt+f4) it allows them to 'save as' which we cant have there is some very vital business data stored in here.

Hi I am working on a spread sheet the populates itself completly from sql. THe users have an area they can change and update but I want to stop them using anything else. I have this chunk of code : With Application .DisplayFullScreen = True .CommandBars("Full...

I cant append cos the blank row at the bottom holds the formatting for the user to add new info to the database.

Hey I am doing some complex marco work and come up against a problem. I have 53 columns of different formula pointing at a row on another sheet. later i have to insert a line on that sheet. I want the formula not to change. How is this done? THanks Malc

Hmmmmm I swear i did it once. Its ok now anyway have a grunt going through the code putting isnull(,0) on ever other line. Thanks for the help.

Yes I know that (see the bottom of the original post) Thats what I am trying to avoid. There is a setting such as : SET [Blah] on that will treat all null as zero in any following arithmatics.

Hi I am sure the answer to this is already in here somewhere but it wont let me search the forum. I have inherited a lot of sql code where columns are added together. However recently the tables have changed to allow nulls. Thus all the addition is returning nulls. I know there is something that...