Report works byitself, but not in a SubReport

Hi All,
I am trying to run a report which has no parameters. it works fine in
design and even on the report server. but as soon as i put it in a
subreport it gives an error
"Error: SubReport could not be shown"
i have tried almost all of the help available on these group, i have
put the report to be of the same size, removed all the parameters(so
there are no parameters).
will highly appreciate any valuable suggestions.
:-)hi,
theboulevardguy1@.gmail.com wrote:
> "Error: SubReport could not be shown"
This is not an Access or VBA error. So take a look at the report events
(On Load, On Open). There must be some piece of code throwing that
exception.
mfG
--> stefan <--|||I presume you are getting the error in the VS designer. Is the calling
report is in the same project as the subreport?
Also you posted this to reporting services group and access. They are
quite different reports. I am assuming this is a reporting services
report.
theboulevardg...@.gmail.com wrote:
> Hi All,
> I am trying to run a report which has no parameters. it works fine in
> design and even on the report server. but as soon as i put it in a
> subreport it gives an error
> "Error: SubReport could not be shown"
> i have tried almost all of the help available on these group, i have
> put the report to be of the same size, removed all the parameters(so
> there are no parameters).
> will highly appreciate any valuable suggestions.
> :-)

Report Wizard Error on SP

Stepping through the Report Wizard to create a new report, the second step
"Design the Query" I entered my SP name. When I click next I get the
following error.
"There is an error in the query. Line 1: Incorrect syntax near
'STORED_PROCEDURE_NAME""
I ran the SP in Query Analyzer and works fine.
The Shared Data Source tested good for the connection.Mike,
Why I think this happens is that the development environment is parsing
the stored procedure to try and determine the resultset that will be
coming back. If it can't, it just gives up and returns the error
message. I've had this happen on procs that use temp tables primarily.
There are a several of ways to handle this.
1. Don't use the wizzard. Manually build your data source, manually key
in the column names for the result set. Some will advocate never using
the wizzard, but don't throw the baby out witht he bathwater...
2. Try entering the proc exec statement with any required parameters:
exec myproc 0, 'parm2'
once you get through the wizzard, change the data set from using the
Command Type of "Text" to use "StoredProcedure", and specify the
parameter(s)/values on the parameter tab.
3. Modify your procedure to return an empty result set that matches
what is normally returned. default your parameter(s) to Null and add a
check for @.parameter = null in the body of the proc. if it is null,
return the empty result set and return. This will give the wizzard
what it is looking for. One technique that worked for me was to
rewrite the proc so that any SELECT ... INTO statements that create and
populate temp tables are changed to explicit table creates and insert
statements. Using table variables instead of temp tables is also an
option, as the development environment parser seems to ignore them when
trying to determine the result set.
Hope this helps!
Regards,
Clayton

Report with x items per page. Can't get this to work.

I have a very simple design that is causing a very large headache, and
I was hoping you could point me in the right direction.
All I need is for my report to have some information at the top, a
list of 5 items, and then some information at the bottom. But there
maybe more then 5 items, say 10. So I would need to generate 2 pages
with all the same information at the top and the bottom but the first
page would contain the first 5 lines and the second the next 5 lines.
The number of items would vary anywhere from 1 to 100, so it needs to
start a new page every 5 items.
I'm actually not using a database connection instead I'm using .net
object that contains all the information I need, including the list of
items. Now when I use a table or list and grouping so I can group the
items into chunks of 5, and then use a page break on group end I can
generate the next page, but the next set of items start at the top of
the page not where the list is on layout, and none of my other
information repeats. Now I've also tried using headers and footers
but for some reason it says I can't use "Fields" in the header and
footer sections so the additional information I need to display cant
be put in the header and foot.
This seems like a very very simple report yet I can't get the report
to do what I need.
Any help would be appreciated, Thanx.On Mar 30, 10:31 am, Edgey.Er...@.gmail.com wrote:
> I have a very simple design that is causing a very large headache, and
> I was hoping you could point me in the right direction.
> All I need is for my report to have some information at the top, a
> list of 5 items, and then some information at the bottom. But there
> maybe more then 5 items, say 10. So I would need to generate 2 pages
> with all the same information at the top and the bottom but the first
> page would contain the first 5 lines and the second the next 5 lines.
> The number of items would vary anywhere from 1 to 100, so it needs to
> start a new page every 5 items.
> I'm actually not using a database connection instead I'm using .net
> object that contains all the information I need, including the list of
> items. Now when I use a table or list and grouping so I can group the
> items into chunks of 5, and then use a page break on group end I can
> generate the next page, but the next set of items start at the top of
> the page not where the list is on layout, and none of my other
> information repeats. Now I've also tried using headers and footers
> but for some reason it says I can't use "Fields" in the header and
> footer sections so the additional information I need to display cant
> be put in the header and foot.
> This seems like a very very simple report yet I can't get the report
> to do what I need.
> Any help would be appreciated, Thanx.
Have you tried adding the header and footer information in the
grouping rows (top and bottom rows of the table control (if you're
using any))?
Enrique Martinez
Sr. Software Consultant

Report runs in the frontend but not in designer!!??

The report gives me a blank screen when I refresh the data under the design mode, but when I run it with my access tool, the data comes out fine.
The report is running on a complex query in an access database.Open the report and do verify database

Report Recovery Help ASAP!

Report A has been deployed and works fine and ties out in production. The
design copy of this report in VS has been corrupted. All other backups of
this report have been corrupted. How do I get the rdl. for Report A fixed?In report manager click on the report, then properties tab. Click on Edit
link. Give it a directory on your local PC. Different than where you project
is. Then in your project add an exisiting item to the project. It will copy
it over to the directory with all your other rdl files.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"OriginalStealth" <OriginalStealth@.discussions.microsoft.com> wrote in
message news:DFA101E4-26E6-4D14-BD30-05ECE46A2DF1@.microsoft.com...
> Report A has been deployed and works fine and ties out in production. The
> design copy of this report in VS has been corrupted. All other backups of
> this report have been corrupted. How do I get the rdl. for Report A
> fixed?