Report/subreport help?

How would you run one report that is made out of two reports at the same time to get them dispayed on seperate pages as well.

Would you create a subreport or something else, and how many subreports can you have within a report, and if you had more then one where is the best places to insert it in the report and would you know where can I find some info about that.

I hope all of this makes sense,because I am just completely stuck.

Regards"How would you run one report that is made out of two reports at the same time to get them dispayed on seperate pages as well... and if you had more then one where is the best places to insert it in the report"

- I would create 2 subreports. The best place to put them (I think) would be the details section. Make a Details a and a Details b and set the NewPageAfter for Details a.

"how many subreports can you have within a report"

- I'm not sure what the limit is. I have a report that has 3 subreports without a problem.

"where can I find some info about that."

- Not sure about any specific websites, but you can try a search in following links:

Crystal Reports Help:
http://support.businessobjects.com/search/advsearch.asp

Crystal Reports Forum:
http://support.businessobjects.com/forums/default.asp|||thanks a lot for your help, I got some good suggestions, I just have to make it work now.

Regards

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 more than one group does not drill down correctly in E

Hello Everyone,
I actually have 6 questions:
1. Why is it that when i create more than one line in the footer of a group
that the report then does not render drill down correctly? I have heard that
this is a bug. Is this true?
2. Why is it that when i create a report with more than 2 groups that drill
down does not work properly?
3. I have a report that has 2 groupings with 1 line in each groups header
and footer section. The drill down works fine in HTML mode but the footer
section of the 2nd internal group does not show on my exported Excel version.
4. In the new version of RS (2005) will i be able to create a report and
have it render on a server with RS 2000 installed?
5. Will RS 2005 integrate into Visual Studio 2005.
6. Will RS 2005 be ready by early November 2005 like everyone says?
To me 1, 2, and 3 above are show stoppers for me using RS in a production
environment...
Thanks for any answers that anyone might give.
CoreyI don't know about 1,2,3. I suggest trying it out in 2005 and see if it
still happens.
RS 2005 reports require RS 2005. A 2005 report can not be used with 2000.
However, you can use a 2000 SQL database as the object/metadata store.
RS 2005 comes with a version of VS 2005 to develop reports (do not requre
purchasing VS). If you have VS 2005 it will integrate with it. The new
controls come with VS 2005.
My confidence level is high that it will be released by early November.
Whether you can get it or not depends on how you plan on getting the
product. If you have MSDN and can download it then yes. If you need shrink
wrap then it will be longer. Early November is what is called RTM (Released
to Manufacturing). To make it available for MSDN download takes very little
extra time, to have shrink wrap available takes longer.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"CoreyMas" <CoreyMas@.discussions.microsoft.com> wrote in message
news:8F4B9BB7-6592-4321-9E0F-CC47E21E9BE2@.microsoft.com...
> Hello Everyone,
> I actually have 6 questions:
> 1. Why is it that when i create more than one line in the footer of a
> group
> that the report then does not render drill down correctly? I have heard
> that
> this is a bug. Is this true?
> 2. Why is it that when i create a report with more than 2 groups that
> drill
> down does not work properly?
> 3. I have a report that has 2 groupings with 1 line in each groups header
> and footer section. The drill down works fine in HTML mode but the footer
> section of the 2nd internal group does not show on my exported Excel
> version.
> 4. In the new version of RS (2005) will i be able to create a report and
> have it render on a server with RS 2000 installed?
> 5. Will RS 2005 integrate into Visual Studio 2005.
> 6. Will RS 2005 be ready by early November 2005 like everyone says?
> To me 1, 2, and 3 above are show stoppers for me using RS in a production
> environment...
> Thanks for any answers that anyone might give.
> Corey|||Thanks Bruce,
Can you tell me if there was a Release Candidate version of RS 2005 that can
be downloaded?
Also i do have access to an MSDN subscription (i work for an online college)
so i will be checking RS 2005 out as soon as it is available.
Corey
"Bruce L-C [MVP]" wrote:
> I don't know about 1,2,3. I suggest trying it out in 2005 and see if it
> still happens.
> RS 2005 reports require RS 2005. A 2005 report can not be used with 2000.
> However, you can use a 2000 SQL database as the object/metadata store.
> RS 2005 comes with a version of VS 2005 to develop reports (do not requre
> purchasing VS). If you have VS 2005 it will integrate with it. The new
> controls come with VS 2005.
> My confidence level is high that it will be released by early November.
> Whether you can get it or not depends on how you plan on getting the
> product. If you have MSDN and can download it then yes. If you need shrink
> wrap then it will be longer. Early November is what is called RTM (Released
> to Manufacturing). To make it available for MSDN download takes very little
> extra time, to have shrink wrap available takes longer.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
> "CoreyMas" <CoreyMas@.discussions.microsoft.com> wrote in message
> news:8F4B9BB7-6592-4321-9E0F-CC47E21E9BE2@.microsoft.com...
> > Hello Everyone,
> >
> > I actually have 6 questions:
> >
> > 1. Why is it that when i create more than one line in the footer of a
> > group
> > that the report then does not render drill down correctly? I have heard
> > that
> > this is a bug. Is this true?
> >
> > 2. Why is it that when i create a report with more than 2 groups that
> > drill
> > down does not work properly?
> >
> > 3. I have a report that has 2 groupings with 1 line in each groups header
> > and footer section. The drill down works fine in HTML mode but the footer
> > section of the 2nd internal group does not show on my exported Excel
> > version.
> >
> > 4. In the new version of RS (2005) will i be able to create a report and
> > have it render on a server with RS 2000 installed?
> >
> > 5. Will RS 2005 integrate into Visual Studio 2005.
> >
> > 6. Will RS 2005 be ready by early November 2005 like everyone says?
> >
> > To me 1, 2, and 3 above are show stoppers for me using RS in a production
> > environment...
> >
> > Thanks for any answers that anyone might give.
> >
> > Corey
>
>|||The last downloadable is September CTP. There is not and there is no plan
for a release candidate to be out for general consumption (I won't be
getting a RC either).
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"CoreyMas" <CoreyMas@.discussions.microsoft.com> wrote in message
news:4FDFB8E6-19AC-455C-A82B-4473AB3B9080@.microsoft.com...
> Thanks Bruce,
> Can you tell me if there was a Release Candidate version of RS 2005 that
> can
> be downloaded?
> Also i do have access to an MSDN subscription (i work for an online
> college)
> so i will be checking RS 2005 out as soon as it is available.
> Corey
> "Bruce L-C [MVP]" wrote:
>> I don't know about 1,2,3. I suggest trying it out in 2005 and see if it
>> still happens.
>> RS 2005 reports require RS 2005. A 2005 report can not be used with 2000.
>> However, you can use a 2000 SQL database as the object/metadata store.
>> RS 2005 comes with a version of VS 2005 to develop reports (do not requre
>> purchasing VS). If you have VS 2005 it will integrate with it. The new
>> controls come with VS 2005.
>> My confidence level is high that it will be released by early November.
>> Whether you can get it or not depends on how you plan on getting the
>> product. If you have MSDN and can download it then yes. If you need
>> shrink
>> wrap then it will be longer. Early November is what is called RTM
>> (Released
>> to Manufacturing). To make it available for MSDN download takes very
>> little
>> extra time, to have shrink wrap available takes longer.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>>
>> "CoreyMas" <CoreyMas@.discussions.microsoft.com> wrote in message
>> news:8F4B9BB7-6592-4321-9E0F-CC47E21E9BE2@.microsoft.com...
>> > Hello Everyone,
>> >
>> > I actually have 6 questions:
>> >
>> > 1. Why is it that when i create more than one line in the footer of a
>> > group
>> > that the report then does not render drill down correctly? I have
>> > heard
>> > that
>> > this is a bug. Is this true?
>> >
>> > 2. Why is it that when i create a report with more than 2 groups that
>> > drill
>> > down does not work properly?
>> >
>> > 3. I have a report that has 2 groupings with 1 line in each groups
>> > header
>> > and footer section. The drill down works fine in HTML mode but the
>> > footer
>> > section of the 2nd internal group does not show on my exported Excel
>> > version.
>> >
>> > 4. In the new version of RS (2005) will i be able to create a report
>> > and
>> > have it render on a server with RS 2000 installed?
>> >
>> > 5. Will RS 2005 integrate into Visual Studio 2005.
>> >
>> > 6. Will RS 2005 be ready by early November 2005 like everyone says?
>> >
>> > To me 1, 2, and 3 above are show stoppers for me using RS in a
>> > production
>> > environment...
>> >
>> > Thanks for any answers that anyone might give.
>> >
>> > Corey
>>

Report with measures in row

Hi,
I would like to create a report on a cube with Report Server (Query Builder) with one dimension in columns and the "measures" dimension members in rows:

Jan Feb Mar ...
Measure1 10 12 14
Measure2 20 22 24
..

How to create with either Tabular or Matrix report type?

Thanks,
Marcus

You can either:

1. Use the RS 2005 SSAS provider but change the report format to request measures on columns.

2. Bypass the RS 2005 SSAS provider and use the MS OLE DB 9.0 Provider for Analysis Services to request the measures on rows and Time on columns. However, in this case you can't use the matrix region and your table columns will be fixed. So, you have to create 12 columns (assuming 12 months on columns) and hide the ones that are not returned.

|||Thank you very much Teo,
I had to chose alternative 2 and created a report with measures in rows and tabular structure. Now I got stuck in some details. I need cascading parameters following the whitepaper " Integrating Analysis Services with Reporting Services" for SQL 2000. But I'm working with SQL2005. I easily establish a parameter for the highest parameter level (here ProductCategory in Adventure Works)

="WITH MEMBER [Product].[Category].[Prod] AS
'[Product].[Category].[" + Parameters!ProductCategory.Value + "]'

SELECT

{ [Measures].[Internet Sales-Discount Amount],[Measures].[Internet Sales-Extended Amount] } ON ROWS ,

{[Date].[Calendar Time].[Month].[January 2003]} ON COLUMNS

FROM [Adventure Works UDM]
WHERE [Product].[Category].[Prod] "

but a link to this existing parameter in a cascading parameter yields an empty list and the report is not executable ([Product Categories] is a natural hierachy):

= "WITH MEMBER Measures.NullColumn AS 'Null'

SELECT
{Measures.NullColumn} ON COLUMNS,
{DESCENDANTS({" + Parameters!ProductCategory.Value + " },
[Product].[Product Categories].[Subcategory])} ON ROWS
FROM
[Adventure Works UDM]"

Are cascading parameters with OLE DB 9.0 and SQL 2005 possible, can you provide an example?

Thanks a lot,
Marcus

sql

Report with measures in row

Hi,
I would like to create a report on a cube with Report Server (Query Builder) with one dimension in columns and the "measures" dimension members in rows:

Jan Feb Mar ...
Measure1 10 12 14
Measure2 20 22 24
..

How to create with either Tabular or Matrix report type?

Thanks,
Marcus

You can either:

1. Use the RS 2005 SSAS provider but change the report format to request measures on columns.

2. Bypass the RS 2005 SSAS provider and use the MS OLE DB 9.0 Provider for Analysis Services to request the measures on rows and Time on columns. However, in this case you can't use the matrix region and your table columns will be fixed. So, you have to create 12 columns (assuming 12 months on columns) and hide the ones that are not returned.

|||Thank you very much Teo,
I had to chose alternative 2 and created a report with measures in rows and tabular structure. Now I got stuck in some details. I need cascading parameters following the whitepaper " Integrating Analysis Services with Reporting Services" for SQL 2000. But I'm working with SQL2005. I easily establish a parameter for the highest parameter level (here ProductCategory in Adventure Works)

="WITH MEMBER [Product].[Category].[Prod] AS
'[Product].[Category].[" + Parameters!ProductCategory.Value + "]'

SELECT

{ [Measures].[Internet Sales-Discount Amount],[Measures].[Internet Sales-Extended Amount] } ON ROWS ,

{[Date].[Calendar Time].[Month].[January 2003]} ON COLUMNS

FROM [Adventure Works UDM]
WHERE [Product].[Category].[Prod] "

but a link to this existing parameter in a cascading parameter yields an empty list and the report is not executable ([Product Categories] is a natural hierachy):

= "WITH MEMBER Measures.NullColumn AS 'Null'

SELECT
{Measures.NullColumn} ON COLUMNS,
{DESCENDANTS({" + Parameters!ProductCategory.Value + " },
[Product].[Product Categories].[Subcategory])} ON ROWS
FROM
[Adventure Works UDM]"

Are cascading parameters with OLE DB 9.0 and SQL 2005 possible, can you provide an example?

Thanks a lot,
Marcus

Report with a treeview

How can I create a report with a tree structure?
I want to show stores and sold items underneath.
ThanksHave a look at:
My problem is to choose indent in a nice way unless you use the
"padding"-property.
David
http://www.c-sharpcorner.com/UploadFile/asif.blog/RecursiveData06132006230750PM/RecursiveData.aspx?ArticleID=fdc78120-bf77-4fb2-9dc5-bb84d734c792
"Mark Goldin" <mgoldin@.ufandd.com> skrev i meddelandet
news:u1rLnh40GHA.4312@.TK2MSFTNGP02.phx.gbl...
> How can I create a report with a tree structure?
> I want to show stores and sold items underneath.
> Thanks
>

Report Viewer Sort and Drill Through

We have the ReportViewer placed inside a DotNetNuke framework which is
displaying the initial report fine. However if we create a sort link on any
table header name or create a link on some data returned for a drill though
the new report renders outside the Iframe, outside the framework, and renders
as if you had called a URL report.
Is there any solution for a link within the report viewer Iframe that will
render to the iframe?
Anything would help,
Thank you,I had the same problem as you, sort of.
The solution is to modify the ReportViewer control. In the Render method,
assign a name to your IFrame.
output.WriteAttribute("name", "reportFrame");
On the BuildUrlString() add the rc:LinkTarget device info to point to your
IFrame.
this._url = this._serverUrl + "?" + this._reportPath +
"&rs:Command=Render&rc:LinkTarget=reportFrame" +
this.EmumProperties(this._properties);
Hope this helps.
Marlon
"Dan Costello breadbelt.com" <Dan Costello
breadbelt.com@.discussions.microsoft.com> wrote in message
news:EAA4C2DE-FDF3-4D45-B044-37BC7FA2700A@.microsoft.com...
> We have the ReportViewer placed inside a DotNetNuke framework which is
> displaying the initial report fine. However if we create a sort link on
> any
> table header name or create a link on some data returned for a drill
> though
> the new report renders outside the Iframe, outside the framework, and
> renders
> as if you had called a URL report.
> Is there any solution for a link within the report viewer Iframe that will
> render to the iframe?
> Anything would help,
> Thank you,
>|||Thank you for the code this helps and gets me closer but still has a problem.
The drill through works fine and the FIRST time I sort a column works great.
However, the second sort in the same iframe seems to loose the iframe
identifier therefore rendering outside as if it was a URL rendered report as
before. Any suggestions?
Thank you again, we are a step closer!
"TechnoSpyke" wrote:
> I had the same problem as you, sort of.
> The solution is to modify the ReportViewer control. In the Render method,
> assign a name to your IFrame.
> output.WriteAttribute("name", "reportFrame");
> On the BuildUrlString() add the rc:LinkTarget device info to point to your
> IFrame.
> this._url = this._serverUrl + "?" + this._reportPath +
> "&rs:Command=Render&rc:LinkTarget=reportFrame" +
> this.EmumProperties(this._properties);
> Hope this helps.
> Marlon
> "Dan Costello breadbelt.com" <Dan Costello
> breadbelt.com@.discussions.microsoft.com> wrote in message
> news:EAA4C2DE-FDF3-4D45-B044-37BC7FA2700A@.microsoft.com...
> > We have the ReportViewer placed inside a DotNetNuke framework which is
> > displaying the initial report fine. However if we create a sort link on
> > any
> > table header name or create a link on some data returned for a drill
> > though
> > the new report renders outside the Iframe, outside the framework, and
> > renders
> > as if you had called a URL report.
> >
> > Is there any solution for a link within the report viewer Iframe that will
> > render to the iframe?
> >
> > Anything would help,
> >
> > Thank you,
> >
>
>|||I was testing on a report that had only one level of drill-through, so I
never had the problem before, as the new report would always show on the
dessignated IFrame.
However, on a new report, with multiple levels of drill-throughs, I am now
faced with the same problem as you. The first level would still show on the
IFrame, but the second would always show on _top.
I'm trying to fix this and will surely let you know if a solution comes up.
If you do find a solution, I would really appreciate if you could post it
too.
Thank you.
Marlon
"Dan Costello breadbelt.com" <Dan Costello
breadbelt.com@.discussions.microsoft.com> wrote in message
news:2D8961A7-2606-4341-A177-34249E1948D3@.microsoft.com...
> Thank you for the code this helps and gets me closer but still has a
> problem.
> The drill through works fine and the FIRST time I sort a column works
> great.
> However, the second sort in the same iframe seems to loose the iframe
> identifier therefore rendering outside as if it was a URL rendered report
> as
> before. Any suggestions?
> Thank you again, we are a step closer!
>
> "TechnoSpyke" wrote:
>> I had the same problem as you, sort of.
>> The solution is to modify the ReportViewer control. In the Render
>> method,
>> assign a name to your IFrame.
>> output.WriteAttribute("name", "reportFrame");
>> On the BuildUrlString() add the rc:LinkTarget device info to point to
>> your
>> IFrame.
>> this._url = this._serverUrl + "?" + this._reportPath +
>> "&rs:Command=Render&rc:LinkTarget=reportFrame" +
>> this.EmumProperties(this._properties);
>> Hope this helps.
>> Marlon
>> "Dan Costello breadbelt.com" <Dan Costello
>> breadbelt.com@.discussions.microsoft.com> wrote in message
>> news:EAA4C2DE-FDF3-4D45-B044-37BC7FA2700A@.microsoft.com...
>> > We have the ReportViewer placed inside a DotNetNuke framework which is
>> > displaying the initial report fine. However if we create a sort link
>> > on
>> > any
>> > table header name or create a link on some data returned for a drill
>> > though
>> > the new report renders outside the Iframe, outside the framework, and
>> > renders
>> > as if you had called a URL report.
>> >
>> > Is there any solution for a link within the report viewer Iframe that
>> > will
>> > render to the iframe?
>> >
>> > Anything would help,
>> >
>> > Thank you,
>> >
>>sql

Report Viewer authentication

Hello,

I am trying to create a simple ASP page to navigate in the reports stored in the report server. If I work in debug mode everything is fine. The page is working and If I call for a report I can see it perfectly. If I publish the report on my test machine (Windows XP Sp2 so IIS 5.1) I see that IE is connecting me with the ASP net user and not the correct one (myself) that is authorized to see the reports. Anybody knows how to solve it?

Thank you!

Andrea Pagliano

If you need the interactive user identity to be propagated to the Report Server, in your app web.config set <indentity impersonate="true"/>. This won't work if the Report Server is ona different machine though unless you enable Kerberos. There are other options as explained here.|||

Thank you very much! That did it!

Thanks again

Andrea Pagliano

Report to show current year revenue only if last year has no reven

I need to create a report that correctly displays ONLY accounts that have
revenue for the current year and no revenue at all for the previous year
(calendar year). The sql below does not do it.
SELECT DISTINCT a.ACCTNBR, a.ACCTNAME, SUM(f.REVENUE) AS REVENUE FROM
FORD.dbo.DATA f, FORD.dbo.ACCOUNT a, FORD.dbo.DATE d
WHERE (d.YEAR = '2005') AND (d.YEAR <> '2004')
GROUP BY a.ACCTNBR, a.ACCTNAME
Please Help
--
DCounttry something like:
SELECT a.ACCTNBR, a.ACCTNAME, SUM(f.REVENUE) AS REVENUE
FROM FORD.dbo.DATA f
join FORD.dbo.ACCOUNT a on whatever
join FORD.dbo.DATE d on whatever
left outer join (
SELECT a1.ACCTNBR
FROM FORD.dbo.DATA f1
join FORD.dbo.ACCOUNT a1 on whatever
join FORD.dbo.DATE d1 on whatever
WHERE (d1.YEAR = '2004')
GROUP BY a1.ACCTNBR, a1.ACCTNAME
having SUM(f1.REVENUE)>0) oj on a.ACCTNBR=oj.ACCTNBR --this is a
subquery that returns all the accounts you don't want
WHERE (d.YEAR = '2005')
and oj.ACCTNBR is null --this gets rid of the unwanted accounts
GROUP BY a.ACCTNBR, a.ACCTNAME
having SUM(f.REVENUE)>0
SELECT a.ACCTNBR, a.ACCTNAME, SUM(f.REVENUE) AS REVENUE
FROM FORD.dbo.DATA f
join FORD.dbo.ACCOUNT a on whatever
join FORD.dbo.DATE d on whatever
WHERE (d.YEAR = '2004')
GROUP BY a.ACCTNBR, a.ACCTNAME
having SUM(f.REVENUE)>0
--
Mary Bray [SQL Server MVP]
Please reply only to newsgroups
"DCount17" <DCount17@.discussions.microsoft.com> wrote in message
news:469690F5-456F-4B07-9610-29646B7A81A5@.microsoft.com...
>I need to create a report that correctly displays ONLY accounts that have
> revenue for the current year and no revenue at all for the previous year
> (calendar year). The sql below does not do it.
> SELECT DISTINCT a.ACCTNBR, a.ACCTNAME, SUM(f.REVENUE) AS REVENUE FROM
> FORD.dbo.DATA f, FORD.dbo.ACCOUNT a, FORD.dbo.DATE d
> WHERE (d.YEAR = '2005') AND (d.YEAR <> '2004')
> GROUP BY a.ACCTNBR, a.ACCTNAME
> Please Help
> --
> DCount|||Thanks for your help Mary. However, I'm not sure how to use the "oj"
statement you placed in the sql statement (see below). I thought you meant
outer join, but I get an error when doing that. I'm not good at complex
queries, so I really appreciate your help. Thanks again.
having SUM(f1.REVENUE)>0) oj on a.ACCTNBR=oj.ACCTNBR --this is a
subquery that returns all the accounts you don't want
WHERE (d.YEAR = '2005')
and oj.ACCTNBR is null --this gets rid of the unwanted accounts
GROUP BY a.ACCTNBR, a.ACCTNAME
having SUM(f.REVENUE)>0
"Mary Bray" wrote:
> try something like:
> SELECT a.ACCTNBR, a.ACCTNAME, SUM(f.REVENUE) AS REVENUE
> FROM FORD.dbo.DATA f
> join FORD.dbo.ACCOUNT a on whatever
> join FORD.dbo.DATE d on whatever
> left outer join (
> SELECT a1.ACCTNBR
> FROM FORD.dbo.DATA f1
> join FORD.dbo.ACCOUNT a1 on whatever
> join FORD.dbo.DATE d1 on whatever
> WHERE (d1.YEAR = '2004')
> GROUP BY a1.ACCTNBR, a1.ACCTNAME
> having SUM(f1.REVENUE)>0) oj on a.ACCTNBR=oj.ACCTNBR --this is a
> subquery that returns all the accounts you don't want
> WHERE (d.YEAR = '2005')
> and oj.ACCTNBR is null --this gets rid of the unwanted accounts
> GROUP BY a.ACCTNBR, a.ACCTNAME
> having SUM(f.REVENUE)>0
> SELECT a.ACCTNBR, a.ACCTNAME, SUM(f.REVENUE) AS REVENUE
> FROM FORD.dbo.DATA f
> join FORD.dbo.ACCOUNT a on whatever
> join FORD.dbo.DATE d on whatever
> WHERE (d.YEAR = '2004')
> GROUP BY a.ACCTNBR, a.ACCTNAME
> having SUM(f.REVENUE)>0
> --
> Mary Bray [SQL Server MVP]
> Please reply only to newsgroups
> "DCount17" <DCount17@.discussions.microsoft.com> wrote in message
> news:469690F5-456F-4B07-9610-29646B7A81A5@.microsoft.com...
> >I need to create a report that correctly displays ONLY accounts that have
> > revenue for the current year and no revenue at all for the previous year
> > (calendar year). The sql below does not do it.
> >
> > SELECT DISTINCT a.ACCTNBR, a.ACCTNAME, SUM(f.REVENUE) AS REVENUE FROM
> > FORD.dbo.DATA f, FORD.dbo.ACCOUNT a, FORD.dbo.DATE d
> > WHERE (d.YEAR = '2005') AND (d.YEAR <> '2004')
> > GROUP BY a.ACCTNBR, a.ACCTNAME
> >
> > Please Help
> > --
> > DCount
>
>

Report to look like a calendar

I have thought about this, and I cannot in my head come up with a way to create this. Maybe I am thinking about it too much, or maybe it is this difficult and I will need a 3rd party tool.

My users have requested a SQL Reporting Services report that looks like a calendar. Each page will be one month on the calendar. And then the data will fall on the calendar according to a date field in the database. It should not be all that difficult, but I cannot think of a way to acheive this.

Has anyone tried to build a report that is basically just a calendar, and each page is a month of the calendar? If so, did you build it using the standard SQL reporting services tools, or did you purchase a 3rd party vendor?

Let me know what route I should look to follow.

Thank you!

T.J.

I think you can do this in reporting service.

I havent done anythig like this but i just thought a way which i used in one of my report..

in matrix create row group

1) by year

2) by month

3) by week and keep 7 columns for each day of the week..

I will try to do this.. If i succeed i will sruely let you know.

|||

Thank you very much. If you are successful, let me know.

By "in matrix" I believe you are refering to a SQL Reporting Services "table" tool, and you will create a group by year, then a group by month, then a group by week, and the week group of the table will have 7 columns.

That sounds possible. Let me know if you are successful, and if so if you run into any unexpected errors.

Thank you for the idea!

T.J.

|||

I have been looking into this in my free time, and could not think of a way to correctly display the data on a SQL report so that it looks like a Calendar. I don't know if anyone else has had any luck with this or not.

I found a 3rd party tool named "Dundas" that appears to allow exactly what I need. Has anyone used Dundas, and if so, have you had any luck?

I also heard that Dundas as going to be included in SQL Reporting Services 2008 version. Can this be verified?

Let me know if you have used Dundas, and your thoughts on their product.

Thank you,

T.J.

|||

In terms of your initial question, I implemented something similar for someone who wanted charts layed out like a calendar. This can easily be adapted to what you want to do. Check out this thread http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=2050082&SiteID=1

Dundas is arguably the best RS charting tool out there. They have Chart, Gauge, Map and Calendar control for RS reports. The "out-of-the-box" RS charts are in fact developed by Dundas.

In terms of SQL RS 2008, you are correct. MIcrosoft have purchased the RS charting technology from Dundas and will include them out the box in 2008. There is currently still debate whether all the Dundas control will be available in the first release.

You can follow the discussions on this in the Katmai RS forum http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=1624&SiteID=1

sql

Report to look like a calendar

I have thought about this, and I cannot in my head come up with a way to create this. Maybe I am thinking about it too much, or maybe it is this difficult and I will need a 3rd party tool.

My users have requested a SQL Reporting Services report that looks like a calendar. Each page will be one month on the calendar. And then the data will fall on the calendar according to a date field in the database. It should not be all that difficult, but I cannot think of a way to acheive this.

Has anyone tried to build a report that is basically just a calendar, and each page is a month of the calendar? If so, did you build it using the standard SQL reporting services tools, or did you purchase a 3rd party vendor?

Let me know what route I should look to follow.

Thank you!

T.J.

I think you can do this in reporting service.

I havent done anythig like this but i just thought a way which i used in one of my report..

in matrix create row group

1) by year

2) by month

3) by week and keep 7 columns for each day of the week..

I will try to do this.. If i succeed i will sruely let you know.

|||

Thank you very much. If you are successful, let me know.

By "in matrix" I believe you are refering to a SQL Reporting Services "table" tool, and you will create a group by year, then a group by month, then a group by week, and the week group of the table will have 7 columns.

That sounds possible. Let me know if you are successful, and if so if you run into any unexpected errors.

Thank you for the idea!

T.J.

|||

I have been looking into this in my free time, and could not think of a way to correctly display the data on a SQL report so that it looks like a Calendar. I don't know if anyone else has had any luck with this or not.

I found a 3rd party tool named "Dundas" that appears to allow exactly what I need. Has anyone used Dundas, and if so, have you had any luck?

I also heard that Dundas as going to be included in SQL Reporting Services 2008 version. Can this be verified?

Let me know if you have used Dundas, and your thoughts on their product.

Thank you,

T.J.

|||

In terms of your initial question, I implemented something similar for someone who wanted charts layed out like a calendar. This can easily be adapted to what you want to do. Check out this thread http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=2050082&SiteID=1

Dundas is arguably the best RS charting tool out there. They have Chart, Gauge, Map and Calendar control for RS reports. The "out-of-the-box" RS charts are in fact developed by Dundas.

In terms of SQL RS 2008, you are correct. MIcrosoft have purchased the RS charting technology from Dundas and will include them out the box in 2008. There is currently still debate whether all the Dundas control will be available in the first release.

You can follow the discussions on this in the Katmai RS forum http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=1624&SiteID=1

Report to look like a calendar

I have thought about this, and I cannot in my head come up with a way to create this. Maybe I am thinking about it too much, or maybe it is this difficult and I will need a 3rd party tool.

My users have requested a SQL Reporting Services report that looks like a calendar. Each page will be one month on the calendar. And then the data will fall on the calendar according to a date field in the database. It should not be all that difficult, but I cannot think of a way to acheive this.

Has anyone tried to build a report that is basically just a calendar, and each page is a month of the calendar? If so, did you build it using the standard SQL reporting services tools, or did you purchase a 3rd party vendor?

Let me know what route I should look to follow.

Thank you!

T.J.

I think you can do this in reporting service.

I havent done anythig like this but i just thought a way which i used in one of my report..

in matrix create row group

1) by year

2) by month

3) by week and keep 7 columns for each day of the week..

I will try to do this.. If i succeed i will sruely let you know.

|||

Thank you very much. If you are successful, let me know.

By "in matrix" I believe you are refering to a SQL Reporting Services "table" tool, and you will create a group by year, then a group by month, then a group by week, and the week group of the table will have 7 columns.

That sounds possible. Let me know if you are successful, and if so if you run into any unexpected errors.

Thank you for the idea!

T.J.

|||

I have been looking into this in my free time, and could not think of a way to correctly display the data on a SQL report so that it looks like a Calendar. I don't know if anyone else has had any luck with this or not.

I found a 3rd party tool named "Dundas" that appears to allow exactly what I need. Has anyone used Dundas, and if so, have you had any luck?

I also heard that Dundas as going to be included in SQL Reporting Services 2008 version. Can this be verified?

Let me know if you have used Dundas, and your thoughts on their product.

Thank you,

T.J.

|||

In terms of your initial question, I implemented something similar for someone who wanted charts layed out like a calendar. This can easily be adapted to what you want to do. Check out this thread http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=2050082&SiteID=1

Dundas is arguably the best RS charting tool out there. They have Chart, Gauge, Map and Calendar control for RS reports. The "out-of-the-box" RS charts are in fact developed by Dundas.

In terms of SQL RS 2008, you are correct. MIcrosoft have purchased the RS charting technology from Dundas and will include them out the box in 2008. There is currently still debate whether all the Dundas control will be available in the first release.

You can follow the discussions on this in the Katmai RS forum http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=1624&SiteID=1

Report Template

Can you create Generic Report Templates with Reporting Services? My problem
is I need to create report templates that will be influenced by external
data. A report template would be generic and the external data would
influence the data to display. There would be some logic involved to
retrieve certain information. For example, can the text for a textbox be
setup generically with an expression or could I pass specifc information to a
query to pull the right text. For example, lets say I have a word that is
stored in the database in 5 languages. I want to pass the query an indicator
to pull the correct text for the language. Is that possible?
Also, can a graph be setup in a generic way? For example, can I pass the
plot values to a graph in a report template? Can I setup the X and Y axis
values to dynamically retrieve information for each value? Can each axis
value be a separate sql statement or can each individual axis be built with
seperate statements.
Thanks - mc>For example, lets say I have a word that is
> stored in the database in 5 languages. I want to pass the query an
> indicator
> to pull the correct text for the language. Is that possible?
Sure, you can set up a report parameter and pass its value to your report
query.
> Also, can a graph be setup in a generic way? For example, can I pass the
> plot values to a graph in a report template? Can I setup the X and Y axis
> values to dynamically retrieve information for each value? Can each axis
> value be a separate sql statement or can each individual axis be built
> with
> seperate statements.
Nope, the chart region can be bound to one dataset only. Max values of X
and Y axis are defined at design time. Sounds like the best option for you
is to pre-process the report definition. In this respect, you can view your
report as the ultimate template. If you need to tweak things, you change the
report definition, upload and render the report.
--
HTH,
---
Teo Lachev, MVP, MCSD, MCT
"Microsoft Reporting Services in Action"
"Applied Microsoft Analysis Services 2005"
Home page and blog: http://www.prologika.com/
---
"mc" <mc@.discussions.microsoft.com> wrote in message
news:335A8727-9483-4351-929A-E1F9406A20B2@.microsoft.com...
> Can you create Generic Report Templates with Reporting Services? My
> problem
> is I need to create report templates that will be influenced by external
> data. A report template would be generic and the external data would
> influence the data to display. There would be some logic involved to
> retrieve certain information. For example, can the text for a textbox be
> setup generically with an expression or could I pass specifc information
> to a
> query to pull the right text. For example, lets say I have a word that is
> stored in the database in 5 languages. I want to pass the query an
> indicator
> to pull the correct text for the language. Is that possible?
> Also, can a graph be setup in a generic way? For example, can I pass the
> plot values to a graph in a report template? Can I setup the X and Y axis
> values to dynamically retrieve information for each value? Can each axis
> value be a separate sql statement or can each individual axis be built
> with
> seperate statements.
>
> Thanks - mc|||What do you mean by pre process the report the report definition? Do you
mean to programmatically find each graph in the report RDL and substitute the
data I need for each graph and then send it for rendering?
Also, when you say max values of X and Y are defined at design time, do you
mean the plot values for lets say a line graph?
Thanks
"Teo Lachev [MVP]" wrote:
> >For example, lets say I have a word that is
> > stored in the database in 5 languages. I want to pass the query an
> > indicator
> > to pull the correct text for the language. Is that possible?
> Sure, you can set up a report parameter and pass its value to your report
> query.
> > Also, can a graph be setup in a generic way? For example, can I pass the
> > plot values to a graph in a report template? Can I setup the X and Y axis
> > values to dynamically retrieve information for each value? Can each axis
> > value be a separate sql statement or can each individual axis be built
> > with
> > seperate statements.
> Nope, the chart region can be bound to one dataset only. Max values of X
> and Y axis are defined at design time. Sounds like the best option for you
> is to pre-process the report definition. In this respect, you can view your
> report as the ultimate template. If you need to tweak things, you change the
> report definition, upload and render the report.
> --
> HTH,
> ---
> Teo Lachev, MVP, MCSD, MCT
> "Microsoft Reporting Services in Action"
> "Applied Microsoft Analysis Services 2005"
> Home page and blog: http://www.prologika.com/
> ---
> "mc" <mc@.discussions.microsoft.com> wrote in message
> news:335A8727-9483-4351-929A-E1F9406A20B2@.microsoft.com...
> > Can you create Generic Report Templates with Reporting Services? My
> > problem
> > is I need to create report templates that will be influenced by external
> > data. A report template would be generic and the external data would
> > influence the data to display. There would be some logic involved to
> > retrieve certain information. For example, can the text for a textbox be
> > setup generically with an expression or could I pass specifc information
> > to a
> > query to pull the right text. For example, lets say I have a word that is
> > stored in the database in 5 languages. I want to pass the query an
> > indicator
> > to pull the correct text for the language. Is that possible?
> >
> > Also, can a graph be setup in a generic way? For example, can I pass the
> > plot values to a graph in a report template? Can I setup the X and Y axis
> > values to dynamically retrieve information for each value? Can each axis
> > value be a separate sql statement or can each individual axis be built
> > with
> > seperate statements.
> >
> >
> > Thanks - mc
>
>|||Yes, I ment programatically changind the report definition.
> Also, when you say max values of X and Y are defined at design time, do
> you
> mean the plot values for lets say a line graph?
Whatever properties are not expression-based. If you expand a property and
don't see the Expression item, this property cannot be controlled duruing
runtime. Your only option is to pre-process the report definition.
--
HTH,
---
Teo Lachev, MVP, MCSD, MCT
"Microsoft Reporting Services in Action"
"Applied Microsoft Analysis Services 2005"
Home page and blog: http://www.prologika.com/
---
"mc" <mc@.discussions.microsoft.com> wrote in message
news:79546631-3B40-4BB1-B31C-BFD28B77DCBC@.microsoft.com...
> What do you mean by pre process the report the report definition? Do you
> mean to programmatically find each graph in the report RDL and substitute
> the
> data I need for each graph and then send it for rendering?
> Also, when you say max values of X and Y are defined at design time, do
> you
> mean the plot values for lets say a line graph?
> Thanks
>
> "Teo Lachev [MVP]" wrote:
>> >For example, lets say I have a word that is
>> > stored in the database in 5 languages. I want to pass the query an
>> > indicator
>> > to pull the correct text for the language. Is that possible?
>> Sure, you can set up a report parameter and pass its value to your report
>> query.
>> > Also, can a graph be setup in a generic way? For example, can I pass
>> > the
>> > plot values to a graph in a report template? Can I setup the X and Y
>> > axis
>> > values to dynamically retrieve information for each value? Can each
>> > axis
>> > value be a separate sql statement or can each individual axis be built
>> > with
>> > seperate statements.
>> Nope, the chart region can be bound to one dataset only. Max values of X
>> and Y axis are defined at design time. Sounds like the best option for
>> you
>> is to pre-process the report definition. In this respect, you can view
>> your
>> report as the ultimate template. If you need to tweak things, you change
>> the
>> report definition, upload and render the report.
>> --
>> HTH,
>> ---
>> Teo Lachev, MVP, MCSD, MCT
>> "Microsoft Reporting Services in Action"
>> "Applied Microsoft Analysis Services 2005"
>> Home page and blog: http://www.prologika.com/
>> ---
>> "mc" <mc@.discussions.microsoft.com> wrote in message
>> news:335A8727-9483-4351-929A-E1F9406A20B2@.microsoft.com...
>> > Can you create Generic Report Templates with Reporting Services? My
>> > problem
>> > is I need to create report templates that will be influenced by
>> > external
>> > data. A report template would be generic and the external data would
>> > influence the data to display. There would be some logic involved to
>> > retrieve certain information. For example, can the text for a textbox
>> > be
>> > setup generically with an expression or could I pass specifc
>> > information
>> > to a
>> > query to pull the right text. For example, lets say I have a word that
>> > is
>> > stored in the database in 5 languages. I want to pass the query an
>> > indicator
>> > to pull the correct text for the language. Is that possible?
>> >
>> > Also, can a graph be setup in a generic way? For example, can I pass
>> > the
>> > plot values to a graph in a report template? Can I setup the X and Y
>> > axis
>> > values to dynamically retrieve information for each value? Can each
>> > axis
>> > value be a separate sql statement or can each individual axis be built
>> > with
>> > seperate statements.
>> >
>> >
>> > Thanks - mc
>>

Report Table Question

I have a report that contains 3 tables. I want to create a 4th table that contains data from the 3 other tables. Is there a way to reference the value from one of the other tables' textbox in my new table. All of these tables are contained in the same report. The 4th table is basically a summary of the other three tables.

Thanks in advance.

i dont think so, because all the textboxes in the table will be created dynamically and you can't refer those textboxes.

you better go for a stored procedure which fetch data from those tables and create a dataset based on this SP and refer this dataset in your fourth table.

Thanks.

|||I've done this before. You have to name the text box that you are referencing first in its name property. Then in the other table you put =ReportItems!Nameoftextbox

Report Snapshot creation fails on large result set

Hello world,
I have some reports that run fine when I use the "Render this report with the
most recent data" selected, but when I want to create a Snapshot it fails to
produce a snapshot. It also depends on how much data I select via the
parameters. If I want a small result set it works, but if I select a large
set it displayes several (3) times the windows login popup (asking my
password each time) and in the end it shows a "You are not authorized to view
this page" error.
The large selection runs for about 7 minutes, the smaller about 2 and does
NOT show the login popup.
The server is in another domain than my login but it is in the "Local
Intranet" in the IE security setup and uses "Automatic logon with current
user credentials"
I suspect it is a recource problem, but I have no idea what causes this
problem.
Can you please help me?
Regards, JanHi,
to answer my own question after wasting a lot of time chasing wrong
leads ;-)
It was the IIS connection-timeout of the report manager; default 120
sec. If the query ran longer than that, it failed. I set it to 15
minutes and now all snapshots are created just fine.
Regards,
Jan Lubbers via SQLMonster.com schreef:
> Hello world,
> I have some reports that run fine when I use the "Render this report with the
> most recent data" selected, but when I want to create a Snapshot it fails to
> produce a snapshot. It also depends on how much data I select via the
> parameters. If I want a small result set it works, but if I select a large
> set it displayes several (3) times the windows login popup (asking my
> password each time) and in the end it shows a "You are not authorized to view
> this page" error.
> The large selection runs for about 7 minutes, the smaller about 2 and does
> NOT show the login popup.
> The server is in another domain than my login but it is in the "Local
> Intranet" in the IE security setup and uses "Automatic logon with current
> user credentials"
> I suspect it is a recource problem, but I have no idea what causes this
> problem.
> Can you please help me?
> Regards, Jan|||Hi,
to answer my own question after wasting a lot of time chasing wrong
leads ;-)
It was the IIS connection-timeout of the report manager; default 120
sec. If the query ran longer than that, it failed. I set it to 15
minutes and now all snapshots are created just fine.
Regards,
Jan Lubbers via SQLMonster.com schreef:
> Hello world,
> I have some reports that run fine when I use the "Render this report with the
> most recent data" selected, but when I want to create a Snapshot it fails to
> produce a snapshot. It also depends on how much data I select via the
> parameters. If I want a small result set it works, but if I select a large
> set it displayes several (3) times the windows login popup (asking my
> password each time) and in the end it shows a "You are not authorized to view
> this page" error.
> The large selection runs for about 7 minutes, the smaller about 2 and does
> NOT show the login popup.
> The server is in another domain than my login but it is in the "Local
> Intranet" in the IE security setup and uses "Automatic logon with current
> user credentials"
> I suspect it is a recource problem, but I have no idea what causes this
> problem.
> Can you please help me?
> Regards, Jan

Report Snapshot

Hi All,

Is it possible to create different report snapshot for different roles?

Thanks,

S Suresh

Can you elaborate on how roles affect report snapshots? I'm not understanding your semantics. We use Roles to mean permissions collections that can be applied to a catalog item for a user, but these have no impact on report snapshots.

Report services compatibility ??

Hi All ...
If I create a report with Microsoft SQL Server Reporting Services
Designers
Version 9.00.1399.00 ... ( Visual Studio 2005) ... Will I be able to
deploy it to SQL Server Report Services 2000 ?
*******
Error 8 An error occurred during the parsing of a resource required to
service this request. Please review the following specific parse
error details and modify your source file appropriately.
*******
I did verify my Report Server name in the "Microsoft CRM Deployment
Manager ... made some modification ...try to deploy again then I'm
getting another error message
******
A connection could not be made to the report server
http:// .........../ReportServer
ADDITIONAL INFORMATION:
The attempt to connect to the report server failed. Check your
connection information and that the report server is a compatible
version. (Microsoft.ReportingServices.Designer)
******
With this one it seems to be a version problem ... Just need an
approval from an expert
TanksNope.
You can deploy RS 2000 to RS 2005 but not RS 2005 to RS 2000.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Frank" <flefe2000@.gmail.com> wrote in message
news:1170879261.176664.43180@.j27g2000cwj.googlegroups.com...
> Hi All ...
> If I create a report with Microsoft SQL Server Reporting Services
> Designers
> Version 9.00.1399.00 ... ( Visual Studio 2005) ... Will I be able to
> deploy it to SQL Server Report Services 2000 ?
>
> *******
> Error 8 An error occurred during the parsing of a resource required to
> service this request. Please review the following specific parse
> error details and modify your source file appropriately.
> *******
>
> I did verify my Report Server name in the "Microsoft CRM Deployment
> Manager ... made some modification ...try to deploy again then I'm
> getting another error message
>
> ******
> A connection could not be made to the report server
> http:// .........../ReportServer
> ADDITIONAL INFORMATION:
> The attempt to connect to the report server failed. Check your
> connection information and that the report server is a compatible
> version. (Microsoft.ReportingServices.Designer)
> ******
> With this one it seems to be a version problem ... Just need an
> approval from an expert
> Tanks
>|||On 7 f=E9v, 15:21, "Bruce L-C [MVP]" <bruce_lcNOS...@.hotmail.com>
wrote:
> Nope.
> You can deploy RS 2000 to RS 2005 but not RS 2005 to RS 2000.
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Frank" <flefe2...@.gmail.com> wrote in message
> news:1170879261.176664.43180@.j27g2000cwj.googlegroups.com...
>
> > Hi All ...
> > If I create a report with Microsoft SQL Server Reporting Services
> > Designers
> > Version 9.00.1399.00 ... ( Visual Studio 2005) ... Will I be able to
> > deploy it to SQL Server Report Services 2000 ?
> > *******
> > Error 8 An error occurred during the parsing of a resource required to
> > service this request. Please review the following specific parse
> > error details and modify your source file appropriately.
> > *******
> > I did verify my Report Server name in the "Microsoft CRM Deployment
> > Manager ... made some modification ...try to deploy again then I'm
> > getting another error message
> > ******
> > A connection could not be made to the report server
> > http:// .........../ReportServer
> > ADDITIONAL INFORMATION:
> > The attempt to connect to the report server failed. Check your
> > connection information and that the report server is a compatible
> > version. (Microsoft.ReportingServices.Designer)
> > ******
> > With this one it seems to be a version problem ... Just need an
> > approval from an expert
> > Tanks- Masquer le texte des messages pr=E9c=E9dents -
> - Afficher le texte des messages pr=E9c=E9dents -
Whaow ... Quick answer ... tanks
I'm using Microsoft CRM 3.0 with SQL Server Report Services 2000 ...
is it an easy task to upgrade Report Services 2000 to 2005 '
Tanks again
Frank|||I'm not familiar with CRM.
A regular RS 2000 environment is not hard to upgrade but there might be
specific things for your environment.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Frank" <flefe2000@.gmail.com> wrote in message
news:1170880734.453903.84940@.s48g2000cws.googlegroups.com...
On 7 fév, 15:21, "Bruce L-C [MVP]" <bruce_lcNOS...@.hotmail.com>
wrote:
> Nope.
> You can deploy RS 2000 to RS 2005 but not RS 2005 to RS 2000.
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Frank" <flefe2...@.gmail.com> wrote in message
> news:1170879261.176664.43180@.j27g2000cwj.googlegroups.com...
>
> > Hi All ...
> > If I create a report with Microsoft SQL Server Reporting Services
> > Designers
> > Version 9.00.1399.00 ... ( Visual Studio 2005) ... Will I be able to
> > deploy it to SQL Server Report Services 2000 ?
> > *******
> > Error 8 An error occurred during the parsing of a resource required to
> > service this request. Please review the following specific parse
> > error details and modify your source file appropriately.
> > *******
> > I did verify my Report Server name in the "Microsoft CRM Deployment
> > Manager ... made some modification ...try to deploy again then I'm
> > getting another error message
> > ******
> > A connection could not be made to the report server
> > http:// .........../ReportServer
> > ADDITIONAL INFORMATION:
> > The attempt to connect to the report server failed. Check your
> > connection information and that the report server is a compatible
> > version. (Microsoft.ReportingServices.Designer)
> > ******
> > With this one it seems to be a version problem ... Just need an
> > approval from an expert
> > Tanks- Masquer le texte des messages précédents -
> - Afficher le texte des messages précédents -
Whaow ... Quick answer ... tanks
I'm using Microsoft CRM 3.0 with SQL Server Report Services 2000 ...
is it an easy task to upgrade Report Services 2000 to 2005 '
Tanks again
Frank|||On 7 f=E9v, 16:23, "Bruce L-C [MVP]" <bruce_lcNOS...@.hotmail.com>
wrote:
> I'm not familiar with CRM.
> A regular RS 2000 environment is not hard to upgrade but there might be
> specific things for your environment.
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Frank" <flefe2...@.gmail.com> wrote in message
> news:1170880734.453903.84940@.s48g2000cws.googlegroups.com...
> On 7 f=E9v, 15:21, "Bruce L-C [MVP]" <bruce_lcNOS...@.hotmail.com>
> wrote:
>
>
> > Nope.
> > You can deploy RS 2000 to RS 2005 but not RS 2005 to RS 2000.
> > --
> > Bruce Loehle-Conger
> > MVP SQL Server Reporting Services
> > "Frank" <flefe2...@.gmail.com> wrote in message
> >news:1170879261.176664.43180@.j27g2000cwj.googlegroups.com...
> > > Hi All ...
> > > If I create a report with Microsoft SQL Server Reporting Services
> > > Designers
> > > Version 9.00.1399.00 ... ( Visual Studio 2005) ... Will I be able to
> > > deploy it to SQL Server Report Services 2000 ?
> > > *******
> > > Error 8 An error occurred during the parsing of a resource required to
> > > service this request. Please review the following specific parse
> > > error details and modify your source file appropriately.
> > > *******
> > > I did verify my Report Server name in the "Microsoft CRM Deployment
> > > Manager ... made some modification ...try to deploy again then I'm
> > > getting another error message
> > > ******
> > > A connection could not be made to the report server
> > > http:// .........../ReportServer
> > > ADDITIONAL INFORMATION:
> > > The attempt to connect to the report server failed. Check your
> > > connection information and that the report server is a compatible
> > > version. (Microsoft.ReportingServices.Designer)
> > > ******
> > > With this one it seems to be a version problem ... Just need an
> > > approval from an expert
> > > Tanks- Masquer le texte des messages pr=E9c=E9dents -
> > - Afficher le texte des messages pr=E9c=E9dents -
> Whaow ... Quick answer ... tanks
> I'm using Microsoft CRM 3.0 with SQL Server Report Services 2000 ...
> is it an easy task to upgrade Report Services 2000 to 2005 '
> Tanks again
> Frank- Masquer le texte des messages pr=E9c=E9dents -
> - Afficher le texte des messages pr=E9c=E9dents -
I will research on the CRM issue but beside that ... is it preferable
to upgrade or start from scratch '

Report service and automatically creating a PDF report.

woundering if there's a way for the user to automatically create a PDF report
via a report button.
Currently when users click the report button the users web interface opens
(would like to not the the web interface just create the PDF without any
interaction) then the user is prompted to open/saved/cancel.
Is it possible to click on the so called report button and automatically
create the PDF? no dialog boxes appering just create the PDF?
Is this a workstation issue with internet exploier?
Running the 2000 version of SQL & it's counter part of reporting services.
All workstations all XP Pro Sp2
MikeHi Mike,
Well I'm using RS 2005 and all the latest stuff here, so I'm not sure
if it'll work but here goes. From a website, my users click a button
and I then do this in C# my code :
//*******************************
string url;
int idStage =3D Convert.ToInt32(lblIdStage.Text);
int annee =3D Convert.ToInt32(lblAnnee.Text);
int idTrimestreAdmission =3D
Convert.ToInt32(lblIdTrimestreAdmission.Text);
url =3D
"http://xxxxx.xxxxx.ca/ReportServer?/Rapport_xxxx/Etxxxge";
url +=3D "&rs:Format=3DPDF";
url +=3D "&idStage=3D" + idStage;
url +=3D "&annee=3D" + annee;
url +=3D "&idTrimestreAdmission=3D" + idTrimestreAdmission;
url +=3D "&idDomaineFormation=3D" +
Convert.ToInt32(Session["IdDomaineFormation"]);
Response.Redirect(url);
//*******************************
This basically pop up a acrobat reader with my report in it.
Hope it helps, cheers.
Mike a =E9crit :
> woundering if there's a way for the user to automatically create a PDF re=port
> via a report button.
> Currently when users click the report button the users web interface opens
> (would like to not the the web interface just create the PDF without any
> interaction) then the user is prompted to open/saved/cancel.
> Is it possible to click on the so called report button and automatically
> create the PDF? no dialog boxes appering just create the PDF?
> Is this a workstation issue with internet exploier?
> Running the 2000 version of SQL & it's counter part of reporting services.
> All workstations all XP Pro Sp2 > > Mike

Report Server FileShare Subscription example

I write .net code to create subsciption instead of report manager. Is there
any example talking about Subscription using Report Server FileShare ? I
only find the example of Report Server Email subscription in Books online. I
try the following code and I successfully create subscription. But when I
try to edit it, error is shown - "Object reference not set to an instance of
an object"
The code is as follows:
Dim FileNamePara As New ParameterValue
FileNamePara.Name = "File Name"
FileNamePara.Value = "Invoice Summary "
extensionParams(0) = FileNamePara
Dim PathPara As New ParameterValue
PathPara.Name = "Path"
PathPara.Value = "\\shkg013devfs\temp\may"
extensionParams(1) = PathPara
Dim renderPara As New ParameterValue
renderPara.Name = "RenderFormat"
renderPara.Value = "PDF"
extensionParams(2) = renderPara
settings.ParameterValues = extensionParams
Dim datRptGenTime As Date
datRptGenTime = DateAdd(DateInterval.Day, 1, Now)
Dim eventType As String = "TimedSubscription"
Dim matchData As String = "<ScheduleDefinition>" & _
"<StartDateTime>" & datRptGenTime.Year & "-" & _
IIf(datRptGenTime.Month < 10, "0" & datRptGenTime.Month,
datRptGenTime.Month) & "-" & _
IIf(datRptGenTime.Day < 10, "0" & datRptGenTime.Day, datRptGenTime.Day) &
"T08:00:00" & _
"+08:00</StartDateTime>" & _
"</ScheduleDefinition>"
Try
mRSProxyUtil.rs.CreateSubscription(ReportName, settings, sEmaiDesc,
eventType, matchData, parameters)
Catch e As SoapException
Console.WriteLine(e.Detail.InnerText.ToString())
End TryI'm not sure why you are getting the object reference error. Is RS
returning it?
Anyway, you are not using the correct setting names. To find the correct
names call GetExtensionSettings. This will return a list of extension names
that the extension excepts. There is a flag that will tell you if the
setting is required or not.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"May Liu" <MayLiu@.discussions.microsoft.com> wrote in message
news:E022B2B3-B882-4E6D-A836-03CC0AE19675@.microsoft.com...
>I write .net code to create subsciption instead of report manager. Is
>there
> any example talking about Subscription using Report Server FileShare ?
> I
> only find the example of Report Server Email subscription in Books online.
> I
> try the following code and I successfully create subscription. But when I
> try to edit it, error is shown - "Object reference not set to an instance
> of
> an object"
> The code is as follows:
> Dim FileNamePara As New ParameterValue
> FileNamePara.Name = "File Name"
> FileNamePara.Value = "Invoice Summary "
> extensionParams(0) = FileNamePara
> Dim PathPara As New ParameterValue
> PathPara.Name = "Path"
> PathPara.Value = "\\shkg013devfs\temp\may"
> extensionParams(1) = PathPara
> Dim renderPara As New ParameterValue
> renderPara.Name = "RenderFormat"
> renderPara.Value = "PDF"
> extensionParams(2) = renderPara
> settings.ParameterValues = extensionParams
> Dim datRptGenTime As Date
> datRptGenTime = DateAdd(DateInterval.Day, 1, Now)
> Dim eventType As String = "TimedSubscription"
> Dim matchData As String = "<ScheduleDefinition>" & _
> "<StartDateTime>" & datRptGenTime.Year & "-" & _
> IIf(datRptGenTime.Month < 10, "0" & datRptGenTime.Month,
> datRptGenTime.Month) & "-" & _
> IIf(datRptGenTime.Day < 10, "0" & datRptGenTime.Day, datRptGenTime.Day) &
> "T08:00:00" & _
> "+08:00</StartDateTime>" & _
> "</ScheduleDefinition>"
> Try
> mRSProxyUtil.rs.CreateSubscription(ReportName, settings, sEmaiDesc,
> eventType, matchData, parameters)
> Catch e As SoapException
> Console.WriteLine(e.Detail.InnerText.ToString())
> End Try

Report Server Database Set Up

i am trying to set up report server on the Standard edition of Sql Server 2005 using winxp.. i generated the script to create the ReportServer/ReportServerTempDB database but when i try to specify a database connection and click apply this message is displayed

Verify Database Edition

The Feature: "Using other editions of sql server for report datasources and/or the report server database" is not supported in this edition of Reporting Services.

i can't i can figure out how to get around this i mean i can configure everything else from the virtual directory but not the Database Setup..What SKU of SQL Server did you install and what SKU of SSRS are you trying to install. This error is thrown when those two don't match.|||yeah i see i have the developer version installed and i installed report server from the standard edition How can i uninstall the report server?|||You should be able to use add/remove programs to get it uninstalled.