Better reports

I want to see my sales by department, or maybe even by 
department and then by supplier.  I also need to see what 
i've sold and what i've received.  Does anyone have any 
better reports than what is in rms?

Thanks,

Dave

0
David4882 (672)
8/12/2004 5:26:32 PM
pos 14173 articles. 0 followers. Follow

3 Replies
692 Views

Similar Articles

[PageSpeed] 46

Dave,

We have a fantastic reporting tool.  We have a new excel 
OLAP product that lets you slice and dice your data in 
Microsoft Excel.  You can view sales, po's, current on 
hand, ect. by departments, suppliers, categories.  We 
have a report that shows current on hand, received to 
date, outstanding on po's and what you've sold all in 
one.  You can view your data over time by year, quarter, 
month, week or even day.  You can see how your stores are 
doing by each department or even see how each supplier 
does at various stores.  You can even see how your Sales 
Reps have been doing over time, see the quantity they've 
sold for any given department, supplier, category and so 
forth.  The product works with both HQ and store ops.  It 
allows you to drill down in to your data to get indepth 
anaylsis.  The product even comes with a free 14 day 
evaulation mode!

If you would like a copy, please email me at

tjensen@positivetechnology.com

Todd Jensen
Whole Sales Account Executive
POSitive Technology
1-888-706-9989
www.positivetechnology.com


0
anonymous (74722)
8/12/2004 5:41:18 PM
David,

What you have described is possible with RMS' built-in Detailed Sales 
Report.

SO Manager > Reports > Sales > Detailed Sales > plug in your dates you're 
after > OK > right click on the body of the report > Show/Hide Columns > 
only check Department, Supplier, Qty Sold and Total Sales for starters. 
Then go to the icons on the top of the report and find Group By (the second 
icon). Select the first 2 columns. Done.

If you wish to save the report, Memorize it by clicking on the disk icon 
(9th icon) and name it.  In the future, it will be listed in the Reports > 
Memorized section.

-- 
=

"david" <david@discussions.microsoft.com> wrote in message 
news:502901c48091$82d72e90$a501280a@phx.gbl...
>I want to see my sales by department, or maybe even by
> department and then by supplier.  I also need to see what
> i've sold and what i've received.  Does anyone have any
> better reports than what is in rms?
>
> Thanks,
>
> Dave
> 


0
spam3944 (2163)
8/19/2004 6:36:40 AM
Yes i know about the detailed sales report.  But wanted 
to see it over time.  Have you looked at this RMS Olap 
Analyzer thing?  It pretty much gives you the way to look 
at a report any which way you want to.  It was easy for 
me to see what i've received by supplier over time and 
what i've sold all in one report, with the ability to 
drill down by time, for example, i could look at it by 
year, or drill down to quarters, months weeks, days ect.  
I'm interested in seeing how it works with HQ as we are 
planning to add new stores.  It's worth the time too take 
a look at it.

David Fulton

>-----Original Message-----
>David,
>
>What you have described is possible with RMS' built-in 
Detailed Sales 
>Report.
>
>SO Manager > Reports > Sales > Detailed Sales > plug in 
your dates you're 
>after > OK > right click on the body of the report > 
Show/Hide Columns > 
>only check Department, Supplier, Qty Sold and Total 
Sales for starters. 
>Then go to the icons on the top of the report and find 
Group By (the second 
>icon). Select the first 2 columns. Done.
>
>If you wish to save the report, Memorize it by clicking 
on the disk icon 
>(9th icon) and name it.  In the future, it will be 
listed in the Reports > 
>Memorized section.
>
>-- 
>=
>
>"david" <david@discussions.microsoft.com> wrote in 
message 
>news:502901c48091$82d72e90$a501280a@phx.gbl...
>>I want to see my sales by department, or maybe even by
>> department and then by supplier.  I also need to see 
what
>> i've sold and what i've received.  Does anyone have any
>> better reports than what is in rms?
>>
>> Thanks,
>>
>> Dave
>> 
>
>
>.
>
0
anonymous (74722)
8/20/2004 6:45:50 PM
Reply:

Similar Artilces:

Crystal report wizard not available in excel
I've loaded Crystal Report 8.5 on my laptop and I'm trying to create a report out of a current Excel Spreadsheet, but the Crystal Report Wizard is not available for use. Any ideas on how I can fix this within Excel will be appreciated. ...

Report layout
I am trying to make a report that shows a beginning balance and ends up with a balance at the end. This can be done if I am reporting month end balances, but my boss wants me to make a report showing categories balances, beginning with the beginning balance and ending with the actual ending balance of the checking account. Also one for the Income categories. Thanks for your help. Elaine Hansen I suggest you find a report that is close to what you want, then export it to a csv or text file (right-click anywhere on the report and select Export ir Export to Excel. There you can add what...

Error 0x8004210a. Sending and Recieving Reported Error
Please help I've just purchased some webspace and a pop3 e-mail account. When I try to set up my e-mail account in Outlook, I get the message above. A friend has tried to set them up on his machine, and has had no problems (he runs Windows XP). I have PC cillin (Virus Checker / Firewall), and I thought this might be causing the problem, so I disabled it and also completely uninstalled it, but I still get the message in Outlook when I set up the e-mail and Test it. I'm running Windows 2000. Thanks Neil ...

problems in deploying reports in crm
I'm trying to deploy some reports, in the new window for reports I selected an existing file and for the report type and choose an rdl file (report file), I choose the related record types, etc.. When hitting the save & close button I get the following error each time: Event code: 3005 Event message: An unhandled exception has occurred. Event time: 2/12/2009 3:22:04 PM Event time (UTC): 2/12/2009 2:22:04 PM Event ID: 2306c3a4df584c32bdf45e8b0baeb2fe Event sequence: 215 Event occurrence: 4 Event detail code: 0 Application information: Application domain: /LM/W3SVC/2/R...

Copying Advanced Financial Reports Into Another Company
I am on version 9.0 and I created some financials in the Advanced Financial reports area, but I would like to use the same layout and customization for the other entities we have in Great Plains. Does anyone know how to do this? I am really trying to avoid having to recreate the same reports for every individual entity. Thanks in advance There is a tool on CustomerSource that lets you copy Advanced Financial Reports from one company to another. On the left side of CustomerSource click on Support >> Automated Solutions. -- Japheth Nolt Microsoft SBF Specialist Landis Computer www....

How to Create a Table of Contents or Index for a Report
I am attempting to us the technique for my application as it is described in the Microsoft Knowledge Base article number 231851. I get an error on the Dim db as Database statemtnt Is there anyone who has used the technique successfulyy for Access 2000? Thanks in advance for any assistance you might give. ...

Report design in Microsoft CRM 3.0
We are trying to learn the report design methodology in MSCRM 3.0. I am using the supplied VPC image of MS CRM 3.0 with the Adventure Works data, which has the SQL SRS already installed on it. I have tried to install Visual Studio both into the image and onto the laptop that is running the image but have failed with both. It seems that it will install onto the image directly, and when it is installed onto the laptop which is running the image, I cannot connect to the image. Please can someone step me through the process of creating an environment for learning the report design skills...

Error When I run reports
When I try to run reports on my MSCRM server i get the following error: ---------------------------------------------------------------------------------- Microsoft CRM Error Report: Error Description: Client found response content type of 'text/html; charset=utf-8', but expected 'text/xml'. The request failed with the error message: -- <html> <head> <title> SQL Server Reporting Services </title><meta name="Generator" content="Microsoft SQL Server Reporting Services 9.00.3042.00" /> <meta name="HTTP Status" c...

RePost Summing Data In A Report
I posted this back on the 16th October with no response, I hope someone can help this time. I am trying to write a report where records are selected for pieces of equipment. In a linked table I record the date and amount of oil added to each piece of equipment. If the oil is completely changed out I record the date of the oil change, the amount of oil added and tick a check box to indicate that the oil was changed. I have a report that shows the details for each piece of equipment. I need to add a sub report to sum the oil added from the last time the oil was changed, not including the ...

Use combo to print report between two sets of dates
I am trying to print a report that shows timesheet entries for two sets of dates. The report also prints out based on the data entry person selected. The user selects their name and then uses another combo box to select pre entered dates. My code is as follows: Private Sub cboDates_Click() Dim stDocName As String Dim FromDate As Date 'Name of criteria start timesheets date field. Dim ToDate As Date 'Name of criteria end timesheets date field. Dim FromOTDate As Date 'Name of criteria start OT date field. Dim ToOTDate As Date 'Name of criter...

Need Help in Generating Report
Greetings All, I am hoping to find a reporting method that will provide sales versus cost of goods figures similar to what is available in an "X" or "Z" report. I can do my own margin calculations with the final figures if that would otherwise overcomplicate the process. My additional desire is to be able to query that report (Crystal or otherwise) based upon a date or range of dates or perhaps ZZ reports. I am not versed in SQL queries, but would appreciate that method if it is truly the best way to go. Any suggestions or "report code writers" out there? W...

Month in title of monthly report
I am new to Access and have been trying to get the month name show up in the title of a report. I am using a form for the input of the [Month] and [Year] as numbers. Then use the form control button to execute a report. This works great. I then would like to use the input from the form [Month] to put the name of the month in the title of the report. I put in a text box and can get it to display the number of the month (ex. 5) but not the name of the month name (Ex. May). I do not know how to format it to mmmm. I tried an array: Dim rmonth rmonth = Array(“January”, “Feb...

IE8 reporting it's IE6
I have this issue on several of our agents machines, for some reason when Internet Explorer 8 is installed it still reports being IE6 to a website when browsing. The result of this is that some sites will not display properly (trying to display an IE6 optimized page even though we're running IE8) and some will not allow it to run at all giving a message that it requires IE7 or later. Platform for at least 3 of the machines is Windows XP sp3. I've uninstalled/reinstalled both IE7 and IE8 multiple times with full reboots, I've removed anything under program files I'...

Move CRM 3.0 Reporting Server
I currently have SRS installed on my CRM database server, and I would like to "move" the CRM reports to another SRS installation on another server. Does anyone have a good understanding of the steps required here? Can I just change the report server URL registry key on the CRM server to point to the new SRS server and use publishreports.exe to publish the CRM reports to the new SRS server? It must be more complicated than that - there must be permission settings, etc. to change on the new SRS server.. Any help would be appreciated!!! hi You might want to refer to this White...

Updating Form==>Query==>Report
I have a date form. It has 2 text boxes that pass starting and ending dates to a query to pull appts from that time period. If the report is left open and the dates change in the date from, I have to manually refresh the report. Is there a way that when I click off of the 2nd text box (ending date on date form) that the data updates when I click back on the open report that it all updates (Rpt.GetFocus = event) perhaps? The reason I ask is that the reports are pulled up evey hour and the operators would like the already open report to update once the form gets focus. This is...

Report can't print form field
My report heading contains a text box with the following data source: ="Transactions since " & Forms!frmPrintTran!txtDate The on-screen preview shows the date fine, but on printing, this textbox displays #Name? The form remains open during print. Happens with both Access 2002 and 2007, DB structure A2000. What gives here? Thanks. -- TedMi This usually happens when there is code in the On Close of the report that closes the form. -- Duane Hookom Microsoft Access MVP "tedmi" wrote: > My report heading contains a text box with the following data source: > ...

CRM and SQL Report Services (SRS)
Hello All, I'm trying to get CRM and SQL Report Services to run on the same system. Everything seems to work with the exception of changing a data source and creating a subscription (big problem). I'm running server 2003 with SQL server 2000, CRM 1.2. SQL Report Services runs fine until I install CRM on the same system. I'm guessing it has to do with both CRM and SRS running in the same web application; but I'm just guessing on that. Any ideas, Caleb caleb@gsicrm.com wrote in message news:<1113288043.187227.183910@g14g2000cwa.googlegroups.com>... > Hello All, ...

How to assign value to controls on a Report
I am trying to assign value on a txtbox control from a form to a txtbox control on a report. Form txtbox control:txtBeginDateRange Report txtbox control:txtStartDate reportName = "Report by DR and Vendor" I am have a problem with this line of code Reports![reportName]!txtStartDate = Me.txtBeginDateRange DoCmd.OpenReport reportName, acViewPreview Any help will be appreciated. Thank you. Ayo. Answered in another post where you asked the same question. ...

CRM Report erro on SQL server web
Can anyone help out with this --tya Server Error in '/Reports' Application. -------------------------------------------------------------------------------- Compilation Error Description: An error occurred during the compilation of a resource required to service this request. Please review the following specific error details and modify your source code appropriately. Compiler Error Message: CS0006: Metadata file 'C:\WINDOWS\assembly\GAC_MSIL\System\2.0.0.0__b77a5c561934e089\System.dll' could not be found Source Error: [No relevant source lines] Source File: Line:...

Create columnar report with field names once per page
I have learned out to create multi-columned Access Columnar Reports with the aid of the Report Wizard and altering the File>Page Setup... However I would like to generate a multi column report for several records but only list the Field Name titles once on the left hand side of the paper. Check out the KB article at http://support.microsoft.com/kb/208491/en-us. -- Duane Hookom Microsoft Access MVP "Ch." wrote: > I have learned out to create multi-columned Access Columnar Reports with the > aid of the Report Wizard and altering the File>Page Setup... However I...

Reporting Services Error on CRM 4 Windows server 2008
Hello. I'm having trouble with CRM connector for SQL Server 2005 reporting services. I installed this connector with no problems, but when I try to acces reports from CRM Web page It says that Connector is not installed. I thought that maybe for Windows server 2008 this might be a firewall issue, but I've already disable from both servers (I have SQL Server and Reporting Services in one server, and CRM on another). I don't know what could be the problem, event viewer doesn't show any errors. Both servers are on Windows server 2008. Please help me. Thanks Jose Ponce ...

Need help in customizing a sales report including
Anyone know how I can make a sales report that contains a sales reps sales within a given time frame, including item price, with tax if any, and tender type (basically the entire sale rung up). I am trying to run a report that shows how much we are putting on types of credit cards, Visa, MasterCard, Discover, cash, etc. Would like to know the SQL statements that are needed to do so. Jack, Are you asking for 2 reports or a single one? The second, how much for each tender types, you have already have, if you separate out your credit card tenders. A tender for MC, a separate for VIS...

Reporting by Batches Follow Up
Following up on a 2/3/05 posting, Kevin Pham [MSFT] has solicited our input for reports needed. Look at the thread starting on 2/3 and post your requests. ...

Movement Report Question
Is it possible to produce a report that shows when items were purchased and how much we paid for them without having to open up each individual purchase order? Prices in my industry change all the time and this would be very helpful. Any ideas? Our reporting add-in has that as part of the purchase orders report. http://www.savitas.net/pages/software/rmsreports/default.aspx You can see all purchase orders for the date range you choose, and then drill down to each line item to see the price paid. Please contact us if you have any questions. Best Regards Jamieson Gill www.savitas.net ...

Deployed SQL Reports
I am trying to deploy the GP SQL reports. I have assigned the user to the database, but it appears they do not have proper access. I am getting error messages like the following: • An error has occurred during report processing. (rsProcessingAborted) o Query execution failed for data set 'dsPrmLocation'. (rsErrorExecutingCommand)  Semantic query execution failed. The SELECT permission was denied on the object 'InventoryPurchaseReceipts', database 'TEST', schema 'dbo'. (rsSemanticQueryEngineError) Any suggestions? Thanks! Craig If you are referring...