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: *

  1. morriskc

    SQL Case Statement Logic

    Thanks all, I did as Duane suggested and added a table to the database. The table approach worked great!
  2. morriskc

    SQL Case Statement Logic

    Is there any way to use the SQL case statement logic to create a column in Access? I am using Access 2000 & the following is the statemnt I am trying to add as a column. CASE WHEN (T1."ProductClass" IN...
  3. morriskc

    Column Formatting

    Here is a thought... Since you are using a stored proc, have the proc return result set be for col1, col2, col3, etc. The value of col1, col2, col3, etc. can be returned from the parameter(s). The Crystal report would then contain col1, col2, col3, etc. which would probably have to be generic...
  4. morriskc

    Why won't this flip the ole db database at runtime

    Chuck, Do your Crystal reports contain the database name when saved? Check by going to Database & seeing if the server name is displayed. You may want to try creating the reports against an alias database name. If you have a seperate web server per environment, you will not need to change...
  5. morriskc

    Dynamic Formatting

    Have you considered allowing the user to select the sort order & field as a prompt before they run the report?
  6. morriskc

    Database - Verify Database doesn't work

    I have run into this in the past. A work around to try is to make a copy of the stored proc, set location to the copy, save, then set location back to the old proc & save. You can then delete the copy of the proc that you no longer need. This usually works for me.
  7. morriskc

    Trying to use Like to select records

    Try a different wildcard character. Some environments use the % as the wildcard.
  8. morriskc

    Export to excel changes data

    I ran into a similiar problem some time back. Reports we had were displaying goofy numbers, but only in Excel. In our case, it turns out that Excel was recalculating the group footer & report totals & including data that was in the report header. For example, our report header had a cost...
  9. morriskc

    How do I call a stored procedure involving 3 result tables?

    ...proc. You will need to return a single result set that contains all the data you need. Rename the fields as needed, e.g., instead of select * from tmp_HdrPurchase select * from tmp_DetPurchase select * from tmp_FtrPurchase use: Select t1.HDRdate_applied ,t1.HDRaddress_name...
  10. morriskc

    CRYSTAL REPORTS and STORED PROCEDURES

    If you change the name of the stored proc, you will have to do a set location to point the report to the renamed proc. Why is the stored proc name changing?
  11. morriskc

    Grouping by Week (With a Twist)

    Do you count tickets that were open for several weeks but are now closed or just open tickets when the report is generated? If I understand you correctly, any ticket that is open today has to be counted for every week since it opened. Therefore, you count the number of open tickets, grouped...
  12. morriskc

    Set Datasource Location???

    We do not make any changes when going from dev to integ or from integ to prod. We just move the server that the sql.ini is pointed to for Sybase or the alias set up in our client network utility for SQL Server.
  13. morriskc

    CRYSTAL REPORTS and STORED PROCEDURES

    yes, you do need to make sure that you have stored procs selected under options database
  14. morriskc

    Switching physical database so CR9 report points to new datasource

    Have you tried creating an alias for your dev box database? When you are ready to move to production, go into your client network utility for SQL Server & edit the alias so that it points to the production box instead of dev. No changes will need to be made to the report.
  15. morriskc

    Switching database once Report is developed

    I always create an alias for my database connection & use that alias for connecting my report to the database. This way, when I switch from dev to test to production, I am switching the sql.ini file on my machine & not touching the report.
  16. morriskc

    Reporting aginst IXOS

    Has anyone used Crystal Reports against IXOS? We are going to start using IXOS as our archiving tool & I have been asked about using CR against IXOS. In particular, any helpful hints, specific problem areas,etc. would be appreciated. KCM
  17. morriskc

    Crystal Reports 8.5 Stored Procedures

    In your procedure, you will need to add a group by statement. Group By customernumber Keep in mind that the other fields in your proc's select statement will either need to be include in the group by or have some kind of compute (MAX, MIN, SUM, AVG) performed within your select statement...
  18. morriskc

    Crystal Reports 8.5 Stored Procedures

    try: routestops.routecode in ('NEC5-1','NEC2-1','NEC3-1','NEC7-1') and customernumber in ('2086','BOA014') and sequence <>'1'
  19. morriskc

    Lots of manual Cross tabs in one Report File ?

    You can try inserting an additional report footer, placing the next crosstab in a report footer(report footer b) and placing the table header in report footer a. Format section report footer b and select new page after. Repeat with as many report footers as you need. I'm not familiar with...
  20. morriskc

    Crystal Reports and temp tables in a stored procedure.

    Frank, I use stored procs (with many temp tables) alot & have found the best approach is to test by running the proc in SQL, like with SQL Programmer. If your proc comes back with more than one result set, Crystal gets very cranky. Even print statements can throw your report off.

Part and Inventory Search

Back
Top