Search results for query: *

Ever wanted to show multiple pivot tables on 1 sheet for analysis but couldn;t because of the danger of them overlapping when refreshed or when options are changed? This link has the answer: nifty camera usage Baically, you add the vastly underrated camera tool to your quick access toolbar...

Hi - relatively new user to ASP.NET and we have a bit of an odd implementation which is giving issues for a couple of users setup is that we have field based users who have IIS & SQL Express installed on their laptops with an ASP.NET app in the wwwroot folder The app location is set up to be a...

Hi In excel, when I try to use File>Send To> Mail recipient (as attachment) the email window pops up fine but when I hit "send" nothing happens I can create a new mail in Outlook, attach the file and send just fine I can send the file in the body of the email - it just won't let me send as an...

Hi all, just looking for general best practice and possibly a rationale for which would be the best way to approach this issue: I have a query which has 9 individual queries unioned together - the database table design requires this :-( I need to be able to restrict data into these...

Hello all, I have the following table layout: BusinessUnit | TimeKey | ExpectedBeer | ActualBeer |Expected Cider | ActualCider etc etc for 8 varieties of drinks There are 3 timekeys that I am interested in for each BusinessUnit (report will run for 1 BusinessUnit ID at a time so not a...

Hi, I have a report that includes a matrix control. Within some of the columns, I wish to apply different formatting to change negative numbers to red. Currently I do this by applying a format of #,##0.0 to the format property of the cells and =iif(Fields!PerVarLY.Value < 0...

Hi all - not a SQL expert by any stretch of the imagination although I have moved on from GUI generated SQL to writing my own. I don't know a huge amount about query optimising but myself and a colleague were just discussing whether it was better / faster to use IN or a set of multiple OR...

Hi, looking for a way (may well be API calls) to force a messagebox to appear on top of all other apps. We have a system where user downloads 2 specific files from our intranet site each week. Users are field based and therefore impatient so they switch to other apps whilst this happens...

Hi - having some issues with uploading a date into an SQL Server table. Data is in MS Excel and I am using VBA to try to insert recrods into a control table. The following works (kind of): Dim strCon As ADODB.Connection Set strCon = New ADODB.Connection stDate = Now strCon.Open...

Well, I guess that's pretty much it... I have a pretty complicated report with lots of queries - most of which are interlinked via synchronisation. The data from these charts is sales by time and comes from 2 queries which are fully linked on all dimensions. They are also linked to the rest of...

Hi, hope this is the right forum - it is the only area that came up on a search for "Active Directory". I'm very green when it comes to Active Directory and had not even heard of LDAP before my boss asked me to look into ways of querying AD. Does anyone have any pointers / good references...

Hi, don't even know if this ispossible so am looking for a push in the right direction if it is...... What I would like to do is obtain the userID (network) of the person calling a report. I would then need to test this userID against which Active Directory groups they are a member of. This...

as per subject, I am trying to resize the HEader row on a matrix control. There are about 9 data columns and 3 groups and there are 4 matrix controls stacked vertically. Only the top matrix control needs headers but I cannot seem to reduce the row height of the header. Whatever I set it at, it...

Hi, trying to set the font colour for a formula based on its result: The formula is: =sum( Fields!PD_Sales_Var_LY.Value)/sum( Fields!PD_Sales_LY.Value) which is a % variance to Last Year calculation. If last year's value is 0 then this will produce an error so I am testing for that 1st and...

Hi, as per subject title, I am trying to find out if you can test the visible state of a control in the report. I have a matrix control which is set up with 3 groups. Groups 2 is dependant on group 1 and group 3 on group 2 with initial visibility property set by a report parameter. The issue...

'lo all, just been upgraded to Office 2003 and it seems the help file behaviour is different from that I am used to. The help files seem to be docking with the excel window (or Word etc) and reducing the screen size. Does anyone know where the setting is (there must be one) to turn this...

As per the subject title - I need to refer to a dataset value in a custom code function. In a textbox, this would look like: =Sum(Fields!BeerMATVar.Value, "KPIs") Can't seem to find the syntax for doing this in code though. I could pass through as an argument I'm sure but there's about 30 bits...

AS per the subject, I am trying to make a section or an RS report conditionally be either visible or hidden. I have a report parameter set up with 2 options that result in a 1 or 0 return value. I am then trying to interrogate this value within the expression setting of the 'Initial State' part...

'lo all, just been 'up'graded to Office 2003 from XP. It used to be that if I entered my windows username into the 'To' box and pressed Ctrl+K, it would resolve the name in the same way it does partial entries. It would appear that this feature is no longer active in my version of...

Hello all, not great on SQL but I can get by - running into a bit of an issue that I can't seem to get round.... Using MS Reporting Services over a SQL Server database Data is currently held like: AGM ID | Product Type | Tied Flag 1234 | Ales | Y 1234 | Lager | Y...