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 Chriss Miller 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. JetRamsey

    Report Builder 3.0 how to force parameter to minimum number of characters

    I have one parameter for my SSRS report, which is surrounded by '%' and '%'. So, I would like to force the user to a minimum of three characters to run the report. Otherwise, the data for the entire database will return back. TIA
  2. JetRamsey

    IIF statement issue

    Cancel Request. One address was in Uppercase and the other in Lowercase. Adding Ucase to both solved the issue.
  3. JetRamsey

    IIF statement issue

    Report Builder 3.0. If my Address field = Location field, I don't want it to print, but I want it to print when Location doesn't match Address. I've tried this, but Location prints in all cases. Any help to correct this would be appreciated...
  4. JetRamsey

    How to grab highest value only. Date conversion.

    I have 8 sections in a report. Each section has it's own Created datetime field and a Modified datetime field. In section 1, I can create a formula of CurrentDateTime-{SafetyReportA.ModifiedDate}, which shows me how long it's been since this section has been updated. To keep in simple...
  5. JetRamsey

    formula help request

    Below, I've listed the results for one field in my target SQL Server database. I've used a green highlight within this field to should the area that I would like to target. You'll notice a value of "124124" and I would like to create a formula based on this field to show 124124 without the...
  6. JetRamsey

    Isolating data from a field with XML data

    I am attempting to pull data from a SQL database and I see a field that contains XML data. In the application, many fields are tied to this one field in the SQL database. If no data is filled out in let's say 6 fields, this XML type field within the SQL DB just shows...
  7. JetRamsey

    Is capturing user's NT login possible through FP15 webdirect

    With a published FP15 webdirect database, is there any way to capture a user's NT Login?
  8. JetRamsey

    Date/Time Parameter help request

    Thanks everyone!!!
  9. JetRamsey

    Date/Time Parameter help request

    Betty, When entering date({Items.Status_Date})>= {?Start Date}, I get an error message of "Bad date format string". I'm guessing that since the "Items.Status_Date" field is a string, that's not going to work out. Kray, Thanks, I tried, but ran into other problems. 1. year({?Start Date})...
  10. JetRamsey

    Date/Time Parameter help request

    I probably didn't ask my question correctly, but thanks for the answer. I want to use a parameter as a START DATE. In CR14, I would create a parameter field and use "Date" as the parameter type. Then, do the same for an END DATE parameter. Normally, the Record parameter would be Date is...
  11. JetRamsey

    Date/Time Parameter help request

    I'm using CR14 and accessing a SQL Server DB. There's a field called Status_Date that turns out to be a string field instead. An example value of this string field looks like 2016/08/01 00:00:00::00, which is 8/1/16 and will always stay 00:00:00:00 since there's another string field that grabs...
  12. JetRamsey

    Extracting data between [ ]

    Thanks Andy, It did not work, but I changed your [3] to a [4] and the correct result appeared. If you know why the [4] works instead, please let me know.
  13. JetRamsey

    Extracting data between [ ]

    Here's the data format: [32] Event linked to [Warehouse] [BB16027901] I'm trying to figure out a way to isolate BB16027901 above and I can't do it with a mid() formula since the database has changed. As seen above there are 3 sets of [ ]. In the first set, the number is 32, which is two...
  14. JetRamsey

    Create a break after each 150 records

    That worked. Thx!
  15. JetRamsey

    Create a break after each 150 records

    Kray, I put in exactly recordnumber mod 150, but it asks for "A Boolean is required" just before recordnumber.
  16. JetRamsey

    Create a break after each 150 records

    I using a site that can geocode lcoations with a max of 150 records. I have a CR 2011 report that spits out over 1200 records. I would like to see a break after each 150 records. Is there a way to do this after each 150 records? Maybe something like: record 149... record 150...
  17. JetRamsey

    Is there an ability to show an photo from an ASP link?

    Within my Crystal Report, I show 3 fields and a fourth field that you click on to show a picture of a person. The photo is simply an ASP link. Is there a way to show the same three feilds and also show the picture from the ASP link query? In other words, http://Server1/photo.asxp?=DRT814...
  18. JetRamsey

    How to display a picture

    Thanks Charily. You made me think a bit harder and found out that I was in the wrong area. In the Format Editor, I neede to go to the Picture tab, then Graphic Location and set the formula there instead.
  19. JetRamsey

    How to display a picture

    I'm using CR version 14 and accessing a MySQL database. A memo field shows a link to a photo like element_16_4e42220543c749116c093cf23ec3cd4b-4-IMG_0320.jpg . Within CR, I can "Insert Picture" and put in the location of...
  20. JetRamsey

    Long time to load report

    Peter, I checked subreports, turned the "Re-import Subreport on Open" flag on and off, but it did not change the speed for opening the report. I seleceted verify database. It stated it was up-to-date. I save the report, opened it again, butthere was no time improvement. To track this down, I...

Part and Inventory Search

Back
Top