Search results for query: *

I'm trying to use the map tool to identify clients of a large social sevices agency in NYC who live in the NY hurricane evacuation zones. I have shape files for the flood zones as one layer, but the client location data is in Oracle, and in a format known as the "State Plane Coordinate (SPC)...

I'm planning a deployment of RS that uses stored procedures to parse out multiselect paramters, but I'd like to do this in our old system without a stored procedure. Im currently using Visual Studio 2005 with SP2, running against Oracle 8i. I found a proposed solution at SQL Server Central...

I'm building a report with drill-thorugh to other reports in Visual Studio 2005. The links are in a table with columns for Process and Category. In the Process textbox Navigation/Jump to report, I have this code: =switch(ReportItems!Process.Value = "Intake", "Intake_Actions"...

Summary and detail rows on a drilldown report often need different headers. When a drilldown is expanded is there any way to show a detail header and hide the summary one? Everything, including rows, has a visble property, but since there are no events, is there any way for the report to...

I'm another frustrated Crystal user, tring to figure out things that are easy there, and not obvious in RS. I have many situations where I need to find a value in a set of rows based on some condition and pass it for display on a group. Example, in a set of client statuses, find the status...

I'm trying to break up a client list by zipcode in several stored procedures where I have to provide a list of zips. I tried writing a function that would supply the list. the query (simplified): SELECT * FROM CLIENT WHERE ZIP IN (Manh_Split_Where_Func(:SITE)) The function: CREATE OR REPLACE...

I have a query which take a minimum of 30 seconds to run: SELECT C.SITE_CD,CD.DESCRIP,COUNT(DISTINCT C.CLIENT_ID) FROM CLIENT C, ASSESS A, CODES CD WHERE C.CLIENT_ID = A.CLIENT_ID AND A.ASSESS_CD = CD.CDVALUE AND A.START_DT BETWEEN TO_DATE(:start_dt,'mm/dd/yyyy') AND...

I'm in the process of converting some Crystal reports to RS I need to do things like count for each person how many decisions are due in the current month. I have in my query (in Oracle 8i) a calculation for DecisionDue_Date, and FirstDayofMonth and LastDayofMonth. I thought I could just find...

I'm converting a report project from VS2003 to 5. I have some data access code that calls an oracle stored procedure and returns a ref cursor. The backend is 8.0.5, and the client is 8.1.7. OracleCommand cm = new OracleCommand(); cm.Connection = cn; cm.CommandType =...

I know next to nothing about Citrix. I work for an agency that runs an intranet and uses Citrix over a VPN to show a Windows client-server application to our sub-contractors. We also have a web-based application on our intranet, that we need to display to the sub-contractors. Our server folks...

I have a detail section where a contact is evaluated for several types of time "compliance," e.g if this is the first attempt at contact was it done within 3 business days of a referral date. If it is after the referal month, was the client seen during the month, if not why not, etc. I'm...

The following is a query in Oracle, that runs in TOAD, and as the basis for a Crystal "push" report. I'm interested in converting the report to Reporting Services, but I get the following error: Provideer cannot derive parameter inforation and SetParameterInfo has not been called. What casues...