If itis problematic, what is the best solution for this?:
I have a big query that retrieve some data. To make it simpler to explain,
imagine this simple query:
SELECT IDEPOL, POL_NAME
FROM POLIZA
WHERE [some filter]
I have in report layout a data region that shows POLIZA information.
I need to have another data region associated with this other query:
SELECT MOVEMENT
FROM PRIMA
WHERE IDEPOL = :IDEPOL
Where :IDEPOL is the IDEPOL returned by the first query.
Of course, I have grouped by IDEPOL in layout (using a List control)
I repeat that this is only an example, The true main query is very big, and
I need to have several other data regions whose queries are of the form of:
SELECT MOVEMEN
FRIMA
WHERE IDEPOL = :IDEPOL
So the usage of a lot of joins is discarded.
Thanks in advance for any help you can give me.
Jaim
[quoted text, click to view] "Wayne Snyder" wrote:
> You must use the Queried section... Name the dataset and the field...
> However I warn you (as does the documentation) that sometimes using the same
> data set for report data and parameters cause (I think the word is )
> unspecified behaviours... - problems... be careful..
>
> --
> Wayne Snyder, MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
>
www.mariner-usa.com > (Please respond only to the newsgroups.)
>
> I support the Professional Association of SQL Server (PASS) and it's
> community of SQL Server professionals.
>
www.sqlpass.org >
> "Jaime Stuardo" <JaimeStuardo@discussions.microsoft.com> wrote in message
> news:526D3602-02A8-40BB-BD1B-D6222D95D730@microsoft.com...
> > Hi all..
> >
> > How can I use a value of a returning dataset to be the default value for a
> > parameter?
> >
> > I tried using =Fields!THE_FIELD.value in Non-queried textbox of the
> > parameter, but this doesn't seem to work.
> >
> > When I press the fx button, the text "Report item not linked to database"
> > is
> > shown in Fields node of the treeview. I don't know if this message has
> > something to do with it.
> >
> > Thanks
> > Jaime
>
>
