Recent content by TheBig1980s

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