|
|
You're in the
sql server reporting services
group:I lost it!! SQL parameter datetim formula
sql server reporting services:
Hai ,
Can anybody say it's not me ? tried it in VS2003 and VS2005 but can't get it working. It seems easy ... I have created a report with a sql stored procedure as dataset. Droped a table on the report. Run the report . See the data. OK. But one of the report parameters is the month (as int) So i what to set a default value for this parameter. I type in the "default values" in "non-queried" the following formula "=Month(Today)". The formula compiler says it's OK. But when i run the report I'm seeing Nothing!!! What I'm missing here.??? Spend 1hour trying.. please help. Is this a bug? michel
Did you change filed names between the report and the data set? I've done
that and the report returns no errors but no data. [quoted text, click to view] "michelk" wrote:
> Hai , > > Can anybody say it's not me ? > > tried it in VS2003 and VS2005 but can't get it working. It seems easy ... > I have created a report with a sql stored procedure as dataset. Droped a > table on the report. Run the report . See the data. OK. > But one of the report parameters is the month (as int) So i what to set a > default value for this parameter. I type in the "default values" in > "non-queried" the following formula "=Month(Today)". The formula compiler > says it's OK. But when i run the report I'm seeing Nothing!!! What I'm > missing here.??? > Spend 1hour trying.. please help. Is this a bug? > > michel > > > >
Michel,
Can you try =Month(Now()) Instead of what you are using currently. This is what I always use for getting the monthnumber and never gave me a hard time. grtz Perry [quoted text, click to view] "michelk" <michelk@removethis.infosupprt.com> wrote in message news:ej6wEb$oGHA.516@TK2MSFTNGP05.phx.gbl... > Hai , > > Can anybody say it's not me ? > > tried it in VS2003 and VS2005 but can't get it working. It seems easy ... > I have created a report with a sql stored procedure as dataset. Droped a > table on the report. Run the report . See the data. OK. > But one of the report parameters is the month (as int) So i what to set a > default value for this parameter. I type in the "default values" in > "non-queried" the following formula "=Month(Today)". The formula compiler > says it's OK. But when i run the report I'm seeing Nothing!!! What I'm > missing here.??? > Spend 1hour trying.. please help. Is this a bug? > > michel > > > >
When developing an expression I do one of two things. Either I have a report
with a single textbox that I assign the expression to so I can see the result or I have a little vb.net app that I use to test the vb.net code. That being said, I quickly did this and it worked no problem. Do this. 1. create new report (blank, nothing on it). 2. add a parameter of type int 3. set the Default values non-queried to this =Month(now()) No quotes put exactly the above 4. Preview -- Bruce Loehle-Conger MVP SQL Server Reporting Services [quoted text, click to view] "michelk" <michelk@removethis.infosupprt.com> wrote in message news:ewt%23wdRpGHA.4848@TK2MSFTNGP03.phx.gbl... > Thanks for responding. > > I did it all. All possible combinations . Without luck. ;-) > The only thing i'm getting is a grayedout input box. ??? The report with > data is working ok. Even when I create a new parameter (int) with this > formula it's still grayed out ???? > If this is the beginning of using SQL reporting service then I'm staying > at crystal reports ... (even when I don't want that to..) > > can someone send me a RDL that works ? > > > "Perry" <sjaak@sjaak.net> wrote in message > news:Os5y2lCpGHA.4812@TK2MSFTNGP04.phx.gbl... >> Michel, >> >> Can you try >> =Month(Now()) >> >> Instead of what you are using currently. This is what I always use for >> getting the monthnumber and never gave me a hard time. >> >> grtz >> >> Perry >> >> >> >> "michelk" <michelk@removethis.infosupprt.com> wrote in message >> news:ej6wEb$oGHA.516@TK2MSFTNGP05.phx.gbl... >> >>> Hai , >>> >>> Can anybody say it's not me ? >>> >>> tried it in VS2003 and VS2005 but can't get it working. It seems easy >>> ... >>> I have created a report with a sql stored procedure as dataset. Droped a >>> table on the report. Run the report . See the data. OK. >>> But one of the report parameters is the month (as int) So i what to set >>> a default value for this parameter. I type in the "default values" in >>> "non-queried" the following formula "=Month(Today)". The formula >>> compiler says it's OK. But when i run the report I'm seeing Nothing!!! >>> What I'm missing here.??? >>> Spend 1hour trying.. please help. Is this a bug? >>> >>> michel >>> >>> >>> >>> >> >> > >
Thanks for responding.
I did it all. All possible combinations . Without luck. ;-) The only thing i'm getting is a grayedout input box. ??? The report with data is working ok. Even when I create a new parameter (int) with this formula it's still grayed out ???? If this is the beginning of using SQL reporting service then I'm staying at crystal reports ... (even when I don't want that to..) can someone send me a RDL that works ? [quoted text, click to view] "Perry" <sjaak@sjaak.net> wrote in message news:Os5y2lCpGHA.4812@TK2MSFTNGP04.phx.gbl... > Michel, > > Can you try > =Month(Now()) > > Instead of what you are using currently. This is what I always use for > getting the monthnumber and never gave me a hard time. > > grtz > > Perry > > > > "michelk" <michelk@removethis.infosupprt.com> wrote in message > news:ej6wEb$oGHA.516@TK2MSFTNGP05.phx.gbl... > >> Hai , >> >> Can anybody say it's not me ? >> >> tried it in VS2003 and VS2005 but can't get it working. It seems easy ... >> I have created a report with a sql stored procedure as dataset. Droped a >> table on the report. Run the report . See the data. OK. >> But one of the report parameters is the month (as int) So i what to set a >> default value for this parameter. I type in the "default values" in >> "non-queried" the following formula "=Month(Today)". The formula compiler >> says it's OK. But when i run the report I'm seeing Nothing!!! What I'm >> missing here.??? >> Spend 1hour trying.. please help. Is this a bug? >> >> michel >> >> >> >> > >
Ok its working ;-)
The problem was that there is a parameter (type string) that was doing something.. If this parameter was standing above any parameter with the month function all the parameters with functions where grayed out... complex explanation .. but anyway it works... I'm in the middle of converting 20 crystal reports to reporting service.... THANKS [quoted text, click to view] "Bruce L-C [MVP]" <bruce_lcNOSPAM@hotmail.com> wrote in message news:eG2hklRpGHA.1440@TK2MSFTNGP03.phx.gbl... > When developing an expression I do one of two things. Either I have a > report with a single textbox that I assign the expression to so I can see > the result or I have a little vb.net app that I use to test the vb.net > code. > > That being said, I quickly did this and it worked no problem. > > Do this. > 1. create new report (blank, nothing on it). > 2. add a parameter of type int > 3. set the Default values non-queried to this > =Month(now()) > > No quotes put exactly the above > 4. Preview > > > -- > Bruce Loehle-Conger > MVP SQL Server Reporting Services > > > > "michelk" <michelk@removethis.infosupprt.com> wrote in message > news:ewt%23wdRpGHA.4848@TK2MSFTNGP03.phx.gbl... >> Thanks for responding. >> >> I did it all. All possible combinations . Without luck. ;-) >> The only thing i'm getting is a grayedout input box. ??? The report with >> data is working ok. Even when I create a new parameter (int) with this >> formula it's still grayed out ???? >> If this is the beginning of using SQL reporting service then I'm staying >> at crystal reports ... (even when I don't want that to..) >> >> can someone send me a RDL that works ? >> >> >> "Perry" <sjaak@sjaak.net> wrote in message >> news:Os5y2lCpGHA.4812@TK2MSFTNGP04.phx.gbl... >>> Michel, >>> >>> Can you try >>> =Month(Now()) >>> >>> Instead of what you are using currently. This is what I always use for >>> getting the monthnumber and never gave me a hard time. >>> >>> grtz >>> >>> Perry >>> >>> >>> >>> "michelk" <michelk@removethis.infosupprt.com> wrote in message >>> news:ej6wEb$oGHA.516@TK2MSFTNGP05.phx.gbl... >>> >>>> Hai , >>>> >>>> Can anybody say it's not me ? >>>> >>>> tried it in VS2003 and VS2005 but can't get it working. It seems easy >>>> ... >>>> I have created a report with a sql stored procedure as dataset. Droped >>>> a table on the report. Run the report . See the data. OK. >>>> But one of the report parameters is the month (as int) So i what to set >>>> a default value for this parameter. I type in the "default values" in >>>> "non-queried" the following formula "=Month(Today)". The formula >>>> compiler says it's OK. But when i run the report I'm seeing Nothing!!! >>>> What I'm missing here.??? >>>> Spend 1hour trying.. please help. Is this a bug? >>>> >>>> michel >>>> >>>> >>>> >>>> >>> >>> >> >> > >
Don't see what you're looking for? Try a search.
|
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
| home · blog · groups | Questions? Comments? Contact the dn |