I've always found the Wrox Books Helpful in getting started with something new.  The books have walk thru's that build on each other.  After working thru the book, I am up...

When I want to pass variables from VB.Net to Report Writer I just use something like this:

Dim IEForm As New frmIEWindow

With IEForm

.URLAddress = "http://SQL/ReportServer?%2fTrustSafekeepingReports%2fHoldingListForAccount&AccountID=" & AccountID & "&rc

How about stripping out the duplicate entries before they ever get to Report Writer.  If using sql, could you use the distinct option???

From VB.net using the following example works just fine.

http://SQL/ReportServer?%2fTrustSafekeepingReports%2fHoldingListForAccount&AccountID=" & AccountID & "&rcarameters=false"

Just did some importing of excel.  I found that importing to a VarChar was a problem.  But convert the fields to NVarChar solved a lot of problems.

chuck

Last update.  Thanks Jeff.  Changed the import to be Null instead of '', and dropped off the checks for '' in the query. 

Works beautiful.  Going to save the operator...

Actually that's excactly what I want (well, its what the boss wants, so its what I want).

Currently the program importing the FinCen file is posting '' to the cells, but...

This looks like it works.  It is striping out any blank rows, and passing thru the matches.  Any suggestions would be appreciated.

chuck

SELECT FinCenPersonal.*, Checks.* FROM   FinCenPersonal

INNER JOIN Checks

ON (Checks.Payee>''...

Thanks for looking at the problem.

I'll Adjust the varchar later, not important right now.

The problem is in the checks table I've got and entry in Payee like "Chuck Sndyer"

and in...

That gets me part way there.  I was using IN because it selected partial matches too.  The performance hit is accectable, there are usually less than 1000 rows in the...

Along with the above check your rights to the Data source (and be sure it deployed also).

If you can't find 'DSNavTest', then it needs to be deployed.

Once found, examine the...

No.  SQL creates two databases for Reporting Services, ReportServer and ReportServerTempDB.

Can't have two sets of them on one server.

I found the real problem.  I was using this url to access the report within my vb app.

http://localhost/Reports/Pages/Report.aspx?ItemPath=%2fTrustSafekeepingReports%2fCallsSummary&rc:FullScreen=False

But I needed to be using this URL instead:

<A...

Just a suggestion, check page width.  I've had blank pages when the width of the body is too much to fit on the page.  Also, the margins can be adjusted.

Thanks.  That is what I was looking for.  Couldn't find it in the docs.