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 Mike Lewis 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. dandot

    Text Delimiter Problem

    my CSV file is currently using " as text delimiters I've found that some text values contain " in the text thus it causes problems importing the problem. Is there a solution to this problem other then using another text delimiter? Thx
  2. dandot

    Scheduling a C# console application

    I've written a C# console application that i would like to have scheduled to run at a certain time on a server machine. How would this be done?
  3. dandot

    Dynamic File Path

    tanks for the help jason
  4. dandot

    Dynamic File Path

    How would I create a string for a dynamic file path for something like this "\\2008\2008-09\2008-09-08\DEFAULT.txt" I planned on using DateTime.Now function to get the year and month etc but the \ are giving me headaches with the string
  5. dandot

    Writing substrings into a variable.

    Thank you dave I ended up goign with a solution like this temp= temp.Replace(" ", ""); temp = temp.Replace("%", ""); string[] dimensions = temp.Split(','); if (dimensions.Length > 1)...
  6. dandot

    Writing substrings into a variable.

    Hi All, I am reading from a file, where I need to move certain pieces of information into variables which I will move later to db. Here is an example of the file... -------->> General Statistics <<-------- , Report Range: 09/02/2008 00:00:00 - 09/02/2008 23:59:59, , Generated On Wednesday...
  7. dandot

    Reverse Engineering Crystal Reports

    Are there any tools to reverse engineer crystal reports? I'm at a new job and apparently the code is not available for these reports. Just an executable.
  8. dandot

    Calling SP on another server

    I am writing a SP on one server.. however I need to get information from a db on another server via a SP or query ... is there a command that lets you do this?
  9. dandot

    Getting row and column data on a cube?

    Hi I am calling an action on a cube. Basically when the user selects a cell.. they want to be taken to a reporting services report with the parameters Quarter ="Q2" and Account ="60205 - Salaries". How would i get this information from a cube to pass on as parameters to a report.
  10. dandot

    Calling Report from a cube

    I have a report with parameters Account and Time. I would like the user to be able to call this report from a cube view. I realize i can do this via actions, but how would i pass the parameter values? Would the target and target type be cube and current cube or does this have to be on the...
  11. dandot

    Would like query to run a little faster

    Avoid using * and try to use joins in your queries rather then subqueries.
  12. dandot

    FIRST Function in SQL Server 2005????

    sorry... ignore the commenting out of hte first lines, was experimenting with the query :)
  13. dandot

    FIRST Function in SQL Server 2005????

    Is the first function available in sql server 2005? I am gettin the following error: Msg 195, Level 15, State 10, Line 7 'FIRST' is not a recognized built-in function name. Here is the query: Select CONVERT(VARCHAR(12), FactPanelHistoryAll.FinalSimulatorReadTime,101) As Date, AVG...
  14. dandot

    Resizing a form to fit resolution

    Hi All.... Is there any property that fits a form to size of the resolution and adjusts the contents accordingly? My apologies if this has been answered before... hte search function is down due to maintenance :(.
  15. dandot

    Make existing column primary key

    I have an existing column that id like to make into a primary key. What is the code for that?
  16. dandot

    Scratch Pad?

    Oh because I have them within boxes and some controls are calculated using IIFs etc.
  17. dandot

    Scratch Pad?

    Is there a scratch pad sort functionality in ms access 2000? For those not familiar with what I am talking about, in actute reports, there is a scratchpad, which allows you to remove controls off the reporting interface and place them in a container where they are held. Its useful in times when...
  18. dandot

    Pivot Tables for excel import

    Users would like to have a pivot table on the bottom of the report. I have 2 solutions in mind... 1) Create a subreport which is the pivot table. 2) Require them to download in excel, and in the download function create a pivot table. Is there a way we can alter the download to excel function...
  19. dandot

    IIF and ADODB.Recordset

    Interesting it worked with the double quotes. Thanks for the help guys!

Part and Inventory Search

Back
Top