You searched for the word(s): userid:672976

More Search Options

RSS Available

• Fixing Specific data to page

  I have a report ssrs2005 which prints ok if I select the id or invoice number for . My reports creates a single invoice which can be printed or exported ok. The issue is I need to be able to print a range of the invoices so I created a where statement Where invoicenumber between 'Invoiceno' and 'InoviceNo2' Then I created a paramenter for it . Every thing look good I am able to put the starting invoice number in and the ending invoice and run the print. The problem is I get 50 or

  Posted to SQL Server Reporting Services (Forum) by cpowers on 4/6/2009

• Need help with update and change SQL query

  Hello I have 2 tables which I need to be able to either add data, change existing data or update date from one table to another with out changing all fields. example table one. Row Id client ID PhoneNo FirstName LastName 1 23 555-555-5551 John Smith 2 23 555-555-5551 John Smith 3 24 555-555-5552 Jane Doe Second table example. type of client Client ID PhoneNo FirstName LastName New 26 555-555-5554 John Doe ChangeRecord 23 555-555-5550 John Smith I need to be able to add the new client to the table

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by cpowers on 2/23/2009

• Need help with Decimal point ssrs field

  I have an expression in my ssrs report =Sum(distance, "mainroute") when I run the report I get a total example 345678.00010298 I need it to reflect 34568 how do I set the decimal to 2 I have tried to use =Sum(distance, "mainroute"),2 but that does not work

  Posted to SQL Server Reporting Services (Forum) by cpowers on 1/28/2009

• Re: I need help ASAP for Detailsview update issue

  I fixed it need to remove some of the code and it worked fine

  Posted to Data Presentation Controls (Forum) by cpowers on 12/2/2008

• Re: Need help with update detail

  I can not select advance because I did a custom sql statement for the select, update ,edit and delete you should be able to see this in the code posted earlier.

  Posted to Data Presentation Controls (Forum) by cpowers on 12/2/2008

• Re: Need help with update detail

  Try that didn't fix the problem I am stumped

  Posted to Data Presentation Controls (Forum) by cpowers on 12/2/2008

• I need help ASAP for Detailsview update issue

  I need some expert help. I created a gridview which has a edit link to a detailsview this connects ok I can enter new data into the detailsview and it saves the data fine to the SQl and the gridview reflect the data that had been entered from the detailsview. The Problem is when I need to edit the fields in a record using the detailsview it allows me to make the change but when I click the update it refresh with the old data and nothing has been updated. I have had several people tell me to check

  Posted to Data Presentation Controls (Forum) by cpowers on 12/2/2008

• Re: Need help with update detail

  That is the only primary key.

  Posted to Data Presentation Controls (Forum) by cpowers on 12/2/2008

• Re: Need help with update detail

  Correction I copied the wrong grid view here is the correct on it still does not work any suggestions The Gridview: < asp : GridView ID ="GridView1" runat ="server" AutoGenerateColumns ="False" CellPadding ="4" DataKeyNames ="ALNLogID" DataSourceID ="SqlDataSource1" Font-Names ="Tahoma" Font-Size ="Smaller" ForeColor ="#333333" GridLines ="None" Style ="z-index: 100; left: 1px; position: absolute;

  Posted to Data Presentation Controls (Forum) by cpowers on 12/2/2008

• Re: Need help with update detail

  MicahG, I checked the gridview and the detail and I have the datakeyName listed in both they should be correct. I haven't changed anything and still can not get the update to work on the detailveiw any suggestions full code is above. The GridView: asp:GridView ID="GridView1" runat="server" AllowSorting="True" AutoGenerateColumns="False" CellPadding="4" DataKeyNames="ALBLogID" DataSourceID="SqlDataSource1" Font-Names="Tahoma"

  Posted to Data Presentation Controls (Forum) by cpowers on 12/2/2008