Problem removing group header

Using SS2000, RS2000, VS2003
I have a report that displays group totals and grand totals but no detail
lines. There is nothing in the group header. I made the height of the group
header as small as possible but there is still too much room between the rows
when the report is run.
I tried removing the group header and that works as far as the space between
rows. However, after removing the group header and running the report, I
noticed that nothing in the report footer was showing up.
Any ideas? Thanks,
--
Dan D.Have you tried setting Group Header's visibility to False?
"Dan D." wrote:
> Using SS2000, RS2000, VS2003
> I have a report that displays group totals and grand totals but no detail
> lines. There is nothing in the group header. I made the height of the group
> header as small as possible but there is still too much room between the rows
> when the report is run.
> I tried removing the group header and that works as far as the space between
> rows. However, after removing the group header and running the report, I
> noticed that nothing in the report footer was showing up.
> Any ideas? Thanks,
> --
> Dan D.|||I tried that and it made the group footer data disappear. Apparently, the
visibility is for the group as a whole and there is no way to make just the
header hidden.
Thanks,
--
Dan D.
"isaak" wrote:
> Have you tried setting Group Header's visibility to False?
> "Dan D." wrote:
> > Using SS2000, RS2000, VS2003
> > I have a report that displays group totals and grand totals but no detail
> > lines. There is nothing in the group header. I made the height of the group
> > header as small as possible but there is still too much room between the rows
> > when the report is run.
> >
> > I tried removing the group header and that works as far as the space between
> > rows. However, after removing the group header and running the report, I
> > noticed that nothing in the report footer was showing up.
> >
> > Any ideas? Thanks,
> > --
> > Dan D.|||Of course you can do this but not from the Edit Group >> Visibility tab. As
you discovered, changing the visibility here affects the whole group.
Make sure the properties window is visible in report designer (menu: View >>
Properties Window) and then select the group header row you want to hide. Now
find the Visibility property in the properties window, expand it and set
Hidden = True.
"Dan D." wrote:
> I tried that and it made the group footer data disappear. Apparently, the
> visibility is for the group as a whole and there is no way to make just the
> header hidden.
> Thanks,
> --
> Dan D.
>
> "isaak" wrote:
> > Have you tried setting Group Header's visibility to False?
> >
> > "Dan D." wrote:
> >
> > > Using SS2000, RS2000, VS2003
> > > I have a report that displays group totals and grand totals but no detail
> > > lines. There is nothing in the group header. I made the height of the group
> > > header as small as possible but there is still too much room between the rows
> > > when the report is run.
> > >
> > > I tried removing the group header and that works as far as the space between
> > > rows. However, after removing the group header and running the report, I
> > > noticed that nothing in the report footer was showing up.
> > >
> > > Any ideas? Thanks,
> > > --
> > > Dan D.|||That did it Jim. Thanks.
--
Dan D.
"Jim" wrote:
> Of course you can do this but not from the Edit Group >> Visibility tab. As
> you discovered, changing the visibility here affects the whole group.
> Make sure the properties window is visible in report designer (menu: View >>
> Properties Window) and then select the group header row you want to hide. Now
> find the Visibility property in the properties window, expand it and set
> Hidden = True.
> "Dan D." wrote:
> > I tried that and it made the group footer data disappear. Apparently, the
> > visibility is for the group as a whole and there is no way to make just the
> > header hidden.
> >
> > Thanks,
> > --
> > Dan D.
> >
> >
> > "isaak" wrote:
> >
> > > Have you tried setting Group Header's visibility to False?
> > >
> > > "Dan D." wrote:
> > >
> > > > Using SS2000, RS2000, VS2003
> > > > I have a report that displays group totals and grand totals but no detail
> > > > lines. There is nothing in the group header. I made the height of the group
> > > > header as small as possible but there is still too much room between the rows
> > > > when the report is run.
> > > >
> > > > I tried removing the group header and that works as far as the space between
> > > > rows. However, after removing the group header and running the report, I
> > > > noticed that nothing in the report footer was showing up.
> > > >
> > > > Any ideas? Thanks,
> > > > --
> > > > Dan D.|||Well, this is weird. I just noticed that when I change the visibility on the
group header to false, the report header and footer both disappear, like
they've also been changed to false. I don't see a visibility setting for the
report header and footer under properties, though. Do you have any idea what
happened? If I change the visibility of the group header back to true, the
report header and footer both appear again.
--
Dan D.
"Jim" wrote:
> Of course you can do this but not from the Edit Group >> Visibility tab. As
> you discovered, changing the visibility here affects the whole group.
> Make sure the properties window is visible in report designer (menu: View >>
> Properties Window) and then select the group header row you want to hide. Now
> find the Visibility property in the properties window, expand it and set
> Hidden = True.
> "Dan D." wrote:
> > I tried that and it made the group footer data disappear. Apparently, the
> > visibility is for the group as a whole and there is no way to make just the
> > header hidden.
> >
> > Thanks,
> > --
> > Dan D.
> >
> >
> > "isaak" wrote:
> >
> > > Have you tried setting Group Header's visibility to False?
> > >
> > > "Dan D." wrote:
> > >
> > > > Using SS2000, RS2000, VS2003
> > > > I have a report that displays group totals and grand totals but no detail
> > > > lines. There is nothing in the group header. I made the height of the group
> > > > header as small as possible but there is still too much room between the rows
> > > > when the report is run.
> > > >
> > > > I tried removing the group header and that works as far as the space between
> > > > rows. However, after removing the group header and running the report, I
> > > > noticed that nothing in the report footer was showing up.
> > > >
> > > > Any ideas? Thanks,
> > > > --
> > > > Dan D.sql

problem opening data connection

Using SS2000, RS2000, VS2003. I'm trying to make changes to some reports that
someone else created. I'm not very familiar with either RS or VS. When I go
into VS and load the solution (someone told me how to find the correct one)
and then in the solution explorer, I double click on the report that I want
to change. Then I click on the "Data" tab and I get this error:
"A connection cannot be made to the database. Set and test the connection
string. SQL Server does not exist or access denied." I double clicked on the
rds file under "Shared Data Sources" and looked on the General tab. This is
the connection string "data source=localhost;initial catalog=SMCLMS_Dev. I
think the contractor developed on his local machine and then deployed to the
development server. I don't have RS on my machine. Will it hurt anything if
I change the connection string to point to the development server?
Thanks,
--
Dan D.No problem check all the parameters and most importantly select the server
and database and user / password. it should work..
Amarnath
"Dan D." wrote:
> Using SS2000, RS2000, VS2003. I'm trying to make changes to some reports that
> someone else created. I'm not very familiar with either RS or VS. When I go
> into VS and load the solution (someone told me how to find the correct one)
> and then in the solution explorer, I double click on the report that I want
> to change. Then I click on the "Data" tab and I get this error:
> "A connection cannot be made to the database. Set and test the connection
> string. SQL Server does not exist or access denied." I double clicked on the
> rds file under "Shared Data Sources" and looked on the General tab. This is
> the connection string "data source=localhost;initial catalog=SMCLMS_Dev. I
> think the contractor developed on his local machine and then deployed to the
> development server. I don't have RS on my machine. Will it hurt anything if
> I change the connection string to point to the development server?
> Thanks,
>
> --
> Dan D.|||Thanks.
If I create a new data source and a new report in the same solution, how do
I deploy it? If I don't use VS2003 to deploy do I take both the rds and rdl
files and upload them to the reports folder? Or is the rds file incorporated
in the rdl file and I just have to upload the rdl file?
Thanks,
--
Dan D.
"Amarnath" wrote:
> No problem check all the parameters and most importantly select the server
> and database and user / password. it should work..
> Amarnath
>
> "Dan D." wrote:
> > Using SS2000, RS2000, VS2003. I'm trying to make changes to some reports that
> > someone else created. I'm not very familiar with either RS or VS. When I go
> > into VS and load the solution (someone told me how to find the correct one)
> > and then in the solution explorer, I double click on the report that I want
> > to change. Then I click on the "Data" tab and I get this error:
> > "A connection cannot be made to the database. Set and test the connection
> > string. SQL Server does not exist or access denied." I double clicked on the
> > rds file under "Shared Data Sources" and looked on the General tab. This is
> > the connection string "data source=localhost;initial catalog=SMCLMS_Dev. I
> > think the contractor developed on his local machine and then deployed to the
> > development server. I don't have RS on my machine. Will it hurt anything if
> > I change the connection string to point to the development server?
> >
> > Thanks,
> >
> >
> > --
> > Dan D.|||If you deploy the rdl from VS2003 it will automatically deploy the rds, if it
hasn't been deployed before. The default is not to allow deployed rds to be
overwritten.
You can also deploy both the rds and rdl by uploading from the Report Manager.
HTH,
magendo_man
"Dan D." wrote:
> Thanks.
> If I create a new data source and a new report in the same solution, how do
> I deploy it? If I don't use VS2003 to deploy do I take both the rds and rdl
> files and upload them to the reports folder? Or is the rds file incorporated
> in the rdl file and I just have to upload the rdl file?
> Thanks,
> --
> Dan D.
>
> "Amarnath" wrote:
> > No problem check all the parameters and most importantly select the server
> > and database and user / password. it should work..
> >
> > Amarnath
> >
> >
> > "Dan D." wrote:
> >
> > > Using SS2000, RS2000, VS2003. I'm trying to make changes to some reports that
> > > someone else created. I'm not very familiar with either RS or VS. When I go
> > > into VS and load the solution (someone told me how to find the correct one)
> > > and then in the solution explorer, I double click on the report that I want
> > > to change. Then I click on the "Data" tab and I get this error:
> > > "A connection cannot be made to the database. Set and test the connection
> > > string. SQL Server does not exist or access denied." I double clicked on the
> > > rds file under "Shared Data Sources" and looked on the General tab. This is
> > > the connection string "data source=localhost;initial catalog=SMCLMS_Dev. I
> > > think the contractor developed on his local machine and then deployed to the
> > > development server. I don't have RS on my machine. Will it hurt anything if
> > > I change the connection string to point to the development server?
> > >
> > > Thanks,
> > >
> > >
> > > --
> > > Dan D.|||If you have VS 2003 that's well and good since it does everything for you,
when you just click "deploy". When you deploy all the details are stored in
tables in an encrypted form so just copying is not the solution.. Other way
is through scripts. using RS.exe
Let me know if you require it or just go to sample.RSS at
\Samples\Reporting Services\Script Samples and select publishsample report.
Just see how to publish a report and you can change accordingly.
Amarnath
"Dan D." wrote:
> Thanks.
> If I create a new data source and a new report in the same solution, how do
> I deploy it? If I don't use VS2003 to deploy do I take both the rds and rdl
> files and upload them to the reports folder? Or is the rds file incorporated
> in the rdl file and I just have to upload the rdl file?
> Thanks,
> --
> Dan D.
>
> "Amarnath" wrote:
> > No problem check all the parameters and most importantly select the server
> > and database and user / password. it should work..
> >
> > Amarnath
> >
> >
> > "Dan D." wrote:
> >
> > > Using SS2000, RS2000, VS2003. I'm trying to make changes to some reports that
> > > someone else created. I'm not very familiar with either RS or VS. When I go
> > > into VS and load the solution (someone told me how to find the correct one)
> > > and then in the solution explorer, I double click on the report that I want
> > > to change. Then I click on the "Data" tab and I get this error:
> > > "A connection cannot be made to the database. Set and test the connection
> > > string. SQL Server does not exist or access denied." I double clicked on the
> > > rds file under "Shared Data Sources" and looked on the General tab. This is
> > > the connection string "data source=localhost;initial catalog=SMCLMS_Dev. I
> > > think the contractor developed on his local machine and then deployed to the
> > > development server. I don't have RS on my machine. Will it hurt anything if
> > > I change the connection string to point to the development server?
> > >
> > > Thanks,
> > >
> > >
> > > --
> > > Dan D.|||Thanks.
--
Dan D.
"magendo_man" wrote:
> If you deploy the rdl from VS2003 it will automatically deploy the rds, if it
> hasn't been deployed before. The default is not to allow deployed rds to be
> overwritten.
> You can also deploy both the rds and rdl by uploading from the Report Manager.
> HTH,
> magendo_man
> "Dan D." wrote:
> > Thanks.
> >
> > If I create a new data source and a new report in the same solution, how do
> > I deploy it? If I don't use VS2003 to deploy do I take both the rds and rdl
> > files and upload them to the reports folder? Or is the rds file incorporated
> > in the rdl file and I just have to upload the rdl file?
> >
> > Thanks,
> > --
> > Dan D.
> >
> >
> > "Amarnath" wrote:
> >
> > > No problem check all the parameters and most importantly select the server
> > > and database and user / password. it should work..
> > >
> > > Amarnath
> > >
> > >
> > > "Dan D." wrote:
> > >
> > > > Using SS2000, RS2000, VS2003. I'm trying to make changes to some reports that
> > > > someone else created. I'm not very familiar with either RS or VS. When I go
> > > > into VS and load the solution (someone told me how to find the correct one)
> > > > and then in the solution explorer, I double click on the report that I want
> > > > to change. Then I click on the "Data" tab and I get this error:
> > > > "A connection cannot be made to the database. Set and test the connection
> > > > string. SQL Server does not exist or access denied." I double clicked on the
> > > > rds file under "Shared Data Sources" and looked on the General tab. This is
> > > > the connection string "data source=localhost;initial catalog=SMCLMS_Dev. I
> > > > think the contractor developed on his local machine and then deployed to the
> > > > development server. I don't have RS on my machine. Will it hurt anything if
> > > > I change the connection string to point to the development server?
> > > >
> > > > Thanks,
> > > >
> > > >
> > > > --
> > > > Dan D.|||I was able to make a change to the report and deploy it using the browser. I
didn't need to make a change to the rds file so I didn't need to redeploy it.
Thanks,
--
Dan D.
"Amarnath" wrote:
> If you have VS 2003 that's well and good since it does everything for you,
> when you just click "deploy". When you deploy all the details are stored in
> tables in an encrypted form so just copying is not the solution.. Other way
> is through scripts. using RS.exe
> Let me know if you require it or just go to sample.RSS at
> \Samples\Reporting Services\Script Samples and select publishsample report.
> Just see how to publish a report and you can change accordingly.
> Amarnath
>
> "Dan D." wrote:
> > Thanks.
> >
> > If I create a new data source and a new report in the same solution, how do
> > I deploy it? If I don't use VS2003 to deploy do I take both the rds and rdl
> > files and upload them to the reports folder? Or is the rds file incorporated
> > in the rdl file and I just have to upload the rdl file?
> >
> > Thanks,
> > --
> > Dan D.
> >
> >
> > "Amarnath" wrote:
> >
> > > No problem check all the parameters and most importantly select the server
> > > and database and user / password. it should work..
> > >
> > > Amarnath
> > >
> > >
> > > "Dan D." wrote:
> > >
> > > > Using SS2000, RS2000, VS2003. I'm trying to make changes to some reports that
> > > > someone else created. I'm not very familiar with either RS or VS. When I go
> > > > into VS and load the solution (someone told me how to find the correct one)
> > > > and then in the solution explorer, I double click on the report that I want
> > > > to change. Then I click on the "Data" tab and I get this error:
> > > > "A connection cannot be made to the database. Set and test the connection
> > > > string. SQL Server does not exist or access denied." I double clicked on the
> > > > rds file under "Shared Data Sources" and looked on the General tab. This is
> > > > the connection string "data source=localhost;initial catalog=SMCLMS_Dev. I
> > > > think the contractor developed on his local machine and then deployed to the
> > > > development server. I don't have RS on my machine. Will it hurt anything if
> > > > I change the connection string to point to the development server?
> > > >
> > > > Thanks,
> > > >
> > > >
> > > > --
> > > > Dan D.sql