I have attached a table and some data plus a very simple query.

Sorry I should be clearer. leave the query as it is but display the data in a reporting services table, you can then use the job number a s a...

You could try putting the data into a table and grouping the table by job number.

proof reading is everything

if you dont match keys you get odd results

I only spoted it after going and doing something else for half an hour and then returning to...

Apex SQL edit , but here is one from SSMS

and the ddl

balance isn't in the Matter table, but as there is one trust for table for the matter table joined on the matter_uno field, the result should be the same every...

would this work ?

SELECT ([Date].[Calendar].[Calendar Year].&[2004],{[Measures].[Internet Sales Amount]}) on columns,

non empty ({[Customer].[Customer Geography].[Customer].[Roger B. Jones],[Customer].[Customer Geography].[Customer].[Customer Key]})

on rows

FROM [Adventure Works]

I dont have the adventure works DB on my machine...

I used WROX SQL Server Analysis services with MDX to start me off and then lots of googling different ideas, you can usualy find some thing close to what you...

Sometimes you need to go through the XML line by line until you find that somewhere in the past you have edited it so that the parameter has now got...

Ones the data source is setup the design interface for SSAS cube is good enough for most basic queries, adding parameters isn't difficult and once you start getting the hang...

I have had many of the same problems with people pushing out hotfixes without letting me know what was about to happen and then wondering why printing failed.

I have installed...

Using SSRS you can have multiple datasets each with an individual query, you can even have them querying separate database servers

Great article, I 've been able to apply it to a pain in the neck I've been working on, but at the risk of looking like a thicko --:D I...

Crystal reports XI will work with sql 2005 databases and analysis services cubes, you might need to make sure you have all the relavent sql drivers on the pc running...

It seems to be an access problem with the OLAP database,

can you process the cube from management studio?

does the agent have the correct security to access the OLAP database?

have...