Search results for query: *

You need to format the date, which is a string. So how does it currently display? MM/dd/yyyy? Or what is the format? -LB

This area is not my forte, but I'll try to describe the issue as best as I can. At work, I have a personal network (centrally located) drive on a wide area network where I store reports, instead of storing them locally. No one else can access my drive. When running CR, I am accessing a database...

This seems to be the same issue as your other posts, but none of them are very clear. Please stick with your initial post instead of starting new threads. Please go back to the post where there were responses and clarify there. Your initial post made it look like you had a field that displayed...

I would like to collect your ideas on improving report speed. I have to chuckle when I see people complaining about reports that take 20 seconds. We have a statewide database with millions of records, hundreds of tables, and an old inefficient server, and if we can get our reports to run in...

I am trying to write a SQL query in Crystal Reports accessing an Oracle database, and I need to use a function that will identify and filter on a value in one field based on a parameter value which is based on a different field. The decode function works except when I need two results for the...

I am using Crystal Reports XI with CR Oracle ODBC Driver 4.2 to an Oracle 8 database. I am trying to use a fiscal year parameter within a command (in a subreport) in order to accomplish the equivalent of: where "table"."date" < date({?fiscal year},7,1) {?fiscal year} is a 4-digit number...

I am using CR XI, with CR ORacle ODBC Driver 4.2 to an Oracle 8 database. I am trying to use a fiscal year parameter within a command (in a subreport) in this way: where "table"."date" < date({?fiscal year},7,1) {?fiscal year} is a number parameter, which will be linked to the main report...

I downloaded about 30 files from a website into Excel, and then copied the contents into one file to work with, only to discover that the fields cannot be formatted as numbers. Going back to the website I discovered that they were created in html. An example of a number field source language...

I have noticed in other threads the use of the replace function to close spaces, as in: replace({table.string},&quot; &quot;, &quot;&quot;) replace({table.string},&quot;a&quot;, &quot;&quot;) When I try this, the string disappears altogether. In the second example, if I insert a space...

I'm not sure about my &quot;hardware&quot; language here, or whether this is the right forum, but... Until recently I had a 56k connection to our Oracle database through a WAN (I guess--the database is housed in another city). Another PC acts as the server to my PC, and I am the only user at...

Hi, This is a silly annoyance, but maybe it's something I'm doing. I have a report with multiple parameters. Every once in a while, the parameter picklist display will change from &quot;Description&quot; (what I originally selected) to &quot;Value + Description&quot; without any knowing...

Hi, I might not be using the right terminology here. I am working with a complex database with dozens of tables, and I have a report which uses ten or twelve tables. The report selects customers based on table_1 and I also have a parameter which asks whether the user wants to see all customers...

I have a report (8.0) with five groups, many running totals, details &quot;a&quot; and &quot;b&quot; sections, and large group and report footer sections for summary data. Since the details can print for many pages, I have put in repeat group headers for the first two groups, and on the first...