|
Hai to all,
Here i am getting a problem while using crystal report which were developed in MS-Access and the same reports i am using in asp.net using sqlserver as backend.
When i am connecting these crystal reports it is giveng error that not able to load.
My doubt is can we use crystalreports generated using Ms-Access in asp.net using SqlServer as backend.
If we can do how to do????What setting i have to give???
Bcz i have to use the already generated reports in my web application.
Can anyone give me a solution for this.
Thanks in advance
Regards,
Kissy
kissy
|
|
|
|
|
It should be common approach otherwise it does nt work.
If you did the report like the following one, Its very much possible to do that for all
http://www.codeproject.com/aspnet/crystal_report.asp[^]
Regards,
Sylvester G
Senior Software Engineer
Xoriant Solutions
sylvester_g_m@yahoo.com
|
|
|
|
|
Hi All,
I have a page which gives the following error on Firefox but works fine on IE. What can b the reason. please help
Invalid postback or callback argument. Event validation is enabled using <pages enableEventValidation="true"/> in configuration or <%@ Page EnableEventValidation="true" %> in a page. For security purposes, this feature verifies that arguments to postback or callback events originate from the server control that originally rendered them. If the data is valid and expected, use the ClientScriptManager.RegisterForEventValidation method in order to register the postback or callback data for validation.
|
|
|
|
|
why you dont try to install IE Tab[^] Add-ons in firefox that integrate IE inside FireFox
I Love SQL
|
|
|
|
|
Is there any solution to make a control visible on scrolling and eliminate the change in location of the control. The control is to be placed directly on the form itself, should not use any container controls like panel
chandra
|
|
|
|
|
as far as i understand u're question you want to add a control to the form and make it visible while scrolling, right?
in such a case, just add the control to the form either in design time or at runtime.
set the autoscroll property of the form to true, and the visible property of the control to true (true by default).
if add during runtime, you need to specify the locatin where the control is to be placed and then you add the control to the container of the form e.g. this.Controls.Add(this.button1); in case of C# where 'button1' is the control u added.
|
|
|
|
|
tal reporthi frineds
i want to print barcode images on Crystal Report
barcode images are stored in database as varbinary datatype
i want fetch these images and show it on crystal report
how can i do this ?
thank you
|
|
|
|
|
Hello Everybody,
Can someone help in finding solution for dataview filter
I know how to use dataview filter and I had been using dataview for my application for biding 5 gridview.
Every gridview is binded by dataview. And when I'm using filter by sending filter criteria using textbox, it is possible to send any kind of string to filter the dataview.
Now problem is when I send
string like
1) *text, it works fine
2) text*, it works fine
3) te*xt, it fails why this is so?
Can someone please help me in this regard
Solution on this will be appreciated
Regards
Balasaheb Kahat
Balasaheb
Software Developer
Platform: Asp.net,vb.net
|
|
|
|
|
WILDCARD CHARACTERS
Both the * and % can be used interchangeably for wildcard characters in a LIKE comparison. If the string in a LIKE clause contains a * or %, those characters should be escaped in brackets ([]). If a bracket is in the clause, the bracket characters should be escaped in brackets (for example [[] or []]). A wildcard is allowed at the start and end of a pattern, or at the end of a pattern, or at the start of a pattern. For example:
"ItemName LIKE '*product*'"
"ItemName LIKE '*product'"
"ItemName LIKE 'product*'"
Wildcard characters are not allowed in the middle of a string. For example, 'te*xt' is not allowed.
for more info
=============
http://msdn2.microsoft.com/en-us/library/system.data.datacolumn.expression.aspx[^]
Regards,
Sylvester G
Senior Software Engineer
Xoriant Solutions
sylvester_g_m@yahoo.com
|
|
|
|
|
ok then how to solve above problem using dataview because user can send string like te*xt, is there any way?
Please suggest some way to solve such problem
Regards,
Balasaheb
Software Developer
Platform: Asp.net,vb.net
Database: SQL Server 2000
|
|
|
|
|
put delimeter [ and ] programmatically
RowFilter = "Name Like 'Sar[*]avanan'"
this will give Names like 'Sar*avanan'
Regards,
Sylvester G
Senior Software Engineer
Xoriant Solutions
sylvester_g_m@yahoo.com
|
|
|
|
|
Thanks for quick & useful reply
I have tried ur code doesn't give expected answer.
Explaination:-
RowFilter = "Name Like 'Sar[*]avanan'"
Suppose Name contains like "Sareeavan", the above doesn't return "Sareeavan" as result, but returns blank
I have a column named "ref" which contains records like 0007k, 0017,0127, I like find out records such as starting with 0*7 search criteria (This should min return 0007k, but wont). As per logic 0*7 should return all above values as result.
RowFilter doesn't work on such criteria, do u have any solution on such criteria?
Regads,
Balasaheb
Software Developer
Platform: Asp.net,vb.net
Database: SQL Server 2000
|
|
|
|
|
you misunderstood that. We can not do any pattern like 'te*xt' . If you want escape the character * from users input. we need to use delimeter [ and ] to remove compilation errors.
Regards,
Sylvester G
Senior Software Engineer
Xoriant Solutions
sylvester_g_m@yahoo.com
|
|
|
|
|
Thanks for ur reply
Finally conclusion is Dataview can not filter string starting with 00*7, we have to do some other solution, is it correct?
otherwise I have to query to database for filter criteria of such requirement.
What I was doing earlier
Retreiving data from database and keep it in cache[20 mins]
For every postback on same page, dataset is fill with this cache data.
Then this ds is converted into dataview in order to filter the record.
Postback happen when
1) on button click Filter,
2) ShowAll button Click
3) Paging
4) Sorting
Regards
Balasaheb
Software Developer
Platform: Asp.net,vb.net
Database: SQL Server 2000
|
|
|
|
|
Yes. You should handle this kind of pattern in Database query or Do it manually. You can not get advantage from RowFilter for this sort of patterns
Regards,
Sylvester G
Senior Software Engineer
Xoriant Solutions
sylvester_g_m@yahoo.com
|
|
|
|
|
I am working on VS 2005 and SQL 2005. I have one procedure where i created XML structure by using for XML explicit option.
Procedure returns correct XML if i execute it from Query analyzer.
But on the other hand, In my client application, only 2033 bytes of xml data is coming
Why Any idea???
Amit
|
|
|
|
|
I'm working on this app and had all my buttons and things on this page working. I have to add some more things, so I elect to use a tabstrip (a componentart tabstrip). So now my original page is on a multipage. Everything looks good and seems right but when the buttons are clicked the page is not posting back??
Anyone know what gives?
|
|
|
|
|
hi
Check if you have any validators in any of the pages in your multipage firing validation,but you may not have given the error message to display.
Or,check the InitialiseComponent() method for the event handlers because i faced the similar problem and in my application,i had some javascripts and after adding it, the event handlers weren't there in InitialiseComponent() method ... Check for it too...
Also do anyone know what have caused the evenhandlers in InitialiseComponent() method to vanish off,when i added Javascript code in my application?
~VSree
|
|
|
|
|
Yea, I disabled them to see. Wasn't the problem.
|
|
|
|
|
Hi
I think if you are using ASP.net 1.1 and if you have changed the name of the button then it maight had happened check the button event name and Id of button both are same and Event handler declaration should match it
<l>Thanks and Regards
Sandeep
|
|
|
|
|
|
i think you have to enable the autopostback=true
Sathesh Pandian
|
|
|
|
|
|
Dudde problem solved ? How ?
<l>Thanks and Regards
Sandeep
|
|
|
|
|
Hi all,
If I create a new hello-world webservice or similar declared like this:
[System.Xml.Serialization.XmlRootAttribute(Namespace = "http://HelloTest/2007/01", IsNullable = false, ElementName = "HelloResponse")]
And serializes the response - in the service - theres a nice namespace on the root node like this:
<HelloResponse xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns=http://HelloTest/2007/01>
This is also present when invoked from a browser. But if I add a webservice reference in Visual Studio and call this method, the "xmlns" attribute is not showing in the Xml! Where? Why??? It is extremely important that this namespace stays on the root node. What am I missing here?
If I extend the response to include some other nodes mapped from classes with own namespace declarations those namespace gets shown - on those nodes that is. Not on the root node. And I need it on the root node
Its really drivíng me nuts - plz clarify...
--
Werner
|
|
|
|