Search results for query: *

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

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?

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

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

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

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

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

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

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

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

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?

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

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?

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?

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

Help getting correct statement for following: SELECT * FROM tblCapacity WHERE startDate < {todays date} AND endDate > ({todays date} or IS NULL) tx in advance

Hi, Wondered if it is possible to have some kind of 'trigger' to run a report and deliver via reportcaster? Basically we have an integration database that puts data between two sql databases. This database has a 'failure' table which capture data that has not been integrated correctly in...

I have a very simple report that displays: EntityID Surname Forename Status EntityID will always be uniquie. I need the report to highlight possible duplicates based on surname and forename - the report should look for exact duplicates in the forename field but only first 5 characters of...

Please excuse the 'newbie' style of the question..... I have been asked to create a data dictionary of a SQL database whereby I would like to detail (to an exel ssheet) the following info from all tables and views in a database...preferably all in one go... table name col name data type length...

I have a report which selects data where: not ({clgnames.short} in [&quot;CLOSED&quot;, &quot;GRP09&quot;, &quot;GRP10&quot;, &quot;GRP12&quot;, &quot;GRP14&quot;, &quot;GRP15&quot;, &quot;GRP16&quot;, &quot;GRP17&quot;, &quot;GRP18&quot;, &quot;GRP19&quot;, &quot;GRP20&quot...