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 bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by mattbrenn

  1. mattbrenn

    Varchar to numeric data type

    Crystal 10 accessing a SQL2K db. Hi I have a quantity field that i would like to perform a sum on, but the data type of the field set in the db is varchar. I'd like to change it to a numeric data type, but am not sure of the best way to do so. Any ideas? TIA Matt
  2. mattbrenn

    Calculating the difference between 2 dates

    Cheers for the info Leigh. I used this in the stored procedure I've got to create the fact table, the data comes out fine as is now useable in the OLAP cube. Thanks again. Matt
  3. mattbrenn

    Calculating the difference between 2 dates

    Hi there I wondering how to calculate the difference between 2 dates. The cube i inherited contains within it a Promised Date and a Received Date, I've been tasked with showing the difference between the 2 and I'm not sure how best to go about it. TIA Matt
  4. mattbrenn

    Changing the database location in Crystal Reports10

    Thanks for that works a treat!!
  5. mattbrenn

    Changing the database location in Crystal Reports10

    Hi, I’m currently hooked up to a SQL test DB for testing a report, all works well so its time to switch to the live database. I’ve used the set data source location option to change to the live DB, which it has. However no data is then returned form the report. When I ‘Show SQL Query’ its still...
  6. mattbrenn

    Stored procedure calling a char based parameter

    Thanks for the tip its very much appreciated Worked first time. Best regards Matt
  7. mattbrenn

    Stored procedure calling a char based parameter

    SQL2K Hi, I've created a stored procedure with a CHAR datatype as the parameter that is passed to it and cant seem to get it to work. I've tried using different fields with different datatypes such as int and numeric and its successful. Is there a problem using a Char datatype as a parameter...
  8. mattbrenn

    Crystal reports versus Microsoft Reporting services

    Thanks to the 3 of you for the information. Should keep me going for a while. best regards Matt
  9. mattbrenn

    Crystal reports versus Microsoft Reporting services

    Hi there. Has any one seen any other threads or links where a comparison between crystal and MS reporting services has been detailed. I'm pretty sure i saw one a couple of weeks ago but cant for the life of me find it. TIA M
  10. mattbrenn

    Using ReCrystallize to run reports

    Thanks for the tip, but alas still doesn't seem to work. I have found a pdf doc on the crystal site which seems to agree with what you said so I'm just running through it at the moment. Im not going to be working for the next week or so, but if i have a result I'll forward you the document for...
  11. mattbrenn

    Using ReCrystallize to run reports

    Using Crystal Reports 8.5 ReCrystallize 3.0.3. Acessesing SQL 2000 DB I’ve currently got a couple of reports that I am running using ReCrystallize to push the parameters to crystal and outputting a report via an .ASP page. All was good until I widened a field on 1 of the reports as the data...
See more

Part and Inventory Search

Back
Top