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

Ok. Thanks On my list of things to investigate, but got pushed down in priority Bob Hagan

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 ran across this thread: http://www.tek-tips.com/viewthread.cfm?qid=1074435 It demonstrates a method of adding a counter variable and resetting it where needed. Exactly what I needed. But... the reset doesn't seem to work as I expected. Public Shared myStatus as String Public Shared...

There is a previous function (at least in RS 2005) in the Expression Editor/Common functions/Miscellaneous section. It works in the details section of a table: "Returns the value of the expression for the previous row of data." Not sure about in a matrix.

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

Ultimately, Santa you are correct. We are trying to design a new application where sites and the zips they cover would be defined in a table. For the moment, we are trying to fend off feature creep in our old application by making only the changes we have to. Our Manhattan office just...

...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 FUNCTION Manh_Split_Where_Func (SITE IN...

This got pushed down the priority list, but I will come back to it. Our DBA thought also there might be something strange about bind variables. Trimming works when some people run the query and not others. Thanks

Never mind. There was another possibility that I didn't test. If you trim coded_rtg, the problem goes away.

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

Case was introduced into Oracle 9, so I don't have it available for this. I didn't qualify the fields here but they are correct in the function. Your approach with datepart works. I'm not sure I would have ever thought of that. Thanks much.

First and LastDayOfMonth come out of my query. TRUNC(SYSDATE,'MONTH') AS FirstDayofMonth, Last_Day(SYSDATE) AS LastDayofMonth The other thread suggests doing date stuff in the query if possible. Oracle 8 has a "Decode" function as the equivalent of if/then/else, but my data can have multiple...

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

Forgot. I'm using the Microsoft Oracle data provider in both VS 2003 and 2005, not the Oracle one. Would that make a difference

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 have no direct contact with the Citrix folks, and only know what an intermediary reports. From what I've heard, the sub-contractors have access through the internet to whatever box Citrix runs on. As I mentioned, we have an old client-server database application and one client is on the box...

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