Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: CuteGeek
  • Content: Threads
  • Order by date
  1. CuteGeek

    Parameter Error Message

    Error Message: The report parameter ‘prmPI’ has a DefaultValue or a ValidValue that depends on the report parameter “prmPI”. Forward dependencies are not valid. I have created a dataset that shows the below query: this is working. SELECT 0 AS ID, 'All' AS name UNION SELECT DISTINCT per.ID...
  2. CuteGeek

    How to pull records out that are different

    Hello, I have a report that I need to only select the below records. How do I do this when there is nothing in the database that make them distinct. Group 1 14987 Acount Number Company 14987 100 14987 300 14987 200 14987 100 Group 1 23444 Acount...
  3. CuteGeek

    Combining two reports with two different graphs

    I have two reports that are using the same tables and fields. The difference is in the where statement that will pull different data for the graphs. What I would like to have is at the begining of the two reports are graphs. I guess I am looking for a way to page break after the first report...
  4. CuteGeek

    Running a report to select specific date

    Hello Everyone, I have a rather deep question:) Having a getdate in the where statement to pull data of all files associated with the month of saledate. Field is dfeSaledate (pulls date of every 1st Tuesday of the month) Example: November 18th Saledate December 3rd (1st Tuesday of...

Part and Inventory Search

Back
Top