Another Date Picker question

I created a report with two parameters, StartDate and EndDate.

They are specified as datetime type.

When I went to the Preview tab, there were date pickers for both values.

After a week or so of using the report, I thought it would be better if I gave the parameters default values. I spent some time reading what others had done in this forum and used the following as the expressions for the parameters:

Code Snippet

=IIF(Weekday(Today()) =1, FormatDateTime(Today(),2),
IIF(Weekday(Today()) =2, FormatDateTime(Today.AddDays(-1),2),
IIF(Weekday(Today()) =3, FormatDateTime(Today.AddDays(-2),2),
IIF(Weekday(Today()) =4, FormatDateTime(Today.AddDays(-3),2),
IIF(Weekday(Today()) =5, FormatDateTime(Today.AddDays(-4),2),
IIF(Weekday(Today()) =6, FormatDateTime(Today.AddDays(-5),2), FormatDateTime(Today.AddDays(-6),2)))))))

=IIF(Weekday(Today()) =1, FormatDateTime(Today.AddDays(6),2),
IIF(Weekday(Today()) =2, FormatDateTime(Today.AddDays(5),2),
IIF(Weekday(Today()) =3, FormatDateTime(Today.AddDays(4),2),
IIF(Weekday(Today()) =4, FormatDateTime(Today.AddDays(3),2),
IIF(Weekday(Today()) =5, FormatDateTime(Today.AddDays(2),2),
IIF(Weekday(Today()) =6, FormatDateTime(Today.AddDays(1),2), FormatDateTime(Today(),2)))))))

and now, there are no date pickers. I am curious. Why are they gone? Can I get them back and still have my default values?

Thanks,

IanO

Try removing the FormatDateTime function.|||

Thanks for your reply. Allow me to explain why the Format is there.

When I had not specified default values for the report parameters, the date pickers provided values that were dates only - no time values. After I put in the IIFs for the default values, the defaults included 12:00:00 AM with the date.

I hunted for quite a while and the solution that I chose was the Format. Perhaps you have another idea of how I can have a default Sunday and a default Saturday for the current week, without the time?

Thanks,

IanO

|||It's odd that the default values gave you a time. I used it here and had only date values. Hmmmm.|||If you want to keep the format text you should be able to add the cdate function.|||

Code Snippet

=CDATE(IIF(Weekday(Today()) =1, FormatDateTime(Today(),2),
IIF(Weekday(Today()) =2, FormatDateTime(Today.AddDays(-1),2),
IIF(Weekday(Today()) =3, FormatDateTime(Today.AddDays(-2),2),
IIF(Weekday(Today()) =4, FormatDateTime(Today.AddDays(-3),2),
IIF(Weekday(Today()) =5, FormatDateTime(Today.AddDays(-4),2),
IIF(Weekday(Today()) =6, FormatDateTime(Today.AddDays(-5),2), FormatDateTime(Today.AddDays(-6),2))))))))

Code Snippet

=CDATE(IIF(Weekday(Today()) =1, FormatDateTime(Today.AddDays(6),2),
IIF(Weekday(Today()) =2, FormatDateTime(Today.AddDays(5),2),
IIF(Weekday(Today()) =3, FormatDateTime(Today.AddDays(4),2),
IIF(Weekday(Today()) =4, FormatDateTime(Today.AddDays(3),2),
IIF(Weekday(Today()) =5, FormatDateTime(Today.AddDays(2),2),
IIF(Weekday(Today()) =6, FormatDateTime(Today.AddDays(1),2), FormatDateTime(Today(),2))))))))

Then make sure your datatype is date because using just your original expression you get an error if the datatype is not a string.

Simone

another backup question

why are 'transaction log' and 'file and file group' dimmed (not available)
on the general tab of the backup window? (right-click on database, all
tasks, backup database)
I am backing up to a file device and need to set a schedule of 1 daily full
backup and backup of the transaction logs every 1/2 hour.
any help is appreciated.
Because the database is in simple recovery mode.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"djc" <noone@.nowhere.com> wrote in message news:ucbsl59UEHA.3420@.TK2MSFTNGP12.phx.gbl...
> why are 'transaction log' and 'file and file group' dimmed (not available)
> on the general tab of the backup window? (right-click on database, all
> tasks, backup database)
> I am backing up to a file device and need to set a schedule of 1 daily full
> backup and backup of the transaction logs every 1/2 hour.
> any help is appreciated.
>
|||Thank you!
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:uWjcUB%23UEHA.1048@.tk2msftngp13.phx.gbl...
> Because the database is in simple recovery mode.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "djc" <noone@.nowhere.com> wrote in message
news:ucbsl59UEHA.3420@.TK2MSFTNGP12.phx.gbl...[vbcol=seagreen]
available)[vbcol=seagreen]
full
>

another backup question

why are 'transaction log' and 'file and file group' dimmed (not available)
on the general tab of the backup window? (right-click on database, all
tasks, backup database)
I am backing up to a file device and need to set a schedule of 1 daily full
backup and backup of the transaction logs every 1/2 hour.
any help is appreciated.Because the database is in simple recovery mode.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"djc" <noone@.nowhere.com> wrote in message news:ucbsl59UEHA.3420@.TK2MSFTNGP12.phx.gbl...
> why are 'transaction log' and 'file and file group' dimmed (not available)
> on the general tab of the backup window? (right-click on database, all
> tasks, backup database)
> I am backing up to a file device and need to set a schedule of 1 daily full
> backup and backup of the transaction logs every 1/2 hour.
> any help is appreciated.
>|||Thank you!
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:uWjcUB%23UEHA.1048@.tk2msftngp13.phx.gbl...
> Because the database is in simple recovery mode.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "djc" <noone@.nowhere.com> wrote in message
news:ucbsl59UEHA.3420@.TK2MSFTNGP12.phx.gbl...
> > why are 'transaction log' and 'file and file group' dimmed (not
available)
> > on the general tab of the backup window? (right-click on database, all
> > tasks, backup database)
> >
> > I am backing up to a file device and need to set a schedule of 1 daily
full
> > backup and backup of the transaction logs every 1/2 hour.
> >
> > any help is appreciated.
> >
> >
>

And/or filter field not enabled in the group filter tab

Howdy,

I have a table that has a group. In this group, I want to filter by 2 different expressions, concatenated with an OR. BUT I can't change the "And/Or" column value for the first entry because it is grayed out. The column will automatically change to an OR value if both my expression column fields are the same (which I don’t want) but if I put any other value in to the expression field of the second row, the "And/Or" field of the first row automatically changes to an AND.

PLEASE! How do I get the And/Or field "ungrayed" so I can change it to what I want?

The 2 filters I and using check the UserID = to the user, and the other is checking a count to get the Top N 1. (So just showing the current user and the top producer)

The OR gets only enabled if the filter expressions of two filters are identical.

Note: another option is to use OR directly in your filter expression. Example:
Filter expression: =(condition1 OR condition2)
Filter type: =
Filter value: =True

-- Robert

|||

Ok,

Is there any plans to make it a changeable field? a couple online articles made it sound like you could choose, rather than it auto populating.

|||Check the Product Feedback Center

http://lab.msdn.microsoft.com/productfeedback/|||Nathan,

Please corrobate the issue here:

file:///C:/Documents%20and%20Settings/chauvinr/Desktop/MSDN%20Product%20Feedback%20Center.URL

|||

"The OR gets only enabled if the filter expressions of two filters are identical."

Who's idea was this?

What is the logic behind making this kind of decision?

I just can't comprehend someone deisgning an application like RS and saying... "lets ONLY give them an OR if the fields used in the field expression is identical"

|||I couldnt imaginge it too having only identical field to use OR.|||

But I realy need to put a Or with different expressions, like "pruductId< 100 or quantity>10"....
Isn’t it possible?

|||

Yes, it is possible. Take a look at Robert's reply post on this thread.

Jarret

|||Sorry but I can't understand....

Filter expression: =(pruductId< 100 or quantity>10)
Filter type: =
Filter value: = ?

But what I have to put on value?

I will apreciate your help.
Thanks.

|||Put '=True' as the value (without the single quotes).|||it only work with the expression:
=IIf((productId >100 or quantity<200), "True"," False")

Many thanks.

And/or filter field not enabled in the group filter tab

Howdy,

I have a table that has a group. In this group, I want to filter by 2 different expressions, concatenated with an OR. BUT I can't change the "And/Or" column value for the first entry because it is grayed out. The column will automatically change to an OR value if both my expression column fields are the same (which I don’t want) but if I put any other value in to the expression field of the second row, the "And/Or" field of the first row automatically changes to an AND.

PLEASE! How do I get the And/Or field "ungrayed" so I can change it to what I want?

The 2 filters I and using check the UserID = to the user, and the other is checking a count to get the Top N 1. (So just showing the current user and the top producer)

The OR gets only enabled if the filter expressions of two filters are identical.

Note: another option is to use OR directly in your filter expression. Example:
Filter expression: =(condition1 OR condition2)
Filter type: =
Filter value: =True

-- Robert

|||

Ok,

Is there any plans to make it a changeable field? a couple online articles made it sound like you could choose, rather than it auto populating.

|||Check the Product Feedback Center

http://lab.msdn.microsoft.com/productfeedback/|||Nathan,

Please corrobate the issue here:

file:///C:/Documents%20and%20Settings/chauvinr/Desktop/MSDN%20Product%20Feedback%20Center.URL

|||

"The OR gets only enabled if the filter expressions of two filters are identical."

Who's idea was this?

What is the logic behind making this kind of decision?

I just can't comprehend someone deisgning an application like RS and saying... "lets ONLY give them an OR if the fields used in the field expression is identical"

|||I couldnt imaginge it too having only identical field to use OR.|||

But I realy

need to put a Or with different expressions, like "pruductId< 100 or

quantity>10"....

Isn’t it possible?

|||

Yes, it is possible. Take a look at Robert's reply post on this thread.

Jarret

|||Sorry but I can't understand....

Filter expression: =(pruductId< 100 or quantity>10)
Filter type: =
Filter value: = ?

But what I have to put on value?

I will apreciate your help.
Thanks.|||Put '=True' as the value (without the single quotes).|||it only work with the expression:

=IIf((productId >100 or quantity<200),

"True"," False")

Many thanks.

And/or filter field not enabled in the group filter tab

Howdy,

I have a table that has a group. In this group, I want to filter by 2 different expressions, concatenated with an OR. BUT I can't change the "And/Or" column value for the first entry because it is grayed out. The column will automatically change to an OR value if both my expression column fields are the same (which I don’t want) but if I put any other value in to the expression field of the second row, the "And/Or" field of the first row automatically changes to an AND.

PLEASE! How do I get the And/Or field "ungrayed" so I can change it to what I want?

The 2 filters I and using check the UserID = to the user, and the other is checking a count to get the Top N 1. (So just showing the current user and the top producer)

The OR gets only enabled if the filter expressions of two filters are identical.

Note: another option is to use OR directly in your filter expression. Example:
Filter expression: =(condition1 OR condition2)
Filter type: =
Filter value: =True

-- Robert

|||

Ok,

Is there any plans to make it a changeable field? a couple online articles made it sound like you could choose, rather than it auto populating.

|||Check the Product Feedback Center

http://lab.msdn.microsoft.com/productfeedback/|||Nathan,

Please corrobate the issue here:

file:///C:/Documents%20and%20Settings/chauvinr/Desktop/MSDN%20Product%20Feedback%20Center.URL

|||

"The OR gets only enabled if the filter expressions of two filters are identical."

Who's idea was this?

What is the logic behind making this kind of decision?

I just can't comprehend someone deisgning an application like RS and saying... "lets ONLY give them an OR if the fields used in the field expression is identical"

|||I couldnt imaginge it too having only identical field to use OR.|||

But I realy

need to put a Or with different expressions, like "pruductId< 100 or

quantity>10"....

Isn’t it possible?

|||

Yes, it is possible. Take a look at Robert's reply post on this thread.

Jarret

|||Sorry but I can't understand....

Filter expression: =(pruductId< 100 or quantity>10)
Filter type: =
Filter value: = ?

But what I have to put on value?

I will apreciate your help.
Thanks.|||Put '=True' as the value (without the single quotes).|||it only work with the expression:

=IIf((productId >100 or quantity<200),

"True"," False")

Many thanks.

And/or filter field not enabled in the group filter tab

Howdy,

I have a table that has a group. In this group, I want to filter by 2 different expressions, concatenated with an OR. BUT I can't change the "And/Or" column value for the first entry because it is grayed out. The column will automatically change to an OR value if both my expression column fields are the same (which I don’t want) but if I put any other value in to the expression field of the second row, the "And/Or" field of the first row automatically changes to an AND.

PLEASE! How do I get the And/Or field "ungrayed" so I can change it to what I want?

The 2 filters I and using check the UserID = to the user, and the other is checking a count to get the Top N 1. (So just showing the current user and the top producer)

The OR gets only enabled if the filter expressions of two filters are identical.

Note: another option is to use OR directly in your filter expression. Example:
Filter expression: =(condition1 OR condition2)
Filter type: =
Filter value: =True

-- Robert

|||

Ok,

Is there any plans to make it a changeable field? a couple online articles made it sound like you could choose, rather than it auto populating.

|||Check the Product Feedback Center

http://lab.msdn.microsoft.com/productfeedback/|||Nathan,

Please corrobate the issue here:

file:///C:/Documents%20and%20Settings/chauvinr/Desktop/MSDN%20Product%20Feedback%20Center.URL

|||

"The OR gets only enabled if the filter expressions of two filters are identical."

Who's idea was this?

What is the logic behind making this kind of decision?

I just can't comprehend someone deisgning an application like RS and saying... "lets ONLY give them an OR if the fields used in the field expression is identical"

|||I couldnt imaginge it too having only identical field to use OR.|||

But I realy

need to put a Or with different expressions, like "pruductId< 100 or

quantity>10"....

Isn’t it possible?

|||

Yes, it is possible. Take a look at Robert's reply post on this thread.

Jarret

|||Sorry but I can't understand....

Filter expression: =(pruductId< 100 or quantity>10)
Filter type: =
Filter value: = ?

But what I have to put on value?

I will apreciate your help.
Thanks.|||Put '=True' as the value (without the single quotes).|||it only work with the expression:

=IIf((productId >100 or quantity<200),

"True"," False")

Many thanks.

And/or filter field not enabled in the group filter tab

Howdy,

I have a table that has a group. In this group, I want to filter by 2 different expressions, concatenated with an OR. BUT I can't change the "And/Or" column value for the first entry because it is grayed out. The column will automatically change to an OR value if both my expression column fields are the same (which I don’t want) but if I put any other value in to the expression field of the second row, the "And/Or" field of the first row automatically changes to an AND.

PLEASE! How do I get the And/Or field "ungrayed" so I can change it to what I want?

The 2 filters I and using check the UserID = to the user, and the other is checking a count to get the Top N 1. (So just showing the current user and the top producer)

The OR gets only enabled if the filter expressions of two filters are identical.

Note: another option is to use OR directly in your filter expression. Example:
Filter expression: =(condition1 OR condition2)
Filter type: =
Filter value: =True

-- Robert

|||

Ok,

Is there any plans to make it a changeable field? a couple online articles made it sound like you could choose, rather than it auto populating.

|||Check the Product Feedback Center

http://lab.msdn.microsoft.com/productfeedback/|||Nathan,

Please corrobate the issue here:

file:///C:/Documents%20and%20Settings/chauvinr/Desktop/MSDN%20Product%20Feedback%20Center.URL

|||

"The OR gets only enabled if the filter expressions of two filters are identical."

Who's idea was this?

What is the logic behind making this kind of decision?

I just can't comprehend someone deisgning an application like RS and saying... "lets ONLY give them an OR if the fields used in the field expression is identical"

|||I couldnt imaginge it too having only identical field to use OR.|||

But I realy

need to put a Or with different expressions, like "pruductId< 100 or

quantity>10"....

Isn’t it possible?

|||

Yes, it is possible. Take a look at Robert's reply post on this thread.

Jarret

|||Sorry but I can't understand....

Filter expression: =(pruductId< 100 or quantity>10)
Filter type: =
Filter value: = ?

But what I have to put on value?

I will apreciate your help.
Thanks.|||Put '=True' as the value (without the single quotes).|||it only work with the expression:

=IIf((productId >100 or quantity<200),

"True"," False")

Many thanks.

And/or filter field not enabled in the group filter tab

Howdy,

I have a table that has a group. In this group, I want to filter by 2 different expressions, concatenated with an OR. BUT I can't change the "And/Or" column value for the first entry because it is grayed out. The column will automatically change to an OR value if both my expression column fields are the same (which I don’t want) but if I put any other value in to the expression field of the second row, the "And/Or" field of the first row automatically changes to an AND.

PLEASE! How do I get the And/Or field "ungrayed" so I can change it to what I want?

The 2 filters I and using check the UserID = to the user, and the other is checking a count to get the Top N 1. (So just showing the current user and the top producer)

The OR gets only enabled if the filter expressions of two filters are identical.

Note: another option is to use OR directly in your filter expression. Example:
Filter expression: =(condition1 OR condition2)
Filter type: =
Filter value: =True

-- Robert

|||

Ok,

Is there any plans to make it a changeable field? a couple online articles made it sound like you could choose, rather than it auto populating.

|||Check the Product Feedback Center

http://lab.msdn.microsoft.com/productfeedback/|||Nathan,

Please corrobate the issue here:

file:///C:/Documents%20and%20Settings/chauvinr/Desktop/MSDN%20Product%20Feedback%20Center.URL

|||

"The OR gets only enabled if the filter expressions of two filters are identical."

Who's idea was this?

What is the logic behind making this kind of decision?

I just can't comprehend someone deisgning an application like RS and saying... "lets ONLY give them an OR if the fields used in the field expression is identical"

|||I couldnt imaginge it too having only identical field to use OR.|||

But I realy need to put a Or with different expressions, like "pruductId< 100 or quantity>10"....
Isn’t it possible?

|||

Yes, it is possible. Take a look at Robert's reply post on this thread.

Jarret

|||Sorry but I can't understand....

Filter expression: =(pruductId< 100 or quantity>10)
Filter type: =
Filter value: = ?

But what I have to put on value?

I will apreciate your help.
Thanks.

|||Put '=True' as the value (without the single quotes).|||it only work with the expression:
=IIf((productId >100 or quantity<200), "True"," False")

Many thanks.

Analysis Services 2005 Lock-up on Calculated Measures

AS 2005/VS 2005 is locking-up when I try to go to the calculated measures tab. It uses some CPU and I think a lot of I/O. My only way out is to close VS.

Everything else is working. I looked at the XML and it looked OK to me (naive me).

I have written out the xml and created another db/cube and the problem came along with the xml.

I'm stuck.

Tom

The calculation tab in BIDS (VS) has to do a parse of the script to display it in the UI, so this would suggest that there is something in the script that is giving it issues.

Try creating another database/cube using the xmla as you did before, but also do the following:

search for the <MDXScript></MDXScript> tags and copy the contents into another file for safe keeping|||

I tried that - no luck.

Also tried a transplant from a OK cube. I'm guessing it is not the mdx scripts.

It happens when I try to go to the translate tab and the perspective tab too (in addition to the calculated tab).

I also re-installed SS/AS/RP/IS 2005; (that was a train wreck)

I am still stuck; I'll try other tabs and maybe get a clue. Any assistance would be appreciated.

|||

OK, I did the previous post off the top of my head and as you must have figured out, you actually need to remove the data under the <MDXScript><Commands><Command><Text> Node to remove the calculation script.

The other structure under the MDXScript node is the <CalculationProperties> - this is where translations and display folders for the calculated members are stored so it might be this data that is causing your issue. This is the only data that I can think of at the moment that would appear in all three tabs that are causing you issues.

If you have not already, you could try the same approach as before, except you can actually remove all the calculation property nodes leaving just empty <CalculationProperties></CalculationProperties> tags.

|||

Got it!

Was behind on SQL server/AS updates and VS updates.

When I updated to cummulative SQL server updates and VS latest update the problem was resolved.

Thank you for your time and your input.

Tom