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. Latoya

    Report from SQL to Excel using a ListBox

    Thank you Skip. I was out for a bit, so I will work on this today and let you know how it goes. Thanks Latoya
  2. Latoya

    Report from SQL to Excel using a ListBox

    Thanks for your help! I will figure it out on my own. Clearly you are not understanding what I am wanting without it being overly complicated. I read your post and I comprehended what you said. No need to be rude or mean. Thanks for your help!
  3. Latoya

    Report from SQL to Excel using a ListBox

    Thank you Skip! I am going to try this and let you know. I had already done the connection, with Microsoft Query and I use my query to pull the records. and then edited the where clause in the table properties. (InStr(?, [wmav_code)>0 seems to work for some trying to do what I am doing...
  4. Latoya

    Report from SQL to Excel using a ListBox

    Hi kjv1611- Thank you for your response. It is just a simple report and I don't want to make it overly complicated per say. The user just wants a weekly report base on the codes that they put in. We use Crystal to generate the report, but we are converting it to a format that is more...
  5. Latoya

    Report from SQL to Excel using a ListBox

    Hi- I am pulling a report from SQL in Excel. I got it all working, except I need multiple user prompts (one parameter with multiple values). So I decided to use a listbox which contains all the possible selection that I want the user to choose from (These values are on another sheet in the...
  6. Latoya

    Generate a report from SQL to Excel using a ListBox

    Hi- I am pulling a report from SQL in Excel. I got it all working, except I need multiple user prompts (one parameter with multiple values). So I decided to use a listbox which contains all the possible selection that I want the user to choose from (These values are on another sheet in the...
  7. Latoya

    ListBox in Excel

    Hi- I am pulling a report from SQL in Excel. I got it all working, except I need multiple user prompts (one parameter with multiple values). So I decided to use a listbox which contains all the possible selection that I want the user to choose from (These values are on another sheet in the...
  8. Latoya

    Crystal Reporting

    Thank you all for your help. I recreated the data source, which was an ODBC, RDO connection source. I hit refreshed and selected the data source, when i was prompted for login credentials, i hit the selction option that says 'This is a trusted connection' that grayed out the login credentials...
  9. Latoya

    Crystal Reporting

    The data source is on a separate SQL server, therefore the credentials that are use, are what is use to login on the network. I am using crystal report 2008 and want to connect to SQL management studio 2012. Thank you.
  10. Latoya

    Crystal Reporting

    Hi- I am new to crystal reports and I am trying to refresh a report in Crystal Reports. When I just try to refresh, the Server Name is not there, when I go to set the database source, it is there, but when I put in my password I get an error that says Cannot find DSN in connection string...

Part and Inventory Search

Back
Top