RS and HTTPS: build

Showing posts with label build. Show all posts

Friday, March 30, 2012

rsFailedToDecryptConfigInformation

I have Windows XP(SP1) With Framework v1.1.4322
- When I build a Report the application display this message:
Build complete -- 0 errors, 0 warnings
- When I deploy a Report the application display this message:
Deploying to http://localhost/ReportServer?%2fReportesSINPHOS
Error rsFailedToDecryptConfigInformation :
The encrypted value for configuration setting Dsn cannot be decrypted.
Deploy complete -- 1 errors, 0 warnings
I also delete and create a new data environment and still send me this
messages.
What can I do, to solve this?Sounds like your configuration file DSN element has become invalid. Running
rsconfig should solve this problem.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"vonpatogm" <vonpatogm@.discussions.microsoft.com> wrote in message
news:1F87BF5B-1366-4B05-9771-33AA80E86434@.microsoft.com...
> I have Windows XP(SP1) With Framework v1.1.4322
> - When I build a Report the application display this message:
> Build complete -- 0 errors, 0 warnings
> - When I deploy a Report the application display this message:
> Deploying to http://localhost/ReportServer?%2fReportesSINPHOS
> Error rsFailedToDecryptConfigInformation :
> The encrypted value for configuration setting Dsn cannot be decrypted.
> Deploy complete -- 1 errors, 0 warnings
> I also delete and create a new data environment and still send me this
> messages.
> What can I do, to solve this?|||Tks.
But, I did run this batch:
rsconfig -c -s11.254.16.11 -dDBSINPHOS -aSQL -uusr_siaish -pimss -t
It send this follow error:
System.Exception: Error: HRESULT=0x8004F992 For more information, see the
event log in the Event Viewer.
at
Microsoft.ReportingServices.ConfigManagement.ConfigFileApp.InstanceMain()
at Microsoft.ReportingServices.BaseCmdLine.CommandLineMain(String[] args,
BaseCmdLine instance)
How do u see it?
"Daniel Reib [MSFT]" wrote:
> Sounds like your configuration file DSN element has become invalid. Running
> rsconfig should solve this problem.
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "vonpatogm" <vonpatogm@.discussions.microsoft.com> wrote in message
> news:1F87BF5B-1366-4B05-9771-33AA80E86434@.microsoft.com...
> > I have Windows XP(SP1) With Framework v1.1.4322
> >
> > - When I build a Report the application display this message:
> > Build complete -- 0 errors, 0 warnings
> >
> > - When I deploy a Report the application display this message:
> > Deploying to http://localhost/ReportServer?%2fReportesSINPHOS
> > Error rsFailedToDecryptConfigInformation :
> > The encrypted value for configuration setting Dsn cannot be decrypted.
> > Deploy complete -- 1 errors, 0 warnings
> >
> > I also delete and create a new data environment and still send me this
> > messages.
> >
> > What can I do, to solve this?
>
>|||Go to the administrator tools and click on event log.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"vonpatogm" <vonpatogm@.discussions.microsoft.com> wrote in message
news:4E148DAA-CE6D-443D-8F83-C861408D768E@.microsoft.com...
> Tks.
> But, I did run this batch:
> rsconfig -c -s11.254.16.11 -dDBSINPHOS -aSQL -uusr_siaish -pimss -t
> It send this follow error:
> System.Exception: Error: HRESULT=0x8004F992 For more information, see the
> event log in the Event Viewer.
> at
> Microsoft.ReportingServices.ConfigManagement.ConfigFileApp.InstanceMain()
> at Microsoft.ReportingServices.BaseCmdLine.CommandLineMain(String[]
args,
> BaseCmdLine instance)
> How do u see it?
> "Daniel Reib [MSFT]" wrote:
> > Sounds like your configuration file DSN element has become invalid.
Running
> > rsconfig should solve this problem.
> >
> > --
> > -Daniel
> > This posting is provided "AS IS" with no warranties, and confers no
rights.
> >
> >
> > "vonpatogm" <vonpatogm@.discussions.microsoft.com> wrote in message
> > news:1F87BF5B-1366-4B05-9771-33AA80E86434@.microsoft.com...
> > > I have Windows XP(SP1) With Framework v1.1.4322
> > >
> > > - When I build a Report the application display this message:
> > > Build complete -- 0 errors, 0 warnings
> > >
> > > - When I deploy a Report the application display this message:
> > > Deploying to http://localhost/ReportServer?%2fReportesSINPHOS
> > > Error rsFailedToDecryptConfigInformation :
> > > The encrypted value for configuration setting Dsn cannot be decrypted.
> > > Deploy complete -- 1 errors, 0 warnings
> > >
> > > I also delete and create a new data environment and still send me this
> > > messages.
> > >
> > > What can I do, to solve this?
> >
> >
> >

Wednesday, March 21, 2012

RS2005 breaks my build: Version 2.0 is not a compatible version

Hi,

We've developed a RS DataExtension on RS2000, including a reference to Microsoft.ReportingServices.Interfaces.dll. Since I have installed RS 2005 on my machine, (we actually saw this issue first on our build server) the project no longer compiles. We get this error:

fatal error CS0009: Metadata file 'c:\Program Files\Microsoft SQL Server\90\SDK\Assemblies\Microsoft.ReportingServices.Interfaces.dll' could not be opened -- 'Version 2.0 is not a compatible version.'

The VS.NET 2003 project does include a '_references' directory, with the RS2000 version of the Microsoft.ReportingServices.Interfaces.dll (v8.0.1038.0) in it and the project file has a local reference like

So since installing RS 2005, it seems like the compiler is picking up the Microsoft.ReportingServices.Interfaces.dll from the GAC. On the build server (and confirmed by the installation on my dev box) RS 2005 installs this dll into the GAC. The compiler can only find this dll in the GAC, or is VS.NET doing tricky things here?

So my question is now, why ... ooooh why does the compiler pick up the wrong dll from the GAC and why ... ooooh why does it not pick up the explicit hintpath that is given in the project file.

Someone please tell me how to force the compiler to look at the correct dll/path.

If you want to build a data extension to be used with RS 2005, you have to use the .NET 2.0 C# compiler (or VS 2005) and your data extension has to reference the updated Microsoft.ReportingServices.Interfaces.dll that was installed by RS 2005.

The Interfaces.dll of RS 2005 is based on .NET 2.0 and cannot be used in a .NET 1.1 (VS 2003) project.

-- Robert

|||

Robert, yes, I understand that.

Indeed for the RS 2005 version of our Data Extension, we will use VS2005 and a reference to the RS 2005 version of the dll.

But, I'd still like to be able to compile the RS 2000 version of our Data Extension, using VS.NET 2003 and a reference to the RS 2000 version of the dll.

So problem is however that I have an existing data extension compiled against the RS 2000 version, which is being compiled using devenv (VS.NET 2003). This all worked until our sysadmin installed RS 2005 on the build server. Since RS 2005 has been installed, VS.NET 2003 always attempts to use the RS 2005 version of the dll's to compile the code, where as it should do as it states in the docs and use the RS 2000 version of the dll as specified in the references hintpath.

I have already build our data extension using csc (.NET v1.1) directly, which does seem to respect the references given to it. I suspect that the issue is more a VS.NET 2003 issue, resolving the dll reference incorrectly 1) from the GAC, 2) from the .NET 2.0 GAC, instead of taking the dll that has been copied in the project directory.

Rudi

|||

A new day, a new result.

Today the build on my machine does work.

I did install VS 2005 yesterday, maybe that 'magically' fixed the problem.

So we're installing VS 2005 on our build server aswell, hopefully that will solve the problem for us.

|||

Turned out that installing VS 2005 did NOT solve the problem.

The real solution exists in creating a *.csproj.user file with the ReferencePath set correctly. When running devenv from the command-line, it will pick up the *.csproj.user file and use the ReferencePath to locate the correct reference.

I was hoping to see (and test) the VS2003 SP1 this month, but this seems to be another 'longwait' program, it was first promised to be April 2006, then June 2006, but still not here: http://msdn.microsoft.com/vstudio/support/servicing/sp1_vs03/default.aspx

RS2005 breaks my build: Version 2.0 is not a compatible version

Hi,

Someone please tell me how to force the compiler to look at the correct dll/path.

The Interfaces.dll of RS 2005 is based on .NET 2.0 and cannot be used in a .NET 1.1 (VS 2003) project.

-- Robert

|||

Robert, yes, I understand that.

Indeed for the RS 2005 version of our Data Extension, we will use VS2005 and a reference to the RS 2005 version of the dll.

But, I'd still like to be able to compile the RS 2000 version of our Data Extension, using VS.NET 2003 and a reference to the RS 2000 version of the dll.

Rudi

|||

A new day, a new result.

Today the build on my machine does work.

I did install VS 2005 yesterday, maybe that 'magically' fixed the problem.

So we're installing VS 2005 on our build server aswell, hopefully that will solve the problem for us.

|||

Turned out that installing VS 2005 did NOT solve the problem.

Friday, March 9, 2012

RS Restore Version Conflict

We are attempting to dry run a SQL 2000 to SQL 2005 upgrade. We build a
server in a test lab with reporting services 2000, SP1 successfully. Backed
up our production (reporting services 2000 SP1) ReportServer databases and
restored to the test lab server. Now we get the following error in report
manager:
The version of the report server database is either in a format that is not
valid, or it cannot be read. The found version is 'C.0.6.54'. The expected
version is 'C.0.6.51'. To continue, update the version of the report server
database and verify access rights. (rsInvalidReportServerDatabase) Get Online
Help
How do I troubleshoot this? I'm not finding anything in online help. Thank
you,Hi Brent,
Welcome to use MSDN Managed Newsgroup!
The error message indicates the database you used to attach is backuped
from a Reporting Services SP2 but you are attaching it to a Report Services
SP1.
You should select the correct version database for Reporting Services.
Sincerely yours,
Michael Cheng
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||I am having a similar problem moving a RS db from 32 bit sql to 64 bit sql.
Could you please extrapolate on "You should select the correct version
database for Reporting Services."
--
MCSD
"Michael Cheng [MSFT]" wrote:
> Hi Brent,
> Welcome to use MSDN Managed Newsgroup!
> The error message indicates the database you used to attach is backuped
> from a Reporting Services SP2 but you are attaching it to a Report Services
> SP1.
> You should select the correct version database for Reporting Services.
>
> Sincerely yours,
> Michael Cheng
> Microsoft Online Partner Support
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> =====================================================> This posting is provided "AS IS" with no warranties, and confers no rights.
>|||Hi,
Thanks for your question but it is not exactly the same as original one.
If you want to move the Report Server database, it would be recommended to
use 32bit SQL Server's database to restore the 32bit SQL Server's database.
Everything should be match.
Sincerely yours,
Michael Cheng
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||We are migrating from a 32 bit SQL server to a 64 bit. I cannot find any
papers on how to do this migration, therefore I detached the DB from 32bit
and reattached to 64 bit server. After reattaching is when I get the error.
Reattaching to 32 is pointless.
--
MCSD
"Michael Cheng [MSFT]" wrote:
> Hi,
> Thanks for your question but it is not exactly the same as original one.
> If you want to move the Report Server database, it would be recommended to
> use 32bit SQL Server's database to restore the 32bit SQL Server's database.
> Everything should be match.
>
> Sincerely yours,
> Michael Cheng
> Microsoft Online Partner Support
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> =====================================================> This posting is provided "AS IS" with no warranties, and confers no rights.
>
>|||Just a guess, but try the SSIS wizards on the 64bit server to move the
databases from a 32bit server.
Cheers
Chris
Aco wrote:
> We are migrating from a 32 bit SQL server to a 64 bit. I cannot find
> any papers on how to do this migration, therefore I detached the DB
> from 32bit and reattached to 64 bit server. After reattaching is when
> I get the error. Reattaching to 32 is pointless.

Saturday, February 25, 2012

rs drops first column in data set

I started having this problem some time ago when trying to build a report using a stored procedure. Existing reports work fine, it is only new reports that result in this error:

The data set ‘WeeklyManagement’ contains a definition for the field ‘BrewNumber’. This field is missing from the returned result set from the data source.

I get this error when I try to preview the report. The missing field is always the first column in the dataset. I have tried everything I can think of, including repeating the column, rewriting the sproc, rewriting the report, everything. I cannot find any reason why this should be happening. Can anyone help? BTW, when I create the dataset and run the sproc, all fields are returned fine. When I examine the xml, all the fields are there, correctly defined.

Help, please! TIA. D. Lewis

Can you publish the sproc? Print statements did this to us in the past.|||

Hmmm. Very interesting. Following is the sproc, which I altered to comment out the 'Print' statements (yes, I did have some in there for debugging purposes). I also as an experiment repeated the first column to see if it would work, and RS began dropping that new column; error message as below:
Build complete -- 0 errors, 0 warnings

The data set ‘WeeklyManagement’ contains a definition for the field ‘B’. This field is missing from the returned result set from the data source.

Preview complete -- 0 errors, 1 warnings
The sproc is a bit messy, and uses a temp table, but for completeness' sake here it is:

use snb01
go

SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
Alter PROCEDURE spBrewhouseOverview
AS
Declare @.BeginDate smalldatetime
Declare @.EndDate smalldatetime
Set @.BeginDate = DATEADD(dd,-45,Getdate())--'9/1/05'
set @.EndDate = Getdate()--'9/15/05'

--Print convert(varchar,@.begindate)
--Print convert(varchar,@.enddate)

--spBrewhouseOverview '8/2/05','8/3/05'
--5/20/03
--Have to convert the dates to char then to date again
--to strip out the time portion that crystall passes
--also added one day to the end time to
--allow for the fact that the end day would be midnight
--at the beginning of the ending day, which would otherwise
--effectively eliminate all brews on that day from showing up.
BEGIN
CREATE TABLE [#tblOverview] (
[ID] [int] IDENTITY (1, 1) NOT NULL ,
[ProBrewID] [int] NULL,
[BrewNumber] [int] NULL ,
[Kettle] [char] (12) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[StartTimeInKettle] [smalldatetime] NULL ,
[StartTimeBoil] [smalldatetime] NULL ,
[EndTimeBoil] [smalldatetime] NULL ,
[Hop1Time] [smalldatetime] NULL ,
[Hop2Time] [smalldatetime] NULL ,
[MossTime] [smalldatetime] NULL ,
[Hop3Time] [smalldatetime] NULL ,
[Hop4Time] [smalldatetime] NULL ,
/*[StartTimeMash] [smalldatetime] NULL ,
[SaccReqTime] [smalldatetime] NULL ,
[SaccTime] [smalldatetime] NULL ,
[MashOutTime] [smalldatetime] NULL ,
[StartTimeInLauter] [smalldatetime] NULL ,
[StartTimeVorlauf] [smalldatetime] NULL ,
[StartTimeLauter] [smalldatetime] NULL ,
[EndTimeLauter] [smalldatetime] NULL ,
[GravityVorlauf] [int] NULL ,
[GravityFirstRunnings] [int] NULL ,
[GravityLastRunnings] [int] NULL ,
[GravityLauter] [int] NULL ,
[HazeFirstRunnings] [int] NULL ,
[HazeLauterVorlauf] [int] NULL ,
[HazeLauterLauter] [int] NULL ,*/
[StartTimeRest] [smalldatetime] NULL ,
[StartTimeWhirlWaterVor] [smalldatetime] NULL,
/*[MashHour] [int] NULL,
[LauterHour] [int] NULL,
[KettleHour] [int] NULL,
[WhirlpoolHour] [int] NULL,
[BrewerMash] [Varchar] (20) NULL,
[BrewerLauter] [Varchar] (20) NULL,*/
[BrewerKettle] [Varchar] (20) NULL,
[BrewerWhirlpool] [Varchar] (20) NULL,
CONSTRAINT [PK_tblOverview] PRIMARY KEY CLUSTERED
(
[ID]
) ON [PRIMARY]
) ON [PRIMARY]
END

SET NOCOUNT ON
INSERT #tblOverview
(Probrewid
, Brewnumber
, Kettle
, StarttimeInKettle
, StartTimeBoil
, EndTimeBoil
, Hop1Time
, Hop2Time
, MossTime
, Hop3Time
, Hop4Time/*
, StartTimeMash
, SaccReqTime
, SaccTime
, MashOutTime
, StartTimeInLauter
, StartTimeVorlauf
, StartTimeLauter
, EndTimeLauter
, GravityVorlauf
, GravityFirstRunnings
, GravityLastRunnings
, GravityLauter
, HazeFirstRunnings
, HazeLauterVorlauf
, HazeLauterLauter*/
, StartTimeRest
, StartTimeWhirlWaterVor)
(
Select a.probrewid
, a.Brewnumber
, a.Kettle
, a.StarttimeInKettle
, a.StartTimeBoil
, a.EndTimeBoil
, a.Hop1Time
, a.Hop2Time
, a.MossTime
, a.Hop3Time
, a.Hop4Time
/*, b.StartTimeMash
, b.SaccReqTime
, b.SaccTime
, b.MashOutTime
, c.StartTimeInLauter
, c.StartTimeVorlauf
, c.StartTimeLauter
, c.EndTimeLauter
, c.GravityVorlauf
, c.GravityFirstRunnings
, c.GravityLastRunnings
, c.GravityLauter
, c.HazeFirstRunnings
, c.HazeLauterVorlauf
, c.HazeLauterLauter*/
, d.StartTimeRest
, d.StartTimeWhirlWaterVor
FROM Proleit.dbo.tblRptKettleAll a
INNER JOIN Proleit.dbo.tblRptMashingAll b on a.Probrewid=b.probrewid
INNER JOIN Proleit.dbo.tblRptLauterAll c on a.Probrewid=c.Probrewid
INNER JOIN Proleit.dbo.tblRptWhirlpoolAll d on a.Probrewid=d.probrewid
WHERE a.StartTimeBoil>=CONVERT(datetime,(CONVERT(varchar,@.BeginDate,112)))
AND a.StartTimeBoil<= DATEADD(day,1,CONVERT(datetime,(CONVERT(varchar,@.EndDate,112))))
)

--Comment out for troubleshooting
--declare a cursor for the table, loop through
--and update each brewer

DECLARE CurC CURSOR FOR SELECT Probrewid,MossTime,StartTimeRest
FROM #tblOverview
DECLARE @.Probrewid int
DECLARE @.TimeMoss datetime
DECLARE @.TimeWhirl datetime
OPEN CurC

FETCH NEXT FROM CurC INTO @.probrewid,@.TimeMoss,@.TimeWhirl
BEGIN
WHILE @.@.FETCH_STATUS=0
BEGIN

--Print convert(varchar,@.probrewid) + ' is probrewid'
--Print convert(varchar,@.TimeMoss) + ' is @.TimeMoss'
--Exec spBrewhouseOverviewSacc @.probrewid,@.timeSacc
--Exec spBrewhouseOverviewVorlauf @.probrewid,@.timeVorlauf
Exec Proleit.dbo.spBrewhouseOverviewKettle @.probrewid,@.timeMoss
Exec Proleit.dbo.spBrewhouseOverviewWhirlpool @.probrewid,@.timeWhirl

FETCH NEXT FROM CurC INTO @.probrewid,@.TimeMoss,@.TimeWhirl
END
END
CLOSE CurC
DEALLOCATE CurC

SET NOCOUNT ON
UPDATE #tblOverview
SET BrewerKettle='None Recorded'
WHERE BrewerKettle is null

UPDATE #tblOverview
SET BrewerWhirlpool='None Recorded'
WHERE BrewerWhirlpool is null

SELECT
a.BrewNumber as B
, a.BrewNumber
, a.Kettle
, Convert(datetime,Convert(varchar,a.StartTimeInKettle,110)) as BrewDate
, DATEDIFF(n,MossTime,Hop3Time) as Minutes
, BrewerKettle as Brewer
, 'Hop3Time' as Type
FROM #tblOverview a
WHERE DATEDIFF(n,MossTime,Hop3Time)<10
OR DATEDIFF(n,MossTime,Hop3Time)>13

UNION ALL

SELECT
a.BrewNumber as B
, a.BrewNumber
, a.Kettle
, Convert(datetime,Convert(varchar,a.StartTimeInKettle,110)) as BrewDate
, DATEDIFF(n,Hop3Time,Hop4Time) as Minutes
, BrewerKettle as Brewer
, 'Hop4Time' as Type
FROM #tblOverview a
WHERE DATEDIFF(n,Hop3Time,Hop4Time)<10
OR DATEDIFF(n,Hop3Time,Hop4Time) > 13

UNION ALL

SELECT
a.BrewNumber as B
, a.BrewNumber
, a.Kettle
, Convert(datetime,Convert(varchar,a.StartTimeInKettle,110)) as BrewDate
, DATEDIFF(n,StartTimeRest,StartTimeWhirlWaterVor) as Minutes
, BrewerWhirlpool
, 'WhirlpoolTime' as Type
FROM #tblOverview a
WHERE DATEDIFF(n,StartTimeRest,StartTimeWhirlWaterVor)>21

Drop Table #tblOverview

GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO

|||If you're not working with a whole lot of data, an @.Table variable instead of a temp table may be more efficient and you won't need the drop table statement at the end.
Try adding to your UNION ALL statements with a select statement at the top that sets a default value.... eg. SELECT 0 as B, 0 as BrewNumber, 0 as Kettle, 0 as BrewDate, etc.... to see if it is a problem with the naming of the fields and the first result set not returning a value.
Maybe dump that above dummy SELECT statement in various places within the stored procedure, so that you can find out where it is breaking. (not returning the right result set)
It could have something to do with the 2 execs you have going there... It would be interesting to see the SQL messages pane.|||I will set to work on those suggestions, thanks.

Just to clarify, the result set returned in Query Analyzer is fine, with no errors and no messages. When I refresh the dataset from within visual studio while designing the report, I also get the entire set with no issues. It is only when I try to preview the report that the thing bonks -- i.e., the first column is dropped and VS tells me that it is not defined.

Also, I went back and examined the two 'exec ....' statements, and they are simple update statements, with no 'Print....' or anything else. Very innocuous, actually. I placed them in separate sprocs because they are reused elsewhere and are long.

RS ADO.Net extensibility? (using a webservices as a datasource?)

Hi All,
I have to build a solution where end-users have to operate data input and
reports. (This means that the GUI must be very user friendly).
Because of this, I was thinking of using Windows Sharepoint Services (WSS)
as a front-end for data input and using Reporting Services for generating
reports on this data.
WSS will make it easy for users, because it has a real good interface for
adding columns or changing input fields. The downside is that the data in WSS
is stored in a SQL database, but it isn't very usable for an end user to get
it out of this Database (You can read why here).
So... I was thinking of building a web service that gets the information out
of WSS and presenting it in rows (record sets) for Reporting Services.
My Question:
Could the ADO.Net extensibility of Reporting Services realize that I can get
data from a webservice? And if so, can I get a recordset from a web services
and use it in the same way as querying a SQL database with RS?
I would be very happy with some help on this subject.
Any thoughts are welcome...
Grt. M.VisserYou can build custom data provider and register it in RSReportServer.config
RS exposes a lightweight version of interfaces (IDbConnection, IDbCommand,
IDataReader).
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSPROG/htm/rsp_prog_extend_dataproc_5c2q.asp
--
Alex Mineev
Software Design Engineer
This posting is provided "AS IS" with no warranties, and confers no rights
"Maarten Visser" <MaartenVisser@.discussions.microsoft.com> wrote in message
news:1DE68EBF-E54A-41B0-A0FB-EA8034807ACD@.microsoft.com...
> Hi All,
> I have to build a solution where end-users have to operate data input and
> reports. (This means that the GUI must be very user friendly).
> Because of this, I was thinking of using Windows Sharepoint Services (WSS)
> as a front-end for data input and using Reporting Services for generating
> reports on this data.
> WSS will make it easy for users, because it has a real good interface for
> adding columns or changing input fields. The downside is that the data in
WSS
> is stored in a SQL database, but it isn't very usable for an end user to
get
> it out of this Database (You can read why here).
> So... I was thinking of building a web service that gets the information
out
> of WSS and presenting it in rows (record sets) for Reporting Services.
> My Question:
> Could the ADO.Net extensibility of Reporting Services realize that I can
get
> data from a webservice? And if so, can I get a recordset from a web
services
> and use it in the same way as querying a SQL database with RS?
> I would be very happy with some help on this subject.
> Any thoughts are welcome...
> Grt. M.Visser
>

Tuesday, February 21, 2012

RS 2005, VS 2005 and specifying printer trays

I am trying to build a demo to prove the following can be done with SQL 2005 Reporting Services:

1. Export report as .pdf to file location. - Done

2. Use CSLA business objects with Reporting Services to reuse the object's ability to populate itself. - Done

3. Set certain reports to print from certain trays on a specific printer. More specifically, for a certain report, I need the first page to print from Tray 1 and all remaining pages to print from Tray 2.

This is the task I am having problems with. I am trying to just get the tray selection working now with just a windows app but even if I get that far, will I need to extend RS and write my own print routine? Also, if this report is served to the client via URL, will I be able to specify the printer and tray or will I need a print server to handle this?

Thanks.

I have had luck with using ABCPDF for PDF manipulation.

http://www.websupergoo.com/

You could create two separate printers with different default trays and then print the first page to one printer, and the rest to another.

Bryan has a good article on printing from Reporting Services:
http://blogs.msdn.com/bryanke/articles/71491.aspx|||Unfortunately, this solution does not work for me. I am printing Optical Recognition Marks on the pages as they are printed so they need to come off the same printer so they are in the proper order to go into the feeder.

RS 2005, VS 2005 and specifying printer trays

I am trying to build a demo to prove the following can be done with SQL 2005 Reporting Services:

1. Export report as .pdf to file location. - Done

2. Use CSLA business objects with Reporting Services to reuse the object's ability to populate itself. - Done

Thanks.

I have had luck with using ABCPDF for PDF manipulation.

http://www.websupergoo.com/

You could create two separate printers with different default trays and then print the first page to one printer, and the rest to another.

RS 2005 Subscription Disabled

Hello,
I'm using SQL 2005 SP2 build 3215 x64 Enterprise (4x dualcore 8Gram)
Everything is working OK (SQL,SSIS,AS,RS) except creating data driven
subscriptions.
I have an report with an custom data source (to AS) wich is working OK.
The credentials are stored in DB, SQL Agent is working a.so.
The web services is running under NT\SYSTEM, I am connected with a
domain user which is local admin.
Report Manager web interface:
I can create "normal" subscriptions and they are working OK.
I can't create data driven subscription (there is no option to create
it). (yes, it is enterprise version, see appendix :) )
Management Studio (started on the server via Remote desktop, logged in
as a domain user in the local admin group):
Both "New Subscription" and "New Data Driven Subscription" are grayed
out (disabled).
I can see the subscription created via Report Manager but I can't access
its properties , I can only delete it.
Question:
How can I create a data driven subscription from Management Studio?
How can I get the Items (create subscription) enabled in the context menu?
What I'm doing wrong ? :)
Cheers,
Radu
APPENDIX:
select @.@.version:
Microsoft SQL Server 2005 - 9.00.3215.00 (X64) Dec 8 2007 17:58:16
Copyright (c) 1988-2005 Microsoft Corporation Enterprise Edition
(64-bit) on Windows NT 5.2 (Build 3790: Service Pack 2)
All the components SQL, AS, RS are running on the same server.I want to add that we have made some time ago an upgrade from Standard
Edition to Enterprise Edition
Maybe something get wrong with upgrading the RS?
Radu

Friday, March 30, 2012

rsFailedToDecryptConfigInformation

Wednesday, March 21, 2012

RS2005 breaks my build: Version 2.0 is not a compatible version

RS2005 breaks my build: Version 2.0 is not a compatible version

Friday, March 9, 2012

RS Restore Version Conflict

Saturday, February 25, 2012

rs drops first column in data set

RS ADO.Net extensibility? (using a webservices as a datasource?)

Tuesday, February 21, 2012

RS 2005, VS 2005 and specifying printer trays

RS 2005, VS 2005 and specifying printer trays

RS 2005 Subscription Disabled

RS and HTTPS

Blog Archive

About Me