Report Organization

I am taking over a RS solution from an ex employee and looking for some
report organization help.
I see you can have a shared datasource with RS.
In the solution there are about 20 projects. Each project contains reports
that are displayed in a folder seen off Report Manager. Is this the proper
way to organize reports -- through projects? Is there a way to have
IIS/Report Manager folder structure to appear in the solution explorer?
Or do you have to create the structure manually? Any help would be
appreciated.
Thanks.Yes very much the right way for you to maintain is using "Projects", moreover
I suggest you can add one more thing as well. i.e. Source control like VSS
integration so that all your reports are very well managed. Regarding your
2nd question it is a "No".
Amarnath
"Brian Shannon" wrote:
> I am taking over a RS solution from an ex employee and looking for some
> report organization help.
> I see you can have a shared datasource with RS.
> In the solution there are about 20 projects. Each project contains reports
> that are displayed in a folder seen off Report Manager. Is this the proper
> way to organize reports -- through projects? Is there a way to have
> IIS/Report Manager folder structure to appear in the solution explorer?
> Or do you have to create the structure manually? Any help would be
> appreciated.
> Thanks.
>
>

Report not rendering properly when passing prms in url

This has probably been answered before, but i cannot find the
solution.. I need to pass prms to a packlist report to pull the correct
packlist once a user is finished with a shipment in our logistics
software. Whenever i pass in the prms the report comes up, but there
are no graphics. I am also using neodynamics barcoding software and
those do not appear either.
Here is the url w/prms i am using :
http://sts-sqlsrv/ReportServer?/SCOUT+Reports/LOGISTICS/rptPacklist2&rc:Command=Render&rc:Format=HTML4.0&rc:Toolbar=True&PacklistId=060421001
Any ideas?
Thanks
JayDialDid you Deploy your graphics to the server as well?
Richard.
"JayDial" <JayDial@.gmail.com> wrote in message
news:1145889309.197930.223470@.e56g2000cwe.googlegroups.com...
> This has probably been answered before, but i cannot find the
> solution.. I need to pass prms to a packlist report to pull the correct
> packlist once a user is finished with a shipment in our logistics
> software. Whenever i pass in the prms the report comes up, but there
> are no graphics. I am also using neodynamics barcoding software and
> those do not appear either.
> Here is the url w/prms i am using :
> http://sts-sqlsrv/ReportServer?/SCOUT+Reports/LOGISTICS/rptPacklist2&rc:Command=Render&rc:Format=HTML4.0&rc:Toolbar=True&PacklistId=060421001
> Any ideas?
> Thanks
> JayDial
>|||The graphics display fine if i browse to the actual report, but not if
i provide the prms in the url.|||Next question is: does the report return a result set with the parms you've
specified? I'm thinking that if no rows are returned then your graphics may
not show up either. Does this work when you preview the report using those
parms?
Richard.
"JayDial" <JayDial@.gmail.com> wrote in message
news:1145892373.787538.120860@.y43g2000cwc.googlegroups.com...
> The graphics display fine if i browse to the actual report, but not if
> i provide the prms in the url.
>|||Hrmm, that is the strangest thing. Today i was getting a couple screen
shots for you, but now the graphics are showing up. I thought maybe it
was a problem with the original url I was using, but when i copy and
paste from the original post everything is to be expected! Thanks for
your help!
-JayDial

Report Model and Stored Procedures

Hi Guys,
I have been searching all the newsgroups, MSDN forums and every
possible place to find a solution for this problem.
I want to use the stored procedures in the database to create my
Report Model (Ad-Hoc model) for Report Builder. I am talking about
Report Builder and NOT "Report Designer", I very well know how to
grab stored procs inside Report Designer to build a report.
One MSDN forum post suggests using the OPENROWSET command to grab the
stored procs but I dont know where to do this inside BIDS when I am in
the "Report Model" project.
Did anyone try this before.
We have a week left before we go to the implementation phase, so we
are kinda desperate to get this solution.You can use openrowset in "Named Query" click on the empty space on the DSV
and select new named query which is some what your query builder there you
can give a select with openrowset.
Amarnath, MCTS
"sqlhiker" wrote:
> Hi Guys,
> I have been searching all the newsgroups, MSDN forums and every
> possible place to find a solution for this problem.
> I want to use the stored procedures in the database to create my
> Report Model (Ad-Hoc model) for Report Builder. I am talking about
> Report Builder and NOT "Report Designer", I very well know how to
> grab stored procs inside Report Designer to build a report.
> One MSDN forum post suggests using the OPENROWSET command to grab the
> stored procs but I dont know where to do this inside BIDS when I am in
> the "Report Model" project.
> Did anyone try this before.
> We have a week left before we go to the implementation phase, so we
> are kinda desperate to get this solution.
>