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. BobDennison

    Scheduling LOVs changes Dynamic Prompts to Static

    I hope there is a solution to my dilema. I am using Crystal Reports 2008 Version 12.2.0.290 with SP2 installed. My data is coming from a Data Warehouse and we are using a third party front end for displaying the reports. I have several reports that have a lot of selection criteria (20 or more...
  2. BobDennison

    Need to format numeric field with null different than zero

    Thank you for the suggestion. I had tried that, but was not getting the results I wanted. I finally figured out a way to do it though. What I did was go into field format. One the numeric tab I set the default value of zeroes to 0. Then I went to the common tab and wrote code under the Suppress...
  3. BobDennison

    Need to format numeric field with null different than zero

    I am using Crystal 2008 and my data is coming from a data warehouse. I have a situation where the users want to display a null value as a dash '-' and a zero value as a zero '0'. I have tried using the customize format, but can't mix the 2 formats on the same field. I tried creating a formula to...
  4. BobDennison

    Subreports with page headings problem

    That works great. Thank you so much.
  5. BobDennison

    Subreports with page headings problem

    Hello everyone, Hope you are having a great day. I am having trouble coming up with a solution to a request I have been given. I hope someone can help me out here. I have been asked to produce a very large report (approximately 100 inches wide). However, the users don't want to see all of the...
  6. BobDennison

    Passing MultiSelect Parameters to a SubReport

    Yes they did. I tried both ways and the static parameters worked but the dynamic parameters prompted me again for input.
  7. BobDennison

    Passing MultiSelect Parameters to a SubReport

    This is working great now. Thank you so much for your help. Bob
  8. BobDennison

    Report header on subreport question

    This works fantastically!!!!!!! Thank you, thank you, thank you!!!!! Bob
  9. BobDennison

    Passing MultiSelect Parameters to a SubReport

    In the main report the parameters are dynamic. Do I make the ones in the sub reports dynamic as well or are they static?
  10. BobDennison

    Report header on subreport question

    Okay. I just moved it to the highest group level and it works, but it also shows the column headings from the 2nd group. Is there any way to not show them on the details drill down?
  11. BobDennison

    Passing MultiSelect Parameters to a SubReport

    I have set up several Report Header sections where I display information about the report, give contact information and collect the parameters. Then I have put the sub reports in 3 different Report Footer sections. Each of the sub reports could be stand alone reports because they each connect to...
  12. BobDennison

    Report header on subreport question

    The main report collects 4 parameters: Beginning year, Ending year, County, and City. Then it passes these parameters to the sub reports. After retrieving the requested data the sub report portion of the report shows totals by accident year: total accidents, total fatal accidents, total injury...
  13. BobDennison

    Report header on subreport question

    I tried to, but the screen shots won't copy. Do you just want the text?
  14. BobDennison

    Report header on subreport question

    I thought I followed your instructions, but perhaps I missed something. I have attached a word doc that explains the steps that I took and shows some screen shots of the different results. I hope this helps. Thanks, Bob http://www.mediafire.com/?led9v40isxeei71
  15. BobDennison

    Passing MultiSelect Parameters to a SubReport

    I saw a thread that addressed an issue similiar to this one, but I am not sure how to adapt it to my situation, since it was dealing with a command, so I am posting this question as a new thread. I am using Crystal 2008 service pack 2. Here is my situation. I have a main report that contains 3...
  16. BobDennison

    Report header on subreport question

    I tried this, but it didn't work. What happens when I do this is I get no records back at all. Any other suggestions would be very helpful. Thank you, Bob
  17. BobDennison

    Report header on subreport question

    Sorry I forgot. I am using Crystal Reports 2008 Version 12.2.0.290
  18. BobDennison

    Passing Array to a sub report with SQL Command

    I have the same issue. I have tried what you suggested, but the subreport gets the data as a string so when it tries to select records based on this string of values it finds nothing that matches. How do I change that string to a set of data to use in the selection wizard?
  19. BobDennison

    Report header on subreport question

    I saw a post regarding this, but did not understand the suggestion. I have a report that contains 3 different subreports. Each of them are getting data from the same source, just using different selection criteria. I need to let the user drill down into the details to get to the individual...
  20. BobDennison

    Distributing specific data to different users

    Thank you for your info. I think the email idea was the one that I saw. I appreciate your help.

Part and Inventory Search

Back
Top