Hi,
I am using the URL format to render a report.
I would like the toolbar to be shown and have it minimised on report load. I have tried setting Toolbar=false but this removes it from the report. I want the toolbar but I want it minimised on when a report is rendered.
ThanksNo, this is not possible. In SP1, you can collapse the parameters area.
--
Brian Welcker
Group Program Manager
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"MikeMcD" <MikeMcD@.discussions.microsoft.com> wrote in message
news:756E8829-D810-4B76-AE5A-14A2B547DC58@.microsoft.com...
> Hi,
> I am using the URL format to render a report.
> I would like the toolbar to be shown and have it minimised on report load.
I have tried setting Toolbar=false but this removes it from the report. I
want the toolbar but I want it minimised on when a report is rendered.
> Thankssql
Showing posts with label format. Show all posts
Showing posts with label format. Show all posts
Wednesday, March 21, 2012
Monday, March 19, 2012
Mine is on G drive
This is a multi-part message in MIME format.
--=_NextPart_000_001B_01C3E759.E237A8F0
Content-Type: multipart/alternative;
boundary="--=_NextPart_001_001C_01C3E759.E237A8F0"
--=_NextPart_001_001C_01C3E759.E237A8F0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
mk:@.MSITStore:G:\MSSQL7\BOOKS\SQLBOL.CHM::/html/r_model_16.htm
Change the above to the drive yours is on. You should be able to just = click on this and bring up the page in Microsoft SQL Server 7.0.
Notice in this there is no listing for an icon that looks like this:
Is my SQL 7.0 weird or something?
Thanks.
-- George Hester
_________________________________
--=_NextPart_001_001C_01C3E759.E237A8F0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&
mk:@.MSITStore:G:\MSSQL7\BOOKS\SQLBOL.CHM::/html/r_model_16.htm
Change the above to the drive yours is = on. You should be able to just click on this and bring up the page in = Microsoft SQL Server 7.0.
Notice in this there is no listing for = an icon that looks like this:
Is my SQL 7.0 weird or = something?
Thanks.
-- George Hester_________________________________
--=_NextPart_001_001C_01C3E759.E237A8F0--
--=_NextPart_000_001B_01C3E759.E237A8F0
Content-Type: image/gif;
name="sqlbetter.gif"
Content-Transfer-Encoding: base64
Content-ID: <001601c3e783$cb030290$c673c318@.hester>
R0lGODlhGAAWAAAAACwAAAAAGAAWAIIAAAAAgACAgID/AADAwMDU0Mj///8AAAADdWi63ArAyUmr
lSLrzEYrjECMJCFEyuAt4CI4GZquRquIpQl1tG1sGsBpoWL4Xg1g0RjKcYgDWS0ERAagvd8PeVsE
rjNWk8T9gpdTV6lsVsmOa++3+B4TBmwDXayOG8B6NGkLEIVPhGg+E4U7enwVXBeSk0kWCQA7
--=_NextPart_000_001B_01C3E759.E237A8F0--This is a multi-part message in MIME format.
--=_NextPart_000_006B_01C3E7F2.D6750140
Content-Type: multipart/alternative;
boundary="--=_NextPart_001_006C_01C3E7F2.D6750140"
--=_NextPart_001_006C_01C3E7F2.D6750140
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
No, not weird. See: http://vyaskn.tripod.com/sql_server_tools_faq.htm#q8 =:-)
-- HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional? =http://vyaskn.tripod.com/poll.htm
"George Hester MVP - IIS" <hesterloli@.hotmail.com> wrote in message =news:ek5YMP45DHA.2072@.TK2MSFTNGP11.phx.gbl...
mk:@.MSITStore:G:\MSSQL7\BOOKS\SQLBOL.CHM::/html/r_model_16.htm
Change the above to the drive yours is on. You should be able to just =click on this and bring up the page in Microsoft SQL Server 7.0.
Notice in this there is no listing for an icon that looks like this:
Is my SQL 7.0 weird or something?
Thanks.
-- George Hester
_________________________________
--=_NextPart_001_006C_01C3E7F2.D6750140
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&
No, not weird. See: http://vyaskn.tripod.com/sql_server_tools_faq.htm#q8">http://vyas=kn.tripod.com/sql_server_tools_faq.htm#q8 :-)
-- HTH,Vyas, MVP (SQL Server)http://vyaskn.tripod.com/">http://vyaskn.tripod.com/Is =.NET important for a database professional? http://vyaskn.tripod.com/poll.htm">http://vyaskn.tripod.com/poll.=htm
"George Hester MVP - IIS" =wrote in message news:ek5YMP45DHA.2072=@.TK2MSFTNGP11.phx.gbl...
mk:@.MSITStore:G:\MSSQL7\BOOKS\SQLBOL.CHM::/html/r_model_16.htm
Change the above to the drive yours =is on. You should be able to just click on this and bring up the page in =Microsoft SQL Server 7.0.
Notice in this there is no listing =for an icon that looks like this:
Is my SQL 7.0 weird or =something?
Thanks.
-- George =Hester_________________________________
--=_NextPart_001_006C_01C3E7F2.D6750140--
--=_NextPart_000_006B_01C3E7F2.D6750140
Content-Type: image/gif;
name="sqlbetter.gif"
Content-Transfer-Encoding: base64
Content-ID: <006601c3e7f2$d5eeba40$719a8451@.pol.net.in>
R0lGODlhGAAWAAAAACwAAAAAGAAWAIIAAAAAgACAgID/AADAwMDU0Mj///8AAAADdWi63ArAyUmr
lSLrzEYrjECMJCFEyuAt4CI4GZquRquIpQl1tG1sGsBpoWL4Xg1g0RjKcYgDWS0ERAagvd8PeVsE
rjNWk8T9gpdTV6lsVsmOa++3+B4TBmwDXayOG8B6NGkLEIVPhGg+E4U7enwVXBeSk0kWCQA7
--=_NextPart_000_006B_01C3E7F2.D6750140--|||Thanks Narayana. Why then is it not in SQL Books Online anywhere? They =have every other icon there. Why not that one? Is this a BOL defect? =I understand it is not earth crashing but it seems to me it should be in =there. In fact I cannot find this icon described in any Microsoft =Documentation at all.
-- George Hester
__________________________________
"Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message =news:uit$mK$5DHA.2576@.TK2MSFTNGP11.phx.gbl...
No, not weird. See: http://vyaskn.tripod.com/sql_server_tools_faq.htm#q8 =:-)
-- HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional? =http://vyaskn.tripod.com/poll.htm
"George Hester MVP - IIS" <hesterloli@.hotmail.com> wrote in message =news:ek5YMP45DHA.2072@.TK2MSFTNGP11.phx.gbl...
mk:@.MSITStore:G:\MSSQL7\BOOKS\SQLBOL.CHM::/html/r_model_16.htm
Change the above to the drive yours is on. You should be able to just =click on this and bring up the page in Microsoft SQL Server 7.0.
Notice in this there is no listing for an icon that looks like this:
Is my SQL 7.0 weird or something?
Thanks.
-- George Hester
_________________________________|||I am not sure why it isn't in Books Online. I also think this was the case
only in SQL Server 7.0. It confused a lot of people, and this icon is
removed in SQL Server 2000.
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional?
http://vyaskn.tripod.com/poll.htm
"George Hester" <hesterloli@.hotmail.com> wrote in message
news:#oNmBHA6DHA.1556@.tk2msftngp13.phx.gbl...
Thanks Narayana. Why then is it not in SQL Books Online anywhere? They
have every other icon there. Why not that one? Is this a BOL defect? I
understand it is not earth crashing but it seems to me it should be in
there. In fact I cannot find this icon described in any Microsoft
Documentation at all.
--
George Hester
__________________________________
"Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message
news:uit$mK$5DHA.2576@.TK2MSFTNGP11.phx.gbl...
No, not weird. See: http://vyaskn.tripod.com/sql_server_tools_faq.htm#q8 :-)
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional?
http://vyaskn.tripod.com/poll.htm
"George Hester MVP - IIS" <hesterloli@.hotmail.com> wrote in message
news:ek5YMP45DHA.2072@.TK2MSFTNGP11.phx.gbl...
mk:@.MSITStore:G:\MSSQL7\BOOKS\SQLBOL.CHM::/html/r_model_16.htm
Change the above to the drive yours is on. You should be able to just
click on this and bring up the page in Microsoft SQL Server 7.0.
Notice in this there is no listing for an icon that looks like this:
Is my SQL 7.0 weird or something?
Thanks.
--
George Hester
_________________________________|||I'm sure it did. I'm like Pavlov's Dog when it comes to green and red =icons. When I see Green I breathe a sigh of relief. When I see Red I =run for the hills. Now I wonder why I am that way? Could it be that I =have been trained to think that way based on the much touted Microsoft =Fundamental User Design? I try to follow the design criteria because I =don't want anyone running for the hills away from my applications.
Thanks Narayana you have put this to rest for me. I'm not happy with it =but so be it.
Oh you know this isn't the only place where this design fundamental is =violated. It is also violated in SQL XML (2000).
-- George Hester
__________________________________
"Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message =news:ueh4YAE6DHA.2764@.TK2MSFTNGP09.phx.gbl...
> I am not sure why it isn't in Books Online. I also think this was the =case
> only in SQL Server 7.0. It confused a lot of people, and this icon is
> removed in SQL Server 2000.
> --
> HTH,
> Vyas, MVP (SQL Server)
> http://vyaskn.tripod.com/
> Is .NET important for a database professional?
> http://vyaskn.tripod.com/poll.htm
> > > > > "George Hester" <hesterloli@.hotmail.com> wrote in message
> news:#oNmBHA6DHA.1556@.tk2msftngp13.phx.gbl...
> Thanks Narayana. Why then is it not in SQL Books Online anywhere? =They
> have every other icon there. Why not that one? Is this a BOL defect? = I
> understand it is not earth crashing but it seems to me it should be in
> there. In fact I cannot find this icon described in any Microsoft
> Documentation at all.
> > --
> George Hester
> __________________________________
> "Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message
> news:uit$mK$5DHA.2576@.TK2MSFTNGP11.phx.gbl...
> No, not weird. See: =http://vyaskn.tripod.com/sql_server_tools_faq.htm#q8 :-)
> > --
> HTH,
> Vyas, MVP (SQL Server)
> http://vyaskn.tripod.com/
> Is .NET important for a database professional?
> http://vyaskn.tripod.com/poll.htm
> > > > > "George Hester MVP - IIS" <hesterloli@.hotmail.com> wrote in message
> news:ek5YMP45DHA.2072@.TK2MSFTNGP11.phx.gbl...
> mk:@.MSITStore:G:\MSSQL7\BOOKS\SQLBOL.CHM::/html/r_model_16.htm
> > Change the above to the drive yours is on. You should be able to =just
> click on this and bring up the page in Microsoft SQL Server 7.0.
> > Notice in this there is no listing for an icon that looks like this:
> > > > Is my SQL 7.0 weird or something?
> Thanks.
> > --
> George Hester
> _________________________________
> > >
--=_NextPart_000_001B_01C3E759.E237A8F0
Content-Type: multipart/alternative;
boundary="--=_NextPart_001_001C_01C3E759.E237A8F0"
--=_NextPart_001_001C_01C3E759.E237A8F0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
mk:@.MSITStore:G:\MSSQL7\BOOKS\SQLBOL.CHM::/html/r_model_16.htm
Change the above to the drive yours is on. You should be able to just = click on this and bring up the page in Microsoft SQL Server 7.0.
Notice in this there is no listing for an icon that looks like this:
Is my SQL 7.0 weird or something?
Thanks.
-- George Hester
_________________________________
--=_NextPart_001_001C_01C3E759.E237A8F0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&
mk:@.MSITStore:G:\MSSQL7\BOOKS\SQLBOL.CHM::/html/r_model_16.htm
Change the above to the drive yours is = on. You should be able to just click on this and bring up the page in = Microsoft SQL Server 7.0.
Notice in this there is no listing for = an icon that looks like this:
Is my SQL 7.0 weird or = something?
Thanks.
-- George Hester_________________________________
--=_NextPart_001_001C_01C3E759.E237A8F0--
--=_NextPart_000_001B_01C3E759.E237A8F0
Content-Type: image/gif;
name="sqlbetter.gif"
Content-Transfer-Encoding: base64
Content-ID: <001601c3e783$cb030290$c673c318@.hester>
R0lGODlhGAAWAAAAACwAAAAAGAAWAIIAAAAAgACAgID/AADAwMDU0Mj///8AAAADdWi63ArAyUmr
lSLrzEYrjECMJCFEyuAt4CI4GZquRquIpQl1tG1sGsBpoWL4Xg1g0RjKcYgDWS0ERAagvd8PeVsE
rjNWk8T9gpdTV6lsVsmOa++3+B4TBmwDXayOG8B6NGkLEIVPhGg+E4U7enwVXBeSk0kWCQA7
--=_NextPart_000_001B_01C3E759.E237A8F0--This is a multi-part message in MIME format.
--=_NextPart_000_006B_01C3E7F2.D6750140
Content-Type: multipart/alternative;
boundary="--=_NextPart_001_006C_01C3E7F2.D6750140"
--=_NextPart_001_006C_01C3E7F2.D6750140
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
No, not weird. See: http://vyaskn.tripod.com/sql_server_tools_faq.htm#q8 =:-)
-- HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional? =http://vyaskn.tripod.com/poll.htm
"George Hester MVP - IIS" <hesterloli@.hotmail.com> wrote in message =news:ek5YMP45DHA.2072@.TK2MSFTNGP11.phx.gbl...
mk:@.MSITStore:G:\MSSQL7\BOOKS\SQLBOL.CHM::/html/r_model_16.htm
Change the above to the drive yours is on. You should be able to just =click on this and bring up the page in Microsoft SQL Server 7.0.
Notice in this there is no listing for an icon that looks like this:
Is my SQL 7.0 weird or something?
Thanks.
-- George Hester
_________________________________
--=_NextPart_001_006C_01C3E7F2.D6750140
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&
No, not weird. See: http://vyaskn.tripod.com/sql_server_tools_faq.htm#q8">http://vyas=kn.tripod.com/sql_server_tools_faq.htm#q8 :-)
-- HTH,Vyas, MVP (SQL Server)http://vyaskn.tripod.com/">http://vyaskn.tripod.com/Is =.NET important for a database professional? http://vyaskn.tripod.com/poll.htm">http://vyaskn.tripod.com/poll.=htm
"George Hester MVP - IIS"
mk:@.MSITStore:G:\MSSQL7\BOOKS\SQLBOL.CHM::/html/r_model_16.htm
Change the above to the drive yours =is on. You should be able to just click on this and bring up the page in =Microsoft SQL Server 7.0.
Notice in this there is no listing =for an icon that looks like this:
Is my SQL 7.0 weird or =something?
Thanks.
-- George =Hester_________________________________
--=_NextPart_001_006C_01C3E7F2.D6750140--
--=_NextPart_000_006B_01C3E7F2.D6750140
Content-Type: image/gif;
name="sqlbetter.gif"
Content-Transfer-Encoding: base64
Content-ID: <006601c3e7f2$d5eeba40$719a8451@.pol.net.in>
R0lGODlhGAAWAAAAACwAAAAAGAAWAIIAAAAAgACAgID/AADAwMDU0Mj///8AAAADdWi63ArAyUmr
lSLrzEYrjECMJCFEyuAt4CI4GZquRquIpQl1tG1sGsBpoWL4Xg1g0RjKcYgDWS0ERAagvd8PeVsE
rjNWk8T9gpdTV6lsVsmOa++3+B4TBmwDXayOG8B6NGkLEIVPhGg+E4U7enwVXBeSk0kWCQA7
--=_NextPart_000_006B_01C3E7F2.D6750140--|||Thanks Narayana. Why then is it not in SQL Books Online anywhere? They =have every other icon there. Why not that one? Is this a BOL defect? =I understand it is not earth crashing but it seems to me it should be in =there. In fact I cannot find this icon described in any Microsoft =Documentation at all.
-- George Hester
__________________________________
"Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message =news:uit$mK$5DHA.2576@.TK2MSFTNGP11.phx.gbl...
No, not weird. See: http://vyaskn.tripod.com/sql_server_tools_faq.htm#q8 =:-)
-- HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional? =http://vyaskn.tripod.com/poll.htm
"George Hester MVP - IIS" <hesterloli@.hotmail.com> wrote in message =news:ek5YMP45DHA.2072@.TK2MSFTNGP11.phx.gbl...
mk:@.MSITStore:G:\MSSQL7\BOOKS\SQLBOL.CHM::/html/r_model_16.htm
Change the above to the drive yours is on. You should be able to just =click on this and bring up the page in Microsoft SQL Server 7.0.
Notice in this there is no listing for an icon that looks like this:
Is my SQL 7.0 weird or something?
Thanks.
-- George Hester
_________________________________|||I am not sure why it isn't in Books Online. I also think this was the case
only in SQL Server 7.0. It confused a lot of people, and this icon is
removed in SQL Server 2000.
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional?
http://vyaskn.tripod.com/poll.htm
"George Hester" <hesterloli@.hotmail.com> wrote in message
news:#oNmBHA6DHA.1556@.tk2msftngp13.phx.gbl...
Thanks Narayana. Why then is it not in SQL Books Online anywhere? They
have every other icon there. Why not that one? Is this a BOL defect? I
understand it is not earth crashing but it seems to me it should be in
there. In fact I cannot find this icon described in any Microsoft
Documentation at all.
--
George Hester
__________________________________
"Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message
news:uit$mK$5DHA.2576@.TK2MSFTNGP11.phx.gbl...
No, not weird. See: http://vyaskn.tripod.com/sql_server_tools_faq.htm#q8 :-)
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional?
http://vyaskn.tripod.com/poll.htm
"George Hester MVP - IIS" <hesterloli@.hotmail.com> wrote in message
news:ek5YMP45DHA.2072@.TK2MSFTNGP11.phx.gbl...
mk:@.MSITStore:G:\MSSQL7\BOOKS\SQLBOL.CHM::/html/r_model_16.htm
Change the above to the drive yours is on. You should be able to just
click on this and bring up the page in Microsoft SQL Server 7.0.
Notice in this there is no listing for an icon that looks like this:
Is my SQL 7.0 weird or something?
Thanks.
--
George Hester
_________________________________|||I'm sure it did. I'm like Pavlov's Dog when it comes to green and red =icons. When I see Green I breathe a sigh of relief. When I see Red I =run for the hills. Now I wonder why I am that way? Could it be that I =have been trained to think that way based on the much touted Microsoft =Fundamental User Design? I try to follow the design criteria because I =don't want anyone running for the hills away from my applications.
Thanks Narayana you have put this to rest for me. I'm not happy with it =but so be it.
Oh you know this isn't the only place where this design fundamental is =violated. It is also violated in SQL XML (2000).
-- George Hester
__________________________________
"Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message =news:ueh4YAE6DHA.2764@.TK2MSFTNGP09.phx.gbl...
> I am not sure why it isn't in Books Online. I also think this was the =case
> only in SQL Server 7.0. It confused a lot of people, and this icon is
> removed in SQL Server 2000.
> --
> HTH,
> Vyas, MVP (SQL Server)
> http://vyaskn.tripod.com/
> Is .NET important for a database professional?
> http://vyaskn.tripod.com/poll.htm
> > > > > "George Hester" <hesterloli@.hotmail.com> wrote in message
> news:#oNmBHA6DHA.1556@.tk2msftngp13.phx.gbl...
> Thanks Narayana. Why then is it not in SQL Books Online anywhere? =They
> have every other icon there. Why not that one? Is this a BOL defect? = I
> understand it is not earth crashing but it seems to me it should be in
> there. In fact I cannot find this icon described in any Microsoft
> Documentation at all.
> > --
> George Hester
> __________________________________
> "Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message
> news:uit$mK$5DHA.2576@.TK2MSFTNGP11.phx.gbl...
> No, not weird. See: =http://vyaskn.tripod.com/sql_server_tools_faq.htm#q8 :-)
> > --
> HTH,
> Vyas, MVP (SQL Server)
> http://vyaskn.tripod.com/
> Is .NET important for a database professional?
> http://vyaskn.tripod.com/poll.htm
> > > > > "George Hester MVP - IIS" <hesterloli@.hotmail.com> wrote in message
> news:ek5YMP45DHA.2072@.TK2MSFTNGP11.phx.gbl...
> mk:@.MSITStore:G:\MSSQL7\BOOKS\SQLBOL.CHM::/html/r_model_16.htm
> > Change the above to the drive yours is on. You should be able to =just
> click on this and bring up the page in Microsoft SQL Server 7.0.
> > Notice in this there is no listing for an icon that looks like this:
> > > > Is my SQL 7.0 weird or something?
> Thanks.
> > --
> George Hester
> _________________________________
> > >
Min(NULL) shows up as 12/30/1899 in cube
Hi!
I have a cube with a measure based on a datetime column with aggregation Min in AS 2000 SP4. The Data Type is set to Date and the Format is set to Short Date. Somehow the the measure shows 12/30/1899 when all values in the datetime column are NULL. If I check the properties in the cube browser it says Formatted Value: 12/30/1899 and Value: 12:00:00 AM.
I've implemented a work around in the reports that use this measure to look for 1899 or AM and replace with it NULL, but what I really want is the cube to display the real value (= NULL) when I browse it.
Any help would be greatly appreciated. Thanks!
Nulls don't behave the same in an OLAP database. In fact they often evaluate to 0 which is what is happening here.
In a relational DB 1 + NULL = NULL
In an OLAP DB 1 + NULL = 1
You might have to change your approach, so possible avenues to explore would be
use an aggregation of None and use a calculation to rollup the values, but this could be slow as you would need to drill down to the leaf level to get any values when using an aggregtion type of none. You might be able to attach the date as an attribute to another dimension, it depends what the date measure is.|||So basically what I have to do is to create a calculated member based on this measure and use that one in the reports?:
iif(the_date_measure == 12/30/1899, NULL, iif(the_date_measure == 12:00:00 AM, NULL, the_date_measure )), which is the same thing I do in the reports.
I've verified it and a date column with NULL becomes 12/30/1899 in AS (in ver 2000 at least). So gotta use a work around as above to fix this.
|||That would work too.
You could even put that type of calculation in the cube. If it were me I would hide the "raw" measure and create a calculated measure with this sort of logic in it.
|||I've now created a calculated member as:
IIF( (InStr([Measures].[Adate], "00:00") > 0) OR (InStr([Measures].[Adate], "00.00") > 0), NULL, [Measures].[Adate])
and it seems to work very well. Looking for AM or 1899 does not work since the value will be 12:00:00 AM, 0:00:00, 00:00:00 depending on regional settings. I looked through all regional settings on my computer and only Faeroese and Italy have a dot separator instead of colon in their time setting (00.00.00).
Btw, do you know how date columns with NULL show up in AS 2005? Same behavior here?
Thanks for all your help!
|||Well you have some more options in AS2005, it is not really typical to use dates based measures so it is hard to say without knowing more details. The Min aggregation should behave the same, but you could also potential use something like LastNonEmpty or None with a calculation to do the rollup.Monday, March 12, 2012
Million Seperator
Dear Sir,
I am Facing Problem with The number Format. Instaed of Thosand Separator I want Million Separator..
For Eg: in Crsyal Report The Number will Display Like this 5,633,000.00. Instaed of This format I want this Number to be display Like 56,33,000.00. How i can Do that,,
Thanks in Advance
AmbilyUse Formula field having this code
stringvar Amount:="453453455.00";
stringvar s:=mid(Amount,1,len(Amount)-3);
select len(s)
case 3 : s & ".00"
case 4 : left(s,1) & "," & right(s,3)& ".00"
case 5 : left(s,2) & "," & right(s,3)& ".00"
case 6 : left(s,1) & "," & mid(s,2,2) & "," & right(s,3)& ".00"
case 7 : left(s,2) & "," & mid(s,2,2) & "," & right(s,3)& ".00"
case 8 : left(s,1) & "," & mid(s,2,2) & "," & mid(s,4,2) & "," & right(s,3)& ".00"
case 9 : left(s,2) & "," & mid(s,2,2) & "," & mid(s,4,2) & "," & right(s,3)& ".00"
case 10 : left(s,1) & "," & mid(s,2,2) & "," & mid(s,4,2) & "," & mid(s,6,2) & "," & right(s,3)& ".00"
default : s & ".00"
Madhivanan|||may i ask how to modify your script to get thousands separator?. i have case statement in my formula for differernt format. Don't want the .xx if they are both zeros.|||Hi 9e9+
Can you post the number and exepeted formated number?
Madhivanan|||Hi Madhi,
Thank you For your Fast Reply...
But i am Not Able to get the format..even though i analysed the function...but it is displaying The same format ,which crytsal report is giving.
Can u plz suggest any Other Function..|||Can you post the code you used?
Madhivanan|||Function (Currencyvar v1)
stringvar s:=mid(Totext(V1),2,len(Totext(V1))-4);
//stringvar str[100]=split(s,",");
//stringVar array str:=split(s,",");
//stringvar s=join(s2,",")
stringvar X:=mid(Totext(V1),Len(Totext(V1))-2,Len(Totext(V1)));
select len(S)
case 3 : s & X
case 4 : left(s,1) & "," & right(s,3)& X
case 5 : left(s,2) & "," & right(s,3)& X
case 6 : left(s,1) & "," & mid(s,2,2) & "," & right(s,3)&X
case 7 : left(s,2) & "," & mid(s,3,2) & "," & right(s,3)& X
case 8 : left(s,1) & "," & mid(s,2,2) & "," & mid(s,4,2) & "," & right(s,3)& X
case 9 : left(s,2) & "," & mid(s,3,2) & "," & mid(s,5,2) & "," & right(s,3)& X
case 10 : left(s,1) & "," & mid(s,2,2) & "," & mid(s,4,2) & "," & mid(s,6,2) & "," & right(s,3)& X
default : s & ".00" ;
This is the code i used. I rewrote the code bcecoz, By default The crystal report is taking $ symbol also with the Number format.
Now i am struggling becoz it will take the Thousand Seperator (,) also. So while taking leng\th , it will count The & symbol and Thousand seperator.
I dont want those...
So i am trying to Split the Number into array (,) and Join again with out Commas.
Can you help me.
I cant change the Reprt options again..coz already 150+ reports addaed..Now for all reports i hav to Update this Format..
or pls suggest me, any short cut method is available ...
Thanks
Ambily|||Hi Mr Madhi,
Thanks a Lot for ur Support.. The problem was Simple...But It troubled a Lot
I wrote A functon with ur code
Function (Currencyvar v1)
Numbervar A:=(Tonumber(V1));
stringvar s:=Totext(A);
stringvar X:=mid(Totext(V1),Len(Totext(V1))-2,Len(Totext(V1)));
select len(s)
case 3 : s & X
case 4 : left(s,1) & "," & right(s,3)& X
case 5 : left(s,2) & "," & right(s,3)& X
case 6 : left(s,1) & "," & mid(s,2,2) & "," & right(s,3)&X
case 7 : left(s,2) & "," & mid(s,3,2) & "," & right(s,3)& X
case 8 : left(s,1) & "," & mid(s,2,2) & "," & mid(s,4,2) & "," & right(s,3)& X
case 9 : left(s,2) & "," & mid(s,3,2) & "," & mid(s,4,2) & "," & right(s,3)& X
case 10 : left(s,1) & "," & mid(s,2,2) & "," & mid(s,4,2) & "," & mid(s,6,2) & "," & right(s,3)& X
default : s & ".00" ;
Now i am getting The currency format , which i need
Once again Thanks!!!
Ambily
I am Facing Problem with The number Format. Instaed of Thosand Separator I want Million Separator..
For Eg: in Crsyal Report The Number will Display Like this 5,633,000.00. Instaed of This format I want this Number to be display Like 56,33,000.00. How i can Do that,,
Thanks in Advance
AmbilyUse Formula field having this code
stringvar Amount:="453453455.00";
stringvar s:=mid(Amount,1,len(Amount)-3);
select len(s)
case 3 : s & ".00"
case 4 : left(s,1) & "," & right(s,3)& ".00"
case 5 : left(s,2) & "," & right(s,3)& ".00"
case 6 : left(s,1) & "," & mid(s,2,2) & "," & right(s,3)& ".00"
case 7 : left(s,2) & "," & mid(s,2,2) & "," & right(s,3)& ".00"
case 8 : left(s,1) & "," & mid(s,2,2) & "," & mid(s,4,2) & "," & right(s,3)& ".00"
case 9 : left(s,2) & "," & mid(s,2,2) & "," & mid(s,4,2) & "," & right(s,3)& ".00"
case 10 : left(s,1) & "," & mid(s,2,2) & "," & mid(s,4,2) & "," & mid(s,6,2) & "," & right(s,3)& ".00"
default : s & ".00"
Madhivanan|||may i ask how to modify your script to get thousands separator?. i have case statement in my formula for differernt format. Don't want the .xx if they are both zeros.|||Hi 9e9+
Can you post the number and exepeted formated number?
Madhivanan|||Hi Madhi,
Thank you For your Fast Reply...
But i am Not Able to get the format..even though i analysed the function...but it is displaying The same format ,which crytsal report is giving.
Can u plz suggest any Other Function..|||Can you post the code you used?
Madhivanan|||Function (Currencyvar v1)
stringvar s:=mid(Totext(V1),2,len(Totext(V1))-4);
//stringvar str[100]=split(s,",");
//stringVar array str:=split(s,",");
//stringvar s=join(s2,",")
stringvar X:=mid(Totext(V1),Len(Totext(V1))-2,Len(Totext(V1)));
select len(S)
case 3 : s & X
case 4 : left(s,1) & "," & right(s,3)& X
case 5 : left(s,2) & "," & right(s,3)& X
case 6 : left(s,1) & "," & mid(s,2,2) & "," & right(s,3)&X
case 7 : left(s,2) & "," & mid(s,3,2) & "," & right(s,3)& X
case 8 : left(s,1) & "," & mid(s,2,2) & "," & mid(s,4,2) & "," & right(s,3)& X
case 9 : left(s,2) & "," & mid(s,3,2) & "," & mid(s,5,2) & "," & right(s,3)& X
case 10 : left(s,1) & "," & mid(s,2,2) & "," & mid(s,4,2) & "," & mid(s,6,2) & "," & right(s,3)& X
default : s & ".00" ;
This is the code i used. I rewrote the code bcecoz, By default The crystal report is taking $ symbol also with the Number format.
Now i am struggling becoz it will take the Thousand Seperator (,) also. So while taking leng\th , it will count The & symbol and Thousand seperator.
I dont want those...
So i am trying to Split the Number into array (,) and Join again with out Commas.
Can you help me.
I cant change the Reprt options again..coz already 150+ reports addaed..Now for all reports i hav to Update this Format..
or pls suggest me, any short cut method is available ...
Thanks
Ambily|||Hi Mr Madhi,
Thanks a Lot for ur Support.. The problem was Simple...But It troubled a Lot
I wrote A functon with ur code
Function (Currencyvar v1)
Numbervar A:=(Tonumber(V1));
stringvar s:=Totext(A);
stringvar X:=mid(Totext(V1),Len(Totext(V1))-2,Len(Totext(V1)));
select len(s)
case 3 : s & X
case 4 : left(s,1) & "," & right(s,3)& X
case 5 : left(s,2) & "," & right(s,3)& X
case 6 : left(s,1) & "," & mid(s,2,2) & "," & right(s,3)&X
case 7 : left(s,2) & "," & mid(s,3,2) & "," & right(s,3)& X
case 8 : left(s,1) & "," & mid(s,2,2) & "," & mid(s,4,2) & "," & right(s,3)& X
case 9 : left(s,2) & "," & mid(s,3,2) & "," & mid(s,4,2) & "," & right(s,3)& X
case 10 : left(s,1) & "," & mid(s,2,2) & "," & mid(s,4,2) & "," & mid(s,6,2) & "," & right(s,3)& X
default : s & ".00" ;
Now i am getting The currency format , which i need
Once again Thanks!!!
Ambily
Military time
How do I format a DateTime to Military time?
--
Message posted via http://www.sqlmonster.com>How do I format a DateTime to Military time?
If you mean the "normal" 24-hour time format (that the whole world
except the US uses by default - *not* just the military!) :
string sTime = YourDateTime.ToString("HH:mm");
Marc
================================================================Marc Scheuner May The Source Be With You!
Berne, Switzerland m.scheuner -at- inova.ch
--
Message posted via http://www.sqlmonster.com>How do I format a DateTime to Military time?
If you mean the "normal" 24-hour time format (that the whole world
except the US uses by default - *not* just the military!) :
string sTime = YourDateTime.ToString("HH:mm");
Marc
================================================================Marc Scheuner May The Source Be With You!
Berne, Switzerland m.scheuner -at- inova.ch
MIGRATIONSQL7 to SQL2000
This is a multi-part message in MIME format.
--=_NextPart_000_004B_01C527DD.F93DF4D0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Hello!!
I have a Data Base in sql7 and I want to transfer to another PC with a = clean installation of SQL2000. How do I do this?
Thanks!!
--=_NextPart_000_004B_01C527DD.F93DF4D0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&
Hello!!
I have a Data Base in sql7 and I want to = transfer to another PC with a clean installation of SQL2000. How do I do = this?
Thanks!!
--=_NextPart_000_004B_01C527DD.F93DF4D0--You can both attach and restore 7.0 databases into 2000:
Moving SQL Server Databases
http://www.support.microsoft.com/?id=224071
Moving Databases between Servers
http://www.support.microsoft.com/?id=314546
Using WITH MOVE in a Restore to a New Location with Detach/Attach
http://support.microsoft.com/?id=221465
How To Transfer Logins and Passwords Between SQL Servers
http://www.support.microsoft.com/?id=246133
Mapping Logins & SIDs after a Restore
http://www.support.microsoft.com/?id=298897
Utility to map users to the correct login
http://www.dbmaint.com/SyncSqlLogins.asp
How to Resolve Permission Issues When a Database Is Moved Between SQL Servers
http://www.support.microsoft.com/?id=240872
User Logon and/or Permission Errors After Restoring Dump
http://www.support.microsoft.com/?id=168001
Disaster Recovery Articles for SQL Server
http://www.support.microsoft.com/?id=307775
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"Utopian" <gla1972@.yahoo.com.ar> wrote in message news:ORGDjc$JFHA.3516@.TK2MSFTNGP10.phx.gbl...
Hello!!
I have a Data Base in sql7 and I want to transfer to another PC with a clean installation of
SQL2000. How do I do this?
Thanks!!
--=_NextPart_000_004B_01C527DD.F93DF4D0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Hello!!
I have a Data Base in sql7 and I want to transfer to another PC with a = clean installation of SQL2000. How do I do this?
Thanks!!
--=_NextPart_000_004B_01C527DD.F93DF4D0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&
Hello!!
I have a Data Base in sql7 and I want to = transfer to another PC with a clean installation of SQL2000. How do I do = this?
Thanks!!
--=_NextPart_000_004B_01C527DD.F93DF4D0--You can both attach and restore 7.0 databases into 2000:
Moving SQL Server Databases
http://www.support.microsoft.com/?id=224071
Moving Databases between Servers
http://www.support.microsoft.com/?id=314546
Using WITH MOVE in a Restore to a New Location with Detach/Attach
http://support.microsoft.com/?id=221465
How To Transfer Logins and Passwords Between SQL Servers
http://www.support.microsoft.com/?id=246133
Mapping Logins & SIDs after a Restore
http://www.support.microsoft.com/?id=298897
Utility to map users to the correct login
http://www.dbmaint.com/SyncSqlLogins.asp
How to Resolve Permission Issues When a Database Is Moved Between SQL Servers
http://www.support.microsoft.com/?id=240872
User Logon and/or Permission Errors After Restoring Dump
http://www.support.microsoft.com/?id=168001
Disaster Recovery Articles for SQL Server
http://www.support.microsoft.com/?id=307775
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"Utopian" <gla1972@.yahoo.com.ar> wrote in message news:ORGDjc$JFHA.3516@.TK2MSFTNGP10.phx.gbl...
Hello!!
I have a Data Base in sql7 and I want to transfer to another PC with a clean installation of
SQL2000. How do I do this?
Thanks!!
Subscribe to:
Posts (Atom)