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 derfloh 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. MRWARNER

    Crosstab Row Numbering

    Hi LB I did have to put the grouping back in, I lost my order when I reopened the report. Didnt realize I could have just sorted. Thanks - Again! [thumbsup2] PS: I have taken 3 different Crystal classes over the past years and they all touched on variables but never went into in depth...
  2. MRWARNER

    Crosstab Row Numbering

    If that is not the coolest thing I have seen I dont know what is. lbass You have helped me more more than once and I am in debted to you. I dont understand the coding with variables, I dont know if I ever will, but this was beautiful. Thank you, Thank you! [bigcheeks] Michele PS:I removed...
  3. MRWARNER

    Crosstab Row Numbering

    Help please, Using Cr9/SQL DB, Crosstabs: I want to add a column to the left of my row header(name)displaying a numerical sequence (1,2,3,4,5 etc....) I guess it would be like numbering the row header but I want to keep the row header (name) as the alpha sort. We will be adding new names each...
  4. MRWARNER

    Monthly date ranges

    Once again, Your Brilliant! Thank you it's perfect and it sorts in the right order too. I voted for you, again. Michele [2thumbsup]
  5. MRWARNER

    Monthly date ranges

    I need help with this too. I have CR9 I have multiple years to report on and when I use Month as the column header (in crosstabs)and Year as a row header the results display months for each year, so I have 2 or 3 sets of months as headers. I only want the month to display once on top like this...
  6. MRWARNER

    lining up fields with labels

    To line up labels and fields you will want to click on both then right click and choose ALIGN or SIZE. Play around with this awhile and you will have everything lined up and even in no time.
  7. MRWARNER

    Cross Tab

    Hmmmm, The way your mind works is amazing. I'll give that a try. Thanks
  8. MRWARNER

    Cross Tab

    Thanks, this was a great tip. Do you know how we could do this with the summarized fields and the totals? Thanks again!
  9. MRWARNER

    CR9 Crosstab Percent of Difference

    I have been searching for a solution and have found lots of answers but not the one I needed. I am posting this because I think it resolves my issue but I'm not sure if I will have repercussions from this method. Please respond. In CR9 Crosstabs I am trying to create a % field based on the...
  10. MRWARNER

    logon failed

    Was your report recently updated from CR8 or CR8.5 to CR9? Does it have Sub-reports, if so how many?
  11. MRWARNER

    CR9 Logon Failed Connection Properties

    No recent changes and hundreds of other reports work perfectly fine. Thanks for help. Michele
  12. MRWARNER

    CR9 Logon Failed Connection Properties

    I am not a developer, I cannot alter the VB application. This code is the suggested fix by (BO) Crystal Reports Knowledge base. I am now guessing it is VB code and not something I can fix within CR9. I have reset the datasource in CR9 on one of the reports and that didnt work. Can you let me...
  13. MRWARNER

    Using ALL in SQL parameters

    Using SQL 2000 Stored Procedures I needed to pass an ALL parameter back to CR9. I couldnt find any information on this for SQL. I borrowed and altered an idea from a friend and it seems to work just great. Can anyone think of any reason why this might not work? I created a temp table and put...
  14. MRWARNER

    CR9 Logon Failed

    Have some reports (CR 9.0) that I open in a vb6 application, the db is SQL 2000 – I am connecting with ODBC If I run the report in crystal I have no problem, when I try to open it in Application I get this message : Logon failed. Details:2800:[Microsoft][ODBC SQL Server Driver][SQL Server]Login...
  15. MRWARNER

    CR9 Logon Failed

    Have some reports (CR 9.0) that I open in a vb6 application, the db is SQL 2000 – I am connecting with ODBC If I run the report in crystal I have no problem, when I try to open it in Application I get this message : Logon failed. Details:2800:[Microsoft][ODBC SQL Server Driver][SQL Server]Login...
  16. MRWARNER

    CR9 Logon Failed Connection Properties

    Have some reports (CR 9.0) that I open in a vb6 application, the db is SQL 2000 – I am connecting with ODBC If I run the report in crystal I have no problem, when I try to open it in Application I get this message : Logon failed. Details:2800:[Microsoft][ODBC SQL Server Driver][SQL Server]Login...
  17. MRWARNER

    logon failed

    Using CR9 - I am getting the same error and have found this same code in the Crystal Knowledge Base. Unfortunately I dont get it. Where am I suppose to write this code? I understand I am getting this error due to writing this report in 8 and then updating to 9. I have many other reports I...
  18. MRWARNER

    Wildcards, Parameters and ALL

    I didnt know that - OOh thank you so much. This may resolve some other issues I was having. Very Good!
  19. MRWARNER

    Wildcards, Parameters and ALL

    Perfect - This works great, and yes these are single values Thanks a bunch I am curious though, why would it behave differently when all that was done was to flip flop field name and parameter?
  20. MRWARNER

    Wildcards, Parameters and ALL

    Here is my code for Parameters that will allow a one or all type search with the (one) being a wildcard search. ('*'+{?Name}+'*' LIKE {@Name} OR {?Name} = "ALL") AND ('*'+{?Insureds}+'*' LIKE {@ssn} OR {?Insureds} = "ALL") I am using Crystal Reports 9 - When I use this with the WildCard "*"...

Part and Inventory Search

Back
Top