need to create a custom rendering format

Hi,
I am new to reporting service and I need to create a file of custom format except for thoese provided in RS,how to do it ? and I also want to put ths format in the dropdownlist in report manager , is there a way to do it?
Thanks a lot
--
Message posted via http://www.sqlmonster.comOn Sat, 22 Jan 2005 15:16:34 GMT, "angela chen via SQLMonster.com"
<forum@.SQLMonster.com> wrote:
>Hi,
>I am new to reporting service and I need to create a file of custom format except for thoese provided in RS,how to do it ? and I also want to put ths format in the dropdownlist in report manager , is there a way to do it?
>Thanks a lot
Yes, it is possible to create a custom rendering extension for RS.
Looks in the RS Books Online for more info. However, the task is not
trivial and, depending on your format, may require a major programming
effort.

Need suggestions on best way

I have several workstations that are running a custom app
using MSDE2000. I need the PCs to replicate with a SQL
server via modem to pick up subscription and exchange
data. What is the best way to accomplish this? Currently
I am using MOBSYNC and scheduleing the event. It has been
unreliable.
connect to your subscriber, go to the management folder and look in the jobs
there. You should find your merge agent there. You can examine its history
there.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"Robert" <anonymous@.discussions.microsoft.com> wrote in message
news:810401c495a5$a8170580$a501280a@.phx.gbl...[vbcol=seagreen]
> Here is alittle background. The PCs are WINXP Pro. The
> PCs are schedule within MOBSYNC to once a week dial up a
> RAS server in Dallas, authenicate, and then replicate. My
> issues are as follow. I use the same username and
> password to authenicate on every PC. Each PC is scheduled
> to this function when no other is. Every 30 minutes
> starting at night across the US, a different PC is set to
> replicate. Some PCs indicate that they ran the process
> when looking at MOBSYNC, but the server says it didn't.
> It is difficult to check the RAS server to verifiy it
> connected because of the userid being the same and time
> zone differences.

need sample code in vb.net

Hi,

I neew a small sample code in VB.NET to create a custom data flow component for SSIS.
All the examples I was able to find it are in C#.

Answer very apreciated.

Go to http://msdn2.microsoft.com/en-US/library/ms136112.aspx

Thanks,
Loonysan
http://mystutter.blogspot.com/

|||There are a number of websites that provide conversion utilities to convert C# to VB. Using those will increase the amount of sample code available to you.|||

SQL Server ships with several simple samples of SSIS components. Please install the SQL samples. The December update is available from MSDN at http://www.microsoft.com/downloads/details.aspx?FamilyId=E719ECF7-9F46-4312-AF89-6AD8702E4E6E&displaylang=en.

-Doug

Need help!

I really just do not understand this and it is really frustrating me... I
made a custom authentication/authorization extension that uses forms
authentication... it works fine on my local system (32bit windows xp pro sp2
with SQL 2005 Dev SP2)... So I installed it onto our development test server
running SQL 2005 Dev edition SP2 (32bit windows server 2003) works great!
figure ok its working! now I go to our master setup, which is like this
Active/Passive failover cluster with shared storage on a SAN... 2 node
cluster... both running windows server 2003 64bit! SQL Server is clustered,
but we dont care much about reporting services being fail over because they
fail so infrequently.. so I do all the same stuff I do to install it on the
32bit server... now this is what happends
I open up http://sqlvirtualhost/Reports (sqlvirtualhost is the virtual
cluster name we gave the sql server instance) it goes to the report server
logon screen, I login, that works fine... I get a list of reports, ok great!
seems to be working! I click on a report... boom problem... gives me a .net
assembly name that has Microsoft.ReportingService.xxxxx in (xxxx changes
sometimes usually Modeling or Design seems like?) anyways it says Access
Denied is the error and thats it! I cant figure out what is denied access or
what is causing it... this same thing with the same config works great on
the two 32bit systems! the assembly is compiled for "AutoCPU" to let .NET
framework auto compile it to 32 or 64bit on demand... im ripping out my hair
here, can anyone help me or give me some direction on what to do or look
for? THANKS A LOT!I added the computer in the domain to the security list that sharepoint
services is on and now the message changed to this "HTTP/1.1 404 Connection:
close Date: Wed, 28 Feb 2007 21:42:58 GMT Server: Microsoft-IIS/6.0
X-Powered-By: ASP.NET MicrosoftSharePointTeamServices: 12.0.0.4518 "
"Smokey Grindel" <nospam@.nospam.com> wrote in message
news:uuYkGzrWHHA.488@.TK2MSFTNGP06.phx.gbl...
>I really just do not understand this and it is really frustrating me... I
>made a custom authentication/authorization extension that uses forms
>authentication... it works fine on my local system (32bit windows xp pro
>sp2 with SQL 2005 Dev SP2)... So I installed it onto our development test
>server running SQL 2005 Dev edition SP2 (32bit windows server 2003) works
>great! figure ok its working! now I go to our master setup, which is like
>this
> Active/Passive failover cluster with shared storage on a SAN... 2 node
> cluster... both running windows server 2003 64bit! SQL Server is
> clustered, but we dont care much about reporting services being fail over
> because they fail so infrequently.. so I do all the same stuff I do to
> install it on the 32bit server... now this is what happends
>
> I open up http://sqlvirtualhost/Reports (sqlvirtualhost is the virtual
> cluster name we gave the sql server instance) it goes to the report server
> logon screen, I login, that works fine... I get a list of reports, ok
> great! seems to be working! I click on a report... boom problem... gives
> me a .net assembly name that has Microsoft.ReportingService.xxxxx in
> (xxxx changes sometimes usually Modeling or Design seems like?) anyways it
> says Access Denied is the error and thats it! I cant figure out what is
> denied access or what is causing it... this same thing with the same
> config works great on the two 32bit systems! the assembly is compiled for
> "AutoCPU" to let .NET framework auto compile it to 32 or 64bit on
> demand... im ripping out my hair here, can anyone help me or give me some
> direction on what to do or look for? THANKS A LOT!
>|||you have this error when you have reporting service with sharepoint services
on?
did you have this issue still? i have the same issue and i solved it by
adding the report server url in sharepoint server exlude list..
- Bava
"Smokey Grindel" wrote:
> I added the computer in the domain to the security list that sharepoint
> services is on and now the message changed to this "HTTP/1.1 404 Connection:
> close Date: Wed, 28 Feb 2007 21:42:58 GMT Server: Microsoft-IIS/6.0
> X-Powered-By: ASP.NET MicrosoftSharePointTeamServices: 12.0.0.4518 "
>
> "Smokey Grindel" <nospam@.nospam.com> wrote in message
> news:uuYkGzrWHHA.488@.TK2MSFTNGP06.phx.gbl...
> >I really just do not understand this and it is really frustrating me... I
> >made a custom authentication/authorization extension that uses forms
> >authentication... it works fine on my local system (32bit windows xp pro
> >sp2 with SQL 2005 Dev SP2)... So I installed it onto our development test
> >server running SQL 2005 Dev edition SP2 (32bit windows server 2003) works
> >great! figure ok its working! now I go to our master setup, which is like
> >this
> >
> > Active/Passive failover cluster with shared storage on a SAN... 2 node
> > cluster... both running windows server 2003 64bit! SQL Server is
> > clustered, but we dont care much about reporting services being fail over
> > because they fail so infrequently.. so I do all the same stuff I do to
> > install it on the 32bit server... now this is what happends
> >
> >
> > I open up http://sqlvirtualhost/Reports (sqlvirtualhost is the virtual
> > cluster name we gave the sql server instance) it goes to the report server
> > logon screen, I login, that works fine... I get a list of reports, ok
> > great! seems to be working! I click on a report... boom problem... gives
> > me a .net assembly name that has Microsoft.ReportingService.xxxxx in
> > (xxxx changes sometimes usually Modeling or Design seems like?) anyways it
> > says Access Denied is the error and thats it! I cant figure out what is
> > denied access or what is causing it... this same thing with the same
> > config works great on the two 32bit systems! the assembly is compiled for
> > "AutoCPU" to let .NET framework auto compile it to 32 or 64bit on
> > demand... im ripping out my hair here, can anyone help me or give me some
> > direction on what to do or look for? THANKS A LOT!
> >
>
>|||any update on this issue? please let me know how do you resolve the issue.
"Bava Mani" wrote:
> you have this error when you have reporting service with sharepoint services
> on?
> did you have this issue still? i have the same issue and i solved it by
> adding the report server url in sharepoint server exlude list..
> - Bava
> "Smokey Grindel" wrote:
> > I added the computer in the domain to the security list that sharepoint
> > services is on and now the message changed to this "HTTP/1.1 404 Connection:
> > close Date: Wed, 28 Feb 2007 21:42:58 GMT Server: Microsoft-IIS/6.0
> > X-Powered-By: ASP.NET MicrosoftSharePointTeamServices: 12.0.0.4518 "
> >
> >
> > "Smokey Grindel" <nospam@.nospam.com> wrote in message
> > news:uuYkGzrWHHA.488@.TK2MSFTNGP06.phx.gbl...
> > >I really just do not understand this and it is really frustrating me... I
> > >made a custom authentication/authorization extension that uses forms
> > >authentication... it works fine on my local system (32bit windows xp pro
> > >sp2 with SQL 2005 Dev SP2)... So I installed it onto our development test
> > >server running SQL 2005 Dev edition SP2 (32bit windows server 2003) works
> > >great! figure ok its working! now I go to our master setup, which is like
> > >this
> > >
> > > Active/Passive failover cluster with shared storage on a SAN... 2 node
> > > cluster... both running windows server 2003 64bit! SQL Server is
> > > clustered, but we dont care much about reporting services being fail over
> > > because they fail so infrequently.. so I do all the same stuff I do to
> > > install it on the 32bit server... now this is what happends
> > >
> > >
> > > I open up http://sqlvirtualhost/Reports (sqlvirtualhost is the virtual
> > > cluster name we gave the sql server instance) it goes to the report server
> > > logon screen, I login, that works fine... I get a list of reports, ok
> > > great! seems to be working! I click on a report... boom problem... gives
> > > me a .net assembly name that has Microsoft.ReportingService.xxxxx in
> > > (xxxx changes sometimes usually Modeling or Design seems like?) anyways it
> > > says Access Denied is the error and thats it! I cant figure out what is
> > > denied access or what is causing it... this same thing with the same
> > > config works great on the two 32bit systems! the assembly is compiled for
> > > "AutoCPU" to let .NET framework auto compile it to 32 or 64bit on
> > > demand... im ripping out my hair here, can anyone help me or give me some
> > > direction on what to do or look for? THANKS A LOT!
> > >
> >
> >
> >

Need help writing a custom View in Sql Server

Does anyone knowif the following sql view is possible to write and execute as a view script?

**********find employee matching the given UserID*************
SELECT * FROM Employees WHERE EmployeeID=@.UserID

***********find client matching the given ClientID**********
SELECT *FROM Clients WHERE ClientID=@.ClientID

**********findall contacts and events associated with ClientID*********
SELECT *FROM Contacts WHERE Contact.ClientID=@.ClientID
SELECT *FROM Events WHERE Event.ClientID=@.ClientID

*********selectall audits with Key values matching the primary keys of each client, contact orevent*********
SELECT *FROM Audit Where Key In (Client.ClientID, Contact.ContactID, Event.EventID)

I basicallyneed to find a employee based on its ID. Then I need to find any records from the table Auditwith Key values matching the given fields in the results of any clients, contacts events that were returned from the previous select statements. Is this possible?

You need list all your table's schema. If they are related, you can write a query with JOINs and put into a view.|||Well I don't want to JOIN them. I just want to select certain items out of the Audit table based on the key values taken from records retrieved from Clients, Contacts and Events. I just need to return records matching the schema in Audit, nothing else.|||

You could do something like this: If this is not what you are looking for you need to detail the structure of each of the tables and the columns that would be used in the [Key] column in the Audit table.

Declare @.table table (KeyIdint)INSERT INTO @.table SELECT <column>FROM EmployeesWHERE EmployeeId = @.UserIdINSERT INTO @.table SELECT <column>FROM ClientsWHERE ClientID=@.ClientIDINSERT INTO @.table SELECT <column>FROM ContactsWHERE Contact.ClientID=@.ClientIDINSERT INTO @.table SELECT <column>FROM EventsWHERE ClientID=@.ClientIDSELECT *FROM AuditWHERE [Key]In (SELECT KeyIdFROM @.table)

|||

You can format and execute a string similar to:

CREATE VIEW MyView as Select * from MyTable where ID = 55

But the view will be hardcoded to the ID of 55...probably not very useful.

A view itself cannot take parameters but I read that you can do it with user-defined functions.

|||

If you need to pass a parameter to it you need to use a stored procedure, not a view.