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
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...
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...
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...
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.