|
You're going to have to explain this from the start. What you're saying doesn't make any sense at all.
Report?? What report?? Where is the data stored and how? What's with the syntx you want?? how do the two relate to each other??
|
|
|
|
|
thanks a lot dave. i hv read it he say "Let's say our Products table might have ProductID, ProductName, ProductCategory and ProductAttributesXML.
We would then use ProductCategory to decide what type of class we store in ProductAttributesXML. So for ProductCategory='Digital Cameras" we could define a class DigitalCameraAttributes with fields such as Pixels, MaximumZoom, StorageType, and a special user control to show these details. Likewise, a class called HardDiskAttributes for the Hard Disks category."
now i want to allow user to specifies this fields from form cos i do not know at design time the product fields. so how can i define the class base on their input.
i hope it make sense.
|
|
|
|
|
Yikes. The only way this would be possible is if you generated code, compiled it and emitted an assembly for it at runtime. This is a VERY ADVANCED level topic and not something I've done, so I don't have any examples. For something like this, normally I'd use something like a "property bag" setup, where basic definitions for various fields common to all class types are defined in a custom collection. That collection would also use a seperately defined "property bag" kind of setup where you're storing key/value type/value information in a seperate collection. You'd also need custom serializer/deserializers to store/parse the data in/from XML files.
If you really want the custom generated class route, Google for ".net dynamic class creation".
|
|
|
|
|
thanks Dave am already storing key/value type/value information in the xml column in the database. i dont no much about custom serializer/deserializers. but the fact is that i only need to break this during report. i dont know if crytal report hav this ability to pull key/value type/value information from sql server
|
|
|
|
|
Your question still isn't very clear. Are you saying that productattribute is stored as XML, so for example:
<productattribute>
<maker>Seagate</maker>
<size>256</size>
<price>50</price>
</productattribute>
and you want to know how to break that XML up to get the sub-nodes for reporting.
Is that the question?
|
|
|
|
|
|
|
thanks a lot. i hv read it he say "Let's say our Products table might have ProductID, ProductName, ProductCategory and ProductAttributesXML.
We would then use ProductCategory to decide what type of class we store in ProductAttributesXML. So for ProductCategory='Digital Cameras" we could define a class DigitalCameraAttributes with fields such as Pixels, MaximumZoom, StorageType, and a special user control to show these details. Likewise, a class called HardDiskAttributes for the Hard Disks category."
now i want to allow user to specifies this fields from form. so how can i define the class base on their input
thanks
|
|
|
|
|
After I setup Component DevExpress for Visual Studio 2008, I can't run my project on other computer.Please help me to solve thisproblem!!!!!
Please guide me create setup file for my project that I can setup and run application on other computer that don't need to install DevExpress Component on that computer.Thanks alot!!!!
|
|
|
|
|
|
This clue is helpfull for me.Thank you very much!!!!!!
|
|
|
|
|
Hello,
I am programming in VB2005
I have a DataColumn with numbers and '<' sign as following:
-10
-5
<-90
<-50
+2
How can I sort this column?
Should I add another hided column and sort it?
Is there another way to do this?
Shay Noy
|
|
|
|
|
I suppose the column is of type string (nvarchar/nchar/varchar/etc).
How do you want this column to be sorted? In other words, what should the order be in the example you posted?
My advice is free, and you may get what you paid for.
|
|
|
|
|
Like this:
<-90 'Smaller than -90
<-50 'Smaller than -50 and that mean that it is bigger that <-90
-10
-5
+2
Shay Noy
|
|
|
|
|
You said that you are allowed to add a new column, so I assume that you are free to adapt the table structure.
If I were you, I would separate the < and > type characters from this column into its own column. Then transform the original column to type int, and simply adapt any queries or code to take both columns into account instead of only the one.
This means that you may have to adapt the query that got the data into this column to begin with, so that it separates the two value types (integers and < / >).
My advice is free, and you may get what you paid for.
|
|
|
|
|
|
Hi friends,
how to avoid flickering of tooltip? This application was done using vs-2003 and is working fine.But after converting it to vs-2008,flickering problem has arised .Please guide me in sorting out this issue.
Thanks,
Prasad
|
|
|
|
|
When you say flickering do you mean it is blinking? (toggling visibility at a fixed interval)...?
|
|
|
|
|
|
I installed a windows service in VB, and the service work fine.
But my service sometimes stop automatically when i don't use it for a long time (about 12hours).
Who can tell me reason?
Thanks.
|
|
|
|
|
There is no reason why Windows would arbitrarily decide to stop a random service after 12 hours so there must be something else going on here. What does your service do?
|
|
|
|
|
May be, an exception goes unhandled which bring down your service. Handle all exceptions and instrument your code to write to Windows Event Log when your service starts and stops. This might help you to troubleshoot your problem.
Also, in Service Manager, you can configure your service to restart automatically after a failure (in Recovery tab).
|
|
|
|
|
Hello great minds!
I built a 2008 vb.net win app with a local MS Access DB that has several reports (.rdlc) They were all working just fine and suddenly:
"An error occurred during local report processing. An internal error occurred on the report server. See the error log for more details."
Can't see any reports at all. Since I could not locate the error log file, I rebooted the system, but the issue remains.
The stacktrace is:
at Microsoft.ReportingServices.Diagnostics.Utilities
.RSTraceInternal.Assert(...)
.RSTrace.Assert(...)
at Microsoft.ReportingServices.ReportProcessing
.ProcessingErrorContext.RegisterItem(...)
.ProcessingErrorContext.Register(...)
.ProcessingErrorContext.Register(...)
.ReportProcessing.RuntimeRICollection.GetExternalImage(...)
.ReportProcessing.ReportProcessing.Merge.Process(...)
.ReportProcessing.ReportProcessing.ProcessReport(...)
.ReportProcessing.ReportProcessing.ProcessReport(...)
.ReportProcessing.ReportProcessing.RenderReport(...)
.ReportProcessing.ReportProcessing.RenderReport(...)
at Microsoft.Reporting
.LocalService.RenderWithDataCache(...)
.LocalService.Render(...)
.WinForms.LocalReport.InternalRender(...)
Thank you very much for your time, interest and help.
alexvw.
modified on Wednesday, November 25, 2009 5:48 PM
|
|
|
|
|
This article describes the same error, and although it talks about MS SQL 2005, I wouldn't be entirely surprised if it at least sets you in the right direction, as Visual Studio 2008 employs MS SQL 2005, and thereby possibly uses some common driver to access your Access DB.
My advice is free, and you may get what you paid for.
|
|
|
|
|
Hi Johan,
Thank you for your help. This morning before going to work, I decided to try a silly thing. I replaced the myform.Designer.vb file with a previous one and it all came back to normal: well, did lose some data, but that won't take my sleep away.
My guess is that the code that created the instance and rendered the reportviewer object got somehow corrupted.
Once again, thanks for your time.
Best regards.
|
|
|
|