Recent content by macvicar

I figured it out. Instead of using a parameter, I added the query I was using for the parameter as a nested Select statement within the query I was using in my sp. Thanks for your suggestions. Jeff

When I run the query in Mgmt Studio, it returns the correct data every time. It's just seems that the new data doesn't get populated into the parameter when the report refreshes. Thanks

How should the parameter be set in RM ? It shows it is there. Has Default is checked and Prompt User is checked. When I run the report for the first time, it displays the correct info. However, when the report refreshes, it says, "Default value or value provided for the report parameter 'CSNID'...

I was previewing the report in VS. But when I deploy, I get an error when it refreshes saying the default value or value provided is not valid. Jeff

I've added the new data set. The parameter I had I've changed so that the available values are from a query based on the new dataset. The default values also are set to a query from the new dataset. The first time I preview the report it works. But when the report auto-refreshes, the parameter...

I have a report in SSRS 2005 that currently requires the user to type in a parameter value in order to return the data. I have a sp that runs to create the report. I'd like to change it so the parameter value is automatically populated from the last record that has been inserted into a...

Basically, we are going to be setting up a warehousing operation. Product will come in, we will warehouse it and then distribute it to several sites. We need to receive the ASN's on inbound material, shipping schedules for outbound and ASN's for outbound. I'd like to be able to receive the goods...

I'm looking for a system that can send/receive/translate various EDI templates (DELFOR, DELJIT, ASN etc.) that is part of an inventory management system. Has anyone had any experience with such a system ? Thanks Jeff

I'm building a db to collect equip fault data in SQL 2005 and need to modify my query to be able to select/display "ALL" records. I'm currently using a sp to assign a shift to each record and then have a query to select all records by shift. I'd like to add an option to the query to be able to...

We are in the process of establishing our EDI procedures and I'm looking for some advice. We are a Tier 1 supplier who will be receiving a DELFOR from our customer for many parts that we will purchase from several Tier 2 suppliers. After receiving the parts from the Tier 2's, we will assemble...