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 Mike Lewis 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. kebbusobj

    Declaring variables in Crystal Reports SQL Expression

    I didn't think so. Thank you for responding, LB. Hope you are doing well. KB
  2. kebbusobj

    Declaring variables in Crystal Reports SQL Expression

    Hello, I believe the answer is "No", but does anyone know for sure if there is a way to declare variables within a SQL Expression for a Crystal Report? My datasource is SQL Server 2005, and my version of Crystal is 2008. I am trying to keep from having to develop a stored procedure for this...
  3. kebbusobj

    Exporting Data to XML converts everything to String Data Type

    unomi, Let me provide you a little more detail, if I may. 1. I am using the ADO.Net (XML)database connection option in Crystal Reports. 2. The developer actually sent me two .xml files with the following components: An .xml file that holds two tables: A table that holds all the fields with...
  4. kebbusobj

    Exporting Data to XML converts everything to String Data Type

    Hi unomi, Thank you for the information you supplied here. My programmer keeps trying to get me what I need, and with his last effort, he provided me two .xml files. A schema file and a data file. I only pulled the data file into Crystal Reports. The data file shows all fields as "string"...
  5. kebbusobj

    Exporting Data to XML converts everything to String Data Type

    Hello All, I am new to XML exporting, and I am working with a .NET developer to provide Business Layer data (not persisted) in an XML file that I can pull into a Crystal Report. Problem is, all data types are converting to String data types, including numeric and currency data in .NET. Is...
  6. kebbusobj

    Creating a Horizontal Row of Text Boxes with Conditional Suppressions

    LBass- Thank you for your response. It's been since before you responded that I have logged back in, and I just saw your response. I actually ended up submitting a case to SAP Tech Support, and I have been working with someone there. We have tried a few things already, but nothing has worked...
  7. kebbusobj

    Creating a Horizontal Row of Text Boxes with Conditional Suppressions

    Hi Charily, Thank you very much for the suggestion; however, the problem with my solution is not with the border suppression. The problem is I can't figure out a way to to force the remaining text boxes that aren't suppressed, to display side-by-side and centered on the page. :) Hi Turkbear...
  8. kebbusobj

    Creating a Horizontal Row of Text Boxes with Conditional Suppressions

    Hi, Thank you very much for the suggestion. I will give it a try and let you know how it goes. Thanks again! KB
  9. kebbusobj

    Creating a Horizontal Row of Text Boxes with Conditional Suppressions

    Hello, I am having a problem with text boxes. I have a need to put a row of text boxes, with single line borders on all 4 sides, directly beside each other in a horizontal row, and only display the text box if data exists. If the text box doesn't display, the row is supposed to remove that...
  10. kebbusobj

    Custom Print Order in Crystal Reports

    I'm sorry. I realize that the last part might be a little difficult to understand, so please allow me to restate. The current sort order and desired sort order results are as follows: Current Sort Order: GroupName 1 2 3 4 5 6 7 GroupName 1...
  11. kebbusobj

    Custom Print Order in Crystal Reports

    Hello, To meet a report requirement, I have created a formula to derive a custom print order for the records in a Crystal Report. It is two-colum report, so the multi-column formatting option is being used in this case, and the printing direction is Accross then Down (to display the records in...
  12. kebbusobj

    Crystal Reports: Need to a formula to check if a field is suppressed

    You bet! I couldn't have done it without you, and I really appreciate it! :) KB
  13. kebbusobj

    Crystal Reports: Need to a formula to check if a field is suppressed

    Sorry, I notice that the formatting messes up for column 2, once I submit post. So, here is the before and after for column2: Before: Beer & Wine(GH) Specialty Drinks (GH) Pina Colada Margaritta Margaritta Swirl ... After: Specialty Drinks (GH) Pina Colada Margaritta...
  14. kebbusobj

    Crystal Reports: Need to a formula to check if a field is suppressed

    OK. For those of you with the same scenario that are looking to this thread for a solution, I came up with a solution to the case (that I pointed out above) where two column headings appear at the top of the 2nd column. This happens when you are at the end of the group and starting another...
  15. kebbusobj

    Crystal Reports: Need to a formula to check if a field is suppressed

    I understand. Thanks again for responding to me before and helping me out on this.
  16. kebbusobj

    Crystal Reports: Need to a formula to check if a field is suppressed

    lbass, This worked!!! I can't believe it!! I have worked on this for over 3 weeks, and couldn't get it to work 100% of the time, but this solutions does. Thank you so much! I have to say though, I am so confused as to why this solution worked and mine did not. What I had b4 was this: 1...
  17. kebbusobj

    Crystal Reports: Need to a formula to check if a field is suppressed

    Hello lbass (LB), If you happen to read this thread, my scenario is the exact same scenario as in thread 149-1092146, which you responded to back in 2005. I was just taking my report down a different solution path, which is why I posted this thread the way I did. The solution you posted in...
  18. kebbusobj

    Images Suddenly Not Displaying in Crystal Reports

    Thanks for the suggestion, LB. I will check the CR help file for any information that might help with this and post a solution here, if I find one. The setting is under the subreport tab, under format subreport. KB
  19. kebbusobj

    Images Suddenly Not Displaying in Crystal Reports

    Hi, Yes, I do have the subreport set to reimport when opening. Am I understanding you correctly to say that this is my problem? I have it setup this way because the business requirements called for the following: 1. A standard, generic header and footer for all reports 2. The ability to...
  20. kebbusobj

    Supressed fiels based upon another conditional suppression

    Thank you, and I'm sorry that we got off on the wrong foot. KB

Part and Inventory Search

Back
Top