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

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?

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

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

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

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

I'm currently using Crystal Reports 14 and was using CR8 before. When opening reports at times, it can take over a minute for some reports. The report does not run a refreshed query and many of the reports do not have "Save Data with Report". I don't understand why some reports open quickly...

I have a report with "details A" containing data that normally ends about 3/4 quarters of the first page. I have a subreport in the "details B" area and if there are only a few lines, the info in that report stays on page 1, which is perfect. However, when the data length in the subreport in...

Within MS access I've create a Select Query that brings back 8 columns. One of the column names is Event. Is there any way to make the results in this Column show as Bold so this column stands out? If so, how. I did go to the format menu, selected font and selected bold, but it made all...

While using a "Oracle in Oraclient11g_home" driver I see "<h" displayed for a memo field. While using a Microsoft ODBC for Oracle, I now see all of the text for the memo field. However, I see that it starts with misc. HTML tags, then all of the text that I want to extract is displayed, and...

CR version 14 I would like to make some corrections to a database. How can I identify if a field has any lower case letters in it?

I would like to use the formula of (currentdatetime - 7), which is what I use for many reports. Unfortunately, the new database that I'm reading records from has the output for a date field as "2013/10/08 00:00:00". So, when I use the Currentdatetime - 7, it doesn't like the date format and...

I'm using Outlook 2003 the points to our Exchange server and Windows 7 64 bit. During each day, I have to close down Outlook and restart it about 1 to 5 times a day. When the bug occurs, I'm unable to click on any of the icons in the Standard toolbar. Thus, I can't send a new message by...

I have an ASP that using this line to pass on the parameters: <form action="DESC.asp?" method="GET" name="parmform"> When using this form, the following output will occur: http://salus/test/DESC.asp?DESC=clown&=View+Report Since I want to pass on the input of this form to a Reportal Server...

Works - {TABLE1.FIELD1} < DateTime (CurrentDate - (365 * 20)) Does not work {TABLE1.FIELD1} < DateTime (CurrentDate - (365.25 * 20)) I'm querying a datetime field and trying to give the user the ability to same X amount of years. In this example, 20 years. Thus, I'm using CurrentDate -...