"Other" rdlc designer

I want to give the ability to my customers to design the reports, without
installing Vs2005 to use its designer, since they are not developers... Is
there some tool that allows me to design rdlc outside of Vs2005 ide?
Thanks in advance.RS2005 comes with Report Builder which allows users to make their own
reports. First you create a database "model" and put on the Report Server
for the users. Then users access Report Builder through Report Manager in a
Web browser. Users can save their report definitions; however, the .rdl
files from Report Builder do not seem to be interchangeable with the .rdl
files produced by Visual Studio.
"Fabio Pagano" <fpagano@.apsystem.it> wrote in message
news:%23ffeIRrQGHA.1204@.TK2MSFTNGP12.phx.gbl...
>I want to give the ability to my customers to design the reports, without
> installing Vs2005 to use its designer, since they are not developers... Is
> there some tool that allows me to design rdlc outside of Vs2005 ide?
> Thanks in advance.
>|||"Bill Miller" <graniteboulder59@.yahoo.com> wrote in message
news:O%23qybEsQGHA.1556@.TK2MSFTNGP09.phx.gbl...
> RS2005 comes with Report Builder which allows users to make their own
> reports.
--CUT--
Thanks, but i use rdlc files (not rdl) which are in "local processing" mode
(that is, without reporting services). So i was searching for a designer for
rdlc files, not rdl.|||rdlc files are the same thing as RS 2005 (not RS 2000) rdl files. All you
have to do is take a rdl file and rename it to rdlc. As a matter of fact,
the designer is so much better in the RS 2005 designer that I design and
test the report there (for instance it has a preview tab) and then I bring
it into my project.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Fabio Pagano" <fpagano@.apsystem.it> wrote in message
news:eVuhlctQGHA.4384@.tk2msftngp13.phx.gbl...
> "Bill Miller" <graniteboulder59@.yahoo.com> wrote in message
> news:O%23qybEsQGHA.1556@.TK2MSFTNGP09.phx.gbl...
>> RS2005 comes with Report Builder which allows users to make their own
>> reports.
> --CUT--
> Thanks, but i use rdlc files (not rdl) which are in "local processing"
> mode
> (that is, without reporting services). So i was searching for a designer
> for
> rdlc files, not rdl.
>|||"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:esWgImtQGHA.5808@.TK2MSFTNGP12.phx.gbl...
> rdlc files are the same thing as RS 2005 (not RS 2000) rdl files. All you
> have to do is take a rdl file and rename it to rdlc.
Ok, but how can i give the customer (that is not a developer nor has
sqlserver 2005 or reporting services) the capability to modify the rdlc
file?|||see http://www.cizer.com/portalcsvs/DesktopDefault.aspx
that is a commercial tool without the need for Visual Studio.
Another option you have is - take the RDL specification and write your
custom program which can author RDL files triggered by user inputs or
events.

"Not enough server storage is available to process this command"

Hi,
We have several customers using replication on similar databases - all with the same schema, published using essentially the same script. One of them has been getting the "Not enough server storage" message when they try to access any network shares on th
e server with the published database on it. This starts happening between 24-36 hours after they first run the snapshot agent.
The application log contains an entry saying "The process could not create file \\[SERVER]\REPLDATA\unc",
and the system log has one saying "The server was unable to allocate from the system paged pool because the pool was empty".
When they turn off the replication everything is fine.
I suggested increasing the IRPStackSize value in the registry, as this was mentioned in the closest article I could find on MSDN/KB (something about Norton AntiVirus), but this didn't make any difference.
This is SQL Server 2000 running on Windows 2000 Server, all with up-to-date service packs.
Any ideas or suggestions would be appreciated.
Mark
from your earlier post i understand that the snapshot creation part gives
out this message.
If the error occurs while the snapshot is being generated, check the
following"
1. Check if the sql server service account has appropriate NTFS and share
level permissions to write to the repldata directory.
2. Check if there is enough storage space on the disk for creating files
in repldata directory.
3. Check if you can run xp_cmdshell "dir
\\distributorname\c$\mssql\repldata"
and dir \\distributor\c$\mssql\repldata from command prompt.
If the error occurs after the snapshot has been completely generated, Refer
-
* KB : 285089 IRPStackSize Parameter in Windows 2000
http://support.microsoft.com/?id=285089
Pls do let me know of the SQL server version (build number). and the event
id's of the event log messages.
Does this message stop replication? are the subscribers and publisher in
sync? - Just to confirm if this message is obstructing replication from
being in sync.

"Invalid Cursor State" - REPOST

MS-SQL 2000, Service Pack 3a and 4
I have customers that are starting to get "Invalid Cursor State" messages
returned from my Clarion MS-SQL. based application.
It appears to happen when i am issuing a "SELECT SUM(TOTAL) FROM..."
statement, but i can be sure of that. I cant pinpoint when the problem
starts. The solution has been to close the screen im on, which closes
connection to the database.
Where can i start to look for this problem?
TIA
Tim MorrisonTim Morrison wrote:
> I have customers that are starting to get "Invalid Cursor State"
> messages returned from my Clarion MS-SQL. based application.
>
Tried reading this article?
http://support.microsoft.com/kb/831997
- Peter
--
Hi! I'm a .signature *virus*!
Copy me into your ~/.signature to help me spread!|||Yup. SP4 is applied to the machine giving me the most problems. It does
however happen to SP3a machines as well.
Tim
"Peter Lykkegaard" <plykkegaard@.nospam.nospam> wrote in message
news:eZOsIYKPHHA.1248@.TK2MSFTNGP02.phx.gbl...
> Tim Morrison wrote:
>> I have customers that are starting to get "Invalid Cursor State"
>> messages returned from my Clarion MS-SQL. based application.
> Tried reading this article?
> http://support.microsoft.com/kb/831997
> - Peter
> --
> Hi! I'm a .signature *virus*!
> Copy me into your ~/.signature to help me spread!
>

"Invalid Cursor State" - REPOST

MS-SQL 2000, Service Pack 3a and 4
I have customers that are starting to get "Invalid Cursor State" messages
returned from my Clarion MS-SQL. based application.
It appears to happen when i am issuing a "SELECT SUM(TOTAL) FROM..."
statement, but i can be sure of that. I cant pinpoint when the problem
starts. The solution has been to close the screen im on, which closes
connection to the database.
Where can i start to look for this problem?
TIA
Tim Morrison
Yup. SP4 is applied to the machine giving me the most problems. It does
however happen to SP3a machines as well.
Tim
"Peter Lykkegaard" <plykkegaard@.nospam.nospam> wrote in message
news:eZOsIYKPHHA.1248@.TK2MSFTNGP02.phx.gbl...
> Tim Morrison wrote:
> Tried reading this article?
> http://support.microsoft.com/kb/831997
> - Peter
> --
> Hi! I'm a .signature *virus*!
> Copy me into your ~/.signature to help me spread!
>

"Invalid Cursor State" - REPOST

MS-SQL 2000, Service Pack 3a and 4
I have customers that are starting to get "Invalid Cursor State" messages
returned from my Clarion MS-SQL. based application.
It appears to happen when i am issuing a "SELECT SUM(TOTAL) FROM..."
statement, but i can be sure of that. I cant pinpoint when the problem
starts. The solution has been to close the screen im on, which closes
connection to the database.
Where can i start to look for this problem?
TIA
Tim MorrisonTim Morrison wrote:

> I have customers that are starting to get "Invalid Cursor State"
> messages returned from my Clarion MS-SQL. based application.
>
Tried reading this article?
http://support.microsoft.com/kb/831997
- Peter
Hi! I'm a .signature *virus*!
Copy me into your ~/.signature to help me spread!|||Yup. SP4 is applied to the machine giving me the most problems. It does
however happen to SP3a machines as well.
Tim
"Peter Lykkegaard" <plykkegaard@.nospam.nospam> wrote in message
news:eZOsIYKPHHA.1248@.TK2MSFTNGP02.phx.gbl...
> Tim Morrison wrote:
>
> Tried reading this article?
> http://support.microsoft.com/kb/831997
> - Peter
> --
> Hi! I'm a .signature *virus*!
> Copy me into your ~/.signature to help me spread!
>

"Ghost" primary key column

Hello,
I have a table 'customers', with 2 records:

SELECT * FROM customers;
customerID | customerName
------+--------
myFriend | myFriend's Name
test | testing user
(2 rows)

but when I'm asking about customerID column, I get the answer:

SELECT customerID FROM customers;
ERROR: column "customerid" does not exist

What happens? I'm using PostgreSQL 8.1.3>> What happens? I'm using PostgreSQL 8.1.3 <<

Why are you positng to a SQL Server Newsgroup? And why did you fail to
provide DDL, anyway?|||(chrisek@.poczta.neostrada.pl) writes:
> I have a table 'customers', with 2 records:
> SELECT * FROM customers;
> customerID | customerName
> ------+--------
> myFriend | myFriend's Name
> test | testing user
> (2 rows)
> but when I'm asking about customerID column, I get the answer:
> SELECT customerID FROM customers;
> ERROR: column "customerid" does not exist
> What happens? I'm using PostgreSQL 8.1.3

The interesting part is that your sample output has customerID, and
so has the your query that generates the error message. But the
message complains that "customerid" in all lower case is missing!

Either PostgreSQL is a very strange beast, or your actual query
used "customerid" and PostgreSQL is case-sensitive, just like
MS SQL Server may be depending on the collation. I will have to admit
that my bets are on the latter.

And, no, I don't mention MS SQL Server on a whim. This newsgroups
is devoted to MS SQL Server, and not very packed with people who
can assist you with PostgreSQL.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx|||"--CELKO--" <jcelko212@.earthlink.net> wrote in message
news:1151263386.915461.288040@.p79g2000cwp.googlegr oups.com...
>>> What happens? I'm using PostgreSQL 8.1.3 <<
> Why are you positng to a SQL Server Newsgroup?

Who knows why people post non-SQL Server-related stuff to an MS SQL Server
newsgroup? It seems to happen an *awful* lot these days though.|||"--CELKO--" <jcelko212@.earthlink.net> wrote in message
news:1151263386.915461.288040@.p79g2000cwp.googlegr oups.com...
> >> What happens? I'm using PostgreSQL 8.1.3 <<
> Why are you positng to a SQL Server Newsgroup? And why did you fail to
> provide DDL, anyway?

I suspect they're the same answer. Not knowing better.

In any case, I think Erland was able to at least try to help.