Member Avatar for Dazpenn
Dazpenn 0 Newbie Poster

Hi, I'm using Crystal Reports XI with a connection to MS SQL Server. I've created an sql query in the Command for the report to run off which seems to work fine. I've added a couple of date parameters (prmBeginDate and prmEndDate) and included these inside the sql query (e.g. 'WHERE DateCreated BETWEEN {?prmBeginDate} AND {?prmEndDate}'). The problem I'm having is that I've added another parameter (prmStatus) in the report which I've allowed multiple ranges on, but now when I run the report I get prompted for the date parameters twice!

Does anyone know of a way to only get prompted once for the date parameter?
Thanks in advance :)

  • 1 Contributor
  • 0 Replies
  • 54 Views
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.