Add New Report Wizard fails

I'm using the Developer version with SP1 and have had to reinstall because
the localhost Reports DBs were lost and there's no obvious way to get just
two empty DB's created...
So, after install, I can edit and deploy to local and Production. BUT: When
I use the "Add New Report" wizard i get a showstopper! I can choose the data
source, key in a simple "SELECT * FROM dbo.ItemType" (for example) as the
query, select "Tabular" style, then move all fields to the "Details" section.
When I click "Next", I get the following error:
TITLE: Microsoft SQL Server
---
This wizard will close because it encountered the following error:
For help, click:
http://www.microsoft.com/events.asp?progname=MicrosoftSqlServer&progver=9.0&msgsrc=CreatePubWizard.dll&msgid=CantStartSnapshotAgent
---
ADDITIONAL INFORMATION:
Key cannot be null.
Parameter name: key (mscorlib)
For help, click:
http://www.microsoft.com/events.asp?progname=MicrosoftSqlServer&progver=9.0&msgsrc=CreatePubWizard.dll&msgid=CantStartSnapshotAgent
--
Program Location:
at System.Collections.Hashtable.get_Item(Object key)
at Microsoft.ReportDesigner.Wizards.ChooseTableStyle.get_StyleBitmap()
at
Microsoft.ReportDesigner.Wizards.ChooseTableStyle.OnEnterPage(EventArgs e)
at Microsoft.SqlServer.Management.UI.WizardPage.RaiseEnterPage()
at Microsoft.SqlServer.Management.UI.WizardForm.NextPage(WizardPage
nextPage)
at Microsoft.SqlServer.Management.UI.WizardForm.Next_Click(Object sender,
EventArgs e)
---
BUTTONS:
OK
---
For help, click:
http://www.microsoft.com/events.asp?progname=MicrosoftSqlServer&progver=9.0&msgsrc=CreatePubWizard.dll&msgid=CantStartSnapshotAgent
---
BUTTONS:
OK
---
I tried clicking the links from the "Send Message Text As E-mail" option on
the "Help" button's drop-down, but the response is a 404 - not found (pretty
message but that's the error code).
I did a Web Search (MSN Search) for keywords in the message but came up empty.
No forum entry with the keywords.
I've run the install again, rebooted, etc, etc, but the error persists...
Clues? Solutions? Please...Report Designer version# is:
Microsoft SQL Server Report Designer
Version 8.00.743.00
Is this SP1? If not, that may be the problem...
"SAinCA" wrote:
> I'm using the Developer version with SP1 and have had to reinstall because
> the localhost Reports DBs were lost and there's no obvious way to get just
> two empty DB's created...
> So, after install, I can edit and deploy to local and Production. BUT: When
> I use the "Add New Report" wizard i get a showstopper! I can choose the data
> source, key in a simple "SELECT * FROM dbo.ItemType" (for example) as the
> query, select "Tabular" style, then move all fields to the "Details" section.
> When I click "Next", I get the following error:
> TITLE: Microsoft SQL Server
> ---
> This wizard will close because it encountered the following error:
> For help, click:
> http://www.microsoft.com/events.asp?progname=MicrosoftSqlServer&progver=9.0&msgsrc=CreatePubWizard.dll&msgid=CantStartSnapshotAgent
> ---
> ADDITIONAL INFORMATION:
> Key cannot be null.
> Parameter name: key (mscorlib)
> For help, click:
> http://www.microsoft.com/events.asp?progname=MicrosoftSqlServer&progver=9.0&msgsrc=CreatePubWizard.dll&msgid=CantStartSnapshotAgent
> --
> Program Location:
> at System.Collections.Hashtable.get_Item(Object key)
> at Microsoft.ReportDesigner.Wizards.ChooseTableStyle.get_StyleBitmap()
> at
> Microsoft.ReportDesigner.Wizards.ChooseTableStyle.OnEnterPage(EventArgs e)
> at Microsoft.SqlServer.Management.UI.WizardPage.RaiseEnterPage()
> at Microsoft.SqlServer.Management.UI.WizardForm.NextPage(WizardPage
> nextPage)
> at Microsoft.SqlServer.Management.UI.WizardForm.Next_Click(Object sender,
> EventArgs e)
> ---
> BUTTONS:
> OK
> ---
> For help, click:
> http://www.microsoft.com/events.asp?progname=MicrosoftSqlServer&progver=9.0&msgsrc=CreatePubWizard.dll&msgid=CantStartSnapshotAgent
> ---
> BUTTONS:
> OK
> ---
> I tried clicking the links from the "Send Message Text As E-mail" option on
> the "Help" button's drop-down, but the response is a 404 - not found (pretty
> message but that's the error code).
> I did a Web Search (MSN Search) for keywords in the message but came up empty.
> No forum entry with the keywords.
> I've run the install again, rebooted, etc, etc, but the error persists...
> Clues? Solutions? Please...|||Report Designer version#:
Microsoft SQL Server Report Designer
Version 8.00.743.00
Is this SP1? If not, perhaps that's my issue?|||I found the SP1 download and applied it - Version 8.00.878.00
However, I still get the original bomb!
Help, please, again...

add date range filter - brand newbie to reporting services

I've used report wizard to create a report - one of the fields in the report is a date field. I simply want a From Date: and To Date: filter which enables a user to select a range of dates to filter results. I know how to do this in .Net, but am not sure how to achieve this in RS. If anyone could shed some light, or point me to an thread which describes a similar process, I'd appreciate it.

thx

If you are using Visual Studio then for the data source your query should be just like a stored procedure with a parm...

Select col1, col2

From tbl1

Where col1 = @.parm1

When you open the report in Report Manager it should have a space for you to type in the value.

Now if you are using Report Builder then I don't know as I'm here looking for that answer myself.

|||

If you are using the report builder you just put the following the filter column for the date field.

Between @.SDate and @.EDate

Then go to your report parameters (right click on the upper left corner of the layout)

Click on each parameter SDate and EDate and set the type to Date/Time. It defaults as a string.

Hope this helps.

Jen

Add a third node to a cluster

Hy,
I have this problem, when I try from the setup wizard of sql 2000 to add the
new node-c the node is listed unavailable. I add the node-c to the cluster
group and function without problem with node-a and node-b, the sql 2000 in
node-a and node-b is function without problem, I not understand why the setup
sql 2000 give the node-c unavaiable to add!
Can anybody help me? sorry for the english!
Windows 2003 Server EE sp 1
SQL Server 2000 EE sp 3a
Server HP DL380
Bernardo
Take a look at the SQLSTP.LOG in the %systemroot%. See if SQL if flagging
NODE C with any information that might lead you in the direction as to why it
is listed as unavailable. Post what you find.
Regards
cT
"bernardo" wrote:

> Hy,
> I have this problem, when I try from the setup wizard of sql 2000 to add the
> new node-c the node is listed unavailable. I add the node-c to the cluster
> group and function without problem with node-a and node-b, the sql 2000 in
> node-a and node-b is function without problem, I not understand why the setup
> sql 2000 give the node-c unavaiable to add!
> Can anybody help me? sorry for the english!
> Windows 2003 Server EE sp 1
> SQL Server 2000 EE sp 3a
> Server HP DL380
|||15:59:39 Begin Setup
15:59:39 8.00.194
15:59:39 Mode = Normal
15:59:39 ModeType = NORMAL
15:59:39 GetDefinitionEx returned: 0, Extended: 0x0
15:59:39 ValueFTS returned: 1
15:59:39 ValuePID returned: 1
15:59:39 ValueLic returned: 1
15:59:39 System: Windows NT Enterprise Server
15:59:39 SQL Server ProductType: Enterprise Edition [0x3]
15:59:39 IsNTCluster returned: 1
15:59:39 Begin Action: SetupInitialize
15:59:39 End Action SetupInitialize
15:59:39 Begin Action: SetupInstall
15:59:39 Reading Software\Microsoft\Windows\CurrentVersion\CommonFi lesDir ...
15:59:39 CommonFilesDir=C:\Program Files\Common Files
15:59:39 Windows Directory=C:\WINDOWS\
15:59:39 Program Files=C:\Program Files\
15:59:39 TEMPDIR=C:\DOCUME~1\HYPHEN~1\LOCALS~1\Temp\1\
15:59:39 Begin Action: SetupInstall
15:59:39 digpid size : 256
15:59:40 digpid size : 164
15:59:40 Begin Action: CheckFixedRequirements
15:59:40 Platform ID: 0xf00000
15:59:40 Version: 5.2.3790
15:59:40 File Version - C:\WINDOWS\system32\shdocvw.dll: 6.0.3790.2440
15:59:40 End Action: CheckFixedRequirements
15:59:40 Begin Action: ShowDialogs
15:59:40 Initial Dialog Mask: 0x183000f7, Disable Back=0x1
15:59:40 Begin Action ShowDialogsHlpr: 0x1
15:59:40 Begin Action: DialogShowSdWelcome
15:59:46 End Action DialogShowSdWelcome
15:59:46 Dialog 0x1 returned: 1
15:59:46 End Action ShowDialogsHlpr
15:59:46 ShowDialogsGetDialog returned: nCurrent=0x2,index=1
15:59:46 Begin Action ShowDialogsHlpr: 0x2
15:59:46 Begin Action: DialogShowSdMachineName
15:59:55 ShowDlgMachine returned: 1
15:59:55 Name = CLX-CLUSTER-SQL, Type = 0x20000008
15:59:55 GetCDKeyForThisVS returned: 0
15:59:55 Begin Action: CheckRequirements
15:59:55 Processor Architecture: x86 (Pentium)
15:59:55 Service Pack: 256
15:59:55 ComputerName: CLX-CLUSTER-C
15:59:55 User Name: hyphenadmin
15:59:55 IsAllAccessAllowed returned: 1
15:59:55 OS Language: 0x409
15:59:55 End Action CheckRequirements
15:59:55 This combination of Package and Operating System allows a full
product install.
15:59:55 End Action DialogShowSdMachineName
15:59:55 begin ShowDialogsUpdateMask
15:59:55 nFullMask = 0x183000f7, nCurrent = 0x2, nDirection = 0
15:59:55 Updated Dialog Mask: 0xb73c037, Disable Back = 0x1
15:59:55 Dialog 0x2 returned: 0
15:59:55 End Action ShowDialogsHlpr
15:59:55 ShowDialogsGetDialog returned: nCurrent=0x4,index=2
15:59:55 Begin Action ShowDialogsHlpr: 0x4
15:59:55 Begin Action: DialogShowSdInstallMode
15:59:57 ShowDlgInstallMode returned: 1
15:59:57 InstallMode : 0x20
15:59:57 End Action DialogShowSdInstallMode
15:59:57 begin ShowDialogsUpdateMask
15:59:57 nFullMask = 0xb73c037, nCurrent = 0x4, nDirection = 1
15:59:57 Updated Dialog Mask: 0xb73c03f, Disable Back = 0x1
15:59:57 Dialog 0x4 returned: 1
15:59:57 End Action ShowDialogsHlpr
15:59:57 ShowDialogsGetDialog returned: nCurrent=0x8,index=3
15:59:57 Begin Action ShowDialogsHlpr: 0x8
15:59:57 Begin Action : DialogShowSdAdvanced
15:59:59 ShowDlgAdvanced returned: 1
15:59:59 Adv Install Mode = -2147483648
15:59:59 End Action : DialogShowSdAdvanced
15:59:59 begin ShowDialogsUpdateMask
15:59:59 nFullMask = 0xb73c03f, nCurrent = 0x8, nDirection = 1
15:59:59 Updated Dialog Mask: 0x3c00f, Disable Back = 0x1
15:59:59 Dialog 0x8 returned: 1
15:59:59 End Action ShowDialogsHlpr
15:59:59 ShowDialogsGetDialog returned: nCurrent=0x4000,index=14
15:59:59 Begin Action ShowDialogsHlpr: 0x4000
15:59:59 Begin Action: DialogShowSdVirtualServer
16:00:01 ShowDlgVirtualServer returned: 0
16:00:01 Ipaddress = 192.9.220.221,255.255.255.0,Lan Team
16:00:01 szNewList =
16:00:01 szModifiedList =
16:00:01 szRemovedList =
16:00:01 End Action DialogShowSdVirtualServer
16:00:01 begin ShowDialogsUpdateMask
16:00:01 nFullMask = 0x3c00f, nCurrent = 0x4000, nDirection = 1
16:00:01 Updated Dialog Mask: 0x3c00f, Disable Back = 0x1
16:00:01 Dialog 0x4000 returned: 1
16:00:01 End Action ShowDialogsHlpr
16:00:01 ShowDialogsGetDialog returned: nCurrent=0x8000,index=15
16:00:01 Begin Action ShowDialogsHlpr: 0x8000
16:00:01 Begin Action : DialogShowSdDiskGroups
16:00:01 ShowDlgDiskGroups returned: 1
16:00:01 Disk Group = B - SQL CLUSTER Group
16:00:01 End Action : DialogShowSdDiskGroups
16:00:01 begin ShowDialogsUpdateMask
16:00:01 nFullMask = 0x3c00f, nCurrent = 0x8000, nDirection = 1
16:00:01 Updated Dialog Mask: 0x3c00f, Disable Back = 0x1
16:00:01 Dialog 0x8000 returned: 1
16:00:01 End Action ShowDialogsHlpr
16:00:01 ShowDialogsGetDialog returned: nCurrent=0x10000,index=16
16:00:01 Begin Action ShowDialogsHlpr: 0x10000
16:00:01 Begin Action: DialogShowSdClusterDef
16:00:05 ShowDlgClusterDef returned: -1
16:00:05 ShowDlgClusterDef: GetLastError returned: 0
16:00:05 The operation completed successfully.
16:00:05 End Action DialogShowSdClusterDef
16:00:05 End Action ShowDialogs
16:00:05 Action CleanUpInstall:
16:00:05 StatsGenerate returned: 2
16:00:05 StatsGenerate (0x0,0x20,0xf00000,0x100,1033,0,0x0,0x20000008,0,0 ,0
16:00:05 StatsGenerate -1,hyphenadmin)
16:00:05 Installation Failed.
"Charles Tolento" ha scritto:
[vbcol=seagreen]
> Bernardo
> Take a look at the SQLSTP.LOG in the %systemroot%. See if SQL if flagging
> NODE C with any information that might lead you in the direction as to why it
> is listed as unavailable. Post what you find.
>
> Regards
> cT
> "bernardo" wrote:
|||This is the sqlstp.log
15:59:39 Begin Setup
15:59:39 8.00.194
15:59:39 Mode = Normal
15:59:39 ModeType = NORMAL
15:59:39 GetDefinitionEx returned: 0, Extended: 0x0
15:59:39 ValueFTS returned: 1
15:59:39 ValuePID returned: 1
15:59:39 ValueLic returned: 1
15:59:39 System: Windows NT Enterprise Server
15:59:39 SQL Server ProductType: Enterprise Edition [0x3]
15:59:39 IsNTCluster returned: 1
15:59:39 Begin Action: SetupInitialize
15:59:39 End Action SetupInitialize
15:59:39 Begin Action: SetupInstall
15:59:39 Reading Software\Microsoft\Windows\CurrentVersion\CommonFi lesDir ...
15:59:39 CommonFilesDir=C:\Program Files\Common Files
15:59:39 Windows Directory=C:\WINDOWS\
15:59:39 Program Files=C:\Program Files\
15:59:39 TEMPDIR=C:\DOCUME~1\HYPHEN~1\LOCALS~1\Temp\1\
15:59:39 Begin Action: SetupInstall
15:59:39 digpid size : 256
15:59:40 digpid size : 164
15:59:40 Begin Action: CheckFixedRequirements
15:59:40 Platform ID: 0xf00000
15:59:40 Version: 5.2.3790
15:59:40 File Version - C:\WINDOWS\system32\shdocvw.dll: 6.0.3790.2440
15:59:40 End Action: CheckFixedRequirements
15:59:40 Begin Action: ShowDialogs
15:59:40 Initial Dialog Mask: 0x183000f7, Disable Back=0x1
15:59:40 Begin Action ShowDialogsHlpr: 0x1
15:59:40 Begin Action: DialogShowSdWelcome
15:59:46 End Action DialogShowSdWelcome
15:59:46 Dialog 0x1 returned: 1
15:59:46 End Action ShowDialogsHlpr
15:59:46 ShowDialogsGetDialog returned: nCurrent=0x2,index=1
15:59:46 Begin Action ShowDialogsHlpr: 0x2
15:59:46 Begin Action: DialogShowSdMachineName
15:59:55 ShowDlgMachine returned: 1
15:59:55 Name = CLX-CLUSTER-SQL, Type = 0x20000008
15:59:55 GetCDKeyForThisVS returned: 0
15:59:55 Begin Action: CheckRequirements
15:59:55 Processor Architecture: x86 (Pentium)
15:59:55 Service Pack: 256
15:59:55 ComputerName: CLX-CLUSTER-C
15:59:55 User Name: hyphenadmin
15:59:55 IsAllAccessAllowed returned: 1
15:59:55 OS Language: 0x409
15:59:55 End Action CheckRequirements
15:59:55 This combination of Package and Operating System allows a full
product install.
15:59:55 End Action DialogShowSdMachineName
15:59:55 begin ShowDialogsUpdateMask
15:59:55 nFullMask = 0x183000f7, nCurrent = 0x2, nDirection = 0
15:59:55 Updated Dialog Mask: 0xb73c037, Disable Back = 0x1
15:59:55 Dialog 0x2 returned: 0
15:59:55 End Action ShowDialogsHlpr
15:59:55 ShowDialogsGetDialog returned: nCurrent=0x4,index=2
15:59:55 Begin Action ShowDialogsHlpr: 0x4
15:59:55 Begin Action: DialogShowSdInstallMode
15:59:57 ShowDlgInstallMode returned: 1
15:59:57 InstallMode : 0x20
15:59:57 End Action DialogShowSdInstallMode
15:59:57 begin ShowDialogsUpdateMask
15:59:57 nFullMask = 0xb73c037, nCurrent = 0x4, nDirection = 1
15:59:57 Updated Dialog Mask: 0xb73c03f, Disable Back = 0x1
15:59:57 Dialog 0x4 returned: 1
15:59:57 End Action ShowDialogsHlpr
15:59:57 ShowDialogsGetDialog returned: nCurrent=0x8,index=3
15:59:57 Begin Action ShowDialogsHlpr: 0x8
15:59:57 Begin Action : DialogShowSdAdvanced
15:59:59 ShowDlgAdvanced returned: 1
15:59:59 Adv Install Mode = -2147483648
15:59:59 End Action : DialogShowSdAdvanced
15:59:59 begin ShowDialogsUpdateMask
15:59:59 nFullMask = 0xb73c03f, nCurrent = 0x8, nDirection = 1
15:59:59 Updated Dialog Mask: 0x3c00f, Disable Back = 0x1
15:59:59 Dialog 0x8 returned: 1
15:59:59 End Action ShowDialogsHlpr
15:59:59 ShowDialogsGetDialog returned: nCurrent=0x4000,index=14
15:59:59 Begin Action ShowDialogsHlpr: 0x4000
15:59:59 Begin Action: DialogShowSdVirtualServer
16:00:01 ShowDlgVirtualServer returned: 0
16:00:01 Ipaddress = 192.9.220.221,255.255.255.0,Lan Team
16:00:01 szNewList =
16:00:01 szModifiedList =
16:00:01 szRemovedList =
16:00:01 End Action DialogShowSdVirtualServer
16:00:01 begin ShowDialogsUpdateMask
16:00:01 nFullMask = 0x3c00f, nCurrent = 0x4000, nDirection = 1
16:00:01 Updated Dialog Mask: 0x3c00f, Disable Back = 0x1
16:00:01 Dialog 0x4000 returned: 1
16:00:01 End Action ShowDialogsHlpr
16:00:01 ShowDialogsGetDialog returned: nCurrent=0x8000,index=15
16:00:01 Begin Action ShowDialogsHlpr: 0x8000
16:00:01 Begin Action : DialogShowSdDiskGroups
16:00:01 ShowDlgDiskGroups returned: 1
16:00:01 Disk Group = B - SQL CLUSTER Group
16:00:01 End Action : DialogShowSdDiskGroups
16:00:01 begin ShowDialogsUpdateMask
16:00:01 nFullMask = 0x3c00f, nCurrent = 0x8000, nDirection = 1
16:00:01 Updated Dialog Mask: 0x3c00f, Disable Back = 0x1
16:00:01 Dialog 0x8000 returned: 1
16:00:01 End Action ShowDialogsHlpr
16:00:01 ShowDialogsGetDialog returned: nCurrent=0x10000,index=16
16:00:01 Begin Action ShowDialogsHlpr: 0x10000
16:00:01 Begin Action: DialogShowSdClusterDef
16:00:05 ShowDlgClusterDef returned: -1
16:00:05 ShowDlgClusterDef: GetLastError returned: 0
16:00:05 The operation completed successfully.
16:00:05 End Action DialogShowSdClusterDef
16:00:05 End Action ShowDialogs
16:00:05 Action CleanUpInstall:
16:00:05 StatsGenerate returned: 2
16:00:05 StatsGenerate (0x0,0x20,0xf00000,0x100,1033,0,0x0,0x20000008,0,0 ,0
16:00:05 StatsGenerate -1,hyphenadmin)
16:00:05 Installation Failed.
"Charles Tolento" ha scritto:
[vbcol=seagreen]
> Bernardo
> Take a look at the SQLSTP.LOG in the %systemroot%. See if SQL if flagging
> NODE C with any information that might lead you in the direction as to why it
> is listed as unavailable. Post what you find.
>
> Regards
> cT
> "bernardo" wrote:
|||Im having the same problem. Does anyone have an idea whats the cause?