Duplicate Rows !

In my ad-hoc reports created by Report Builder, my data is grouped if there are more than one records corresponding to some value.Is there any way to override this behaviour?
In the report designer I can do this by using the 'Hide Duplicates' property of the textbox. But doing so will make the report unusable through Report Builder.
I would like to see all values even if they are repeating when they are exported to excel.

Any help is appreciated !

I'm assuming you have created a table with multiple groups.

Try creating a table that only has a single group, or make sure that the group with the duplicate date is the right-most group.

|||

Hi,

My report is an ad-hoc report and I have not defined any groups.
I need to avoid changing the column order in the report too. So is there any property in Report Builder tool corresponding to the 'Hide Duplicates' property that is available in the Report Designer ?

Duplicate key error

I'm having trouble when trying to apply a snapshot to the subsciber. The
distibution agent reports error "unexpected EOF found in BCP data file error"
in addition it reports " duplicate key error". I have filtered the data
being sent and choosen to delete the rows at the subscriber table that match
the filter. I've checked the subscriber table and all looks ok. The
snapshot application has deleted the rows that are in the filter but when it
inserts the filtered rows it's showing a "duplicate key error". How can this
be? Can any one explain this?
I found that dropping and recreating the table does work however, I don't
want to drop and re-create the table as there is existing data in the
subscriber table that needs to be preserved.
Thanks,
Reana
Can you have a look at the snpashot files to confirm what is happening. There
should be a delete statement with a where clause and the bcp data file should
only have rows that correspond tot he where clause. Also check for any
duplicates in the bcp data files.
Cheers,
Paul Ibison

Duplicate display of values in the Details section

Hi folks,

i have a peculiar problem, i am passing a query from VB 6.0 to crystal reports to revieve the data i want and i am successful in doing that. But the problem is, it is
duplicating the output, i'm seeking for. it duplicates when the output is places in the Details section but when i place it in the Header section then there is no duplication.
can any one please tell me why?

thanx in advance.......

number3I hope I've understood the question correctly...

How many rows is your query returning? The details section is the only section that creates a new section for every row returned by the query. If you drag the field into the header you are only going to get the value from the first row. This is how crystal is supposed to work.

If you need a second details section (from another result set), you need to look at placing a subreport in the header.|||you need to run your SQL in a database viewer tool. possibly you have linked some tables together but not put a criteria in the select expert..

you CAN choose "select distinct records" on the database menu, but this will make the report run more slowly. you should really fix up your sql so it doesnt return you duplicatessql

Duplex printing SRS 2000

Is it possible to set a printer to duplex within SQL Reporting Service 2000?
I have several reports to print and need to switch back and forth between
duplex (Front and Back) and one sided printing.
TIABump
"bhughes" wrote:
> Is it possible to set a printer to duplex within SQL Reporting Service 2000?
> I have several reports to print and need to switch back and forth between
> duplex (Front and Back) and one sided printing.
> TIA
>
>|||I guess no one else has been able to do this either. Time to start looking
for a new report writer.
"bhughes" wrote:
> Is it possible to set a printer to duplex within SQL Reporting Service 2000?
> I have several reports to print and need to switch back and forth between
> duplex (Front and Back) and one sided printing.
> TIA
>
>sql

Dumb question: Sanpshot reports

Will a report based on a scheduled snapshot send itself out (either to an email or data space) if the data in the new snap shot is the same as the previous?

If so is there any method to only send out a report if the data has changed?

And if not what do most people use snap shot based subscriptions for?

Thanks.

1.) Yes.

2.) You can try to use Data Driven Subscriptions. What you will have to do is have the query which generates the list of recipients detect if the data has changed, and return an empty set if this is the case. SSRS will not really help you do this, so you will need to cook up your own way of determining if the data has changed since the last report went out.

dumb question

Hi all, yes this is a dumb question, but I cant find a formatting answer...
A zero value eg 0, or 0.0 is supressed on RS reports by default.
How can I stop this, the report must show all zeros regardless in a total
field.
If I use default as the format type then I will see 0, but as the field is a
percentage, I have to use the % attribute for the format type..
So, how can I force the showing of a zero in a total fiel ie. 0%
Thanx in advanceHow about =iif(Fields!Total.value>0,Fields!Total.value,0) in the expression
of that text box. Then right click the text box and pick properties format
and put in P (for percent or P0 or P1 according to how many places you want
after the decimal. Hope that works for you.
"Scotchy" wrote:
> Hi all, yes this is a dumb question, but I cant find a formatting answer...
> A zero value eg 0, or 0.0 is supressed on RS reports by default.
> How can I stop this, the report must show all zeros regardless in a total
> field.
> If I use default as the format type then I will see 0, but as the field is a
> percentage, I have to use the % attribute for the format type..
> So, how can I force the showing of a zero in a total fiel ie. 0%
> Thanx in advance|||Hi KimB, thanks for your suggestion, actuall tried that approach to no avail.
cheers
Paul
"KimB" wrote:
> How about =iif(Fields!Total.value>0,Fields!Total.value,0) in the expression
> of that text box. Then right click the text box and pick properties format
> and put in P (for percent or P0 or P1 according to how many places you want
> after the decimal. Hope that works for you.
>
> "Scotchy" wrote:
> > Hi all, yes this is a dumb question, but I cant find a formatting answer...
> >
> > A zero value eg 0, or 0.0 is supressed on RS reports by default.
> >
> > How can I stop this, the report must show all zeros regardless in a total
> > field.
> >
> > If I use default as the format type then I will see 0, but as the field is a
> > percentage, I have to use the % attribute for the format type..
> >
> > So, how can I force the showing of a zero in a total fiel ie. 0%
> >
> > Thanx in advance|||Have you tried =iif(Fields!Total.value>0,Fields!Total.value,"0.0%")? I
think that should work for you.

DTSRUN

When I am on the sql server and I issue my dtsrun statement, the package
runs fine, however, when I run it from another server, it reports that the
package ran successfully, however, upon further inspection I see that the
package did not run at all.
Any ideas ?
I would check security issues first.
Secondly, what do you mean by it ran successfully? Does your DTS package
throw errors when it runs into problems, or does it just go merrily on about
it's business and report that it finished all of it's steps. (Whether they
were successful or not).
Not much help, but more information would be useful and I'm sure others here
will have more ideas for you.
Rick Sawtell
MCT, MCSD, MCDBA
"rob" <rwc1960@.bellsouth.net> wrote in message
news:TfH%c.75928$N11.50380@.bignews5.bellsouth.net. ..
> When I am on the sql server and I issue my dtsrun statement, the package
> runs fine, however, when I run it from another server, it reports that the
> package ran successfully, however, upon further inspection I see that the
> package did not run at all.
> Any ideas ?
>
>
|||I execute the following from the DOS prompt from a server other than the SQL
server...
C:\dtsrun /SSqlServerIPaddressHere /Uusername /Ppasword /Npackagename
1. Messages appear in the DOS window which state that the package is running
2. The final message states that the package successfully completed
However, upon further review, none of the tasks in the package were
completed.
I did get permission errors to begin with, but after I fixed them, I just
get that the package completed successfully when in fact, none of the tasks
were completed.
"Rick Sawtell" <ricksawtell@.hotmail.com> wrote in message
news:uDER1vclEHA.644@.tk2msftngp13.phx.gbl...
> I would check security issues first.
> Secondly, what do you mean by it ran successfully? Does your DTS package
> throw errors when it runs into problems, or does it just go merrily on
about
> it's business and report that it finished all of it's steps. (Whether
they
> were successful or not).
>
> Not much help, but more information would be useful and I'm sure others
here[vbcol=seagreen]
> will have more ideas for you.
>
> Rick Sawtell
> MCT, MCSD, MCDBA
>
> "rob" <rwc1960@.bellsouth.net> wrote in message
> news:TfH%c.75928$N11.50380@.bignews5.bellsouth.net. ..
the[vbcol=seagreen]
the
>
|||Try using the /L option and specifying a log file for the package status
information. This may help you narrow down the problems.
When you run the package from the SQL Server machine, are you logged in as a
local Admin? I'm not sure about the security issues with the DTS packages,
but that is still the first place I would be looking in this case. Check
the log file and see what information is coming back to you.
Rick Sawtell
MCT, MCSD, MCDBA
"rob" <rwc1960@.bellsouth.net> wrote in message
news:GcI%c.76012$N11.16495@.bignews5.bellsouth.net. ..
> I execute the following from the DOS prompt from a server other than the
SQL
> server...
> C:\dtsrun /SSqlServerIPaddressHere /Uusername /Ppasword /Npackagename
> 1. Messages appear in the DOS window which state that the package is
running
> 2. The final message states that the package successfully completed
> However, upon further review, none of the tasks in the package were
> completed.
> I did get permission errors to begin with, but after I fixed them, I just
> get that the package completed successfully when in fact, none of the
tasks[vbcol=seagreen]
> were completed.
>
>
>
> "Rick Sawtell" <ricksawtell@.hotmail.com> wrote in message
> news:uDER1vclEHA.644@.tk2msftngp13.phx.gbl...
package[vbcol=seagreen]
> about
> they
> here
package
> the
> the
>

DTSRUN

When I am on the sql server and I issue my dtsrun statement, the package
runs fine, however, when I run it from another server, it reports that the
package ran successfully, however, upon further inspection I see that the
package did not run at all.
Any ideas ?I would check security issues first.
Secondly, what do you mean by it ran successfully? Does your DTS package
throw errors when it runs into problems, or does it just go merrily on about
it's business and report that it finished all of it's steps. (Whether they
were successful or not).
Not much help, but more information would be useful and I'm sure others here
will have more ideas for you.
Rick Sawtell
MCT, MCSD, MCDBA
"rob" <rwc1960@.bellsouth.net> wrote in message
news:TfH%c.75928$N11.50380@.bignews5.bellsouth.net...
> When I am on the sql server and I issue my dtsrun statement, the package
> runs fine, however, when I run it from another server, it reports that the
> package ran successfully, however, upon further inspection I see that the
> package did not run at all.
> Any ideas ?
>
>|||I execute the following from the DOS prompt from a server other than the SQL
server...
C:\dtsrun /SSqlServerIPaddressHere /Uusername /Ppasword /Npackagename
1. Messages appear in the DOS window which state that the package is running
2. The final message states that the package successfully completed
However, upon further review, none of the tasks in the package were
completed.
I did get permission errors to begin with, but after I fixed them, I just
get that the package completed successfully when in fact, none of the tasks
were completed.
"Rick Sawtell" <ricksawtell@.hotmail.com> wrote in message
news:uDER1vclEHA.644@.tk2msftngp13.phx.gbl...
> I would check security issues first.
> Secondly, what do you mean by it ran successfully? Does your DTS package
> throw errors when it runs into problems, or does it just go merrily on
about
> it's business and report that it finished all of it's steps. (Whether
they
> were successful or not).
>
> Not much help, but more information would be useful and I'm sure others
here
> will have more ideas for you.
>
> Rick Sawtell
> MCT, MCSD, MCDBA
>
> "rob" <rwc1960@.bellsouth.net> wrote in message
> news:TfH%c.75928$N11.50380@.bignews5.bellsouth.net...
> > When I am on the sql server and I issue my dtsrun statement, the package
> > runs fine, however, when I run it from another server, it reports that
the
> > package ran successfully, however, upon further inspection I see that
the
> > package did not run at all.
> >
> > Any ideas ?
> >
> >
> >
>|||Try using the /L option and specifying a log file for the package status
information. This may help you narrow down the problems.
When you run the package from the SQL Server machine, are you logged in as a
local Admin? I'm not sure about the security issues with the DTS packages,
but that is still the first place I would be looking in this case. Check
the log file and see what information is coming back to you.
Rick Sawtell
MCT, MCSD, MCDBA
"rob" <rwc1960@.bellsouth.net> wrote in message
news:GcI%c.76012$N11.16495@.bignews5.bellsouth.net...
> I execute the following from the DOS prompt from a server other than the
SQL
> server...
> C:\dtsrun /SSqlServerIPaddressHere /Uusername /Ppasword /Npackagename
> 1. Messages appear in the DOS window which state that the package is
running
> 2. The final message states that the package successfully completed
> However, upon further review, none of the tasks in the package were
> completed.
> I did get permission errors to begin with, but after I fixed them, I just
> get that the package completed successfully when in fact, none of the
tasks
> were completed.
>
>
>
> "Rick Sawtell" <ricksawtell@.hotmail.com> wrote in message
> news:uDER1vclEHA.644@.tk2msftngp13.phx.gbl...
> > I would check security issues first.
> >
> > Secondly, what do you mean by it ran successfully? Does your DTS
package
> > throw errors when it runs into problems, or does it just go merrily on
> about
> > it's business and report that it finished all of it's steps. (Whether
> they
> > were successful or not).
> >
> >
> > Not much help, but more information would be useful and I'm sure others
> here
> > will have more ideas for you.
> >
> >
> > Rick Sawtell
> > MCT, MCSD, MCDBA
> >
> >
> >
> > "rob" <rwc1960@.bellsouth.net> wrote in message
> > news:TfH%c.75928$N11.50380@.bignews5.bellsouth.net...
> > > When I am on the sql server and I issue my dtsrun statement, the
package
> > > runs fine, however, when I run it from another server, it reports that
> the
> > > package ran successfully, however, upon further inspection I see that
> the
> > > package did not run at all.
> > >
> > > Any ideas ?
> > >
> > >
> > >
> >
> >
>