I have just tried adding the fact table to its very own cube and then processing. Exactly the same thing has happened. The data is there but the browser has...

I have just deleted the data source and then set everything up all over again and I am still getting exactly the same issue.

Still no further with this one. :crying:

Would you say that if you want to go to the lowest level and parameterise a person its best to use the ROLAP data?...

That was the first thing I tried.

In report Report Parameters I made available values None Queried and set default values to NULL.

Preview....

Add a child ID to the parameter box...

I have the data set, set up in the Analysis Services data set creation pane.

I have the Child up at the top in the dimension window. I have checked...

Create 3 new facts for every question based on the age groups and its all working fine now 🙂

Thanks

Still at a loss with the report.

The problem with creating pre the report is that the data is coming from a cube. The DOB is in the child dimension and...

Thats where its going wrong.

The summary details I just wanted in a text box at the top of the page. not in a table.

I do have a table but I...

so annoying.

I have created another textbox in my table

=SWITCH(reportitems!Ageasat.Value>=16, 1,TRUE,0)

and called it Over16_1_Closed

I run it and I have a 1 against all my over 16 pupils. I then go...

Wow, Some of its working.

I have added this to a new field

=SWITCH(reportitems!Ageasat.Value>=16, "Over 16",

reportitems!Ageasat.Value<=5, "Under 5",

reportitems!Ageasat.Value>5 and reportitems!Ageasat.Value<16, "between 5 and 16",

TRUE,"Not one of the above categories")

Which brings up an...

Thank you so much.

It works and my data source is much quicker too.

Ive added my screen shots to http://my.opera.com/DebzE/blog/reporting-services-using-analysis-services-data-source-showing-facts-at-pupi

I wouldnt have been able to figure that one...

Ive been screenshotting the issue here....

http://my.opera.com/DebzE/blog/reporting-services-using-analysis-services-data-source-showing-facts-at-pupi

Managed to update to Preserve but Im still getting 0's coming through.

I used this as instructions on how to do it...

http://msdn.microsoft.com/en-us/library/ms345138(SQL.90).aspx

Fantastic,

I will have a look at that and let you know how it goes

Debbie

I do apologise. I do not wish to 'flabbergast ' any one. post withdrawn.

stevefromOZ (6/1/2010)

---

Stewart is right, I regularly connect to the office domain using a VPN connection and work will all of the mentioned services and more.

Keep in mind that to connect...