Search results for query: *

UPDATE: Disregard this posting. There was a SharePoint trusted account in SQL that needed to have permissions to the new database. Once I got the permissions set to this new database, the report worked. I tried to delete this posting, but I don't see a way of doing so. Thanks, for the...

Hello: Years ago, I composed SQL reports for a client and placed them on a tab in Business Portal 4.0 (SharePoint). They all worked fine. The reports pull from views that contain simple select statements with "UNION ALL" clauses delineating the data for each of the three company databases...

Hello: I added a Document Library, as a web part in the header section of a SharePoint 2007/Microsoft Dynamics GP Business Portal 4.0 (32-bit) page. I do not get any issues with actually adding this Document Library web part. But, depending on how I use this web part, I get the "Server Error...

Hello: I have Crystal XI running on Windows 7 with SQL 2005. In SQL, I created a login in the "Security" folder. Subsequently, in the Data Sources section of Administrative Tools in Control Panel, I created a SQL Native Client ODBC connection with this login. This DSN Name is the one that I...

Yes, in fact, the users have Full Control permissions.

The client has a dual monitor. And, we have a 3rd-party Excel Add-In that "pushes" data into our accounting system from this excel spreadsheet with a click of a button in the Add-Ins tab. On one monitor, we see the Excel spreadsheet containing this data that we "push" with this Add-In. When...

Oh, OK. Maybe that was it. You're right. I did remove that old second subreport. Again, thanks for all of your help and for all that you do! I still say that you're a genius! You would be the "Murdock" on my A-Team. No matter how the writers portrayed his character, he truly was the...

Yes, it does make a difference. Before, data was getting doubled-up and was affecting my Customer Totals. But, as Hannibal said to B.A in the old "A-Team" tv show, "Have it your way, B.A. The best offense is the best defense." Mr T., then, smiled and said "Thanks, Hannibal! Thanks!" It...

Hi LB: You're a genius! I finally got this to work. There were two things that led to this success. First, as you said, I needed to simply use the same subreport that I had. Secondly, I needed to suppress some key fields and sections. Most notably, I needed to suppress the report footer of...

I used the same formulas that you gave. So, it's useless to repost them.

Well, I tried all this and it just gave me 0 for the customer totals.

Well, what other groups are you looking for? Beyond the relevant ones that I just said, Group 1 is salesperson ID and Group 3 is Item Class ID. There's no need to get upset. I'll find a way to get this work through whatever resource I have to. If this is upsetting you, then I'll understand...

Group 2 is customer number, group 4 is item number. Did I not mention that earlier? I apologize, in advance, if I did not. I don't have a problem with not adding a second subreport. But, can you add a shared variable formula to a subreport that is already displaying data? I did not know...

Group footer 4 contains the subreport that shows the quantities per item. It is for these items that I need to have a customer total for. That's why I created a new subreport that sits in group header 2, so that I could create shared variables. So, that should also address the questions that...

Hi There: Below are the answers: 1) What fields are you grouping on in your main report? Customer ID and Item ID. 2) In which section is the subreport located? Group Header 2. 3) How is the subreport linked to the main report? By customer, item, and item class. And also, within the...

I tried all of those formulas that were suggested on 04/07/10, but the Customer Totals came out as 0. So, unfortunately, I'm no better off after having tried that.

I wish that I could attach a file to this case without having to create a free "Media Fire" account. So, I'm going to describe my attachment, as best as I can. The attachment would show the problem that I'm running into. I was able to get this shared variables stuff to work, except for one...

I'll try this. Thanks! Just for your edification, though, the reason that I have a subreport for the quantities is because the quantities are in the Excel spreadsheet and I need to pull those quantities onto the report. I re-checked the wording of what I said. It's all accurate. I think...

In this report, I have a subreport that pulls the item quantities from an Excel spreadsheet. The item IDs for these quantities are in the main report in a group footer grouped by item ID, of course. And, I have placed the subreported quantities into this same group footer as well. This is...

I have a Crystal XI report containing inventory items. These items come from a SQL 2005 table. In this report, I also have a subreport that pulls the item quantities from an Excel spreadsheet. These items and quantities are in a group footer. When I generate this report, the data in both the...