Recent content by JetRamsey

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.