Search results for query: *

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

Cancel Request. One address was in Uppercase and the other in Lowercase. Adding Ucase to both solved the 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...

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

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

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

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

Thanks everyone!!!

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})...

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

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

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.

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

That worked. Thx!

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

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

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

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.

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

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