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 Mike Lewis 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: *

  1. drgsolutions

    Asked for parameters multiple times?

    I am using CR11 with the backend SQL Server 2005. My report has 8 parameters. As some of my parameters are dependent upon data within SQL Server, I have had to set up a total of 4 data sources (3 commands). The problem is that when I refresh the report I get asked for the same parameters...
  2. drgsolutions

    Dynamically set field in recordset

    I am attempting to dynamically set the field I wish to update at run time. This is my code (DAO) rs.Edit rs(parameter) rs.Update I have tried using [] () ! and . characters to now avail. Anyone know how to pass a string character into a recordset object and have it recognized as a field...
  3. drgsolutions

    Select 'ALL'

    This is all very helpful except that I already have used a command as the source of my report. When I attempt to write a 2nd command that would be the source of my parameter list the Database Expert sends up a second dialog box asking me to link the command statements together. Am I missing...
  4. drgsolutions

    Moving report criteria to report header

    I'm using Crystal Reports 11/XI I have a report that has 7 parameters which a user can select any or all. I would like to show the user's selection criteria on the report or page header. I wrote the following into a formula that was in that report header. If {?Gender} <> "All" Then "Gender...
  5. drgsolutions

    Program Chart at run time

    Yes, whether the user can use a pie chart, bar, or stacked bar hart.
  6. drgsolutions

    Program Chart at run time

    I have CRXI (11). I am creating reports for a client that are as flexible as possible. To do that it would be great to be able to program the chart/ chart wizard at run time. Has anybody attempted that?
  7. drgsolutions

    Insert SQL directly into CR11

    Is there anyway to insert SQL directly into CR11 and by pass having to create it by using the CR experts? Thanks

Part and Inventory Search

Back
Top