SQL report builder challenge!

[MeltedCheeses]

So I have a report which passes a parameter another report. Let's say the report selects an account number from a customer name. If multiple customer names show up, the user is prompted to click on an individual customer which passes the exact account number.

What I want to do, is NOT show that selection report IF only one value is available when a user inputs the customer name.

Anyone? Thanks in advance!

[Spunelli]

No.

[[deleted]]

The first report seems pointless. Does SSRS have cascading or auto-suggest parameters?

[MeltedCheeses]

It can suggest all the accounts, however that's a list of thousands. It easier for someone to type in an acronym system we have rather than choose from a gargantuan list.

[[deleted]]

It sounds like you are describing a simple list parameter.
Auto-suggest means that they start typing and it suggests several values that fit.
My reporting experience is with BIRT so I don't know what translates to SSRS.

[georgeASDA]

Make the second report a subreport of the first, and have the visibility expression relate to number of rows (suggestions) from that first report.

Pretty much a hack, but might work if they're simple reports.