Search results for query: *

Thanks as a quick fix i ended up using a query for each line of code in my excel dashboard.(basically separating the unions) I will try to recode using your suggestions One more question My Excel dashboard has another sheet that I created a sql crosstab query for it. It looks great but now I...

unfortunately I am not an expert in sql would i be able to still have a where statement inside each union. Here is one of the sql unions I want FISCALYEAR AND FISCALPERIOD TO =? select ASI.BUSGROUP,SUM(ASI.XTNDPRCE),SUM(ASI.EXTDCOST) from FAIRFIELDSQL.ASI.dbo.OLI80100A ASI left outer join...

HI, I am not sure if I should post in SQL or Office. Can you add parameters in sql if the query is written as a union? I am creating a dashboard in Excel 2003 using sql. I have all the queries done and am now trying to add parameters. IF I only add the question mark for the one part of the...

Hi As a newbie to SSRS I have been struggling with a report that I had to create for MGMT. I have to fit 100 columns and to have it print only on 8.5 x 11 paper (landscape).( I am exaggerating a bit on the columns) Its width is 11in and I use every inch of it to fit my sales numbers, but when...

Hi I am using outlook 2003 and on the left side in the navigation panel I see my mailbox with sub folders underneath. I ended up doing a right click on my Archive folder and choosing close. Does anyone know how to reopen it. Thanks

I have the same issue. Has anyone come up with a solution? Thanks Hope

OK tried that and yes i do get all the info but on the email part I am only getting the cust email for both. I think maybe it is not a joining problem maybe I need an if statement somewhere. I want to see on the same line the cust email and the rep associated with that cust along with the reps...

My tables are as follows Master_Type Master_ID INET1 SLP JG0000 ekjg@.....net CUS A00005 Lees ART SHOP CUSTNMBR CUSTNAME SLPRSNID A00005 LEES ART SHOP JG0000...

Hi I am sure this is an easy one but I just can not get the right data to come out. Crystal 9.2 3 tables Customer, salesperson, Email My problem is the email table. It 3 main fields are master type & master ID and email ID When I try to do I report to show customer id and their email...

It is both internet and company network. Only blocking certain employees from sending PDFs

Hi Wondering if and how can I block certain file attachements from being sent out? For example: I do not want any PDF files being sent out. I have Outlook 2002 running on Windows 2000 Thanks

Hi, Thanks and yes you are right it does default to the floppy. To me there is no problem booting from the cd however my boss wants an emergency repair disk and startup disks from our 2 main servers (on CD). We are having some work done on them and he is worried that they may mess things up so...

Hi I would like to create a bootable cd(Startup). I have win2000 server I put the cd in and went to type the command makeboot I tried telling the command to go to my cd writer but the application failed. It only worked using the floppies. How can I do this. I have read some info on here and...

This worked however I had to chage the parameter to string not number. Thanks and have a great day.

Hi, Sorry but that did not work it is still looking for a string or array

I tried the above and it is telling me there is an error in the formula, it is looking for a string or an array date(tonumber({?Enter Ending Date}

The date string is alway the same. The above did not work. I have Crystal 8.5/ Sql 7.0 database I need the user to enter a beg date and a ending date and the report to grab the data between those dates without time being a factor. Thanks, Hope

Hi I am having a problem with dates here. The field in the table is a string(date/time) ex 20040106 12:01:01.57 I am trying to create a report where the user is promted to enter a item number and the start & ending dates(without time) I have tried a couple of different convert formats...

It did leave my programs intact, however I did have to reinstall/repair Outlook & the printer.

Just an update. I used the win 2000 cd and did an over the top installation. Which let me keep existing programs & settings.