how to create report without Report wizard

Hi,

Whenever I tried creating reports under-->BUsiness Intelligence Projects-->REport wizard or Report type.Everytime Report wizard opens.What i am trying to say is I want to build manually(Like in crytsal reports).But I don't see any option.One more Question---Once after Designing the table in Report Wizard,like Page fields,Group fields,Diaplay Fields,Is there any option that I can add more fields OR Change Existing fields.Do I have to do in Report designer Layout??I don't see any option for doing in SSRS 2000.Sorry for small questions,I am very new to SSRS2000 ,and programming too.Thank you.

HI,srijyothi:

You can check out this article about:

Generate Ad-hoc Reports with Microsoft Reporting Services 2005

http://www.devx.com/dbzone/Article/28047/1954?pf=true

This response contains a reference to a third party World Wide Web site. Microsoft is providing this information as a

convenience to you. Microsoft does not control these sites and has not tested any software or information found on these

sites; therefore, Microsoft cannot make any representations regarding the quality, safety, or suitability of any software or

information found there. There are inherent dangers in the use of any software found on the Internet, and Microsoft cautions

you to make sure that you completely understand the risk before retrieving any software from the Internet.

If i misunderstand you about your question, please feel free to correct me and i will try to help you with more information.

I hope the above information will be helpful. If you have any issues or concerns, please let me know. It's my pleasure to be of assistance

|||

HI,srijyothi:

We are marking this issue as "Answered". If you have any new findings or concerns, please feel free to unmark the issue.
Thank you for your understanding!

How to create image field?

Hello,
I would like to store some images in an msde table. When I go into the
enterprise manager design table mode and pick image as a field type, it
defaults to 16 bytes in size, and doesn't allow me to change the size. I
can't create a varbinary field greater than 8000 bytes either. The msde
instance is a recent install downloaded fresh from Microsoft, so it is the
current version (but for the life of me I can't figure out how to determine
the version #).
I've also tried using a shareware package called MSDE manager, but with the
same results.
How do I create an image field of 50K, for example?
thanks
Marc Pelletier
Hi,
It is not an issue, By default it will take bytes. Image data type will
allow you store a maximum of 2 GB. No need to change any thing
VARBINARY will allow a maximum of bytes.
Thanks
Hari
SQL Server MVP
"Marc Pelletier" <no.email@.please.com> wrote in message
news:Xns959A92CA0DCBAmpdd445@.216.168.3.44...
> Hello,
> I would like to store some images in an msde table. When I go into the
> enterprise manager design table mode and pick image as a field type, it
> defaults to 16 bytes in size, and doesn't allow me to change the size. I
> can't create a varbinary field greater than 8000 bytes either. The msde
> instance is a recent install downloaded fresh from Microsoft, so it is the
> current version (but for the life of me I can't figure out how to
> determine
> the version #).
> I've also tried using a shareware package called MSDE manager, but with
> the
> same results.
> How do I create an image field of 50K, for example?
> thanks
> Marc Pelletier
|||"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in news:eFR6PmUxEHA.1264
@.TK2MSFTNGP12.phx.gbl:

> It is not an issue, By default it will take bytes. Image data type will
> allow you store a maximum of 2 GB. No need to change any thing
> VARBINARY will allow a maximum of bytes.
>
I don't mean to look a gift horse in the mouth, but you haven't told me
anything. Do you mean to say that even though it appears to be 16 bytes, I
can actually stuff whatever I want in there? That doesn't seem likely.
cheers
Marc Pelletier
|||> I don't mean to look a gift horse in the mouth, but you haven't told me
> anything. Do you mean to say that even though it appears to be 16 bytes, I
> can actually stuff whatever I want in there? That doesn't seem likely.
Stop looking at enterprise manager to "tell you anything." The 16 bytes
represents a pointer to the data, not the actual data. Hari was not lying
when he said that you can store ~2 GB of data in there...
|||Typically, all that is stored in the data row for image, text, or ntext
columns is a 16 byte pointer to where the actual data is stored. You can
store up to 2GB of data for each data value using these data types.
For more information about how the data for these data types are stored,
see:
http://msdn.microsoft.com/library/?u...asp?frame=true
http://msdn.microsoft.com/library/?u...asp?frame=true
http://msdn.microsoft.com/library/?u...asp?frame=true
Alan Brewer [MSFT]
Content Architect
SQL Server Documentation Team
This posting is provided "AS IS" with no warranties, and confers no rights
|||"Aaron [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in
news:#l6OeKbxEHA.2876@.TK2MSFTNGP12.phx.gbl:

> Stop looking at enterprise manager to "tell you anything." The 16
> bytes represents a pointer to the data, not the actual data. Hari was
> not lying when he said that you can store ~2 GB of data in there...
>
Ok, thanks, I didn't think he was lying ( and if I gave that impression,
sorry). That being the case, how come varbinary allows me to set the size
up to 8000, when it also has a limit of ~2G? How would I define my field
to store a large amount of data?
I'm guessing that under the hood they are essentially the same type,
since I could stream any binary data into an image field anyway, couldn't
I?
thanks
Marc Pelletier
|||> sorry). That being the case, how come varbinary allows me to set the size
> up to 8000, when it also has a limit of ~2G?
Who said varbinary has a limit of ~2 GB?

> How would I define my field
> to store a large amount of data?
Using the IMAGE datatype, not VARBINARY.

> I'm guessing that under the hood they are essentially the same type,
> since I could stream any binary data into an image field anyway, couldn't
> I?
I'm not going to presume to know exactly how the engine works with these
types. But I know that they are stored at least slightly differently,
similar to VARCHAR(8000) and TEXT (even though, deep down, they are both
just storing text).
|||"Aaron [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in
news:O0zalzcxEHA.2568@.TK2MSFTNGP10.phx.gbl:

> Who said varbinary has a limit of ~2 GB?
>
Well... I did. But I shouldn't have. If it isn't clear already, I'm new to
sql server. I generally vigorously avoid database programming, but can't
avoid it for my current project.
Thanks for the help, everyone. I think I'm away for now.
Marc
|||Hello,
I am new to databases. But i dont understand how one could store a picture
in a cell in a database? Or do you mean that there is a link to the picture
in the cell?
Thanks
WStoreyII
"Marc Pelletier" wrote:

> Hello,
> I would like to store some images in an msde table. When I go into the
> enterprise manager design table mode and pick image as a field type, it
> defaults to 16 bytes in size, and doesn't allow me to change the size. I
> can't create a varbinary field greater than 8000 bytes either. The msde
> instance is a recent install downloaded fresh from Microsoft, so it is the
> current version (but for the life of me I can't figure out how to determine
> the version #).
> I've also tried using a shareware package called MSDE manager, but with the
> same results.
> How do I create an image field of 50K, for example?
> thanks
> Marc Pelletier
>
|||=?Utf-8?B?V1N0b3JleUlJ?= <WStoreyII@.discussions.microsoft.com> wrote in
news:54836FEC-DDCB-4F80-85F0-13F580D4C292@.microsoft.com:

> I am new to databases. But i dont understand how one could store a
> picture in a cell in a database? Or do you mean that there is a link
> to the picture in the cell?
>
WStorey,
The image is stored as a binary stream directly in a blob (binary large
object, I think ) field of the database. It adds a substantial overhead to
the process, and I think that in many cases it is better to store the image
on disk and store a reference to it in the db, as you have suggested.
However it is what I am going to do. In my case the number ( and size) of
images will be fairly small and dynamic, maybe a couple of thousand, and
will be accessed a lot, so I expext the sql server cacheing to help with
the performance hit.
The how is explained quite clearly in
http://support.microsoft.com/default...en-us;309158#1
for the csharp case.
Hope this helps.
Marc Pelletier

How to Create a system Type Table/ change User table to System Table.

Is there any Posibility to change a User Table to System Table.

How to create one system table.

I am in Big mess that One of the Table I am using is in System Type.

I cant Index the same. Is there any Mistake we can change a user table to system table.....

You can do it, but I am not sure it is that great of an idea to do. You have to allow system updates on your server, and update some system tables to allow this (SQL 2000). What problem are you facing?|||

I am not trying to create a system table.

Unfortunately my user table is in System type.

Having Enough data in that.

so I want to bring back to the User Table type.

|||are you using sql 2000?|||

ya I am using sql 2000. Is there any possibility of this happening?

How to Revert Back?

|||

Yes, you can revert the object back from being a system table. You have to manually edit the sysobjects table, and remove the system object bit from the status column.

Here is a thread in which I show how to update the sysobjects table.

http://www.tek-tips.com/viewthread.cfm?qid=1267568&page=1

This should not be done by someone who isn't comfertable making changes to the system tables manually. If this isn't done correctly you could loose the table or database. Be sure to backup the database before making this change so that you can restore if it doesn't go well.

It is recommended that you never mark user created procedures as system procedures as this fix doesn't work in SQL Server 2005 and up.

|||

Thanks For ur Information.....

can u tell me any possibility of this happen a guess? because I cant Figure it out......

|||Someone had to manually set the table to be a system table, either by editing the sysobjects table directly, or by using the procedure which Microsoft provides which makes this change.

How to create a datasource which Connection type is SQL Server Anlysis Service in rss script?

I am making a rss script to deploy the reports and datasources.
I need to create a datasource which Connection type is SQL Server Anlysis Service. Thanks.

Does anyone know that? Or I am asking a stupid question?|||

I assume this has already been resolved but for anyone else;

Create a Datasouce in VS (or BIDS) of the Connection Type that you require and then open up the resulting .rds to

view the resulting connection type code.

i.e. For Analysis Services Connection Types

<Extension>OLEDB-MD</Extension> = Extension Code is "OLEDB-MD"

How to create a datasource which Connection type is SQL Server Anlysis Service in rss script?

I am making a rss script to deploy the reports and datasources.
I need to create a datasource which Connection type is SQL Server Anlysis Service. Thanks.

Does anyone know that? Or I am asking a stupid question?|||

I assume this has already been resolved but for anyone else;

Create a Datasouce in VS (or BIDS) of the Connection Type that you require and then open up the resulting .rds to

view the resulting connection type code.

i.e. For Analysis Services Connection Types

<Extension>OLEDB-MD</Extension> = Extension Code is "OLEDB-MD"

How to create 3 users tables?

Hello,

In my web site I have 2 types of users: students and professors.
All users need to login but the personal information for each user type has different fields.

So I create 3 tables: professors, students and authentication,
"professors" will have all the personal data from professors.
"students" will have all the personal data from students.
authentication will have the username and password from all users.

How can i link authentication table to both professors and students tables so when the user logins i get the data from that user, either a professor or student?

And is the right way to do this?

I am using SQL 2005 and Asp.Net 2.0

Thanks,
Miguel

Since students are associated with their professors and vice versa, I would create the realtionship as follows:

Table: Staff
Columns: StaffID, FirstName, LastName, Username, Password

Table: Students
Columns: StudentID, FirstName, LastName, Username, Password

Table: StudentsStaff
Columns: StaffID, StudentID

Each time a student is assigned to a professor, the database will add to the StudentsStaff table the ID of the student and the ID of the professor. Then you will be able to get data representing all the professors a student is enrolled with and all the students a professor has enrolled.

How to cotrol format of datetime attributes?

There is an attribute that have type DateTime, based on the field type in data source. It hasn't separate name column. The member caption is formatted as yyyy-MM-dd hh:mm:ss. Can I control the format of Member name without giving separate name column.

I assigned different format in the format field of key property window, but it had no effect. What I did wrong?

Hello. I do not think that you will have to pay any penalty from adding a new column in the data source view with a new format of your date column. I recommend to use the TSQL function CONVERT that have arguments for different date formats. Have a look at CONVERT in Books On Line, and you will see the complete list of different codes/arguments for different date formats.

HTH

Thomas Ivarsson

|||

Thank you,

I thought about more sofisticated solution, that can be used in multi culture environment without adding x additional fields with "formatting" of a datetime attribute.

I hoped, that the AS2005 is smarter as AS2005 and offers more possibilties.

Do you know what is the format field in key properties for?