Classic ASP in Report Manager

Can I run classic asp pages in the report manager?
I'm implementing a multi-value select report which works fine using a
standard html page. I want to serive my values from a database however
and am therefor using asp. The asp page will display in the report
manager but the code will not run.
Thoughts?
Thanks!I had uploaded the asp page to the report manager. Keeping the page
outside report manager did the trick.
-J|||You would need to add the correct script mappings to the Report Manager
virtual directory. We do not add .asp mappings by default.
--
Brian Welcker
Group Program Manager
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Jim" <emailjeffp@.yahoo.com> wrote in message
news:1114279221.384407.35000@.z14g2000cwz.googlegroups.com...
>I had uploaded the asp page to the report manager. Keeping the page
> outside report manager did the trick.
> -J
>

clarification on Reporting services

hi folks,

I want to display a message "no records retrieved" in the preview tab of the report in RS when no records are retrieved for a query specified in the data tab of the report in RS.Is there any custom code for this?How to accomplish this?Can anyone help me find a solution for this?Pls send me the procedure for this .

You could:

1. Set the message in the NoRows property of the data region bound to the dataset.

2. Display the message in a textbox which is hidden if the dataset has rows or visible otherwise.

|||

Dear sir,

Thank you for your reply..I was successful with the first point.Can u tell me how to proceed with the second point?

How to display the message in the textbox?should i type something in the textbox value property?if so how?

Regards

Balaji

|||Drop a textbox in the report body with the desired text, e.g. "No data". Set the textbox Visibility Hidden expression to =IsNothing(First(Fields!<some field name>.Value, "<your dataset name>")) = Falsesqlsql

clarification on Reporting services

hi folks,

I want to display a message "no records retrieved" in the preview tab of the report in RS when no records are retrieved for a query specified in the data tab of the report in RS.Is there any custom code for this?How to accomplish this?Can anyone help me find a solution for this?Pls send me the procedure for this .

You could:

1. Set the message in the NoRows property of the data region bound to the dataset.

2. Display the message in a textbox which is hidden if the dataset has rows or visible otherwise.

|||

Dear sir,

Thank you for your reply..I was successful with the first point.Can u tell me how to proceed with the second point?

How to display the message in the textbox?should i type something in the textbox value property?if so how?

Regards

Balaji

|||Drop a textbox in the report body with the desired text, e.g. "No data". Set the textbox Visibility Hidden expression to =IsNothing(First(Fields!<some field name>.Value, "<your dataset name>")) = False

City, State expression problem!

I have a report which lists the city and state. The problem is that
the city and state are in one field and were in Upper case. I used the
strconv but I don't know how to make the state portion Upper instead or
Proper.
Right now the output looks like this: Birminham, Al
Any help is appreciated.Try the following:
select replace(ColName,right(ColName,1), Upper(right(ColName,1)))
Good Luck
swtjen01 wrote:
> I have a report which lists the city and state. The problem is that
> the city and state are in one field and were in Upper case. I used the
> strconv but I don't know how to make the state portion Upper instead or
> Proper.
> Right now the output looks like this: Birminham, Al
> Any help is appreciated.

ChunkData table is growing!

Hi,
I have a report that refers to lots of external images (200+ each
run). I've been taking a snapshot of this report so that it's quicker
for users. I've limited the history to 1 snapshot. However, it appears
that the images are being cached in the ChunkData table (in the
ReportServer database) and that the data isn't automatically purged
once the snapshot no longer exists. Is there any way to manually purge
unused data?
Thanks,
CamelIf you look in the Reporting Services log files you should see a line like
this:
w3wp!library!1!10/2/2007-09:50:47:: i INFO: Cleaned 0 batch records, 0
policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running
jobs, 0 persisted streams
Thats the process that runs that will clean up those tables. If those items
are no longer needed then you'll see "15 chunks" cleaned or some such in
that log message. If they are necessary then they will not be cleaned.
Most of the stuff in the tables in the TempDB database can be cleaned out
without hurting anything though so if you want you can shutdown the SRS
Service and wipe those tables clean and you should be ok.
--
Chris Alton, Microsoft Corp.
SQL Server Developer Support Engineer
This posting is provided "AS IS" with no warranties, and confers no rights.
--
> From: Camel <hamishmurphy@.gmail.com>
> Newsgroups: microsoft.public.sqlserver.reportingsvcs
> Subject: ChunkData table is growing!
> Date: Fri, 05 Oct 2007 05:17:09 -0000
> Organization: http://groups.google.com
> Hi,
> I have a report that refers to lots of external images (200+ each
> run). I've been taking a snapshot of this report so that it's quicker
> for users. I've limited the history to 1 snapshot. However, it appears
> that the images are being cached in the ChunkData table (in the
> ReportServer database) and that the data isn't automatically purged
> once the snapshot no longer exists. Is there any way to manually purge
> unused data?
> Thanks,
> Camel
>|||Hi Chris,
Thanks for your reply. I've checked the log out and found the
following exception:
3wp!dbcleanup!1e68!8/10/2007-16:30:20:: e ERROR: Sql Error in
CleanOrphanedSnapshots: System.Data.SqlClient.SqlException: Timeout
expired. The timeout period elapsed prior to completion of the
operation or the server is not responding.
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior
cmdBehavior, RunBehavior runBehavior, Boolean returnStream)
at System.Data.SqlClient.SqlCommand.ExecuteReader()
at
Microsoft.ReportingServices.Library.InstrumentedSqlCommand.ExecuteReader()
at
Microsoft.ReportingServices.Library.DatabaseSessionStorage.CleanOrphanedSnapshots(Int32&
chunksCleaned)
w3wp!library!1e68!8/10/2007-16:30:20:: i INFO: Cleaned 0 batch
records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
chunks, 0 running jobs
Any ideas why this would be the case?
Camel
On Oct 6, 12:55 am, cal...@.online.microsoft.com (Chris Alton [MSFT])
wrote:
> If you look in the Reporting Services log files you should see a line like
> this:
> w3wp!library!1!10/2/2007-09:50:47:: i INFO: Cleaned 0 batch records, 0
> policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running
> jobs, 0 persisted streams
> Thats the process that runs that will clean up those tables. If those items
> are no longer needed then you'll see "15 chunks" cleaned or some such in
> that log message. If they are necessary then they will not be cleaned.
> Most of the stuff in the tables in the TempDB database can be cleaned out
> without hurting anything though so if you want you can shutdown the SRS
> Service and wipe those tables clean and you should be ok.
> --
> Chris Alton, Microsoft Corp.
> SQL Server Developer Support Engineer
> This posting is provided "AS IS" with no warranties, and confers no rights.
> --
> > From: Camel <hamishmur...@.gmail.com>
> > Newsgroups: microsoft.public.sqlserver.reportingsvcs
> > Subject: ChunkData table is growing!
> > Date: Fri, 05 Oct 2007 05:17:09 -0000
> > Organization:http://groups.google.com
> > Hi,
> > I have a report that refers to lots of external images (200+ each
> > run). I've been taking a snapshot of this report so that it's quicker
> > for users. I've limited the history to 1 snapshot. However, it appears
> > that the images are being cached in the ChunkData table (in the
> > ReportServer database) and that the data isn't automatically purged
> > once the snapshot no longer exists. Is there any way to manually purge
> > unused data?
> > Thanks,
> > Camel|||That usually means you are having a performance issue on the SQL Server
database that is causing it not to return data in the 30 second command
timeout window. It could also be blocking on the SQL Server as well.
Check and see if there are any SPIDs out there that are blocking other
processes.
I'd check your SQL Server Activity and see if there is anything that could
be causing this.
--
Chris Alton, Microsoft Corp.
SQL Server Developer Support Engineer
This posting is provided "AS IS" with no warranties, and confers no rights.
--
> From: Camel <hamishmurphy@.gmail.com>
> Newsgroups: microsoft.public.sqlserver.reportingsvcs
> Subject: Re: ChunkData table is growing!
> Date: Mon, 08 Oct 2007 23:20:17 -0000
> Hi Chris,
> Thanks for your reply. I've checked the log out and found the
> following exception:
> 3wp!dbcleanup!1e68!8/10/2007-16:30:20:: e ERROR: Sql Error in
> CleanOrphanedSnapshots: System.Data.SqlClient.SqlException: Timeout
> expired. The timeout period elapsed prior to completion of the
> operation or the server is not responding.
> at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior
> cmdBehavior, RunBehavior runBehavior, Boolean returnStream)
> at System.Data.SqlClient.SqlCommand.ExecuteReader()
> at
> Microsoft.ReportingServices.Library.InstrumentedSqlCommand.ExecuteReader()
> at
>
Microsoft.ReportingServices.Library.DatabaseSessionStorage.CleanOrphanedSnap
shots(Int32&
> chunksCleaned)
> w3wp!library!1e68!8/10/2007-16:30:20:: i INFO: Cleaned 0 batch
> records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
> chunks, 0 running jobs
> Any ideas why this would be the case?
> Camel
> On Oct 6, 12:55 am, cal...@.online.microsoft.com (Chris Alton [MSFT])
> wrote:
> > If you look in the Reporting Services log files you should see a line
like
> > this:
> > w3wp!library!1!10/2/2007-09:50:47:: i INFO: Cleaned 0 batch records, 0
> > policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running
> > jobs, 0 persisted streams
> >
> > Thats the process that runs that will clean up those tables. If those
items
> > are no longer needed then you'll see "15 chunks" cleaned or some such in
> > that log message. If they are necessary then they will not be cleaned.
> >
> > Most of the stuff in the tables in the TempDB database can be cleaned
out
> > without hurting anything though so if you want you can shutdown the SRS
> > Service and wipe those tables clean and you should be ok.
> > --
> > Chris Alton, Microsoft Corp.
> > SQL Server Developer Support Engineer
> > This posting is provided "AS IS" with no warranties, and confers no
rights.
> > --
> >
> > > From: Camel <hamishmur...@.gmail.com>
> > > Newsgroups: microsoft.public.sqlserver.reportingsvcs
> > > Subject: ChunkData table is growing!
> > > Date: Fri, 05 Oct 2007 05:17:09 -0000
> > > Organization:http://groups.google.com
> >
> > > Hi,
> >
> > > I have a report that refers to lots of external images (200+ each
> > > run). I've been taking a snapshot of this report so that it's quicker
> > > for users. I've limited the history to 1 snapshot. However, it appears
> > > that the images are being cached in the ChunkData table (in the
> > > ReportServer database) and that the data isn't automatically purged
> > > once the snapshot no longer exists. Is there any way to manually purge
> > > unused data?
> >
> > > Thanks,
> >
> > > Camel
>
>|||Hi Chris,
I ran CleanOrphanedSnapshots manually with an Actual Execution Plan.
The query takes between 5 and 6 minutes. The bottleneck is in the
second query:
DELETE ChunkData FROM ChunkData INNER JOIN #tempSnapshot ON
ChunkData.SnapshotDataID = #tempSnapshot.SnapshotDataID
The query takes 91% of the total execution time. 31% of this statement
is spent on a Sort, 31% on a Distinct Sort and 29% on a Clustered
Index Seek. It's deleting 22000+ records. Can you make any suggestions
to improve the performance of deleting records from the ChunkData
table?
Camel
On Oct 10, 1:37 am, cal...@.online.microsoft.com (Chris Alton [MSFT])
wrote:
> That usually means you are having a performance issue on the SQL Server
> database that is causing it not to return data in the 30 second command
> timeout window. It could also be blocking on the SQL Server as well.
> Check and see if there are any SPIDs out there that are blocking other
> processes.
> I'd check your SQL Server Activity and see if there is anything that could
> be causing this.
> --
> Chris Alton, Microsoft Corp.
> SQL Server Developer Support Engineer
> This posting is provided "AS IS" with no warranties, and confers no rights.
> --
>|||Unfortunately SQL Performance isn't my area of expertise. Try the regular
SQL Database newsgroup and see if they can give you any pointers there.
--
Chris Alton, Microsoft Corp.
SQL Server Developer Support Engineer
This posting is provided "AS IS" with no warranties, and confers no rights.
--
> From: Camel <hamishmurphy@.gmail.com>
> Newsgroups: microsoft.public.sqlserver.reportingsvcs
> Subject: Re: ChunkData table is growing!
> Date: Thu, 11 Oct 2007 23:40:10 -0000
> Organization: http://groups.google.com
> Lines: 34
> Hi Chris,
> I ran CleanOrphanedSnapshots manually with an Actual Execution Plan.
> The query takes between 5 and 6 minutes. The bottleneck is in the
> second query:
> DELETE ChunkData FROM ChunkData INNER JOIN #tempSnapshot ON
> ChunkData.SnapshotDataID = #tempSnapshot.SnapshotDataID
> The query takes 91% of the total execution time. 31% of this statement
> is spent on a Sort, 31% on a Distinct Sort and 29% on a Clustered
> Index Seek. It's deleting 22000+ records. Can you make any suggestions
> to improve the performance of deleting records from the ChunkData
> table?
> Camel
> On Oct 10, 1:37 am, cal...@.online.microsoft.com (Chris Alton [MSFT])
> wrote:
> > That usually means you are having a performance issue on the SQL Server
> > database that is causing it not to return data in the 30 second command
> > timeout window. It could also be blocking on the SQL Server as well.
> >
> > Check and see if there are any SPIDs out there that are blocking other
> > processes.
> > I'd check your SQL Server Activity and see if there is anything that
could
> > be causing this.
> > --
> > Chris Alton, Microsoft Corp.
> > SQL Server Developer Support Engineer
> > This posting is provided "AS IS" with no warranties, and confers no
rights.
> > --
> >
>|||I'll see what I can find out. Thanks for your help.
On Oct 13, 5:23 am, cal...@.online.microsoft.com (Chris Alton [MSFT])
wrote:
> Unfortunately SQL Performance isn't my area of expertise. Try the regular
> SQL Database newsgroup and see if they can give you any pointers there.
> --
> Chris Alton, Microsoft Corp.
> SQL Server Developer Support Engineer
> This posting is provided "AS IS" with no warranties, and confers no rights.
> --
> > From: Camel <hamishmur...@.gmail.com>
> > Newsgroups: microsoft.public.sqlserver.reportingsvcs
> > Subject: Re: ChunkData table is growing!
> > Date: Thu, 11 Oct 2007 23:40:10 -0000
> > Organization:http://groups.google.com
> > Lines: 34
> > Hi Chris,
> > I ran CleanOrphanedSnapshots manually with an Actual Execution Plan.
> > The query takes between 5 and 6 minutes. The bottleneck is in the
> > second query:
> > DELETE ChunkData FROM ChunkData INNER JOIN #tempSnapshot ON
> > ChunkData.SnapshotDataID = #tempSnapshot.SnapshotDataID
> > The query takes 91% of the total execution time. 31% of this statement
> > is spent on a Sort, 31% on a Distinct Sort and 29% on a Clustered
> > Index Seek. It's deleting 22000+ records. Can you make any suggestions
> > to improve the performance of deleting records from the ChunkData
> > table?
> > Camel
> > On Oct 10, 1:37 am, cal...@.online.microsoft.com (Chris Alton [MSFT])
> > wrote:
> > > That usually means you are having a performance issue on the SQL Server
> > > database that is causing it not to return data in the 30 second command
> > > timeout window. It could also be blocking on the SQL Server as well.
> > > Check and see if there are any SPIDs out there that are blocking other
> > > processes.
> > > I'd check your SQL Server Activity and see if there is anything that
> could
> > > be causing this.
> > > --
> > > Chris Alton, Microsoft Corp.
> > > SQL Server Developer Support Engineer
> > > This posting is provided "AS IS" with no warranties, and confers no
> rights.
> > > --

chunkdata and snapshotdata tables

Can someone advise under what conditions these tables are populated? I
gather from the documentation that if you set the 'Render this report from
an execution snapshot ' Properties of a report through ReportManager via a
schedule or whatever then the snapshot will be created as per the schedule
and stored.
I don't believe there are any snapshot schedules on the RS server, and the
'History' and 'Schedule' table is empty but the 'SnapshotData' and
'ChunkData' tables are accumulating daily.
I think they should be empty; nothing in BOL about, any insight on these
table contents?Snapshots are generated for every report rendering. Depending on the
context the report was rendered in the snapshot may only be available to
certain users under certain conditions. The RS Temp db and the catalog DB
both store snapshots depending on how "permanent" the snapshot is.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"CR" <CR@.discussions.microsoft.com> wrote in message
news:8D34CCC3-1404-4DD7-B074-21B95DB57027@.microsoft.com...
> Can someone advise under what conditions these tables are populated? I
> gather from the documentation that if you set the 'Render this report
from
> an execution snapshot ' Properties of a report through ReportManager via
a
> schedule or whatever then the snapshot will be created as per the schedule
> and stored.
> I don't believe there are any snapshot schedules on the RS server, and the
> 'History' and 'Schedule' table is empty but the 'SnapshotData' and
> 'ChunkData' tables are accumulating daily.
> I think they should be empty; nothing in BOL about, any insight on these
> table contents?

Chronicles from Giai

I share a forum after some months and it's not my favourite thing. I report my recent experiences about installation. A couple of days ago I downloaded Windows Server 2003 R2 and succesfully installed it. Right bottom on my desktop screen an icon shows that: Windows Server 2003, Enterprise Edition Evaluation Copy, Build 3790 (Service Pack 1). I guessed it is a copy with already installed its Service Pack 1. Then I searched for possible upgrades in Windows Server 2003 R2 home page and found nothing. I could have stopped here, but I had an already downloaded WindowsServer2003-KB889101-SP1-x86-ENU.exe copy for normal WindowsServer2003 and installed also this Sp. System has installed it without errors and I'm going well. I should have asked an expert before doing that, but I hate to wait for answers: that's why I don't like forums. By the way, can anyone tell me if WindowsServer2003-KB889101-SP1-x86-ENU.exe is good for Windows Server 2003 R2? I can reinstall everything, as I have all downloads on CD-ROM & DVD. Then today I've downloaded Microsoft SQL 2005: 3 hours for 950 MB. I installed succesfully it. I downloaded also Northwind and Pubs database scripts and attached them to SQL 2005. I can browse tables of Northwind and Pubs. One thing: even if online guide is very complete, it takes 10 seconds to load, quite a lot. Another thing: now I find in my computer also a copy of Microsoft Visual Studio 2005, just after having downloaded SQL 2005. Is it a complete version of Microsoft Visual Studio 2005, or what?

I'm glad you were able to install. Sorry that it took so long to download, but we're now bundling more into the product than we were with SQL Server 2000.

For your 10 seconds to load question, we'll need to get an answer from the Database Engine team.

For your question about Microsoft Visual Studio 2005: The edition you get with SQL Server 2005 is really just an empty shell that other components can install into. The Business Intelligence Developer Studio (BIDS) feature in Tools installs itself as a package into Visual Studio. If you don't already have Visual Studio on your machine, the empty Visual Studio shell is installed.

Good luck with everything.

-Jeffrey

Chinise, Japanise, Korean character not on PDF

My report has Chinise, Japanise, and Korean characters and they look fine on
the SQL report services viewer, but when we export to PDF, the unicode
character are replaced by question marks "'". We are using the latest sp
of SQL report services. Any ideas?Hi
Did you get your chinese characters from the database? I stored mine in the
database in utf-8 format, but when displayed in report designer and report
server, the chinese characters do not appear, instead it shows exactly the
utf-8 string eg "&4fd;". Seems the "&" character is being replaced by "&",
what some people call escape sequence
"wheresaldo" wrote:
> My report has Chinise, Japanise, and Korean characters and they look fine on
> the SQL report services viewer, but when we export to PDF, the unicode
> character are replaced by question marks "'". We are using the latest sp
> of SQL report services. Any ideas?|||Well, for my testing onlyh I didn't store the chinese character on the
database, I just copy/paste chinese in the report editor. The chinese
character look great on the report viewer, but when I export to PDF, I just
get question marks instead, '.
If we decide to use the SQL report services, the chinese will be stored on a
database, so if you find a solution to your problem, please share it with me,
Than you,
"Chiara" wrote:
> Hi
> Did you get your chinese characters from the database? I stored mine in the
> database in utf-8 format, but when displayed in report designer and report
> server, the chinese characters do not appear, instead it shows exactly the
> utf-8 string eg "&4fd;". Seems the "&" character is being replaced by "&",
> what some people call escape sequence
> "wheresaldo" wrote:
> > My report has Chinise, Japanise, and Korean characters and they look fine on
> > the SQL report services viewer, but when we export to PDF, the unicode
> > character are replaced by question marks "'". We are using the latest sp
> > of SQL report services. Any ideas?

Chinese Characters in PDF

I have a report that needs to be able to show Chinese characters in a PDF,
any idea how to make it recognize chinese instead of squares and gibberish?Use a font that supports Chinese. The default Arial font does not support
Chinese characters. Use somethikg like Tahoma that supports Chinese
characters.
--
Ravi Mumulla (Microsoft)
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Roger Twomey" <rogerdev@.vnet.on.ca> wrote in message
news:OW1$wD$cEHA.2352@.TK2MSFTNGP09.phx.gbl...
> I have a report that needs to be able to show Chinese characters in a PDF,
> any idea how to make it recognize chinese instead of squares and
gibberish?
>|||I tried Tahoma and I get question marks in the PDF.
I don't know which other Fonts may support Chinese (etc) is there another I
could try'
"Ravi Mumulla (Microsoft)" <ravimu@.online.microsoft.com> wrote in message
news:enrOOv$cEHA.3572@.TK2MSFTNGP10.phx.gbl...
> Use a font that supports Chinese. The default Arial font does not support
> Chinese characters. Use somethikg like Tahoma that supports Chinese
> characters.
> --
> Ravi Mumulla (Microsoft)
> SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> "Roger Twomey" <rogerdev@.vnet.on.ca> wrote in message
> news:OW1$wD$cEHA.2352@.TK2MSFTNGP09.phx.gbl...
> > I have a report that needs to be able to show Chinese characters in a
PDF,
> > any idea how to make it recognize chinese instead of squares and
> gibberish?
> >
> >
>|||Take a look at Asian font packs for PDF on Adobe website.
--
Ravi Mumulla (Microsoft)
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Roger Twomey" <rogerdev@.vnet.on.ca> wrote in message
news:uPPL6vZdEHA.3392@.tk2msftngp13.phx.gbl...
> I tried Tahoma and I get question marks in the PDF.
> I don't know which other Fonts may support Chinese (etc) is there another
I
> could try'
> "Ravi Mumulla (Microsoft)" <ravimu@.online.microsoft.com> wrote in message
> news:enrOOv$cEHA.3572@.TK2MSFTNGP10.phx.gbl...
> > Use a font that supports Chinese. The default Arial font does not
support
> > Chinese characters. Use somethikg like Tahoma that supports Chinese
> > characters.
> >
> > --
> > Ravi Mumulla (Microsoft)
> > SQL Server Reporting Services
> >
> > This posting is provided "AS IS" with no warranties, and confers no
> rights.
> > "Roger Twomey" <rogerdev@.vnet.on.ca> wrote in message
> > news:OW1$wD$cEHA.2352@.TK2MSFTNGP09.phx.gbl...
> > > I have a report that needs to be able to show Chinese characters in a
> PDF,
> > > any idea how to make it recognize chinese instead of squares and
> > gibberish?
> > >
> > >
> >
> >
>|||Choose Font-family of SimSun will work.
Joe
"Ravi Mumulla (Microsoft)" wrote:
> Take a look at Asian font packs for PDF on Adobe website.
> --
> Ravi Mumulla (Microsoft)
> SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no rights.
> "Roger Twomey" <rogerdev@.vnet.on.ca> wrote in message
> news:uPPL6vZdEHA.3392@.tk2msftngp13.phx.gbl...
> > I tried Tahoma and I get question marks in the PDF.
> >
> > I don't know which other Fonts may support Chinese (etc) is there another
> I
> > could try'
> >
> > "Ravi Mumulla (Microsoft)" <ravimu@.online.microsoft.com> wrote in message
> > news:enrOOv$cEHA.3572@.TK2MSFTNGP10.phx.gbl...
> > > Use a font that supports Chinese. The default Arial font does not
> support
> > > Chinese characters. Use somethikg like Tahoma that supports Chinese
> > > characters.
> > >
> > > --
> > > Ravi Mumulla (Microsoft)
> > > SQL Server Reporting Services
> > >
> > > This posting is provided "AS IS" with no warranties, and confers no
> > rights.
> > > "Roger Twomey" <rogerdev@.vnet.on.ca> wrote in message
> > > news:OW1$wD$cEHA.2352@.TK2MSFTNGP09.phx.gbl...
> > > > I have a report that needs to be able to show Chinese characters in a
> > PDF,
> > > > any idea how to make it recognize chinese instead of squares and
> > > gibberish?
> > > >
> > > >
> > >
> > >
> >
> >
>
>

Chinese characters doesn't print correctly

I develop my report in VS2005 and it print out with the Chinese characters
but when I deployed it to reporting service and print it I get boxes that
replaced the Chinese characters. The Chinese character is held in text boxes
in the report that are not queried from the database. The Chinese characters
are static headers.
--
Thank you,
The DiepHi Diep,
Since you were using a static report without querying from your database,
could you please send your report to me (changliw_at_microsoft_dot_com) for
further research?
Currently I performed a simple test with a TextBox header which was filled
with Chinese characters. After I deploy it to my report server, it worked
fine. The Chinese characters were displayed without any problem.
Look forward to your response. I am very glad to work with you for further
research.
Best regards,
Charles Wang
Microsoft Online Community Support
=====================================================When responding to posts, please "Reply to Group" via
your newsreader so that others may learn and benefit
from this issue.
======================================================This posting is provided "AS IS" with no warranties, and confers no rights.
======================================================|||After I installed the Report Viewer 2005 service pack 1 and reboot my server
the report printed Chinese characters fine. Thank you.
--
Thank you,
The Diep
"Charles Wang[MSFT]" wrote:
> Hi Diep,
> Since you were using a static report without querying from your database,
> could you please send your report to me (changliw_at_microsoft_dot_com) for
> further research?
> Currently I performed a simple test with a TextBox header which was filled
> with Chinese characters. After I deploy it to my report server, it worked
> fine. The Chinese characters were displayed without any problem.
> Look forward to your response. I am very glad to work with you for further
> research.
> Best regards,
> Charles Wang
> Microsoft Online Community Support
> =====================================================> When responding to posts, please "Reply to Group" via
> your newsreader so that others may learn and benefit
> from this issue.
> ======================================================> This posting is provided "AS IS" with no warranties, and confers no rights.
> ======================================================>
>|||Hi Diep,
Thank you for your reply and the detailed additional feedback on how you
were successful in resolving this issue. This information has been added to
Microsoft's database. Your solution will benefit many other users, and we
really value having you as a Microsoft customer.
If you have any other questions or concerns, please do not hesitate to
contact us. It is always our pleasure to be of assistance.
Have a nice day!
Best regards,
Charles Wang
Microsoft Online Community Support
=====================================================When responding to posts, please "Reply to Group" via
your newsreader so that others may learn and benefit
from this issue.
======================================================This posting is provided "AS IS" with no warranties, and confers no rights.
======================================================|||Hi
I have the same problem: the legend of a chart displays boxes instead of
chinese characters.
I've installed the Report Viewer 2005 service pack 1 on my local pc and it
works fine. But when I've installed the service pack on the server, in the
report the chinese characters are still replaced with boxes! Where is the
problem?
The OS on the pc used for development is Windows 2000 service pack 4; the
server OS is Windows Server 2003 standard edition service pack 1.
Thank you
Renato|||I have it working on my server 2003. I installed the service pack 1 from
here http://support.microsoft.com/kb/933137 then I installed some chinese
true font on my server as well. The chinese characters still didn't display
correctly until I rebooted my system.
--
Thank you,
The Diep
"Renato" wrote:
> Hi
> I have the same problem: the legend of a chart displays boxes instead of
> chinese characters.
> I've installed the Report Viewer 2005 service pack 1 on my local pc and it
> works fine. But when I've installed the service pack on the server, in the
> report the chinese characters are still replaced with boxes! Where is the
> problem?
> The OS on the pc used for development is Windows 2000 service pack 4; the
> server OS is Windows Server 2003 standard edition service pack 1.
> Thank you
> Renato
>|||Hi Renato,
If you are a MSDN Managed Newsgroup user, could you please have a new post
so that we can assist you more dedicatedly?
Best regards,
Charles Wang
Microsoft Online Community Support
=========================================================Delighting our customers is our #1 priority. We welcome your
comments and suggestions about how we can improve the
support we provide to you. Please feel free to let my manager
know what you think of the level of service provided. You can
send feedback directly to my manager at: msdnmg@.microsoft.com.
=========================================================This posting is provided "AS IS" with no warranties, and confers no rights.
=========================================================

Cheking if report's rendering in excel

Hi,
Is there a way to use an expression to check if the report is in html or
Excel?
For instance, for displaying in html I could want some format, but in Excel
not.
Is there a way to test something like this':
=iif(ReportExcel, "GainsBoro", "White")
The part of ReportExcel, to test if Iâ'm in excel is the one I want to know
(ReportExcel should be an expression, that returns true of false).
Would be also nice to see if Iâ'm in html.
Basically, I want to avoid Actions in the excel file.
Thanks in advance,
Santiago E. ReilWhat you could do is have an extra parameter passed to the report lets say we pass temp.
Depending on if you are rendering in excel or HTML format pass 0 or 1 for the parameter.
Now you can use the value of temp to see if you are rendering in excel or HTML.
>--Original Message--
>Hi,
>Is there a way to use an expression to check if the report is in html or >Excel?
>For instance, for displaying in html I could want some format, but in Excel >not.
>Is there a way to test something like this':
>=3Diif(ReportExcel, "GainsBoro", "White")
>The part of ReportExcel, to test if I=E2?Tm in excel is the one I want to know >(ReportExcel should be an expression, that returns true of false).
>Would be also nice to see if I=E2?Tm in html.
>Basically, I want to avoid Actions in the excel file.
>Thanks in advance,
>Santiago E. Reil
>.
>

checking report expression syntax

Hello!

I have a report that I am writing that was displaying perfectly, until I had to add in group totals and "sum" some of the expressions. When I did that for some reason it over rode the "format percent" part of the expresson and is no longer "formatting as a percent"

Any tips of where I could go to get my syntax in order?

Any help would be appriciated!!

If you can, post the expression that you are using.

One quick idea is that for the format string to work, you need to have your expression return the correct type. For example, if your expression returns a string and you are formatting a float as a percent, it isn't going to work.

|||

This is one of the expressions Im using :

Sum(Val(FormatPercent((Fields!ID30_DaysCNT.Value/Fields!TOTAL_UPB_CNT.Value),0)))

This among many other things in this report are making me crazy!!

Thanks for any input :)

|||

try moving the FormatPercent to the outside of the sum expression:

FormatPercent(Sum(Fields!ID30_DaysCNT.Value/Fields!TOTAL_UPB_CNT.Value))

|||Ok that actually worked....awesome thanks!!|||But wait, what about the Val() that needs to go in there ? how do I do it with that ?|||I thought you said it works now. Is there a reason you need to use the Val function?|||It did work until I got towards the end of the document.....I need the Val because sporatically throughout my report there are NAN and Infinity's ...but sometimes the Zero's do show through ....

Checking Format of a string in Report Parameter

Is there a way to find out if the user entered the date in correct format for the report parameter? For example, I am using string data type and requring the user to enter date in yyyy/mm/dd format. Can I capture and prompt the user accordingly if the date string is not provided in the above format?

Why dont you create the parameter in a Datetime format and let the user enter it in a date time format. After that you use the functions to convert itto a string in your desired format.

|||

You might be able to take advantage of the isDate() function; however, at the moment I don't see how to apply it.

Checking for NULL parameters in an expression

I have a report parameter that is NULLable. If it's NULL, I'd like a label on my report to say that it's null. If it's not NULL, the label will simply show the value. How do I check, in an expression, for a NULL parameter?IF whatever IS System.DBNull.Value then

Checking for NULL dates in Report

Hi,
I have a date field in my report dataset. I want to check for NULL date
before displaying it in the report. I have tried using the exp
=IIF(IsNothing(Fields!Date.Value),"",Month(Fields!Date.Value)&"/"&Day(Fields!Date.Value)&"/"&Year(Fields!Date.Value)).
But this doesnt work. I see #error in my report where ever date value is
NULL or blank. I have also tried using Len and IsDate functions but they too
dont seem to work. Can anyone help me ?
Thanks,
RKHi,
Tue and False part are evaluated in a IIF function. That's why you have an
#error.
You can use Visibility property.
--
Jean-Pierre Riehl
http://blog.djeepy1.net
http://www.bewise.fr
"ramakrishna" <ramakrishna@.translogicsys.com> wrote in message
news:O2Cm3S%23ZIHA.6140@.TK2MSFTNGP02.phx.gbl...
> Hi,
> I have a date field in my report dataset. I want to check for NULL date
> before displaying it in the report. I have tried using the exp
> =IIF(IsNothing(Fields!Date.Value),"",Month(Fields!Date.Value)&"/"&Day(Fields!Date.Value)&"/"&Year(Fields!Date.Value)).
> But this doesnt work. I see #error in my report where ever date value is
> NULL or blank. I have also tried using Len and IsDate functions but they
> too dont seem to work. Can anyone help me ?
> Thanks,
> RK
>
>
>|||Hi,
Thanks for the reply. I want to display the date only when its not null. So
I have used the IIF expression. But the checking using the function
IsNothing or IsDate doesnt seem to work.
--
RK
"Jean-Pierre Riehl" <jean-pierre.riehl@.bewise.fr> wrote in message
news:19928F8F-CDF8-4F4F-8C6A-C8B50D13C5C7@.microsoft.com...
> Hi,
> Tue and False part are evaluated in a IIF function. That's why you have an
> #error.
> You can use Visibility property.
> --
> Jean-Pierre Riehl
> http://blog.djeepy1.net
> http://www.bewise.fr
>
> "ramakrishna" <ramakrishna@.translogicsys.com> wrote in message
> news:O2Cm3S%23ZIHA.6140@.TK2MSFTNGP02.phx.gbl...
>> Hi,
>> I have a date field in my report dataset. I want to check for NULL date
>> before displaying it in the report. I have tried using the exp
>> =IIF(IsNothing(Fields!Date.Value),"",Month(Fields!Date.Value)&"/"&Day(Fields!Date.Value)&"/"&Year(Fields!Date.Value)).
>> But this doesnt work. I see #error in my report where ever date value is
>> NULL or blank. I have also tried using Len and IsDate functions but they
>> too dont seem to work. Can anyone help me ?
>> Thanks,
>> RK
>>
>>
>|||On Feb 5, 11:49=A0pm, "ramakrishna" <ramakris...@.translogicsys.com>
wrote:
> Hi,
> Thanks for the reply. I want to display the date only when its not null. S=o
> I have used the IIF expression. But the checking using the function
> IsNothing or IsDate doesnt seem to work.
> --
> RK"Jean-Pierre Riehl" <jean-pierre.ri...@.bewise.fr> wrote in message
> news:19928F8F-CDF8-4F4F-8C6A-C8B50D13C5C7@.microsoft.com...
>
> > Hi,
> > Tue and False part are evaluated in a IIF function. That's why you have =an
> > #error.
> > You can use Visibility property.
> > --
> > Jean-Pierre Riehl
> >http://blog.djeepy1.net
> >http://www.bewise.fr
> > "ramakrishna" <ramakris...@.translogicsys.com> wrote in message
> >news:O2Cm3S%23ZIHA.6140@.TK2MSFTNGP02.phx.gbl...
> >> Hi,
> >> I have a date field in my report dataset. I want to check for NULL date=
> >> before displaying it in the report. I have tried using the exp
> >> =3DIIF(IsNothing(Fields!Date.Value),"",Month(Fields!Date.Value)&"/"&Day=(Field=ADs!Date.Value)&"/"&Year(Fields!Date.Value)).
> >> But this doesnt work. I see #error in my report where ever date value i=s
> >> NULL or blank. I have also tried using Len and IsDate functions but the=y
> >> too dont seem to work. Can anyone help me ?
> >> Thanks,
> >> RK- Hide quoted text -
> - Show quoted text -
Any value that returns "NULL" from your database is treated like a
"Nothing" object in .Net. Wherever possible, you will want to use the
IsNothing function. If I recall, Len(Nothing) returns Nothing, not 0
Second, the Month, Day and Year functions expect a Date object. It is
possible that you are passing them a Text fieldand it doesn't know how
to parse it. This could be why the function is returning a #error.
Third, when doing Date formatting, you should probably use the Format
function instead of breaking the date apart.
=3DIIF( IsNothing(Fields!Date.Value), "", Format( CDate(Fields!
Date.Value), "M/d/yyyy" ) )
-- Scott

CHECKDB errors

SQL2K.
In the interests of research, how would one go about introducing errors
into a database to get CHECKDB to report errors?
Any changes I've made just corrupt the entire database which then gets
marked as suspect.
Any help appreciated.There is no publicly-available way to do this through T-SQL (obviously we
have internal tools to allow us to test CHECKDB and repair thoroughly). I'm
not in a position to publicly describe how to corrupt a database, as you can
imagine, but if you can describe what you'd like to research I can answer
any questions you have and save you the hassle.
Regards.
--
Paul Randal
Dev Lead, Microsoft SQL Server Storage Engine
This posting is provided "AS IS" with no warranties, and confers no rights.
<KJGNews@.hotmail.com> wrote in message
news:uI9kioE1DHA.1916@.TK2MSFTNGP10.phx.gbl...
> SQL2K.
> In the interests of research, how would one go about introducing errors
> into a database to get CHECKDB to report errors?
> Any changes I've made just corrupt the entire database which then gets
> marked as suspect.
> Any help appreciated.
>|||Paul, you seem like a great person to ask re data
corruption. I'll list some of the errors I'm seeing below
and if you could elaborate / offer any insight I'd really
appreciate it.
What I've got is a ~12 GB db, 4 tables in the millions of
records (largest is 60+, others are ~25, ~10 million).
Because of the size I have been trying to keep up
performance by shrinking the DB daily (NOTRUNCATE option),
and defragging indexes weekly.
SQL Books indicates disk errors as the cause of these
errors, and CHECKTABLE/CHECKALLOC/CHECKDB find a bunch of
errors but can't fix the one(s) causing the real problems.
Basically what happens is that some SELECT statements
began returning errors like these:
[Microsoft][ODBC SQL Server Driver][DBNETLIB]
ConnectionCheckForData (CheckforData()).
Server: Msg 11, Level 16, State 1, Line 0
General network error. Check your network documentation.
Server: Msg 823, Level 24, State 2, Line 2
I/O error (bad page ID) detected during read at offset
0x000001a7c2c000 in file 'F:\SQLData\WBReports_Data.mdf'.
The SELECTs that returned those errors were related to one
key so I tried to delete that data (which would have been
~1/2 mil. records), this stuck the DB in "suspect" status
from which we have not been able to undo. I've done other
testing by restoring from backups, but to no avail.
Some of the other errors from the system logs are:
17066 :
SQL Server Assertion: File: <recbase.cpp>, line=1378
Failed Assertion = 'm_offBeginVar < m_SizeRec'.
Error: 823, Severity: 24, State: 2
I/O error (bad page ID) detected during read at offset
0x000001a7c2c000 in file 'F:\SQLData\WBReports_Data.mdf'.
17066 :
SQL Server Assertion: File:
<p:\sql\ntdbms\storeng\drs\include\record.inl>, line=1447
Failed Assertion = 'm_SizeRec > 0 && m_SizeRec <=MAXDATAROW'.
TIA for any insight you may have.
Cheers, Ken H.
>--Original Message--
>There is no publicly-available way to do this through T-
SQL (obviously we
>have internal tools to allow us to test CHECKDB and
repair thoroughly). I'm
>not in a position to publicly describe how to corrupt a
database, as you can
>imagine, but if you can describe what you'd like to
research I can answer
>any questions you have and save you the hassle.
>Regards.
>--
>Paul Randal
>Dev Lead, Microsoft SQL Server Storage Engine
>This posting is provided "AS IS" with no warranties, and
confers no rights.
><KJGNews@.hotmail.com> wrote in message
>news:uI9kioE1DHA.1916@.TK2MSFTNGP10.phx.gbl...
>> SQL2K.
>> In the interests of research, how would one go about
introducing errors
>> into a database to get CHECKDB to report errors?
>> Any changes I've made just corrupt the entire database
which then gets
>> marked as suspect.
>> Any help appreciated.
>>
>
>.
>|||Hi Ken,
The 823 indicates you've got a bad page on the F: drive - i.e. the disk
hardware cannot physically read the page. All the other errors you describe
have the same root cause. You'll need to replace that disk and restore your
database from the last known good backup.
Regards.
--
Paul Randal
Dev Lead, Microsoft SQL Server Storage Engine
This posting is provided "AS IS" with no warranties, and confers no rights.
"Ken Hillyer" <mrstick@.beer.com> wrote in message
news:041801c3d494$f6bcc300$a101280a@.phx.gbl...
> Paul, you seem like a great person to ask re data
> corruption. I'll list some of the errors I'm seeing below
> and if you could elaborate / offer any insight I'd really
> appreciate it.
> What I've got is a ~12 GB db, 4 tables in the millions of
> records (largest is 60+, others are ~25, ~10 million).
> Because of the size I have been trying to keep up
> performance by shrinking the DB daily (NOTRUNCATE option),
> and defragging indexes weekly.
> SQL Books indicates disk errors as the cause of these
> errors, and CHECKTABLE/CHECKALLOC/CHECKDB find a bunch of
> errors but can't fix the one(s) causing the real problems.
> Basically what happens is that some SELECT statements
> began returning errors like these:
> [Microsoft][ODBC SQL Server Driver][DBNETLIB]
> ConnectionCheckForData (CheckforData()).
> Server: Msg 11, Level 16, State 1, Line 0
> General network error. Check your network documentation.
> Server: Msg 823, Level 24, State 2, Line 2
> I/O error (bad page ID) detected during read at offset
> 0x000001a7c2c000 in file 'F:\SQLData\WBReports_Data.mdf'.
> The SELECTs that returned those errors were related to one
> key so I tried to delete that data (which would have been
> ~1/2 mil. records), this stuck the DB in "suspect" status
> from which we have not been able to undo. I've done other
> testing by restoring from backups, but to no avail.
> Some of the other errors from the system logs are:
> 17066 :
> SQL Server Assertion: File: <recbase.cpp>, line=1378
> Failed Assertion = 'm_offBeginVar < m_SizeRec'.
> Error: 823, Severity: 24, State: 2
> I/O error (bad page ID) detected during read at offset
> 0x000001a7c2c000 in file 'F:\SQLData\WBReports_Data.mdf'.
> 17066 :
> SQL Server Assertion: File:
> <p:\sql\ntdbms\storeng\drs\include\record.inl>, line=1447
> Failed Assertion = 'm_SizeRec > 0 && m_SizeRec <=> MAXDATAROW'.
> TIA for any insight you may have.
> Cheers, Ken H.
>
> >--Original Message--
> >There is no publicly-available way to do this through T-
> SQL (obviously we
> >have internal tools to allow us to test CHECKDB and
> repair thoroughly). I'm
> >not in a position to publicly describe how to corrupt a
> database, as you can
> >imagine, but if you can describe what you'd like to
> research I can answer
> >any questions you have and save you the hassle.
> >
> >Regards.
> >
> >--
> >Paul Randal
> >Dev Lead, Microsoft SQL Server Storage Engine
> >
> >This posting is provided "AS IS" with no warranties, and
> confers no rights.
> >
> ><KJGNews@.hotmail.com> wrote in message
> >news:uI9kioE1DHA.1916@.TK2MSFTNGP10.phx.gbl...
> >> SQL2K.
> >>
> >> In the interests of research, how would one go about
> introducing errors
> >> into a database to get CHECKDB to report errors?
> >>
> >> Any changes I've made just corrupt the entire database
> which then gets
> >> marked as suspect.
> >>
> >> Any help appreciated.
> >>
> >>
> >
> >
> >.
> >|||Paul,
Thanks for your reply,
I am looking to write something to run a consistency check against a number
of databases and to automate the checking of the output. Getting return
values
from these commands is fiddly at best!
I've been through several iterations of looking for the best way and have
settled
on DBCC CHECKDB(db) WITH TABLERESULTS (which appears to be undocumented).
Various attempts with DMO (CheckTables/CheckTablesWithResult) have ended in
tears, as
the return values seem to well, er, not return anything in QueryResults
object (tried both VB
and Perl).
On the way to doing this, I was hoping to learn something about the internal
structure of databases, but can understand your reluctance to share this
info<g>
"Paul S Randal [MS]" <prandal@.online.microsoft.com> wrote in message
news:utJ5ydH1DHA.1760@.TK2MSFTNGP10.phx.gbl...
> There is no publicly-available way to do this through T-SQL (obviously we
> have internal tools to allow us to test CHECKDB and repair thoroughly).
I'm
> not in a position to publicly describe how to corrupt a database, as you
can
> imagine, but if you can describe what you'd like to research I can answer
> any questions you have and save you the hassle.
> Regards.
> --
> Paul Randal
> Dev Lead, Microsoft SQL Server Storage Engine
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> <KJGNews@.hotmail.com> wrote in message
> news:uI9kioE1DHA.1916@.TK2MSFTNGP10.phx.gbl...
> > SQL2K.
> >
> > In the interests of research, how would one go about introducing errors
> > into a database to get CHECKDB to report errors?
> >
> > Any changes I've made just corrupt the entire database which then gets
> > marked as suspect.
> >
> > Any help appreciated.
> >
> >
>|||Much appreciated Paul, thanks!
>--Original Message--
>Hi Ken,
>The 823 indicates you've got a bad page on the F: drive -
i.e. the disk
>hardware cannot physically read the page. All the other
errors you describe
>have the same root cause. You'll need to replace that
disk and restore your
>database from the last known good backup.
>Regards.
>--
>Paul Randal
>Dev Lead, Microsoft SQL Server Storage Engine
>This posting is provided "AS IS" with no warranties, and
confers no rights.
>"Ken Hillyer" <mrstick@.beer.com> wrote in message
>news:041801c3d494$f6bcc300$a101280a@.phx.gbl...
>> Paul, you seem like a great person to ask re data
>> corruption. I'll list some of the errors I'm seeing
below
>> and if you could elaborate / offer any insight I'd
really
>> appreciate it.
>> What I've got is a ~12 GB db, 4 tables in the millions
of
>> records (largest is 60+, others are ~25, ~10 million).
>> Because of the size I have been trying to keep up
>> performance by shrinking the DB daily (NOTRUNCATE
option),
>> and defragging indexes weekly.
>> SQL Books indicates disk errors as the cause of these
>> errors, and CHECKTABLE/CHECKALLOC/CHECKDB find a bunch
of
>> errors but can't fix the one(s) causing the real
problems.
>> Basically what happens is that some SELECT statements
>> began returning errors like these:
>> [Microsoft][ODBC SQL Server Driver][DBNETLIB]
>> ConnectionCheckForData (CheckforData()).
>> Server: Msg 11, Level 16, State 1, Line 0
>> General network error. Check your network documentation.
>> Server: Msg 823, Level 24, State 2, Line 2
>> I/O error (bad page ID) detected during read at offset
>> 0x000001a7c2c000 in
file 'F:\SQLData\WBReports_Data.mdf'.
>> The SELECTs that returned those errors were related to
one
>> key so I tried to delete that data (which would have
been
>> ~1/2 mil. records), this stuck the DB in "suspect"
status
>> from which we have not been able to undo. I've done
other
>> testing by restoring from backups, but to no avail.
>> Some of the other errors from the system logs are:
>> 17066 :
>> SQL Server Assertion: File: <recbase.cpp>, line=1378
>> Failed Assertion = 'm_offBeginVar < m_SizeRec'.
>> Error: 823, Severity: 24, State: 2
>> I/O error (bad page ID) detected during read at offset
>> 0x000001a7c2c000 in
file 'F:\SQLData\WBReports_Data.mdf'.
>> 17066 :
>> SQL Server Assertion: File:
>> <p:\sql\ntdbms\storeng\drs\include\record.inl>,
line=1447
>> Failed Assertion = 'm_SizeRec > 0 && m_SizeRec <=>> MAXDATAROW'.
>> TIA for any insight you may have.
>> Cheers, Ken H.
>>
>> >--Original Message--
>> >There is no publicly-available way to do this through
T-
>> SQL (obviously we
>> >have internal tools to allow us to test CHECKDB and
>> repair thoroughly). I'm
>> >not in a position to publicly describe how to corrupt a
>> database, as you can
>> >imagine, but if you can describe what you'd like to
>> research I can answer
>> >any questions you have and save you the hassle.
>> >
>> >Regards.
>> >
>> >--
>> >Paul Randal
>> >Dev Lead, Microsoft SQL Server Storage Engine
>> >
>> >This posting is provided "AS IS" with no warranties,
and
>> confers no rights.
>> >
>> ><KJGNews@.hotmail.com> wrote in message
>> >news:uI9kioE1DHA.1916@.TK2MSFTNGP10.phx.gbl...
>> >> SQL2K.
>> >>
>> >> In the interests of research, how would one go about
>> introducing errors
>> >> into a database to get CHECKDB to report errors?
>> >>
>> >> Any changes I've made just corrupt the entire
database
>> which then gets
>> >> marked as suspect.
>> >>
>> >> Any help appreciated.
>> >>
>> >>
>> >
>> >
>> >.
>> >
>
>.
>|||Your best bets are to use the value of @.@.ERROR after the command has run or
to output to a file and then parse. I would warn against using the
tableresults output as it is undocumented and will be changing substantially
in Yukon. Many of the database internals are documented in Kalen's Inside
SQL Server 2000 book but they're beyond the scope of this forum to get into.
--
Paul Randal
Dev Lead, Microsoft SQL Server Storage Engine
This posting is provided "AS IS" with no warranties, and confers no rights.
<KJGNews@.hotmail.com> wrote in message
news:#ZN#8RP1DHA.2000@.TK2MSFTNGP11.phx.gbl...
> Paul,
> Thanks for your reply,
> I am looking to write something to run a consistency check against a
number
> of databases and to automate the checking of the output. Getting return
> values
> from these commands is fiddly at best!
> I've been through several iterations of looking for the best way and have
> settled
> on DBCC CHECKDB(db) WITH TABLERESULTS (which appears to be undocumented).
> Various attempts with DMO (CheckTables/CheckTablesWithResult) have ended
in
> tears, as
> the return values seem to well, er, not return anything in QueryResults
> object (tried both VB
> and Perl).
> On the way to doing this, I was hoping to learn something about the
internal
> structure of databases, but can understand your reluctance to share this
> info<g>
>
> "Paul S Randal [MS]" <prandal@.online.microsoft.com> wrote in message
> news:utJ5ydH1DHA.1760@.TK2MSFTNGP10.phx.gbl...
> > There is no publicly-available way to do this through T-SQL (obviously
we
> > have internal tools to allow us to test CHECKDB and repair thoroughly).
> I'm
> > not in a position to publicly describe how to corrupt a database, as you
> can
> > imagine, but if you can describe what you'd like to research I can
answer
> > any questions you have and save you the hassle.
> >
> > Regards.
> >
> > --
> > Paul Randal
> > Dev Lead, Microsoft SQL Server Storage Engine
> >
> > This posting is provided "AS IS" with no warranties, and confers no
> rights.
> >
> > <KJGNews@.hotmail.com> wrote in message
> > news:uI9kioE1DHA.1916@.TK2MSFTNGP10.phx.gbl...
> > > SQL2K.
> > >
> > > In the interests of research, how would one go about introducing
errors
> > > into a database to get CHECKDB to report errors?
> > >
> > > Any changes I've made just corrupt the entire database which then gets
> > > marked as suspect.
> > >
> > > Any help appreciated.
> > >
> > >
> >
> >
>|||The fun I've had trying to ouput to a file<g>....
Running as a scheduled job outputs in unicode, which i have had so
much trouble parsing, it's unbelievable.
I'll continue looking for a tidy solution before going down the multipart
road.
Thanks very much for your time.
"Paul S Randal [MS]" <prandal@.online.microsoft.com> wrote in message
news:O0R9z%23T1DHA.3140@.tk2msftngp13.phx.gbl...
> Your best bets are to use the value of @.@.ERROR after the command has run
or
> to output to a file and then parse. I would warn against using the
> tableresults output as it is undocumented and will be changing
substantially
> in Yukon. Many of the database internals are documented in Kalen's Inside
> SQL Server 2000 book but they're beyond the scope of this forum to get
into.
> --
> Paul Randal
> Dev Lead, Microsoft SQL Server Storage Engine
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> <KJGNews@.hotmail.com> wrote in message
> news:#ZN#8RP1DHA.2000@.TK2MSFTNGP11.phx.gbl...
> > Paul,
> >
> > Thanks for your reply,
> >
> > I am looking to write something to run a consistency check against a
> number
> > of databases and to automate the checking of the output. Getting return
> > values
> > from these commands is fiddly at best!
> >
> > I've been through several iterations of looking for the best way and
have
> > settled
> > on DBCC CHECKDB(db) WITH TABLERESULTS (which appears to be
undocumented).
> > Various attempts with DMO (CheckTables/CheckTablesWithResult) have ended
> in
> > tears, as
> > the return values seem to well, er, not return anything in QueryResults
> > object (tried both VB
> > and Perl).
> >
> > On the way to doing this, I was hoping to learn something about the
> internal
> > structure of databases, but can understand your reluctance to share this
> > info<g>
> >
> >
> > "Paul S Randal [MS]" <prandal@.online.microsoft.com> wrote in message
> > news:utJ5ydH1DHA.1760@.TK2MSFTNGP10.phx.gbl...
> > > There is no publicly-available way to do this through T-SQL (obviously
> we
> > > have internal tools to allow us to test CHECKDB and repair
thoroughly).
> > I'm
> > > not in a position to publicly describe how to corrupt a database, as
you
> > can
> > > imagine, but if you can describe what you'd like to research I can
> answer
> > > any questions you have and save you the hassle.
> > >
> > > Regards.
> > >
> > > --
> > > Paul Randal
> > > Dev Lead, Microsoft SQL Server Storage Engine
> > >
> > > This posting is provided "AS IS" with no warranties, and confers no
> > rights.
> > >
> > > <KJGNews@.hotmail.com> wrote in message
> > > news:uI9kioE1DHA.1916@.TK2MSFTNGP10.phx.gbl...
> > > > SQL2K.
> > > >
> > > > In the interests of research, how would one go about introducing
> errors
> > > > into a database to get CHECKDB to report errors?
> > > >
> > > > Any changes I've made just corrupt the entire database which then
gets
> > > > marked as suspect.
> > > >
> > > > Any help appreciated.
> > > >
> > > >
> > >
> > >
> >
> >
>

Checkboxes in Rdl Table

I am looking fo any suggestion how to put a checkbox in a cell in a table on a rdl report. I used the wizard to make a report that has drilldown in it. I want to be able to have a check box in the cell on every row. When I check this box I want a paramater to run a sub report that builds pdfs of information that corresponsed to the data in that rows thats are checked. Any suggestions. I didnt find any tools that add checkboxes to my toolbox on the report builder. I am using vs2005.net C# asp.net

Right Click on the

|||

I am looking to do the exact same thing. Have you had any progress finding the answer?

|||

No I figured out how to do this in a regular ASP page but not a rdl report I have seen it done thought in an example but can find the example on the web. I will let you know if I finf the example.

Checkbox in reports

I have a report on which i want to add a checkbox to the extreme left of
every row and allow the user the ability to select it, hit a button named
"Export" and move the contents of only that row to MS Excel.
Does Reporting services 2000 support this? Any suggestions on how this can
be done?
Thanks...uh; i'd start with 'not trying to use excel for reporting'
-Aaron
Gaurav wrote:
> I have a report on which i want to add a checkbox to the extreme left of
> every row and allow the user the ability to select it, hit a button named
> "Export" and move the contents of only that row to MS Excel.
> Does Reporting services 2000 support this? Any suggestions on how this can
> be done?
> Thanks...

checkbox and listbox for report parameters

How can I use checkbox and listbox (with multiple selection) for report
paramters? Do I need to go into the coding to do this, or I can do this from
the designing tool? Currently I can only use either a textbox (for single
value) or a pulldown box (for list of pre-defined values). I want to have a
listbox where the user can select multiple values and a checkbox to indicate
a Yes/No filter. Thanks.There have been lots of posts about this topic. Check the archives, which
you can find here...
http://groups-beta.google.com/group/microsoft.public.sqlserver.reportingsvcs?hl=en&lr=
... and search for multi-value parameters.
--
Cheers,
'(' Jeff A. Stucker
\
Business Intelligence
www.criadvantage.com
---
"Joseph" <Joseph@.discussions.microsoft.com> wrote in message
news:9EA971CF-8606-43E2-A09F-223008E2076A@.microsoft.com...
> How can I use checkbox and listbox (with multiple selection) for report
> paramters? Do I need to go into the coding to do this, or I can do this
> from
> the designing tool? Currently I can only use either a textbox (for single
> value) or a pulldown box (for list of pre-defined values). I want to have
> a
> listbox where the user can select multiple values and a checkbox to
> indicate
> a Yes/No filter. Thanks.|||Thanks for the info.
"Jeff A. Stucker" wrote:
> There have been lots of posts about this topic. Check the archives, which
> you can find here...
> http://groups-beta.google.com/group/microsoft.public.sqlserver.reportingsvcs?hl=en&lr=
> ... and search for multi-value parameters.
> --
> Cheers,
> '(' Jeff A. Stucker
> \
> Business Intelligence
> www.criadvantage.com
> ---
> "Joseph" <Joseph@.discussions.microsoft.com> wrote in message
> news:9EA971CF-8606-43E2-A09F-223008E2076A@.microsoft.com...
> > How can I use checkbox and listbox (with multiple selection) for report
> > paramters? Do I need to go into the coding to do this, or I can do this
> > from
> > the designing tool? Currently I can only use either a textbox (for single
> > value) or a pulldown box (for list of pre-defined values). I want to have
> > a
> > listbox where the user can select multiple values and a checkbox to
> > indicate
> > a Yes/No filter. Thanks.
>
>

Checkbox

Hi,

In the reports tollbox there is no Checkbox control,In my report i want to add the checkboc control,How to add checkboc control to the toolbox.

Please help me.

Thanks in advance

I do not believe that you can do that. Are you wanting to add a check box to actual body of a report or are you wanting to use a check box to select a parameter?|||

Hi,

Thank you very much for your reply.I want to display available columns to the users,so he can select the columns he want,we have to display those selected columns in the report body.thatswhy i want to display avalable columns to user.Without checkbox how to achieve this.

Thanks inadvance

|||

Maybe use multivalue parameter with list of available report columns ? Every value have embedded checkbox and you can add default value "show all" or something like that.

Maciej

|||

Hi,

I tried in that way.I put one multivaled parameter that display all the available columns,Suppose i have the multivaled parameter named "columns" with values:Date,Empid,State.When user select date and Empid,Columns parameter returns the string in this format:'date,empid',then how we set the visibility property for the table columns based on this string.With this iam struggling.

Please help me

Thanks in advance

|||

Try this:

in your column visibility expression enter this code: "=iif(InStr(Parameters!Columns.Value,"show all") > 0 or InStr(Parameters!Columns.Value,"<this column name>") >0, true, false)"

I assumed that InStr() returns "0" or less when there is no match but better check it yourself

Maciej