Search results for query: *

If you know you will have a "/" or other character you can rely on, this should formula should work. NumberVar endStr; if InStr ({projectname},"/") <> 0 then endStr := InStr ({projectname},"/") - 1 else endStr := Length ({projectname}); Left ({projectname}, endStr )

I do have my own schema in this database where I can add a table. Since I'm making more and more reports that need this decode from an ID to a text description, I will consider adding my own table and converting the reports - in my "spare" time. Luckily this particular list of choices is quite...

Thanks, lbass! That worked great. I haven't worked with arrays much and would not have figured that out on my own.

I have a multiple value parameter set as a number type. The values of the parameter list are numbers, but I also have descriptions for each that are string values. I am displaying only the description for the users to select the parameters. The descriptions are not available in the database...

We have some Crystal Reports 9 in a Remedy application, using the AR System ODBC provided by Remedy. When the reports run through the Remedy app they appear as Letter size and print fine. But if we export to Word, Excel, RTF the page size changes to Custom 8.5 X 11.5 and then wants to be...

I have a CR7 report that displays number fields. The values are whole numbers, like 1288. When I run the report at my desk, it shows as &quot;1288&quot;. But when the user runs it at her desk, the number shows as &quot;1,288.00&quot;. The File > Options for the report are set to show numbers...

Thanks so much for the help. That worked great! kdk13

On a form, I have a button that generates an email. Within the email text, I am putting a dollar amount. This dollar amount comes from a recordset that I retrieve from the tables. The field in the table is formatted as Currency. The field on the form is formatted as Currency. The record...

The columns are the columns from the drop-down list. The drop-down acts like a temp table or an array while you are picking an item. Your Row Source should show all fields you want to eventually populate onto the form and these get stored into columns in the drop down list. For example, in...

I just learned how to do this a couple weeks ago. I have a cbo486Contact where I choose the Contact Name. In the cbo486Contact Row Source, I grabbed all the fields I wanted to populate. In the Column Widths property, I changed any to zero that I didn't want to see while picking from the...

Thanks for your help. Since I had the start and end date columns in the combo box, we were able to write vb to display the dates on change of the Funding Year. Thank you especially for the explanation of when to use the quotes and pound signs. The pound signs were what I needed to solve a...

OK, hopefully this question is easier than yesterday's which still doesn't have a solution. I have a table, tblFundingYear. It has three fields: FundingYear (PK), StartDate, and EndDate. I have another table Request that has the FundingYear on it. When the user is entering info on a form...

I only show the text in the drop down. I'm not showing the other fields, since they aren't useful to the user. kdk13

I'm sure this is easy for someone who knows what they are doing. If there's already a post that answers this, please let me know. I have a Service table with a unique service id, a service text description, and an expiration date. Then a Request table stores the service id for the request...

Thanks! I'll try it out.

I'm just an idiot. I've been looking for help in CR9 and on the Crystal forum and this forum as well as various newsletters. Where do you go in CR9 to edit the SQL? When I do Database > Show SQL Query, it just shows the SQL and has an OK button. No changes are allowed. Or do you have to...

The evaluate formula is different for each column depending on what I'm trying to capture. Mostly they are looking at the status of the ticket or the team assigned to the ticket. I don't think this is causing the problem. I did put the RTs themselves in the detail and then unsuppressed it...

I have running totals created in the Running Total Expert. They all have a Summary of distinct count on Ticket_id, Evaluate using a formula, and Reset on change of Group. I have 2 RTs for each column - one to reset on G2 and one for G1. Then I have a formula for each RT that if the RT is null...

I've had a lot of luck suppressing subreports only when there is no data to show. In the subreport, I determine what the main field that I'm looking for is - if it's not there, that means there was no data. Then I conditionally suppress each section in that subreport with the isnull(). I then...

OK, I spoke too soon. In 8.5, when my data runs over a page, the next page running totals for GF2 and GF1 are zero. At least I got something with 7. Even my workaround doesn't work. I'll keep playing around. I turned off repeat group header and keep group together, but it still doesn't work.