Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: jasperjasper
  • Order by date
  1. jasperjasper

    How to display in the current date column of a crosstab in a date rang

    I have a cross tab that displays trucks that have arrived at their destination. For the columns, I am displaying the received date and for the rows, the truck that has arrived. If the truck has not arrived, (still in transit) the user requests that they display in the current date column of the...
  2. jasperjasper

    Added a field to the stored procedure not showing up in report

    OK, I stand corrected. Thanks for your help.
  3. jasperjasper

    Added a field to the stored procedure not showing up in report

    oops ...got it...I had to verify the database... Why dont they just call that refresh!!!! Thanks for all your help in this group.You've been great.
  4. jasperjasper

    Added a field to the stored procedure not showing up in report

    I added a field to a stored proc that my report is based on. I refreshed the database and the stored proc from the server explorer, it displays the new field...however in the field explorer, my report is not showing the new field... What am I missing....
  5. jasperjasper

    Configuring Cross Tab Reports

    I am trying to develop a report which displays data in columns....where the columns are dates and the rows are truck numbers....like so.... 12/15 12/16 12/17 12/18 ----- ----- ----- ----- 123xyz 4343PPP 124POY 112jtj 434KKR 98JJM 434jjt 848NCB 440jvj I...
  6. jasperjasper

    Trouble Creating a cross tab report in VS.NET

    That was it....Thank you so much. Have a great holiday. Tek-Tips to the rescue again....SUPER!
  7. jasperjasper

    Trouble Creating a cross tab report in VS.NET

    no..its been a while since i used it
  8. jasperjasper

    Trouble Creating a cross tab report in VS.NET

    I am trying to create a cross tab using the crystal reports wizard from within the VS.NET IDE... The finsih button in the wizard is greyed out.... I don't understand why...anyone know what the heck I am doing wrong... Thanks
  9. jasperjasper

    How can I get crystal to format 1 column for each date

    I have a report that will have data in a 7 day period.... 12/1 12/2 12/3 12/4 12/5 ---- xxxx xxxx xxxxx xxxxx xxxx xxxx I want the data to line up columns by the date value.... Any one know how to do this?
  10. jasperjasper

    How can you test a crystal report in .NET

    I have creatd the report in Crystal by doing a project add component...crystal report... How can I run it inside the IDE? Thanks
  11. jasperjasper

    How can I set a dbgrid cell color

    I have a dbgrid that i fill with data no problem via a dataset. One of the columns in the grid is an amount column. I can read thru the grid testing the amount value in each row, but if the value is less than 0 I want to make the value red, otherwise green. I have been unable to do this. Is...
  12. jasperjasper

    IE will not connect

    I have been asked to help a friend with his computer. They have a DSL connection. When they log onto AOL its fine. If you click Internet Explorer, it connects fine. However, without logging onto AOL, if you click the explorer icon, you won't connect... BUT, I have seen it work without going...
  13. jasperjasper

    How to display duplicate values contained in a column

    WOW...Great. That is correct. Thank you so much. I should have known that.
  14. jasperjasper

    Installing VB6 AFTER Visual Studio is installed

    Has anyone installed VB6 AFTER installing Visual Studio.NET? Thanks..Ed
  15. jasperjasper

    How to display duplicate values contained in a column

    I need to create a stored procedure to display all duplicate values that are in a column. In the following list I need to display the duplicate values --- which in this case is 543211. Can anyone give me a clue on how to accomplish this in SQL via a stored proc. Thanks VendInv# -------- 000001...
  16. jasperjasper

    dbgrid coloring

    I wanted to set the forecolor of one column (Amount) in the grid. I read each amount in a loop, and if the amount is < 0 i want the text to display red, else green. In VB6 this was easy....
  17. jasperjasper

    dbgrid coloring

    Is there an easy way to add color to a grid column...say its based on an amount > 0 green.... I have been sent some code but its lengthy...in VB6 it was one line of code...like cell.backcolor = green Cant i do this in VB.NET
  18. jasperjasper

    Object must implement ICONVERTIBLE

    I am receiving the following error message in my Add routine... Object must implement IConvertible. It is happening on the ExecuteReader statement. I did get this once before, but I dont remember what it was that took care of it....
  19. jasperjasper

    How can I get all the reports that use a specific query

    I have to do a research job. I need to find all the forms and reports that use a specific query. I have Speed Ferret, however I am getting numerous errors from it...I cant get it to work... is there something else that will do that... is there a systable of sorts that I can query.... Thanks
  20. jasperjasper

    VB.NET Vs. Access

    I have been working with VB.NET for the past few months trying to learn it. I am wondering what you all think about it as it compares to developing in Access. I find that Access is way more flexible to use. I think VB.NET has gotten more difficult to use than easier ..... I would love to hear...

Part and Inventory Search

Back
Top