build error, MDX reports

I get this error for some of my reports, it only happens for my MDX reports
and even then it is not all of them. They have all worked at some point or
another but recently this has started to happen
The expression for the query 'DataSet1' contains an error: [BC306481] String
constants must end with a double quote.
here's the code from dataSet1 of one of my reports
= "WITH" & " MEMBER [Measures].[Percentage Pref]" & "
AS"&" 'iif(isempty([Measures].[Number]),CDBl(0),"&" iif( sum(
{Ancestor([Preference Status].CurrentMember,1) } , [Measures].[Number]) = 0, 0,"&" cdbl(cdbl( [Measures].[Number]) / sum( {Ancestor([Preference
Status].CurrentMember,1) }, [Measures].[Number]) )))' " &
"select " &
"{[Measures].[Number],[Measures].[Percentage Pref]} on columns, " &
"{[Preference Status].[Preference Status].Members} on rows, " &
"{[Preference School].[Preference School LEA].[" & Parameters!LEA.Value &
"]} on pages, " &
"{[Round].[Round].[" & Parameters!Round.Value & "]} on AXIS(3) " &
"from [admissions]"
has the right number of quotes and i know this because they have worked
before, which leads me to believe there is an underlying error somewhere
else.
Any ideas' MSFT guys, this sounds like your area'
thanks
GregFixed this myself, for some unknonw reason you need to put quoates at the
beginning and end of every single line..... any of the MSFT guys wanna
explain why?
This was a very strange error as it has worked before without quotes on
every line.
Greg
"Greg" <Greg.conn@.nospam.nospam> wrote in message
news:epwa4TB$FHA.1548@.TK2MSFTNGP10.phx.gbl...
>I get this error for some of my reports, it only happens for my MDX reports
>and even then it is not all of them. They have all worked at some point or
>another but recently this has started to happen
> The expression for the query 'DataSet1' contains an error: [BC306481]
> String constants must end with a double quote.
> here's the code from dataSet1 of one of my reports
> = "WITH" & " MEMBER [Measures].[Percentage Pref]" & "
> AS"&" 'iif(isempty([Measures].[Number]),CDBl(0),"&" iif( sum(
> {Ancestor([Preference Status].CurrentMember,1) } , [Measures].[Number])
> = 0, 0,"&" cdbl(cdbl( [Measures].[Number]) / sum( {Ancestor([Preference
> Status].CurrentMember,1) }, [Measures].[Number]) )))' " &
> "select " &
> "{[Measures].[Number],[Measures].[Percentage Pref]} on columns, " &
> "{[Preference Status].[Preference Status].Members} on rows, " &
> "{[Preference School].[Preference School LEA].[" & Parameters!LEA.Value &
> "]} on pages, " &
> "{[Round].[Round].[" & Parameters!Round.Value & "]} on AXIS(3) " &
> "from [admissions]"
> has the right number of quotes and i know this because they have worked
> before, which leads me to believe there is an underlying error somewhere
> else.
> Any ideas' MSFT guys, this sounds like your area'
> thanks
> Greg
>
>