Different Headings...or what?

[mission2java]

Sales guys are driving me nuts with a report...that I was not expecting. They currently use word to create station specifications for our customers. Now the problem is I cannot understand how to do what they want in Crystal.

See my data resides in SQL Server with a table of proposals. A proposal may have many stations
So for instance a proposal may be:

Proposal 1
Station 1
Station 2
Station 3...

But the problem is on this report they want to show a report with each station as the whole report. Meaning they dont want a header of a proposal and listing all the stations. They basically want to display just one station on the entire report. I know I can group by Station #...but the problem is when they run the report it will show all the stations wont it? Can I prompt them for which station they are looking for and if they don't select any it shows all the stations? I have to group by ProposalID first right? I dont want to mess this up since it is taking me quite some time to get a good report out of this...

The station numbers are text that look like: "3.1", "3.2", "3.3", etc "3.x" So I want to be able to when the report opens it say:

Please enter the position number 3.x that you want to view:

And they type in 3.1 / etc. If they TYPE one in it just prints like the following:

Proposal HEADER...
Proposal Info
Station 3.1
Station 3.1 info

BUT if they dont type one in it should print out something like this:

Proposal HEADER
Proposal Info
Station 3.1
Station 3.1 info
Station 3.2
Station 3.2 info
Station 3.3
Station 3.3 info
...etc

Please help!!!!

Jon

 

[bdreed35]

You can create a paramter that has a default value of "ALL" and then a list of valid proposal numbers. The problem you will face is that the list of valid proposal's won't get updated on there own. There are third party tools that will allow you to do this if you have to have it.

I would create a parameter that has "ALL" as the default value, and allow them to enter a value themselves.

In your Record Selection criteria, use this:

(
  If {?Proposal_ID} <> &quot;ALL&quot; Then 
      {table.Proposal_ID} = {?Proposal_ID}
  Else If {?Proposal_ID} = 0 Then 
      True
)

This will return all records if they choose "ALL" or just the proposal id that they chose.
Check out this post for some other examples: thread767-709166

~Brian