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

    RS 2008 r2 map geometry datatype

    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)...
  2. roberthagan

    MultiSelect parameters with oracle

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

    Problem w/Llnks in table to navigate to drill-through reports

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

    Drilldown Report - display different headers for detail/summary

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

    Drilldown Report - display different headers for detail/summary

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

    Paasing Non-Aggregates to a Group

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

    Crystal equivalnet next and previous

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

    Paasing Non-Aggregates to a Group

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

    Function to return a list for an IN()

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

    Function to return a list for an IN()

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

    date parameter conversion

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

    date parameter conversion

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

    date parameter conversion

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

    Date comparison

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

    Date comparison

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

    Date comparison

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

    Difference VS2003 & 5 accessing ORA SP

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

    Difference VS2003 & 5 accessing ORA SP

    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 =...
  19. roberthagan

    Display intranet web application over VPN?

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

    Display intranet web application over VPN?

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

Part and Inventory Search

Back
Top