Report Services Examples.. please.. VS.NET

Hi..

Im newbie on Report Services with VS.NET... I made a cube on olap.. and
I try to lear some mdx for my reports..

But, in the report designer... I need a lot of help..

Please.. anybody.. can help me??

Thanks a lot...!

Karina Gamez

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!A good forum for RS is microsoft.public.sqlservr.reportingsvcs. There's
also a lot of stuff at the MSDN web site
http://msdn.microsoft.com/SQL/sqlwa...es/default.aspx

--
Hope this helps.

Dan Guzman
SQL Server MVP

"Karina Gamez" <akgamez@.merkafon.com> wrote in message
news:41832186$0$10069$c397aba@.news.newsgroups.ws.. .
> Hi..
> Im newbie on Report Services with VS.NET... I made a cube on olap.. and
> I try to lear some mdx for my reports..
> But, in the report designer... I need a lot of help..
> Please.. anybody.. can help me??
> Thanks a lot...!
>
> Karina Gamez
> *** Sent via Developersdex http://www.developersdex.com ***
> Don't just participate in USENET...get rewarded for it!

Report Server doesn't install

Hi!!
I'm trying to install SQL Report Services on my mahicne. I get the designer
installed, as well as other tools, but the Report Server doesn't get
installed, and I can't open or deploy any report. I have WXP Pro, S2K SP4, RS
Dev Edition SP1, and using my admin account.
The "ReportServer" or "Reports" virtual forlders on IIS doesn't exist after
installation, nor does the "ReportServer" folder under the SQL Server
harddisk folders.
Anyone has experimented the same problem? Any help is really appreciated!
Many thanks in advance!!!
MNBusually there is a log at
C:\Program Files\Microsoft SQL Server\80\RS Setup Bootstrap\Log
Do you have any error during installation? Did it say succesful? Is there
any thing failed in the log?
"MNB" <MNB@.discussions.microsoft.com> wrote in message
news:840955B5-53E2-434F-89E4-C50B7648FD2D@.microsoft.com...
> Hi!!
> I'm trying to install SQL Report Services on my mahicne. I get the
> designer
> installed, as well as other tools, but the Report Server doesn't get
> installed, and I can't open or deploy any report. I have WXP Pro, S2K SP4,
> RS
> Dev Edition SP1, and using my admin account.
> The "ReportServer" or "Reports" virtual forlders on IIS doesn't exist
> after
> installation, nor does the "ReportServer" folder under the SQL Server
> harddisk folders.
> Anyone has experimented the same problem? Any help is really appreciated!
> Many thanks in advance!!!
> MNB|||Nope! I don't get any error messages in installation. Also, the setup doens't
create ny ReportServer or ReportServerTempDB on my SQL Server. I'm using
mixed authentication on the SQL installation.
Don't know what else I can do! The LOG file doesn't show errors at first
glace.. but it's huge, I should give it a deeper look. Any help on where to
look?
Many thanks!
MNB
"ME" wrote:
> usually there is a log at
> C:\Program Files\Microsoft SQL Server\80\RS Setup Bootstrap\Log
> Do you have any error during installation? Did it say succesful? Is there
> any thing failed in the log?
>
> "MNB" <MNB@.discussions.microsoft.com> wrote in message
> news:840955B5-53E2-434F-89E4-C50B7648FD2D@.microsoft.com...
> > Hi!!
> >
> > I'm trying to install SQL Report Services on my mahicne. I get the
> > designer
> > installed, as well as other tools, but the Report Server doesn't get
> > installed, and I can't open or deploy any report. I have WXP Pro, S2K SP4,
> > RS
> > Dev Edition SP1, and using my admin account.
> >
> > The "ReportServer" or "Reports" virtual forlders on IIS doesn't exist
> > after
> > installation, nor does the "ReportServer" folder under the SQL Server
> > harddisk folders.
> >
> > Anyone has experimented the same problem? Any help is really appreciated!
> >
> > Many thanks in advance!!!
> > MNB
>
>|||look at the last lines in the log. It should say something
"MNB" <MNB@.discussions.microsoft.com> wrote in message
news:CAE1A0A9-A136-4E33-A586-52B6CA30D518@.microsoft.com...
> Nope! I don't get any error messages in installation. Also, the setup
> doens't
> create ny ReportServer or ReportServerTempDB on my SQL Server. I'm using
> mixed authentication on the SQL installation.
> Don't know what else I can do! The LOG file doesn't show errors at first
> glace.. but it's huge, I should give it a deeper look. Any help on where
> to
> look?
> Many thanks!
> MNB
>
> "ME" wrote:
>> usually there is a log at
>> C:\Program Files\Microsoft SQL Server\80\RS Setup Bootstrap\Log
>> Do you have any error during installation? Did it say succesful? Is
>> there
>> any thing failed in the log?
>>
>> "MNB" <MNB@.discussions.microsoft.com> wrote in message
>> news:840955B5-53E2-434F-89E4-C50B7648FD2D@.microsoft.com...
>> > Hi!!
>> >
>> > I'm trying to install SQL Report Services on my mahicne. I get the
>> > designer
>> > installed, as well as other tools, but the Report Server doesn't get
>> > installed, and I can't open or deploy any report. I have WXP Pro, S2K
>> > SP4,
>> > RS
>> > Dev Edition SP1, and using my admin account.
>> >
>> > The "ReportServer" or "Reports" virtual forlders on IIS doesn't exist
>> > after
>> > installation, nor does the "ReportServer" folder under the SQL Server
>> > harddisk folders.
>> >
>> > Anyone has experimented the same problem? Any help is really
>> > appreciated!
>> >
>> > Many thanks in advance!!!
>> > MNB
>>|||Does the name of your server have an underscore in it? Or any other special
character. Some people have had trouble due to the name of their server.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"MNB" <MNB@.discussions.microsoft.com> wrote in message
news:CAE1A0A9-A136-4E33-A586-52B6CA30D518@.microsoft.com...
> Nope! I don't get any error messages in installation. Also, the setup
doens't
> create ny ReportServer or ReportServerTempDB on my SQL Server. I'm using
> mixed authentication on the SQL installation.
> Don't know what else I can do! The LOG file doesn't show errors at first
> glace.. but it's huge, I should give it a deeper look. Any help on where
to
> look?
> Many thanks!
> MNB
>
> "ME" wrote:
> > usually there is a log at
> > C:\Program Files\Microsoft SQL Server\80\RS Setup Bootstrap\Log
> >
> > Do you have any error during installation? Did it say succesful? Is
there
> > any thing failed in the log?
> >
> >
> > "MNB" <MNB@.discussions.microsoft.com> wrote in message
> > news:840955B5-53E2-434F-89E4-C50B7648FD2D@.microsoft.com...
> > > Hi!!
> > >
> > > I'm trying to install SQL Report Services on my mahicne. I get the
> > > designer
> > > installed, as well as other tools, but the Report Server doesn't get
> > > installed, and I can't open or deploy any report. I have WXP Pro, S2K
SP4,
> > > RS
> > > Dev Edition SP1, and using my admin account.
> > >
> > > The "ReportServer" or "Reports" virtual forlders on IIS doesn't exist
> > > after
> > > installation, nor does the "ReportServer" folder under the SQL Server
> > > harddisk folders.
> > >
> > > Anyone has experimented the same problem? Any help is really
appreciated!
> > >
> > > Many thanks in advance!!!
> > > MNB
> >
> >
> >

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 requesting 8.5 x 14 paper

Hello,
I have created a report in Reporting Services 2.0 using Visual Studio 2005
Report Designer. The report is defined as 8.5w x 11h.
For some reason when I preview the report using the Report Viewer and choose
to print the report, the printer is requesting 8.5w x 14h paper. I don't see
anything in the design that seems to call for that.
How can I debug this and get this to print properly? I would be more than
happy to provide the XML code that is generated by the designer.I would say that it is getting the 8.5 x 14 settings from your printer.
Check what the default paper is for your printer.
Craig
"WebPhenom" <WebPhenom@.discussions.microsoft.com> wrote in message
news:4CF88391-BB3E-45F9-ADF4-5D7B3F8AF35E@.microsoft.com...
> Hello,
> I have created a report in Reporting Services 2.0 using Visual Studio 2005
> Report Designer. The report is defined as 8.5w x 11h.
> For some reason when I preview the report using the Report Viewer and
> choose
> to print the report, the printer is requesting 8.5w x 14h paper. I don't
> see
> anything in the design that seems to call for that.
> How can I debug this and get this to print properly? I would be more than
> happy to provide the XML code that is generated by the designer.|||Actually, this occurs with every printer I print to so I don't think it is
from the default settings on the printer.
Is there something else that I could be checking?
I am going to try to recreate the report from scratch to see if that will
help. I hate to do that but I am at my wits end. In the mean time, if there
is something else I could be checking, please let me know.
"Craig" wrote:
> I would say that it is getting the 8.5 x 14 settings from your printer.
> Check what the default paper is for your printer.
> Craig
> "WebPhenom" <WebPhenom@.discussions.microsoft.com> wrote in message
> news:4CF88391-BB3E-45F9-ADF4-5D7B3F8AF35E@.microsoft.com...
> > Hello,
> >
> > I have created a report in Reporting Services 2.0 using Visual Studio 2005
> > Report Designer. The report is defined as 8.5w x 11h.
> >
> > For some reason when I preview the report using the Report Viewer and
> > choose
> > to print the report, the printer is requesting 8.5w x 14h paper. I don't
> > see
> > anything in the design that seems to call for that.
> >
> > How can I debug this and get this to print properly? I would be more than
> > happy to provide the XML code that is generated by the designer.
>
>|||Have you got the 8in x 14in setting on any printer?
"WebPhenom" <WebPhenom@.discussions.microsoft.com> wrote in message
news:FF84DD5D-523C-4B83-8F5B-2CA1106CE8D6@.microsoft.com...
> Actually, this occurs with every printer I print to so I don't think it is
> from the default settings on the printer.
> Is there something else that I could be checking?
> I am going to try to recreate the report from scratch to see if that will
> help. I hate to do that but I am at my wits end. In the mean time, if
> there
> is something else I could be checking, please let me know.
> "Craig" wrote:
>> I would say that it is getting the 8.5 x 14 settings from your printer.
>> Check what the default paper is for your printer.
>> Craig
>> "WebPhenom" <WebPhenom@.discussions.microsoft.com> wrote in message
>> news:4CF88391-BB3E-45F9-ADF4-5D7B3F8AF35E@.microsoft.com...
>> > Hello,
>> >
>> > I have created a report in Reporting Services 2.0 using Visual Studio
>> > 2005
>> > Report Designer. The report is defined as 8.5w x 11h.
>> >
>> > For some reason when I preview the report using the Report Viewer and
>> > choose
>> > to print the report, the printer is requesting 8.5w x 14h paper. I
>> > don't
>> > see
>> > anything in the design that seems to call for that.
>> >
>> > How can I debug this and get this to print properly? I would be more
>> > than
>> > happy to provide the XML code that is generated by the designer.
>>|||We have the same problem.
The report is set to use letter but it defaults to A4 for any printer
the user chooses. The default settings on the printers are also set to
letter. We tried this with different reports and we get the same
result. Running the same report from other clients the default page
size is letter.
>From this we can tell it is not the report and not the printer driver.
It seems like the Active-X control is the problem as it is getting it's
default setting from somewhere on this particular userss computer.|||Sadly, I had to recreate the report from scratch. Doing that solved the
problem but there must have been SOMETHING in the RDL to tell the printer it
needed/wanted Legal paper.
I wish I had an answer for you for your A4 problem.
"grandersg@.gmail.com" wrote:
> We have the same problem.
> The report is set to use letter but it defaults to A4 for any printer
> the user chooses. The default settings on the printers are also set to
> letter. We tried this with different reports and we get the same
> result. Running the same report from other clients the default page
> size is letter.
> >From this we can tell it is not the report and not the printer driver.
> It seems like the Active-X control is the problem as it is getting it's
> default setting from somewhere on this particular userss computer.
>|||I have the same problem and have checked every setting as well. I'd rather
not recreate my reports, so if anyone has another idea, I'd appreciate it!
"WebPhenom" wrote:
> Sadly, I had to recreate the report from scratch. Doing that solved the
> problem but there must have been SOMETHING in the RDL to tell the printer it
> needed/wanted Legal paper.
> I wish I had an answer for you for your A4 problem.
> "grandersg@.gmail.com" wrote:
> >
> > We have the same problem.
> >
> > The report is set to use letter but it defaults to A4 for any printer
> > the user chooses. The default settings on the printers are also set to
> > letter. We tried this with different reports and we get the same
> > result. Running the same report from other clients the default page
> > size is letter.
> >
> > >From this we can tell it is not the report and not the printer driver.
> > It seems like the Active-X control is the problem as it is getting it's
> > default setting from somewhere on this particular userss computer.
> >
> >