Adding a new column is DBNULL

Hello,

VS 2005

I am developing the database application. This is a live database and is being used by the customer. I am to release a new version and I had to add new columns to fit the requirements DateStarted (DateTime), and TotalHours(Int) into a database table.There are already over a 1000 rows in this table.

When the customer wants to look at a record in this table and insert the value into the text boxes (Front-end), when it gets to the DateStarted or TotalHours it comes up with a error message:"

The value for column 'DateStarted' in table 'IncidentTask' is DBNull."The method for inserting is:

Code Snippet

Me.dtDateStarted.Value = Me.DsIncidentsControl.IncidentTask(0).DateStarted

What are the possible solutions to this problem? Would it mean checking for a DBNULL before displaying in the textboxes? Or updating the new column rows with an date:

Code Snippet

UPDATE IncidentTask SET DateStarted = '1/1/2005' WHERE (DateStarted IS NULL)

Many thanks for any suggestions,

Steve

You can either have the application check for null values and display an empty string when dbnull,

OR,

UPDATE the table and put a 'dummy' date in all null rows.

Adding a legend to a report

I want to add a legend to a report. In the .Net version of the report, a
button was clicked which brought up a html page. Any suggestions?Why not adding a hyperlink to your RS reports which also points to a html
page?
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Delton Blackwell" <deltonblackwell@.hotmail.com> wrote in message
news:OjCNQTTWEHA.3024@.TK2MSFTNGP09.phx.gbl...
> I want to add a legend to a report. In the .Net version of the report, a
> button was clicked which brought up a html page. Any suggestions?
>|||I don't quite understand your question. Would you please elaborate on what
you are attempting to achieve
--
Bruce Johnson [MSFT]
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Delton Blackwell" <deltonblackwell@.hotmail.com> wrote in message
news:OjCNQTTWEHA.3024@.TK2MSFTNGP09.phx.gbl...
> I want to add a legend to a report. In the .Net version of the report, a
> button was clicked which brought up a html page. Any suggestions?
>

Adding a "DB Version" Table: Suggestions?

I'm putting a little table in my DB that I'll call zstblVersion.

("..stbl" for System Table, "z" so it sinks to the bottom of the list and
doesn't look like something to do with the app)

The purpose is to let somebody look at the DB and divine which version they're
seeing.

So far, I've got 3 columns:

- VersionID
- VersionDescription (freeform text description of the changes in this version
of the DB)
- AppVersionRequired (numeric field, containing the lowest version of the front
end that will work with this version of the DB)

Opinions? Suggestions?
--
PeteCresswellHi

I have seen several application that use this sort of thing, and they can be
useful for support.

You may want to add entries for the release date, date upgraded/installed,
the username who upgraded, previous version number, OS (at time of
install!), possibly SQL Server versions (at time of install) etc

These could be put in a readonly filegroup, although you would need to do a
little more when doing the upgrades.

John

"(Pete Cresswell)" <x@.y.z> wrote in message
news:hkkeovomiv3jidkll7mda1jrkk4ptuc1p2@.4ax.com...
> I'm putting a little table in my DB that I'll call zstblVersion.
> ("..stbl" for System Table, "z" so it sinks to the bottom of the list and
> doesn't look like something to do with the app)
> The purpose is to let somebody look at the DB and divine which version
they're
> seeing.
> So far, I've got 3 columns:
> - VersionID
> - VersionDescription (freeform text description of the changes in this
version
> of the DB)
> - AppVersionRequired (numeric field, containing the lowest version of the
front
> end that will work with this version of the DB)
> Opinions? Suggestions?
> --
> PeteCresswell

Add Version to Custom Report

Hello
Has anybody found a good way to add version control to a report? I could
add a text box to the report and enter Version:20060927. Because this is a
manual operation some developers may forget and it will become unreliable.
If someone found a better way please let me know.
Thanks
Johnuse Globals!ExecutionTime expression. It will display the date and time
when the report is generated. Playing around with it will help you produce
what you wanted.
hth,
"John A Kushwarra" <jkushwarra@.empire.edu> wrote in message
news:uMVVWyj4GHA.4352@.TK2MSFTNGP03.phx.gbl...
> Hello
> Has anybody found a good way to add version control to a report? I could
> add a text box to the report and enter Version:20060927. Because this is
> a manual operation some developers may forget and it will become
> unreliable. If someone found a better way please let me know.
> Thanks
> John
>sql

Add NT users

what's the version of your SQL Server and NT?
>--Original Message--
>After adding NT users as SQL Server logins, I tried to
set
>them up on their PC using ODBC connections but get the
>message:
>SQL Server error: 18452
>Login failed for user (null). Reason: not associated with
>a trusted SQL Server connection
>Can someone advise on basic checks?
>(Our SQL Server is setup for MIXED MODE and I myself can
>use the NT Authentication since I belong to the SQL ADMIN
>group via the main DOMAIN server setup)
>thks!
>.
>Login failed for user 'null' means that we were unable to 'impersonate' the
user. We need to be able to impersonate when we authenticate to SQL using
your Windows NT credentials.
Typical client server environment:
Scenario 1:
Client --> SQL
If this fails, then it may be a problem with the communication between the
client and the Domain Controller. You can make network traces from the
client and /or enable Kerberos logging to verify if this is the case. This
may occur when using sockets, but not with Named Pipes connections.
Scenario 2:
Web Server/SQL Environment
Client-->IIS-->SQL.
If your scenario looks like the Scenario 2 (Web Server/SQL Environment),
then this scenario is more complicated to configure.
The middle machine (IIS) must be trusted for Security Delegation. And the
Domain Admin needs to set the spn for SQL Server.
The client machine must use TCP/IP and authenticate via Kerberos
authentication. If it uses NTLM, then this will fail with "Login failed
for user 'null'".
This article goes over various scenarios:
http://msdn.microsoft.com/library/d...-us/dnnetsec/ht
ml/SecNetch05.asp
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.

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 a "print" button to Report Manager?

I know that there is a print button with RS 2.0, but is there a way to
add the button on the current version of report manager?
Thanks,
TrintSP2 will have the print functionality. It is coming out very soon, so
please keep an eye out for it in the next couple weeks to month or so.
--
| From: "trint" <trinity.smith@.gmail.com>
| Newsgroups: microsoft.public.sqlserver.reportingsvcs
| Subject: Add a "print" button to Report Manager'
| Date: 29 Mar 2005 04:25:25 -0800
| Organization: http://groups.google.com
| Lines: 5
| Message-ID: <1112099125.393374.154240@.o13g2000cwo.googlegroups.com>
| NNTP-Posting-Host: 65.244.90.165
| Mime-Version: 1.0
| Content-Type: text/plain; charset="iso-8859-1"
| X-Trace: posting.google.com 1112099129 1365 127.0.0.1 (29 Mar 2005
12:25:29 GMT)
| X-Complaints-To: groups-abuse@.google.com
| NNTP-Posting-Date: Tue, 29 Mar 2005 12:25:29 +0000 (UTC)
| User-Agent: G2/0.2
| Complaints-To: groups-abuse@.google.com
| Injection-Info: o13g2000cwo.googlegroups.com; posting-host=65.244.90.165;
| posting-account=Ih-yCA0AAADzXymSlPU6JhcQ_cZnGStd
| Path:
TK2MSFTNGXA03.phx.gbl!TK2MSFTNGP08.phx.gbl!newsfeed00.sul.t-online.de!t-onli
ne.de!news.glorb.com!postnews.google.com!o13g2000cwo.googlegroups.com!not-fo
r-mail
| Xref: TK2MSFTNGXA03.phx.gbl microsoft.public.sqlserver.reportingsvcs:46347
| X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
|
| I know that there is a print button with RS 2.0, but is there a way to
| add the button on the current version of report manager?
| Thanks,
| Trint
|
|