Formating a box??

Hi everyone, Im using SSRS 2000 and I was wondering is there a way to
create a click button? I have 2 reports linked with hyperlinks but I
wanted to make it look more presentable. So, instead of just clicking
on the words, if I had a box that looked like a click button would be
more presentable.
Thanks in advance,
AbnerOn Oct 15, 3:51 pm, abz <abz81s...@.gmail.com> wrote:
> Hi everyone, Im using SSRS 2000 and I was wondering is there a way to
> create a click button? I have 2 reports linked with hyperlinks but I
> wanted to make it look more presentable. So, instead of just clicking
> on the words, if I had a box that looked like a click button would be
> more presentable.
> Thanks in advance,
> Abner
No, I'm afraid not. The best way to create this functionality is to
create an ASP.NET application that interacts w/SSRS. Sorry that I
could not be of greater assistance.
Regards,
Enrique Martinez
Sr. Software Consultant|||On Oct 15, 5:40 pm, EMartinez <emartinez...@.gmail.com> wrote:
> On Oct 15, 3:51 pm, abz <abz81s...@.gmail.com> wrote:
> > Hi everyone, Im using SSRS 2000 and I was wondering is there a way to
> > create a click button? I have 2 reports linked with hyperlinks but I
> > wanted to make it look more presentable. So, instead of just clicking
> > on the words, if I had a box that looked like a click button would be
> > more presentable.
> > Thanks in advance,
> > Abner
> No, I'm afraid not. The best way to create this functionality is to
> create an ASP.NET application that interacts w/SSRS. Sorry that I
> could not be of greater assistance.
> Regards,
> Enrique Martinez
> Sr. Software Consultant
oh ok, thanks any way.

Format of DateTime types in Select vs Open Table

From within the SQL Server Management Studio, if I select a table and displa
y
it (right click Open Table), columns of type DateTime are displayed with the
mm/dd/yyyy hh:mm:ss format. However, if I SELECT * FROM the same table from
a
query in the Query Analyzer (or New Query in 2005), the same column is
displayed with a yyyy-mm-dd hh:mm:ss format.
Why is there a difference in display format between opening the table in the
Management Studio and SELECT'ing in a query?
Short of using a CONVERT in the SELECT, is there a way of controlling the
display format of DateTime types in both scenarios?
Michael
--
Michael Hocksteinmichael (howlinghound@.nospam.nospam) writes:
> From within the SQL Server Management Studio, if I select a table and
> display it (right click Open Table), columns of type DateTime are
> displayed with the mm/dd/yyyy hh:mm:ss format. However, if I SELECT *
> FROM the same table from a query in the Query Analyzer (or New Query in
> 2005), the same column is displayed with a yyyy-mm-dd hh:mm:ss format.
> Why is there a difference in display format between opening the table in
> the Management Studio and SELECT'ing in a query?
Open Table respects the regional settings, while by default Query Analyzer
does not. You can change this for QA by going into Tools->Options->
Connections and check "Use regional settings...". There does not seem to be
any similar option for Management Studio. but query results always
apparently uses ISO format. (I can't really tell from here, because my
regional settings are the ISO format.)
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx|||Thank you!
Michael Hockstein
"Erland Sommarskog" wrote:

> michael (howlinghound@.nospam.nospam) writes:
> Open Table respects the regional settings, while by default Query Analyzer
> does not. You can change this for QA by going into Tools->Options->
> Connections and check "Use regional settings...". There does not seem to b
e
> any similar option for Management Studio. but query results always
> apparently uses ISO format. (I can't really tell from here, because my
> regional settings are the ISO format.)
>
> --
> Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
> Books Online for SQL Server 2005 at
> http://www.microsoft.com/technet/pr...oads/books.mspx
> Books Online for SQL Server 2000 at
> http://www.microsoft.com/sql/prodin...ions/books.mspx
>

Form submission showing null values

I have designed a for to submit some info to a sql database, but when i enter the information to the form fields and click submit, I get an error saying that a null value cannot be submitted, when it should not be null.

Not to sound whiney, but i really need a code fix, not links to msdn pages that define properties (usually dont do this, but i have a deadline to submit this to my tech admin of my company's site)

Here is the code, and THANK YOU to anyone who helps me with this!!

<%

@.PageLanguage="VB"MasterPageFile="~/MasterPage.master" %>

<

scriptrunat="server">PrivateSub Submitdata(ByVal SourceAsObject,ByVal eAs EventArgs)

SqlDataSource1.Insert()

EndSub' Submitdata

</

script>

<

asp:ContentID="Content1"runat="server"ContentPlaceHolderID="ContentPlaceHolder1"><asp:sqldatasourceid="SqlDataSource1"runat="server"connectionstring="<%$ ConnectionStrings:clientInfoConnectionString %>"selectcommand="SELECT Client Name,Client Address FROM Clients"insertcommand="INSERT INTO Clients (ClientName,ClientAddress) VALUES (@.CName,@.CAddress)"><insertparameters><asp:formparametername="CName"formfield="Namebox"/><asp:formparametername="CAddress"formfield="Addressbox"/></insertparameters></asp:sqldatasource> Name:<br/><asp:TextBoxID="Namebox"runat="server"/><br/>

<asp:RequiredFieldValidatorID="RequiredFieldValidator1"runat="server"ControlToValidate="Namebox"ErrorMessage="Please Enter A Name"></asp:RequiredFieldValidator>

<br/>Address:<br/><asp:TextBoxID="Addressbox"runat="server"/><br/>

<asp:RequiredFieldValidatorID="RequiredFieldValidator2"runat="server"ControlToValidate="Addressbox"ErrorMessage="Please Enter An Address"></asp:RequiredFieldValidator>

<br/><asp:ButtonID="Submitbtn"runat="server"Text="Submit"OnClick="Submitdata"/><br/>

</

asp:Content>

Thanks,

The King

If the columns accept null values your code without any change will work.To Insert into a column wich donot accept null this is the work around.

Make a small change in your code to make it work.

Remove the input parameter specified in the design and add the same in your code .so this part

<insertparameters>

<asp:formparametername="CName"formfield="Namebox"/>

<asp:formparametername="CAddress"formfield="Addressbox"/>

</insertparameters>

can be removed.

In the submit click add this code

SqlDataSource1.InsertParameters.Add(

"CName", Namebox.Text)

SqlDataSource1.InsertParameters.Add(

"CAddress", Addressbox.Text)

Now you are done.

|||

All I can say is

Thank You!!!!!!

It finally works!

Thanks so much,

The King