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!

  • Congratulations Chriss Miller 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: Kennymc
  • Content: Threads
  • Order by date
  1. Kennymc

    Has anyone used Crystal reports with online Microsoft Dynamics 365

    Has anyone used Crystal reports with online Microsoft Dynamics 365 ? Using a 3rd party ODBC connector and tried a different connection through reportbuilder and get the same message DataSource.Error: Dynamics365BusinessCentral: Request failed: The remote server returned an error: (400) Bad...
  2. Kennymc

    SAP 2020 missing data

    found a 3rd party ODBC connection so I can connect Crystal reports to Dynamics 365. Since new the 365 tables are small so I did a quick report of 1 table to view the all data. Worked once but then the key id field was blank. contacted support and both blame the other. However the ODBC...
  3. Kennymc

    Crystal connection to Microsoft business central 365

    HI, Have always used a local server and kept our accounting software in house . Trying to find something so I can connect Crystal reports to access the data from Microsoft Business Central 365 online I have experimented with PowerBI and it will connect. Would think Crystal would have...
  4. Kennymc

    HP 448 uthrium driver

    Have an older version of Backup exc 9? and need to pack up 2003 server. I have another 2003 server that has no issue but the other cannot seem to find the tape drive. Checked on the web and concluded I need the driver for the HP 448. But since both tape drive and server are obsolete and...
  5. Kennymc

    printing 4 by 6 labels

    I print a lot of shipping labels for Amazon. Never had an issue until this month. Previously when I selected the label printer it would automatically adjust to the proper print size. Now it stays on 11 by 8.5 and will not let me change it. I have an older PC with windows 7 and the using the same...
  6. Kennymc

    backup exec

    I have the latest version and backup via a usb passport. It works well except when I switch to another passport my jobs get updated to include backing up a new drive ( the new passport). When it backs up it goes in a continued loop backing up 200 gigs or more of data instead of the actual 25. I...
  7. Kennymc

    Active X

    Hi, I have others users run reports using Crystal Active X for viewing reports. Seems the latest update from Microsoft has stopped Active X from running. The report pulls up a blank page. Is there a newer version. All machines are 32 bit. With the previous updates I was able to add the report...
  8. Kennymc

    Lucky number 7

    I have a Crystal report that prints Bill of ladings (BOL) from our accounting system. I can only print 7 items on the BOL. So after 7 lines, I force it to start a new page. Works perfectly for less than 7 lines and 8 or more. However when there is exactly 7 lines it prints a blank second page...
  9. Kennymc

    Alignment

    Trying to import data from an Excel file that has many Order headers and Order lines. I need to convert it into a fixed length text file so I can import the information into our accounting system. Unfortunately the import is fixed width and dependent on the column position. I have it working...
  10. Kennymc

    Crystal 9

    My PC died and I can not find my original CD for Crystal 9. I did find my license. Any way/where I can get another Cd of CR 9 Advanced?
  11. Kennymc

    anonymous login

    I have a windows server 2003 that runs Trend Micro SMB. Recently I upgraded from 3.5 to 3.6 to accomadate a few Vista computers on my network. I have the web console set up for anonymous login but it requests the admin and password. It didn't do this for 3.5 Trend will force updates to the...
  12. Kennymc

    HP firmware

    I have a HP 350ml running windows 2003. One of the drives went bad under warranty and I contacted HP. Before they would send me another drive they required me to update to the latest firmware. So I did that and ran their diagnostics only to find out I have a bad drive. Replaced the drive and...
  13. Kennymc

    Subject line warning

    Is there anyway to warn or force an internal person to put something in the subject line? I can find information on OutLook Express but not Outlook
  14. Kennymc

    Data Selection

    More of a curious question. If you're creating formulas for example, sometimes you have a choice of selecting existing report fields or going back to the table to get the data. When you have this choice, What would be the best programming practice to use?
  15. Kennymc

    sums incorrectly

    I have a field I am trying to post a summary. I have it reset to 0 in the groupheader1 Customer name Group footer 2 has the formula also have my calculation for openamt whileprintingrecords numbervar totalopenamt totalopenamt := totalopenamt + openamt in groupfooter 1 I have...
  16. Kennymc

    Database connection

    Currently using Crystal 9 and want to connect to an old database from Q&A. Can't find the right DLL I need to download. database file extention is DTF get the error No database DLL has been specified.
  17. Kennymc

    Joins not working correct

    I am using CR 9 and a sql 2000 database. I have tried all join types, reversed links but still get the same number of records. There are rows in axapataoraclelines that do not have a corresponding row in inventtable. If I use Crystal SQl designer - I get all the rows The query by CR9 SELECT...
  18. Kennymc

    how to get MTD, YTD columns

    I want to develope a report that looks like this Sales as of "aug 15, 2004" - cust# daily sales MTD sales YTD sales lastyear sales a1 1.00 2.00 4.00 10.00 a2 4.00 5.00 15.00 a3 1.00...
  19. Kennymc

    Carriage return

    In a sql database table there is a column called address. However if you have more than one line on the address, it's separated by a carriage return within the same column. when I view the field within the applications I can see the entire address. In Crystal I only see the first line. How...
  20. Kennymc

    Can connect no tables

    I can connect to my Oracle 7.3.4 database in CR 9 but no tables appear. Currently using Oracle own ODBC and it works, but can not get the left outer join to work. It was suggested I use the CR driver. If I use Admin32 I can connect and see the tables but get an warning message that I need to...

Part and Inventory Search

Back
Top