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

    Select Expert Formula for Parameter

    Does anyone know how to make this work? I need this field to be equal to the parameter ?Site, but I also want it to be equal to -1 or -2. It's saying I need it to be an array. Basically it's to chart limits which are for site =-1 and/or site=-2 plus the actual site. The Site parameter is dynamic...
  2. nicmcd77

    Legend resizing and overlapping onto chart

    Of course!! Formula worked perfectly. Thanks so much!
  3. nicmcd77

    show multiple selections on a parameter in header

    I just normally do my parameter displays like this: if {?Parameter}="*" then "All Parameters" else join ({?Parameters},",") if you don't have the wildcard then you could just use join ({?Parameters},",")
  4. nicmcd77

    Legend resizing and overlapping onto chart

    I have a chart for Crystal Reports 2013. Does anyone know how I can force the legend to NOT resize if the text is too large? Can i force it to only display a certain number of values? I don't see anywhere I can configure anything with the legend. I need it to resize based on the values but...
  5. nicmcd77

    Date Time Conversion Formula explanation

    Hi all This is sort of a backwards request in that I have the solution but need to know why it's working. I have a report that uses these formulas to convert the date from UTC to the local user's PC time. (So I've been told). However, I don't understand exactly HOW they work. Could someone...
  6. nicmcd77

    Chart Title Scaling Help

    I have a report that can be run for a large or small set of data. When there are only a few samples over a small time period, the Sample Date individually displays fine. However, if there are several Sample Dates, it tries to cram them all in. Is there some sort of conditional setting that can...
  7. nicmcd77

    Suppress Page Header before Report Footers

    I actually just moved the Text to a new Group Header and it solved the whole thing. I knew it was something simple!
  8. nicmcd77

    Suppress Page Header before Report Footers

    I'm sure this has been answered somewhere but I can't seem to find a solution specific to my report. I'm using CR 2013, I have a Page Header that I want displayed as long as I have records in the Detail section. Once all details have been displayed, I then have 2 subreports in the Report Footers...
  9. nicmcd77

    Shared Number Variable ARRAY

    Thanks, I saw that one. It's a little more complex than I need.
  10. nicmcd77

    Shared Number Variable ARRAY

    Can someone please help me with all the required formulas that would allow me to create and pass an array of numbers to be used in a subreport? I have a number of PR IDS generated in my main report that I want to pass to my subreport. My subreport then performs summaries and calculations on...
  11. nicmcd77

    Suppress Group Header based on Shared Variable

    I have a shared variable being passed from my subreport to main report (Lot Number). I am trying to then suppress the Group Header in the main report if there is no Lot Number but it's not working. I assume it's because it processes after the report? Is there any other option? Formula in Group...
  12. nicmcd77

    Case Insensitive Not working CR 2008

    Has anyone had issues with Crystal Reports and Trackwise database? I have "Database server is case-insensitive" checked off and it's still not working. For my parameter, if the user enters "LAV", I want "LAV, lav, LAv" all returned. But it's only returning exactly what the user types. Also, if...
  13. nicmcd77

    Case Insensitive Not working CR 2008

    Has anyone had issues with Crystal Reports and Trackwise database? I have "Database server is case-insensitive" checked off and it's still not working. For my parameter, if the user enters "LAV", I want "LAV, lav, LAv" all returned. But it's only returning exactly what the user types. Also, if...
  14. nicmcd77

    Passing multiple values from subreport to main report to be used in another subreport?!

    I get 3 rows of blank values back. If I only use this portion of the formula: Whileprintingrecords; Shared Stringvar AllLotNo; AlLLotNo := AllLotNo & ", " & {F4111.ILLOTN}; If I just run the subreport alone, I get: 1. , VNPRL1011 2. , VNPRL1011, VNPRL1012 3. , VNPRL1011, VNPRL1012, VNPRL1013...
  15. nicmcd77

    Passing multiple values from subreport to main report to be used in another subreport?!

    I have this in my subreport to gather the lot numbers (which I have been able to get, however when I run the subreport by itself, I'm getting 3 rows of values, shouldn't I get an array with commas all in one row? Also, don't I need a formula to share the variable with the main report or is this...
  16. nicmcd77

    Passing multiple values from subreport to main report to be used in another subreport?!

    Hi all, I am using CR2008 and am lost. The first issue, is that I have a subreport that may have 1 or many values (Lot Number). I created this variable in the subreport and have it in the report footer Lot Number subreport WhilePrintingRecords; shared stringvar VNteardown; VNteardown:=...
  17. nicmcd77

    Pass multiple values from subreport to main report to be used in a different subreport?

    Hi all, I am using CR2008 and am lost. The first issue, is that I have a subreport that may have 1 or many values (Lot Number). I created this variable in the subreport and have it in the report footer Lot Number subreport WhilePrintingRecords; shared stringvar VNteardown; VNteardown:=...

Part and Inventory Search

Back
Top