Search results for query: *

I was looking to do the same sort of multi-column thing; briefly played around with the Columns property of the report Body. I never actually tested it though since what I really wanted was accomplished using multiple Matrix controls anyhow. This property might work for you.

Sorry, I guess a little more information could have been helpful. I'm looking at the report Properties, Execution link trying to setup a Report-Specific Schedule (the Configure button there). I see the same behaviour (or lack thereof) when I click on Site Settings, Manage Shared Schedules, New...

Ok folks, need some assistance here. I'm setup as the Reporting Services admin but for some reason whenever I click on the "Configure" button nothing happens. My feeling is maybe there's a setting somewhere not configured but where to look? Any ideas? Thanks, O.

Hey all, I've CR9/C# application that calls the ReportDocument.SetDataSource method, passing it a DataTable populated earlier. The report, if run on its own, requires four variables. The report Stored Proc gets called earlier through code, hence my using SetDataSource to pass-in the data...

Thanks Catadmin, Yeah, I tried playing around with IF and IIF statements but couldn't get things to work quite right. The IF statement was based upon a field that appears in all of four grids on the form. However not every grid will have data, thus the conditional. Since this was my first RS...

Does anyone know whether you can run Reporting Services reports from a VB.NET or C# application, much as you would a Crystal (having the ability to set parameters through code, etc.)?

The parameter used in the report is the CompanyID. When I give the user a dropdown to select the company they see the name as the text but the id is assigned to the parameter. In the end I simply created another dataset to return the company name since I couldn't always rely upon a...

I've a report that executes 4 stored procs. Basically it's 4 different activity breakdowns of a vendor's activity. The user selects a Companyname from the input parameters Label; the value is the CompanyID. I'm trying to assign the CompanyName to a textbox in the report header. Right now it's...

Hello all, I've a report with your typical date params, a CompanyType, and a CompanyName (which is based upon the CompanyType), and Product. The order of selection is this: DateFrom DateTO CompanyType Company Product If the user jumps down to Product, clicks on the drop-down for the combo...

Yeah. Sorry, I forgot to paste in the code after changing and re-adding the brackets. and ((@iLic = 1 and lc.LicenseCompanyID = @LicenseCompanyID) or (@iLic = 0))-- and lc.licensecompanyID > 0)) and ((@iPT = 1 and p.refProductTypeID = @ProductType) or (@ipt = 0)) -- and p.refProductTypeID >...

Thanks all, The code I have (that runs but doesn't seem to finish) looks like this: --Sample1 and (@iLic = 1 and lc.LicenseCompanyID = @LicenseCompanyID or @iLic = 0) and (@iPT = 1 and p.refProductTypeID = @ProductType or @ipt = 0) I've also tried: --Sample2 and (@iLic = 1 and...

Hello, I've a query that can accept 6 variables that affect it's outcome. Currently the SQL string is built dynamically through an asp. So if the user selects values for COUNTRY and PRODUCT the string is built to look something like: ....where ProductID = @varProductID and CountryCode =...

Hello, I've declared a variable as Table and am trying to fill it. This works fine: insert into @tblZeroUnit select FacilityNbr, orderid, detailSeqNbr, SKU, SkuOriginalqty, skushipqty, skuclass, skuuom from database_name.dbo.orderdet where orderid = @orderid and skushipqty = 0 However the...

Hello, I'm trying to avoid using dynamic sql as much as possible. In the environment for which I must write some procedures the databases do not have standard names (will have multiple db's of the same structure but with slightly different names on one server). Most of the procedures on the...

Hi, I'm trying to disable the ability to expand an hierarchical datagrid. Ideally I'd like to make the "plus" sign a user sees invisible. Any ideas? Thanks, O.

Hi all, I have an hierarchical dataset and a form with your standard parent/child grids (parent records displayed in grid at top of form, child grid below changes to show related details when parent changes). I need to find a way to get the actual datatable row reference by the grid. For...

Never mind, I found a way to return the actual row behind the hierarchical dataset instead of just the row index of the child relationship.

Hello, I'm having some trouble dealing with an hierarchical dataset. In a dataset that has two records in the parent table, 20 records in the child table related to the 1st record and 5 related to the 2nd (where the datatable behind the child relation has a total of 25 records) how do I find...

Hello all, I'm in the process of designing a report that will function much like an invoice. When printing the invoices I may have to output about 100-1000 at a time. Because the nature of the data dictates it the report has many text boxes that I'm using as unbound fields. Essentially I have...

You may be talking about the Infragistics web controls. They give you this kind of control over buttons. The Infragistics NetAdvantage subscription is not free but well worth it if you're looking into buying a control package.