Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. olichap

    newspaper columns ?

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

    Can't configure a schedule

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

    Can't configure a schedule

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

    changing Datasource clears report parameters

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

    How to conditionally control textbox text in Header

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

    Running reports from an app

    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.)?
  7. olichap

    How to conditionally control textbox text in Header

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

    How to conditionally control textbox text in Header

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

    Preview stuck in loop when parameters chosen out of order

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

    Conditional Where clause

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

    Conditional Where clause

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

    Conditional Where clause

    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 =...
  13. olichap

    filling table variable using dynamic sql

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

    Trying to avoid using dynamic SQL

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

    How to disable Expand/Collapse in datagrid

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

    How to get row index behind dataset relation

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

    Finding row position of childtable record.

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

    Finding row position of childtable record.

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

    CR9-looking for way to combine report objects

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

    Finding New Controls?

    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.

Part and Inventory Search

Back
Top