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!

  • Congratulations strongm 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. robmason10

    Resolving full UNC path from file dialog....

    From with IE I need to be able to open a file dialog to specify where a certain file is stored for later retrieval. Natrually this path is stored in a DB and called on-demand. The issue is that users will point the file dialog to files via their mapped drives and users 'may' have different...
  2. robmason10

    Connect 2 lists to aggregated list/view without designer

    I have 2 lists that I want to connect/aggregate in to a 3rd list - both lists contain an explicit reference field that I can use to link the two but can I do it with 'out of the box' sharepoint and no sharepoint designer?
  3. robmason10

    Automatically create new site based on record insert

    I have a custom list that when I add a new record to I want it to automatically create a child site from a template. In theory.... From main portal - Input new record to list - save Creates new site based on template x with standard settings (permissions etc) Passes URL to original record to...
  4. robmason10

    Solution req'd - print and duplicate to file

    I am looking for a simple solution: I have a 3rd party app that has a dedicated printer for certain deals that produces hard copies on execution of a deal. I need a simple solution that in addition to keeping the current set-up (hard copy) captures the print and saves to electronic readable...
  5. robmason10

    xslt - supress data if return = 0

    Sorry... The output lists data on multiple shareholders (based on AnnualReturnShareMemberDetailsItem) However if the Total Shares held (i.e. TotalShareCount) is zero then I do not want that AnnualReturnShareMemberDetailsItem shown on the list. i.e. Currently shows: Shareholder Num shares...
  6. robmason10

    xslt - supress data if return = 0

    Firstly - apologies in advance I am novice at the extreme - I am stuck with no developers with an urgent defect so seeing if I can get a head start. I have a sproc that feeds an xslt that feeds in to a word template. The template is currently showing repeating regions. If the balance is zero I...
  7. robmason10

    How do I send HTML in email?

    I have a page that: a) Defines email addresses to send info to b) details a report in HTML that I want to embed in the email. The end result I need is to open my email client with the addresses completed and the html embedded. The bad news is I don't want to use CDO in any way. I find it hard...
  8. robmason10

    Update qry based on other line

    Not quite - in fact I made an error on my example. Basically tblMerged is DTS to create tblTrans - when tblTrans is created then tblTrans.TransID is created - I then need to link tblTrans and tblMerged together (using other linked fields to get the matched rows) I then need to UPDATE...
  9. robmason10

    Update qry based on other line

    Have asked something similar earlier but am lost again so will start again.. I have 2 tables - tbl Merged was used to create tbltrans but I now need to update some ID fields in tblTrans (as these were auto creates they didn't exist before so couldnt do it...) anyway.. tblMerged F1 LinkedID...
  10. robmason10

    Simple update query....

    Sorry in advance - have gone blank on what should be quite simple... Basically i ave one table... TypeID Name ReverseID I want to update the ReverseID value with the TypeID value of another row - the criteria being the Name as I cannot use the TypeID due to it being a new insert on a live...
  11. robmason10

    A Beginners guide to data migration please....

    OK so its not my job but we are a bit stretched and it looks like I am going to have to do it myself - sok please excuse my ignorant terminology etc Basically I have 5 sql tables which are linked by an auto-generated key i.e. Table 1 [Key 1] = Table 2 [Key 1] Table 2 [Key 2] = Table 3 [Key 2]...
  12. robmason10

    Excel export to diff worksheets

    Different worksheets in the same workbook.
  13. robmason10

    Excel export to diff worksheets

    I have 4 reports that I need to integrate to another application. As the reports use exactly the same parameters I would like to add 3 subsequent reports to the first so that when integrated the user only has to run one report. Issue is that when the report(s) are exported to Excel I need the 4...
  14. robmason10

    Suppress if Suppressed?

    Is it possible to Suppress a detail field based on IF GH2 is Suppressed? I have 2 running total fields and want to Suppress one if the group to which it really relates is Suppressed? Hope that makes sense?
  15. robmason10

    calculate balances outside selection parameters

    Do your parameters limit what is selected (report selection) or just what is shown? - Limit what is selected but I appreciate this will have to change Is this one balance, or a large number of balances? One balance per group Which version of Crystal? 8.5 Your best solution would be a running...
  16. robmason10

    calculate balances outside selection parameters

    Solution required for calculating opening balances - would appreciate your innovative solutions. I have a report that queries a very large transaction file called LEDGER. The report currently uses parameter fields to restrict the date range of transactions displayed. Problem is I need the...
  17. robmason10

    Export to XL sends number as text

    When I export to excel, a field on the crys reports is formatted as a number but when exported it is 'number stored as text'. Any way I can ensure it is formatted as a number in excel without manual intervention?
  18. robmason10

    Remote dsn

    Is it possible to connect to crystal to a remote dsn? Basically I have a site with a dsn outside of the domain root - I would like to connect to this dsn/database so that I have live data access. Possible?
  19. robmason10

    Syntax re-arrangement

    Here's the dilemma.... We have a 3rd part piece of s/w that has a 'built-in' sql engine...but it isn't comprehensive...I have the following sytex which works perfectly directly on the sql db but doesn't work when integrated through this 3rd party stuff - problem is I don't know what does and...

Part and Inventory Search

Back
Top