Search results for query: *

I have the need to create a variable name with a space and add a macro variable to the end. I'm having a bit of trouble with the syntax. I have really simplified my example as not to get into the other complexities of my program. Essentially, I want the variable name to resolve to First Name1...

I'm a PC SAS programmer, but I've been asked to learn Mainframe using JCL / TSO. I was wondering if there were any resources or guides someone could point me to so I could get started. I'm kind of wading my way through here blindly and have some program examples, but I think it would be helpful...

I am attempting to do a passthrough prompt from my universe and I'm experiencing some strange results in Crystal. In the Universe Designer, I have the prompt setup like this: dbo.table1.YEAR >= '{@year}' The variable year refers to the prompt: {?year_prompt} which is setup as a string. I...

I thought I posted this yesterday, but I couldn't find my thread. Is there a function either in VBA or on the macro form that I can use that would return the name of the open form? Thanks in advance.

I am trying to get a macro variable to resolve using a counter &CNT. So, the first variable would be cov1, cov2,etc. The statement runs fine, but when I run the %PUT _ALL_; statement nothing is returned. I know it is reading records from the data set because it works if I use a manual name. Am I...

Is it possible without DDE, to export a data set to Excel with a password? Is ODS capable?

I have created a letter off of a data source that contains two different types of addresses: one is the Primary Address and the other is a Billing Address. In my mail merge letter, I do not want to display the Billing Address if the Billing Address Tax ID does not equal the Primary Address Tax...

I have a report where I have a Detail A and a detail B Basically, in Detail A I have the main report and in Detail B contains a subreport. When it outputs, if it has multiple records for the same name, it does this: John Doe details 1 Subreport for John Doe John Doe details 2 Subreport for...

Here is what I am attempting: Basically, I have a main report and a subreport. The main report looks a little like this: details a id # ... details b subreport I am using a shared variable in the main report to share the id # to the subreport. formula field in main report...

This may be very simple, but I don't know if it can be done. Lets say that I am grouping on an ID number so Crystal wants to sort that first in ascending order and then I also have a date that I want to sort. I would like to sort the date first as the ID number isn't always in the order that...

I'm trying to write a formula for some parameter logic and I just can't see to get the syntax right for the case statement. Can anybody help? code: Select case {?network} Case "ALL" true; Case "IN NETWORK" {@benefit name} like ["*IN NET*"] Case "OUT OF NETWORK" {@benefit name} like...

Lets say that I have a list of times in a report like so: 11/6/06 9:30 am 11/6/06 9:45 am 11/6/06 10:15 am 11/6/06 12:00 pm Is it possible to tell the variance (difference) between the dates and times from the field and the record below it? For example, is there a calculation that does...

Is it possible to insert a subreport, have the main report and subreport linked (so the data can be matched together) without actually having the subreport run? Meaning that I run the the subreport as a main report, save the data, and then insert it as a subreport on my main report without...

I have created a parameter in crystal 8.5 to input a list of member #s. I am using the import pick list function on the parameter to import a list of values from a text file. My question is: Is there any function in crystal 8.5 that allows a select all function? Importing the pick list gives...

I am sure this is probably very novice, but I am having difficulty with it. I have a main report that it searching for a specific set of members. Then in the subreport, I want to take those membership numbers in the main report and search only those numbers in the subreport. What is the easiest...

I am trying to copy/paste a list of values from excel into Crystal and have it return the list of values, but I am kinda new to crystal and I need help with the formula. How do I make a formula so I can input a list of values and have it compare it to the field? {field.fieldname} in {}