Search results for query: *

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

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

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

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

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

I'm trying to find a way to tell how much memory (physical and virtual) is being held by my application at any given moment. Does anyone know of a way to do this from within the app? Essentially I'd like some way of reporting the values you'd see under the Task Manager "Processes" tab...

I've a report that was constructed using an existing XML schema file. At runtime I am trying to pass my populated dataset to the report (7 tables in all). I've tried using: rptPrn.setdatasource(dataset.tables) also tried: rptPrn.setdatasource(dataset) also tried...

Does anyone know how to create a subreport on the fly in VB.NET and add it to an existing report object? Thanks, O.

I'm hoping someone can point me in the right direction here. I've a medical claim report and need to set the data values. A good portion of the report's values I could set easily by simply binding/dropping the appropriate data field onto the proper place in the form. However 23 lines of the...

I've 8 tables that are properly linked, with one we'll call tblList as the parent. I have a group in the report on what amounts to a CustID field in tblList (numeric in all tables). At present I'm just roughing out the report to make sure I can display the related data properly. There are 2089...

I've a report with right and left margins set to 1/8 of an inch. When previewed all my report objects are in place and look fine. When printed the report has side margin that are set to 1/4 of an inch. My report's margins are all set to 0, which I thought would give me access to the entire form...

I'm trying to utilize the JulianCalander object to return the integer associated with the day of the year but am confused as to why it doesn't seem to calculate the value as it should. For instance the date 06/26/2003 should have a value of 177. Dim dtJul As New...

I've got a report object/report form (CR 8.5, populated through VB6 app) which prints fine as a single print job. What I'm trying to do is combine multiple instances of the same report into one multi-page document/print job. My users are essentially printing invoices, each of which is one...