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!

Register Log in
  • Congratulations derfloh 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. franklin1232

    ADO Recrodset Error 3001 with command parameters

    Below is the statement used to execute a stored procedure from VBA using ADO with command parameters. I captured it from the SQL Profiler while debugging my code. exec sp_GrossIntervalSalesReport 1, 0, 'Dec 31 2007 12:00:00:000AM', 'Jan 27 2008 12:00:00:000AM', 3, 0, 2006, 3, 0, 2006, 0, 1, 2...
  2. franklin1232

    Performance troubleshooting thoughts

    I am having trouble with a large report and it's run time. It takes almost 2 hours to format 45 pages. First I verified the SQL server 2000 database configuration. The main report and sub report both use views for data. So I ran both at the same time and used that trace data to fine tune...
  3. franklin1232

    Sort on Formula

    I am using Crystal XI. I have a number of running totals. The running total results are than used to calculate a points value for each group which is location. The points formula is supposed to rank the locations. Problem is the formula isn't sortable since it's not based on a database field...
  4. franklin1232

    Update Select with IS NOT Null

    This is a simple update query, but it is causing me problems. The inner SELECT returns only rows with matching PLUNum through the INNER JOIN. However when K_Menu and C_Menu are joined there are addtional records returned and the PLUNum values for those addtional records is NULL. QSRCat and...
  5. franklin1232

    Older version download or purchase

    I have an old application that use version 6 to create reports. The viewer is embedded in this application and I have to way to upgrade to a newer version. I need to make some simple changes to the a few of these reports. Can I do this from version 8.5 or above? It always want to upgrade the...
  6. franklin1232

    running totals evaluate formula problem

    I am trying to create a running totals field with an evalute formula. {Y_CheckItem.SaleTime} in DateTime (2005, 06, 25, 15, 00, 00) to DateTime (2005, 08, 30, 18, 00, 00) and {Y_CheckItem.MenuID}=9708 Everything I do seems to get messed up when I use the "in DateTime" function including...
  7. franklin1232

    Date Parameter Range Problem

    I am using a sql sever that has a datetime field I would like to use in my record select. So I create a datetime parameter field and add it to my select statement. The problem is that as soon as I set the parameter to allow ranage vales and the select to be "is between" the formula produces an...
  8. franklin1232

    Update data warehouse over web

    We have 36 stores each with their own SQL 2000 server. I want to send data back to the coporate office every night. I wanted to modify the information slightly before sending it in and want it to be secure. I have considered a few different options, but was looking for advice. What is the...
  9. franklin1232

    ASP.Net Crystal XI Remote images

    I was using CR.Net to dynamicaly change images in a report. Streaming a file into a dataset table then binding the report to that table. This was working well. Most of my applications use impersonation to access a remote servers file share for these images. Then I see XI and the great...
  10. franklin1232

    Pictures using Asp.net/CR.net

    I have a 8.5 report that I used the RDC and VB6 to change and OLE image object on the format of the reports detail section. This works well. Now I want to do this in ASP.net, but the sections and events don't seem to be available in the .Net GUI. I have a report object I can access the...
  11. franklin1232

    Datagrid update event hyperlink column

    I have a hyperlink column in my data grid. The column contains part numbers. When the user makes changes to other fields and hits update I need to capture the hyperlink column value. In the update event this is my could Dim strpartnum as string = e.item.cells(0).text The strpartnum variable...
  12. franklin1232

    ATT PagePac 20 help

    I just switched from a Norstar ICS to a Cisco Avvid. I bought a Bogen TAM-B and set it up in station mode off an analog ATA Cisco box. I am able to connect a test set to the output from the TAM-B and hear the page but when it's plugged in to the page input on the Pagepac, nothing. The...
  13. franklin1232

    Quarterly sales report

    My boss wants a report that sums up all quoted and booked dollars for the year by quarter. Problem I had was the data isn't related so I used a subreport. Then a shared variable to pass the total quoted dollars back to the main report. The main report has two groups. Group1 is customer...
  14. franklin1232

    Quarterly Sales with subreport

    I am creating a report that has two groups. First group is the customerID second is date by Quarter. This part totals my order dollars by quarter. Here is the problem. I added a subreport to show the quoted dollars per quarter as well and linked it by customer. What is happening is the...
  15. franklin1232

    Report Snaking not working like I hoped

    I have a report That I want to look like this: Group Header Detail Detail Detail Detail Group Header Detail Detail So I have tried a number of different combos for setting up columns and nothing is working. I grabbed some samples from Microsoft that claimed to do this, but when I...
  16. franklin1232

    Network Perfomance Monitor

    I have been getting redirector errors on some of my NT 4.0 workstations and performance seems to have slowed down after adding some new more computers to our network. I didn't think it would be an issue since the network is fairly small 65 computers and 5 servers. The network has a gigabit...
  17. franklin1232

    Looking for a better List box control

    I have some data that I would like to display in a hierarchial fashion. I would also like to be able to set font info on individual lines. I was thinking a control that used HTML as it's rowsource. Can any one suggest a control that might work? Thanks
  18. franklin1232

    Tab Control Page Click event not firing!

    I have a subform with a tab control and 3 pages. I am tring to run code that excecutes when a user clicks or activates certain pages. Problem is that the Page_Click event isn't working. I can use the TabControl_Change but then the code runs more than it needs too. I would like to avoid...
  19. franklin1232

    CF type I or II Bar Code Scanner

    Does anyone know a good bar code scanner that would fit my Toshiba e740. I have looked at Socket, but they are so expensive. Anything would be helpful.
  20. franklin1232

    How can I modify SQL statement in ADO conn

    I have been forced into use an ado connection through ODBC because of problems with Crystal and it's direct interaction with my ODBC driver. So I put in a rather long SQL statement to build my ADO recordset and it works great, but opps I need to select one more field. I can't find a way to...

Part and Inventory Search

Back
Top