Search results for query: *

Dynamics GP10 is running on SQL 2005 (9.00.4035.00 SP3). I am the support provider for Dynamics GP10, but they have another service provider for network/hardware. Several users get intermittent errors including: A SQL network connection error occurred and your connection was cleared. This...

I am writing a select statement to use in a view. The first column of data I need is retrieved with the first case statement below; I call that column TxnCode. Then I need to write data to a second column that depends on the TxnCode returned in the first column. The script below tells me...

I have a report parameter that allows the user to select which customer to report on. I linked it to the customer list in my database. The user would like to be able to see both the customer ID AND the customer name when selecting which customer to report. I can put the customer ID field in...

Crystal XI. SQL 2005. I am trying to write a new report off a SQL Stored Procedure. Wen I try to add the data to the report, it prompts me for all the various paramters for the stored proc. I click "set as null" for each, then click ok. Then I get this error: Database Connector Error...

I have a view that returns approximately 5 million rows and is growing at the rate of several thousand rows per month. I'm using a reporting tool that crashes when I try to report off the view. I tested writing the view to a table and reporting off the table, and the reporting tool works fine...

In Group Expert - Options - Options, I selected Customize Group Name Field, and I have a formula as Group Name. The custom group name shows on the report as the label for the group. But when I create a chart, the actual group value is showing up as the X Axis label instead of the Group Name...

We are attemping to migrate a customer to a new server with SQL 2005 SP3. They are currently on SQL 2000 SP3. They have 11 dbs. We made SQL 2000 backups of all dbs. Then we successfully restored the dynamics db and 9 of the 11 dbs to the SQL 2005 server. Using Management Studio, we right...

I have a report that has four parameter fields. The first one is RegionSelectBy, and it has three static choices: County, Wide Area, and Area. Each of the three static choices has its own parameter field with a dynamic list of values from the data. The user may select one or more counties...

I have a report where the user wants to be able to select the level of subtotaling he sees. He may choose to see each month, the sub-total for the quarters only, or the sub-total for the years only. I did this by inserting the same field (sale date) in Groups 1, 2 and 3. In Group...

I have an Access 2003 Macro that includes three delete table steps. I ran into an issue where the first table had already been deleted (user error), so when the user ran the macro, it failed because it could not complete the first delete table step. Is there some way to get it to move on if it...

I have an Access database that has a query in it that returns the following columns for property sales: County Month Sold Price Range Count of sales for county/month sold/price range group It sums by county, month sold, and price range. Results look something like this: Smith County August...

I have an Access query that counts the number of home sales/closings by region, by month. The query is summarizing data found in a detail table that lists every single home sale/closing and includes fields such as address, area, square footage, lot size, closing price, etc. So Area A had 5...

I am working in Crystal XI now. In some earlier versions, when you picked a detail field and did Insert Summary, you were offered the option of inserting the summary for all groups and grand total at the same time. That option seems to be gone in XI. Am I just missing it? Is it somewhere...

The user wants a parameter that allows them to choose multiple values, but they want to limit how many can be chosen. I know how to set up a parameter that is either False on Allow Multiple Values or True on Allow Multiple Values, but if I set it to True, I don't know how to restrict how many...

I want to display all the choices a user selects for a parameter that allows multiple choices. I have successfully used join({?Parameter},', ') for string parameters, but now I am trying to use it for a parameter that is numbers rather than text. The join apparently wants text/string only...

I have a parameter that allows multiple choices. The parameter values have a Value and a Description. I want to display the Descriptions that the user selects in the parameter. To display the values, I would do: join({?parameter},', ') But I don't know what formula to use to display the...

Client has home sale data (one row per sale) that falls into the following hierarchy of location: County - the highest level - made up of several wide areas. Wide Area - a region within the county - this is a three digit number ending with 0 - example 120. Area - this is a sub-set of Wide...

SQL 2005 User is reporting that in Mgmt Studio, he cannot select one of his databases when he tries to configure a maintenance plan. He says all the others can be selected but not this one. I'm heading out there this morning to look for myself, but I've never seen this. Any ideas? Thanks!

I'm really new to SRS and trying to grasp all the concepts here. I come from a strong Crystal background, so I'm trying to translate Crystal concepts to SRS and failing in some cases :( Here's my current question. I want to create a calculated field so I can do other calculations on it. I...

New to SRS. Trying to determine how to do something I would do in Crystal with conditional running total. Imagine in the tables an invoice with a header table and a detail table. The Header table has a doc number and doc amount. Te Detail table has each of the item numbers that we sold on...