Link to dbf file

Hi. I have a dbf file that has about 1.2 million lines of
data. That file is produced by another system's
proecesses. I'm wondering if there's a way for me to link
my SQL Server database to that file? Any suggestions would
be great. Thanks!
dbf file is: M:\Data\Shipped.dbfHi,
Yes, it is possible.
You can create a linked server from the Enterprise Manager (EM). Please try
the steps.
1. Create an ODBC DSN for the .dbf file by using 'ODBC Data Source
Administrator' in Administarive tools.
2. Select Microsoft OLE Provider for ODBC drivers to create a new linked
server. You should specify the datasource and catalog in the boxes.
3. In security tab, you should configure it to access this .dbf file
without problem.
You can do the same using TSQL, Have a look into the below link, You have
various options to connect to DBase and Foxpro dbf files.
http://groups.google.co.in/groups?q...le&hl=en&lr=&ie
=UTF-8&oe=UTF-8&selm=VA.0000447d.0110b58c%40compuserve.com&rnum=7
Thanks
Hari
MCDBA
"mj" <anonymous@.discussions.microsoft.com> wrote in message
news:133ab01c411ed$1a65b150$a101280a@.phx
.gbl...
> Hi. I have a dbf file that has about 1.2 million lines of
> data. That file is produced by another system's
> proecesses. I'm wondering if there's a way for me to link
> my SQL Server database to that file? Any suggestions would
> be great. Thanks!
> dbf file is: M:\Data\Shipped.dbf
>

Link to dbf file

Hi. I have a dbf file that has about 1.2 million lines of
data. That file is produced by another system's
proecesses. I'm wondering if there's a way for me to link
my SQL Server database to that file? Any suggestions would
be great. Thanks!
dbf file is: M:\Data\Shipped.dbf
Hi,
Yes, it is possible.
You can create a linked server from the Enterprise Manager (EM). Please try
the steps.
1. Create an ODBC DSN for the .dbf file by using 'ODBC Data Source
Administrator' in Administarive tools.
2. Select Microsoft OLE Provider for ODBC drivers to create a new linked
server. You should specify the datasource and catalog in the boxes.
3. In security tab, you should configure it to access this .dbf file
without problem.
You can do the same using TSQL, Have a look into the below link, You have
various options to connect to DBase and Foxpro dbf files.
http://groups.google.co.in/groups?q=...e&hl=en&lr=&ie
=UTF-8&oe=UTF-8&selm=VA.0000447d.0110b58c%40compuserve.com&rnum= 7
Thanks
Hari
MCDBA
"mj" <anonymous@.discussions.microsoft.com> wrote in message
news:133ab01c411ed$1a65b150$a101280a@.phx.gbl...
> Hi. I have a dbf file that has about 1.2 million lines of
> data. That file is produced by another system's
> proecesses. I'm wondering if there's a way for me to link
> my SQL Server database to that file? Any suggestions would
> be great. Thanks!
> dbf file is: M:\Data\Shipped.dbf
>

Lines in text column run together

Hi,
I'm using SQL RS 2000. My report has a text column that contains line
breaks. When printing this column in on a report, all of the lines run
together.
I've tried using a grid and list view and neither work.
Any ideas? Is there a function I should be using?
Thanks.
- JeffAre you using vbcrlf for the line breaks? I use that and it has always
worked for me.
"Jeff" wrote:
> Hi,
> I'm using SQL RS 2000. My report has a text column that contains line
> breaks. When printing this column in on a report, all of the lines run
> together.
> I've tried using a grid and list view and neither work.
> Any ideas? Is there a function I should be using?
> Thanks.
> - Jeff|||What do I do with the vrcrlf? The source application SQL RS is reading from
is a Great Plains text column. So I don't have control over how the data
enters the field. I just want to report it out.
- J
"SFrench" wrote:
> Are you using vbcrlf for the line breaks? I use that and it has always
> worked for me.
> "Jeff" wrote:
> > Hi,
> >
> > I'm using SQL RS 2000. My report has a text column that contains line
> > breaks. When printing this column in on a report, all of the lines run
> > together.
> >
> > I've tried using a grid and list view and neither work.
> >
> > Any ideas? Is there a function I should be using?
> >
> > Thanks.
> >
> > - Jeffsql

Lines in a job cmdexec step

Does it only execute the first line, or is there a way to have it
execute multiple lines? Sure seems like it just does one line. Seems
fine if that line executes a .cmd file with multiple lines.
But for some reasons I *thought* you could put multiple lines in the
little text window in the job editor and it would work, but it's not.
I'm trying to set a couple of environment variables before calling a
dts package:
--
set foo=123
dtsrun mypackage
--
Thanks.
Josh> Does it only execute the first line, or is there a way to have it
> execute multiple lines?
For cmdExec job steps, only the first line will be executed. Is using a bat file an option?
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"jxstern" <jxstern@.wherever.com> wrote in message news:q13v529cuemj7e79o2is9cfds5vncn4v8s@.4ax.com...
> Does it only execute the first line, or is there a way to have it
> execute multiple lines? Sure seems like it just does one line. Seems
> fine if that line executes a .cmd file with multiple lines.
> But for some reasons I *thought* you could put multiple lines in the
> little text window in the job editor and it would work, but it's not.
> I'm trying to set a couple of environment variables before calling a
> dts package:
> --
> set foo=123
> dtsrun mypackage
> --
>
> Thanks.
> Josh
>|||On Tue, 9 May 2006 15:11:47 +0200, "Tibor Karaszi"
<tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote:
>> Does it only execute the first line, or is there a way to have it
>> execute multiple lines?
>For cmdExec job steps, only the first line will be executed. Is using a bat file an option?
Guess so!
Already had them written, actually, for testing purposes.
Now have to run them through the deployment process ...
Thanks.
Josh

Lines in a job cmdexec step

Does it only execute the first line, or is there a way to have it
execute multiple lines? Sure seems like it just does one line. Seems
fine if that line executes a .cmd file with multiple lines.
But for some reasons I *thought* you could put multiple lines in the
little text window in the job editor and it would work, but it's not.
I'm trying to set a couple of environment variables before calling a
dts package:
set foo=123
dtsrun mypackage
--
Thanks.
Josh> Does it only execute the first line, or is there a way to have it
> execute multiple lines?
For cmdExec job steps, only the first line will be executed. Is using a bat
file an option?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"jxstern" <jxstern@.wherever.com> wrote in message news:q13v529cuemj7e79o2is9cfds5vncn4v8s@.
4a
x.com...
> Does it only execute the first line, or is there a way to have it
> execute multiple lines? Sure seems like it just does one line. Seems
> fine if that line executes a .cmd file with multiple lines.
> But for some reasons I *thought* you could put multiple lines in the
> little text window in the job editor and it would work, but it's not.
> I'm trying to set a couple of environment variables before calling a
> dts package:
> --
> set foo=123
> dtsrun mypackage
> --
>
> Thanks.
> Josh
>|||On Tue, 9 May 2006 15:11:47 +0200, "Tibor Karaszi"
<tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote:

>For cmdExec job steps, only the first line will be executed. Is using a bat file an
option?
Guess so!
Already had them written, actually, for testing purposes.
Now have to run them through the deployment process ...
Thanks.
Josh

Lines disappear

Hello Group,
has anyone ever seen this problem. I was asked to work on an old database
from project I had not been on (when does that ever happen...) anyway I go
right to the database diagram to get a look at what I am dealing with. When
I open the diagram a strange behavior manifests itself: the lines that show
relationships between the tables all disappear!
I can see them for just a moment and then just one by one disappear. The
daughter tables all have a field that has a "record id" which has a PK. They
have a field which stores the PK of the related table.
Why is this does this?
RichIs this for SQL 2005 or a previous version? Are you connecting from a
workstation or locally?
"Rich" wrote:
> Hello Group,
> has anyone ever seen this problem. I was asked to work on an old database
> from project I had not been on (when does that ever happen...) anyway I go
> right to the database diagram to get a look at what I am dealing with. When
> I open the diagram a strange behavior manifests itself: the lines that show
> relationships between the tables all disappear!
> I can see them for just a moment and then just one by one disappear. The
> daughter tables all have a field that has a "record id" which has a PK. They
> have a field which stores the PK of the related table.
> Why is this does this?
> Rich|||Hello Edgardo,
Version = 2000
Connection = my workstation has Enterprise Manager connecting to the
database server
"Edgardo Valdez, MCTS, MCITP, MCSD, MCDBA" wrote:
> Is this for SQL 2005 or a previous version? Are you connecting from a
> workstation or locally?
> "Rich" wrote:
> > Hello Group,
> >
> > has anyone ever seen this problem. I was asked to work on an old database
> > from project I had not been on (when does that ever happen...) anyway I go
> > right to the database diagram to get a look at what I am dealing with. When
> > I open the diagram a strange behavior manifests itself: the lines that show
> > relationships between the tables all disappear!
> >
> > I can see them for just a moment and then just one by one disappear. The
> > daughter tables all have a field that has a "record id" which has a PK. They
> > have a field which stores the PK of the related table.
> >
> > Why is this does this?
> >
> > Rich|||I have some more questions:
1-. If you can connect locally to the same server, do you experience the
same behavior?
2-. Did you try connecting from another workstation?
3-. What is the Service Pack Level in the server?
"Rich" wrote:
> Hello Edgardo,
> Version = 2000
> Connection = my workstation has Enterprise Manager connecting to the
> database server
> "Edgardo Valdez, MCTS, MCITP, MCSD, MCDBA" wrote:
> > Is this for SQL 2005 or a previous version? Are you connecting from a
> > workstation or locally?
> >
> > "Rich" wrote:
> >
> > > Hello Group,
> > >
> > > has anyone ever seen this problem. I was asked to work on an old database
> > > from project I had not been on (when does that ever happen...) anyway I go
> > > right to the database diagram to get a look at what I am dealing with. When
> > > I open the diagram a strange behavior manifests itself: the lines that show
> > > relationships between the tables all disappear!
> > >
> > > I can see them for just a moment and then just one by one disappear. The
> > > daughter tables all have a field that has a "record id" which has a PK. They
> > > have a field which stores the PK of the related table.
> > >
> > > Why is this does this?
> > >
> > > Rich

Lines disappear

Hello Group,
has anyone ever seen this problem. I was asked to work on an old database
from project I had not been on (when does that ever happen...) anyway I go
right to the database diagram to get a look at what I am dealing with. When
I open the diagram a strange behavior manifests itself: the lines that show
relationships between the tables all disappear!
I can see them for just a moment and then just one by one disappear. The
daughter tables all have a field that has a "record id" which has a PK. They
have a field which stores the PK of the related table.
Why is this does this?
Rich
Is this for SQL 2005 or a previous version? Are you connecting from a
workstation or locally?
"Rich" wrote:

> Hello Group,
> has anyone ever seen this problem. I was asked to work on an old database
> from project I had not been on (when does that ever happen...) anyway I go
> right to the database diagram to get a look at what I am dealing with. When
> I open the diagram a strange behavior manifests itself: the lines that show
> relationships between the tables all disappear!
> I can see them for just a moment and then just one by one disappear. The
> daughter tables all have a field that has a "record id" which has a PK. They
> have a field which stores the PK of the related table.
> Why is this does this?
> Rich
|||I have some more questions:
1-. If you can connect locally to the same server, do you experience the
same behavior?
2-. Did you try connecting from another workstation?
3-. What is the Service Pack Level in the server?
"Rich" wrote:
[vbcol=seagreen]
> Hello Edgardo,
> Version = 2000
> Connection = my workstation has Enterprise Manager connecting to the
> database server
> "Edgardo Valdez, MCTS, MCITP, MCSD, MCDBA" wrote:

Lines disappear

Hello Group,
has anyone ever seen this problem. I was asked to work on an old database
from project I had not been on (when does that ever happen...) anyway I go
right to the database diagram to get a look at what I am dealing with. When
I open the diagram a strange behavior manifests itself: the lines that show
relationships between the tables all disappear!
I can see them for just a moment and then just one by one disappear. The
daughter tables all have a field that has a "record id" which has a PK. The
y
have a field which stores the PK of the related table.
Why is this does this?
RichIs this for SQL 2005 or a previous version? Are you connecting from a
workstation or locally?
"Rich" wrote:

> Hello Group,
> has anyone ever seen this problem. I was asked to work on an old database
> from project I had not been on (when does that ever happen...) anyway I go
> right to the database diagram to get a look at what I am dealing with. Wh
en
> I open the diagram a strange behavior manifests itself: the lines that sho
w
> relationships between the tables all disappear!
> I can see them for just a moment and then just one by one disappear. The
> daughter tables all have a field that has a "record id" which has a PK. T
hey
> have a field which stores the PK of the related table.
> Why is this does this?
> Rich|||Hello Edgardo,
Version = 2000
Connection = my workstation has Enterprise Manager connecting to the
database server
"Edgardo Valdez, MCTS, MCITP, MCSD, MCDBA" wrote:
[vbcol=seagreen]
> Is this for SQL 2005 or a previous version? Are you connecting from a
> workstation or locally?
> "Rich" wrote:
>|||I have some more questions:
1-. If you can connect locally to the same server, do you experience the
same behavior?
2-. Did you try connecting from another workstation?
3-. What is the Service Pack Level in the server?
"Rich" wrote:
[vbcol=seagreen]
> Hello Edgardo,
> Version = 2000
> Connection = my workstation has Enterprise Manager connecting to the
> database server
> "Edgardo Valdez, MCTS, MCITP, MCSD, MCDBA" wrote:
>sql

Lines

I have a report that I need to add a line every 5 records (don't ask!), I
can't see anyway to do this simply using the line control.
Am I missing something or do I have to look at doing this progmatically?Found the answer.
I added a border to the bottom of the detail row in a table control and then
set the borders visibility to an expression so that it was only visible every
5 rows.

line to extend to edge of page when using a matrix

I have a few lines in my report page headers and

page footers. On the report I have a matrix, which extends the report horizontally across

two pages or more. How can I get the lines to extend to the edge of the

report?

i'm still having trouble with this, does anyone have any ideas?

line to extend to edge of page when using a matrix

I have a few lines in my report page headers and

page footers. On the report I have a matrix, which extends the report horizontally across

two pages or more. How can I get the lines to extend to the edge of the

report?

i'm still having trouble with this, does anyone have any ideas?

Line positions

Hi everyone,

I have kind of trouble with my report controls.I draw the lines and borders and they look OK on Report page at layout screen but on preview screen and trasported pdf documents i see that lines are not on the particular order or on position i designed(especilally control borders....)I've tried to look up reports on other computers too and i keep having the trouble.What could it be?Anyone has any suggestion?

Hi

Did you manage to get a solution with the layout rendering problem? I'm experiencing the same prob. Very annoying.

Help will be highly appreciated.

J

|||I have the same problem too

Line positions

Hi everyone,

I have kind of trouble with my report controls.I draw the lines and borders and they look OK on Report page at layout screen but on preview screen and trasported pdf documents i see that lines are not on the particular order or on position i designed(especilally control borders....)I've tried to look up reports on other computers too and i keep having the trouble.What could it be?Anyone has any suggestion?

Hi

Did you manage to get a solution with the layout rendering problem? I'm experiencing the same prob. Very annoying.

Help will be highly appreciated.

J

|||I have the same problem toosql

Line positions

Hi everyone,

I have kind of trouble with my report controls.I draw the lines and borders and they look OK on Report page at layout screen but on preview screen and trasported pdf documents i see that lines are not on the particular order or on position i designed(especilally control borders....)I've tried to look up reports on other computers too and i keep having the trouble.What could it be?Anyone has any suggestion?

Hi

Did you manage to get a solution with the layout rendering problem? I'm experiencing the same prob. Very annoying.

Help will be highly appreciated.

J

|||I have the same problem too

Line location as expression

Is it possible to move lines based on the values from dataset(trying to draw graph kinda thing by joining points using lines) ?Let me know if I am not clear here.

Thanks

Yes, it is possible if I understand you correctly and if you are willing to do some custom rendering. Check out CustomReportItem and look at the Polygons sample in the RS sample stuff.

If you go this route, take it from me you will find out it's not all about 1's and 0's <rofl>.

But, yes, you are really not being clear <g>. So maybe I've misunderstood...

>L<

sql

Line graph - line width

How do I set the line width (weight) of lines with a line chart. Lines
always seem several pixels wide.
Also, when selecting "Numeric or time-scale values" on the X-axis of a line
chart the labels appear vertically in the Chart Properties dialog box but
appear horizontally when the report is generated. I have RS sp1 installed.
How do I fix this problem?Answer to your first problem:
Layout view: right-click the chart, select properties, go to the data tab,
press the edit button for the desired value, go to the appearance tab and
there you can set the width of a line.
They've put it away quite well :)
"Stephen Strong" <StephenStrong@.discussions.microsoft.com> wrote in message
news:B7EB33C9-E210-4F18-9E08-AC588746DC7F@.microsoft.com...
> How do I set the line width (weight) of lines with a line chart. Lines
> always seem several pixels wide.
> Also, when selecting "Numeric or time-scale values" on the X-axis of a
> line
> chart the labels appear vertically in the Chart Properties dialog box but
> appear horizontally when the report is generated. I have RS sp1 installed.
> How do I fix this problem?|||Thanks! I've noticed that setting the line weight to 0.75 pixels produces
sharp lines. Less than 0.75 and the line doesn't appear.
"Pieter van Maasdam" wrote:
> Answer to your first problem:
> Layout view: right-click the chart, select properties, go to the data tab,
> press the edit button for the desired value, go to the appearance tab and
> there you can set the width of a line.
> They've put it away quite well :)
> "Stephen Strong" <StephenStrong@.discussions.microsoft.com> wrote in message
> news:B7EB33C9-E210-4F18-9E08-AC588746DC7F@.microsoft.com...
> > How do I set the line width (weight) of lines with a line chart. Lines
> > always seem several pixels wide.
> >
> > Also, when selecting "Numeric or time-scale values" on the X-axis of a
> > line
> > chart the labels appear vertically in the Chart Properties dialog box but
> > appear horizontally when the report is generated. I have RS sp1 installed.
> > How do I fix this problem?
>
>|||This is a limitation of the chart control in RS 2000 which only allows
integer values for line width. This will change in RS 2005. For pixel-based
output format (like TIFF) you won't notice to much difference, but in vector
graphics formats (like EMF) you will see differences especially when zooming
or at high resolutions (e.g. printing).
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Stephen Strong" <StephenStrong@.discussions.microsoft.com> wrote in message
news:80991847-4967-4F14-840E-20F72C0DE53B@.microsoft.com...
> Thanks! I've noticed that setting the line weight to 0.75 pixels produces
> sharp lines. Less than 0.75 and the line doesn't appear.
> "Pieter van Maasdam" wrote:
> > Answer to your first problem:
> >
> > Layout view: right-click the chart, select properties, go to the data
tab,
> > press the edit button for the desired value, go to the appearance tab
and
> > there you can set the width of a line.
> >
> > They've put it away quite well :)
> >
> > "Stephen Strong" <StephenStrong@.discussions.microsoft.com> wrote in
message
> > news:B7EB33C9-E210-4F18-9E08-AC588746DC7F@.microsoft.com...
> > > How do I set the line width (weight) of lines with a line chart.
Lines
> > > always seem several pixels wide.
> > >
> > > Also, when selecting "Numeric or time-scale values" on the X-axis of a
> > > line
> > > chart the labels appear vertically in the Chart Properties dialog box
but
> > > appear horizontally when the report is generated. I have RS sp1
installed.
> > > How do I fix this problem?
> >
> >
> >
>

Line feed problem in HTML

I'm using a string in report which contains chr(10) -> Line feed characters. They show up correctly (there are several lines) in Preview screen and in pdf-format but NOT in browser. I think the browser doesn't understand those characters. Is there a way to replace them somehow with other useful keys? If there is an example would be great...

I use the equivalent of the old vbCrLf i.e. carriage return followed by a line feed, and this works fine in the HTML.

Try using Chr(13) & Chr(10) or the .NET property Environment.NewLine.

For formatting in SQL I use CHAR(13) + CHAR(10)

|||I'm sorry but I didn't get it. I have 3 rows long field in report(Fields!Address.value) and that value contains those carriage returns. So should I edit the expression of the field to find where the carriage returns are and replace them somehow?|||try Replace(Fields!Address.Value, chr(10), Environment.NewLine)

Line Count in Crystal Report

Is there any function or way to get the no of lines displayed in the detail section of the report.

Hlp me.

Thx in advance.

Ashok Sis that not a group function.. something you would put in the group footer (a total)?

i cant be too specific because im still learning crystal myself!|||You need to use two formulae
Formula1 @.Reset having the code
Numbervar n;
WhilePrintingRecords;
n:=0;
Formula2 @.Count having the code
Numbervar n;
WhilePrintingRecords;
n:=n+1;
Now Place Formual1 at PageHeader
Formula2 at Details Section.
Now the last value is the total number of records of that page|||Or you could just use the inbuilt RecordNumber function. It works fine if you are not hiding any records in your record set

- Jukka|||My Problem is not getting the recordcount. I need to get the line count.
A Record may be displayed in multiple lines.

To be Specific, I have four Detail sections, and in that for three sections i have used can grow property except the first one. In this case I need to get the Line nos of the detail section.

Thx,

Ashok

Line Chart Line Color

Is it possible to change line color in the line chart. I can change series
color in a bar chart, but cannot seem to change the color of the lines when
selecting a smooth line chart.
-ChrisThe relevant property in line charts is the border line color property.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Chris Borgers" <ChrisBorgers@.discussions.microsoft.com> wrote in message
news:4852411A-7B54-4A8D-9E19-E3787F9D1656@.microsoft.com...
> Is it possible to change line color in the line chart. I can change
series
> color in a bar chart, but cannot seem to change the color of the lines
when
> selecting a smooth line chart.
> -Chris

Line Chart Color

Hello,

My line chart displays all lines in a single color (the series color). I'd like a single color per item in the series just like the bar chart. Is there a way to change this? Or is the only differentiation the markers?

Michael

To put different colors for lines in line chart, Please select chart properties-goto Data-under values goto Edit-Apperance-goto Series Style...-select Border and Line-Color. give suitable color here. (and i think line and marker will have the same color.)|||

Merin,

I did see that option. But doing that changes the colors for ALL lines in my chart. I'd like my series to have different colors, if possible. Any ideas?

Michael

|||for each value u need to select colors. u may have different values inside data in chart properties , for each case u need to follow the same path and choose different color.it worked for me. i hope it will work for u also|||

Ugh, that sounds a lot messier than I thought, especially since my series are all dynamic. Can I reference the color pallete using an array? Or perhaps I'll wait to SRS 2008 with the Dundas charts.

Michael

|||What you mean by dynamic series?|||I mean I have multiple lines on the chart, one for each series value. All the lines are the same color.|||i am trying to do the same thing too.

i was able to for a 100% stacked column chart, using multiple data values, and still specify a color for each value in the stacked column chart (3 of them in my case).

however for my current line chart with only 1 data value, the default colors are automatic according to a color scheme, but i want to be able to define the colors. i was thinking of the following methods using coding under the chart properties -? data -? values (double click the value item) -? edit chart value -? appearance -? series style -? border and line -? color -? ?x

(refer to code snippet)

and the color will be hardcoded to the value string of the data. alternative you can put it as a database column. these are just my ideas. would be great if someone out there has a better solution ... always open to learn.

rev-boy

=IIf(
Fields!DATA_COLUMN.Value = "Type 1", "Green",
IIf
(
Fields!DATA_COLUMN.Value = "Type 2", "Red",
IIf
(
Fields!DATA_COLUMN.Value = "Type 3", "Brown", "Black"
)
)
)