sql server reporting services: Displaying data from multiple databases -- sql server reporting services

You're in the

sql server reporting services

group:

Displaying data from multiple databases

jbmeeh
12/7/2004 3:59:02 PM

sql server reporting services: I am using a subreport to lookup up a name from a code value since the lookup
table is in a separate database from the main report. How do I limit the
white space on the name field? I have defined a single textbox in the
subreport, but when I preview the subreport it displays a complete line.
Similarly, when the main report previews the subreport displays the complete
line. I have tried placing the textbox in a rectangle, but it doesn't appear

Re: Displaying data from multiple databases

Jeff A. Stucker
12/7/2004 6:38:48 PM

You could also try putting the subreport in a rectangle. (Can you guess,
I'm stuck on rectangles for solving white space problems?)

Cheers,

'(' Jeff A. Stucker
\

Business Intelligence
www.criadvantage.com
--------------------------------------
[quoted text, click to view]

Re: Displaying data from multiple databases

Bruce L-C [MVP]
12/7/2004 8:17:46 PM

If you have a table for the data of the main report, add another column to
the table and put the subreport in that column. If it is a single value they
it will not go to another row.

--
Bruce Loehle-Conger
MVP SQL Server Reporting Services

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server reporting services group.

home · blog · groups

Questions? Comments? Contact the dn