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
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
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)...
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...
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.
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?
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.
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...
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...
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 :(.
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.