Search results for query: *

Hello all; I'm working on a report that uses parameter input on the date field of a table. What I've done is use the Criteria between (enter start date) and (enter end date) to pull the correct data. Which works well. I also created a subquery to count the total number and obtain the first date...

Hi, I have an interesting request from a site owner. she will be publishing all of her protocols on our Intranet Sharepoint site. She will be the only one updating documents. What she wants is for all of her users to only get the protocols from the site. What happens now is that the users...

I need some help. I was playing with changing the design of my <site> homepage, and I applied the template from another site. Instead of applying the site as a template (for its design) it completely replaced my site default page with the new page. how do I restore the <old> site default...

We recently had our netowrk engineer leave the roganization. I'm the content admin for Sharepoint, but I'm not a server or dba guy. Since we've set up sharepoint the e-mail alerts or notifications have never worked. We use exchange and outlook. I can't find anywhere where you create the link...

I'm wanting to use Sharepoint for document libraries of procedures, forms, etc. Is there a way in sharepoint to force a user to check-out a document before editing?

I'm working on using Access for an issue submission form. What I'd like to be able to do is pass their user ID from active Directory to the User ID field in the main table. It can be behind the scenes, just to be pulled for reporting purposes. Most times if I ask users to enter their ID, they...

New to sharepoint, and unfortunately, I'm not a programmer, so please bear with me.... any help would be appreciated. I'm the guinea pig here for Sharepoint, and we've set up a website for a new project. I've created an issues list, but there doesn't appear to be a good way to run reports off...

Anyone got any favorite links to other career-oriented sites for independent IT pros?? Things like sources for whether to incorporate or not, contracting, etc. Enquiring minds want to know! Thanks. Zencalc

So... I'm trying to develop some enterprise-wide views for my company, to hide what we don't care about and see what we do care about. In creating a new View, "A", I chose type "Entry", with no Groups and All Tasks. I want to hide the (worthless)Duration column, and insert the "Work" column...

Hi, I'm having a problem that I need a fresh set of synapses to work on. In project, (desktop 2000 version) I have set up a master resource pool that contains generic job-related resources, (ie. report analyst). In putting together my master project plan (a portfolio, per se) I can then...

I'm creating a survey web page and creating a MS frontpage form to go back into a access db. no problem there, I've done it quite a few times... BUT, here's my dilemna. For the questions, I'd like to have the user choose a value from 1 to 10, or "NA" or <no value> if the question is not...

Hello all; In my select statement, I need to select all records such that (currentdatetime - 1 year < {my.field} > currentdatetime) How do I format the currentdatetime - 1 year part?? Thanks! zen

I have a report that lists the number of orders for many hundred of vendors. I am grouping by the vendor and then want to display the count of the orders, with just the total counts displayed for each vendor, for 2001, 2002, 2003nad then sum total for the three years. I wrote a formula to...

I'm using Crystal Decisions Knowledge Base article c2006981 to print the header only at the top of the page when exporting to csv. Which works great, by the way. But now, I also have to print a second header after every 10,000 records. The conditional formatting for detail sections doesn't...

I have a report format that needs to repeat a header section (and increase the header section counter by 1) after every 1900 entries in the detail section. I'm not very versed in using variables and print state operators, so if someone could help me on this, I'd appreciate it. Brian

I have a phone number field in a report that is a jumble of numbers and/or spaces/ and or dashes, (&quot;-&quot; or &quot; &quot;). My formula to get rid of these characters was if &quot;-&quot; in {EnrCommunicationInfo.CommValue} then Replace ({EnrCommunicationInfo.CommValue},&quot;-&quot...

Does anyone have any tools or resources where I can get some knowledge of writing some very basic scripts? I need to write something to replace a character string, in a csv file, with a [CR], and replace another character string with just a blank space. When I try to use &quot;replace&quot...

The report I'm creating has a header I need to define with formulas and parameters. My problem is how to keep a number, for example, 00, or 00401, to display exactly as I type them in? Another example, I have a 15-digit number field that only has 9 digits, so the field should be...

I have a report that I need to export to CSV. When I do so, however, the header and footer reprints with each row of data. How can I structure the report so that the header only prints at the beginning, and the footer only at the end? remember, this is an export to csv format. Thanks again. Brian

I'm using Crystal to export data into a character separated values file. Does anyone know a way to create a formula to add a line feed character at the end of a set of fields? Or possibly a special character I can add to the design view in the appropriate place? This is only important for...