Search results for query: *

Good Morning All, I am looking for recommendations for how to keep track of our internal report versions. Not versions of reporting services like 2005, or 2008; but versions of each report. We may have several different people making changes on reports and would like to be able to put a version...

I have a form where the first group header is shipping information. The second header is column headings for the item, desc and qty. I only want to repeat the column headings on subsequent pages and not the entire shipping header. When I try to select just the static row groups member for the...

Good morning everyone, Just wondering if there is a way to format the fields besides scripting it. For example-- I know I can change the format of my current decimal fields to only show 2 places to the right of the decimal by using this in the dataset select query...

Good morning everyone, Can someone point me in the right direction for this? Will I have to key in my own connection string to make it happen? What is the syntax for 2 data sources? Also when I deploy this report based on 2 data sources, will the user have any trouble? I would like to use...

Hello again everyone, On the webpage, the report I deployed only shows to be about 1 inch tall. To see the whole report you have to scroll. When I preview it before I deploy it, it is normal height. How can I fix this? What setup did I miss? TIA! Sunny

I am just getting started. Have completely setup and installed SSRS. I have created my first report and am trying to deploy it. It let's me deploy it without error. Sometimes I can view it from the webpage where it's deployed and sometimes I get the following error "An internal error occurred...

Good morning everyone, Does anyone have a W2 form for crystal reports already made up? I know I could make one, I was just hoping to purchase one that was already completed. It would be great if it was already configured for this years changes, but if not, I could potentially make those...

Hello everyone, Can someone tell me how the canned Single-level bom Report is sorted? We would like to have the WO traveler print the components in the same order and I can't figure out what that order is. Thanks in advance, SunnyD

Hello everyone, Is there a way to use the Calc and Base modules of open office with Crystal Reports? I was thinking I would be able to define a name in Calc on a spreadsheet and then grab that db with crystal but it always tells me that it is unrecognized format. Any suggestions? I have...

Hello All- We are switching out a few components for some other components. We do this all the time therefore I know the process itself is working. But I have about 5 unrelated items that I need to replace. When I run the replace/delete component utility, it tells me no bills found. However...

We have just a handful of items that are setup just like our other items, but they do not pull a cost on the costed BOM report. It says 0 for avg cost and for total cost of that item, for the bill. Has anyone seen this before? I have compared item entries in the IM1 table between the ones that...

We are just starting to setup and use WO. We haven't entered any WOs yet. We setup several work centers and operations codes and a few routings. Then we changed the way we wanted to setup the routings so I deleted them all. I also would like to delete a couple of the operation codes. Several of...

I have a string field with date values like 20060628. What is the best/easiest way to convert this field to a date type? I tried cdate but it is looking for commas. Do I have to insert the commas to be able to convert it? If so, how is best to do that? Thanks very much in advance! SunnyD

We are trying to add PRI connectivity to an existing system (currently uses DS1). We were quoted a hefty cost by our vendor - and some of the line items don't seem to make sense (to me). Anyone know why we would need "MSDN Software Options" just to connect PRI to one controller? Also, what is a...

I need to create 2 parameters that will need to be "linked" together; for use in later queries and forms. I need the user to be able to enter a list of item numbers and quantities. But I need to know which item number goes with which qty. How can I prompt the user for these values and keep...

This may be too broad of a question, but maybe someone can give me a jumping off point. I need to write a report that will allow the user to enter a list of Bill numbers- the report will take that list of bills and explode them to the lowest level to find out if we have enough of each item (at...

Hello all. Not sure - this post might should go in the formula forum instead. I am working on a reorder rpt that lists invoices by customer and sorts by date. I put a counter field in that resets for each customer and basically assigns a sequential number to each invoice. I needed to show the...

I have a report that lists all the receipts for a given item. I want to narrow it to include only the receipts up to the current qty on hand amount. So if item A currently has 1000 OH, then I want to see a list of the last receipts up to 1000. The problem I am having is that the reciepts do not...

I have 2 SQL 2000 servers that I want to link. I used sp_addlinkedserver and also tried to set it up through enterprise manager. It seems to allow me to link the servers (the linked server appears in the sysservers table) but when I try to query any tables I get errors. Currently I am getting...

I have an inventory report that shows on hand quantities for items with transactional activity. The transaction qtys are grouped and subtotaled by year. The user wants to know the percentage of the yearly transaction subtotal to the qty on hand- i.e. does the qty on hand = 300% of what was used...