Search results for query: *

Cancel that - I think that I have it working now - I removed the view, and joined directly to the tables instead, and it seems to be working OK... Sometimes it just takes writing it down to set you on a new track... Sorry for any inconvenience!

I am using an Access2000 ADP, connecting to a SQL 2000 backend. I have a datasheet that is based on the sql statement below SELECT VariousFields FROM Detail D INNER JOIN Product P ON D.ProductCode = P.ProductCode INNER JOIN Master M ON D.RefNo = M.RefNo LEFT OUTER JOIN...

Thanks very much for your help! I think that is more than likely the problem, as I am pretty sure I have 1.1 installed. Will have to try it on another machine. I believe that you coded this - looks like it is an excellent tool (from screenshots and comments above) - a demo on the web site...

I can't seem to get this to run... I keep getting the following error: ShowCatalogs: xfaultcode ->XMLAnalysisError.88BA0500 xfaultstring-> Unable to process the request because the DataSourceInfo property was missing or not correctly specified. xfaultsoap-> My datasource is defined as...

Hi Sarkman - thanks for those links, they're very helpful... FYI, I got the query to work as I wanted, using the following MDX SELECT {[Banner].[Banner Code].Members, [All Banner]} on Columns, {{[Territory].[Region Name].Members, [All Territory]} * { [Measures].[Cust Count],[Measures].[Percent...

Hmmmmm...Ok - will have to rethink how I display the info then... Thanks very much for your help - I really appreciate you putting the time in to give me a hand on this!! I have been having real trouble trying to get my head around MDX queries - can you recommend a good site or reference...

Hi Sarkman, Thanks very much for your help. That will certainly help me to calculate the count of customers and the percentage of total in my cube. Is it possible to add another dimension on the columns, so that I would have Corporate Banners on the columns, Regions on the rows, and two rows...

I have constructed a sales cube (using MS SQL Server) Customers can be grouped by Region, and also by Corporate Banner (eg Caltex, McDonalds) SalesItem is the fact table, and there are two dimensions - Customer.Region and Customer.Banner I am trying to build a query that will display the count...

thanks for your help and your prompt replies...will give it a try!!!

Yeah - I figured that - couldn't find any documentation on ~ within VS IDE or on msdn....any ideas on how to do it html?

Hi umairms, Thanks very much for your help - that is just what I was looking for, and works well from code. Do you know how to do the same thing from an html page? - I want to set the <link> tag to point to a stylesheet, which will always be in the same location relative to the root directory...

How do I return the root directory of the current project?? I have developed a web control that will be used on a number of pages, but it always references a file that is in the root directory of the current project (same location as web.config etc). How can I ensure that it always points back...

This should be very easy, but I can't seem to work out how to do it... I have a web application which I have developed in VS.net (c#) Initially, when I set up the web app, I mapped it to a virtual directory that was two levels deep ie if &quot;VirtualDirectory1&quot; is a virtual directory...