Search results for query: *

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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.

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