Showing posts with label reset. Show all posts
Showing posts with label reset. Show all posts

Wednesday, March 21, 2012

Datetime Parameters reset to String

When I go to Report > Report Parameters... in VS, I create date parameters and specify the type as datetime. I then add the parameters to my SQL statement. I then go back to look at the parameters and they have changed to string. This happens every time I make a modification to the SQL statement. Is this a bug, or am I missing a step? I thought someone would have asked this before, but I can't find a post for it in this forum.

Thanks in advance,

Scott

Parameter's type can change to string, but it should only happen once. What version are you using?|||I'm using 2005. I'm not 100% sure but I'm fairly certain that it happens every time I change the SQL statement.|||Its Not a bug, Its a Feature :)))

But yes - I don belive its a bug.
It happened to me a few time that when I played with the dataset its changed my parameter type from dateTime to string.

If this will be your only problem with the dateTime parameter you should be happy.
Its also have some problems with some localization sometimes....

Tuesday, February 14, 2012

DateDiff

Hi,
I am using this formula and I want to reset (Zero) the formula on change of group and grand total it. Can't work out how to do it! Probably something really simple.
DateDiff ("s",Previous ({Order.DateReceived}) ,{Order.DateReceived})
Many ThanksYou can have two formulas,

first one will be group wise total

second one will have the entire total (grand total)|||Crystal won't allow me to summarise this field based on the time calcuation! DOH!